What would be a revolution in excel is if we could have probability distributions in cells. Right now all spreadsheets are fairly deterministic and we think that tells us something about the real world. Having an ability to make cells distributions (and then all resultant cells would be distributions too) would represent the uncertainty in the world better (and expose lots of interesting things like distributions of tails)
Guesstimate (https://getguesstimate.com) has been around for years. I assumed Excel and Google would incorporate its features quickly, but it never seems to have taken off.
Features:
- All cells are named (auto named if you don't set them)
- Cells can have single values, many types of probability distribution, or sample data
- Formulas also produce distributions as first class outputs, because calculation is a Monte Carlo sim
- Each cell also has a pop-up box that invites you to explain your reasoning -- built in documentation
It got so much right. Sample data particularly useful because you can build a probabilistic bottom-up forecast and then update it with real-world data.
What would this look like? Whenever I need something like that, I just stick each parameter in its own cell and use functions from there.
I would love an easier way to communicate to tech/math-illiterate CEOs that worst case, average case, and best case are different things, but must all be planned for.
When I did Process Improvement we used MiniTab for this.
I honestly was not a fan of that program and would have loved to be able to use Excel, but there are so many statistical things you just can't do in it.
> This library solves that problem. It registers xarray data structures as custom JAX PyTrees. This allows JAX to seamlessly flatten xarray objects into their raw arrays for accelerated computation and then unflatten the results back into fully labeled xarray objects, preserving critical metadata like dimension names and coordinates.
flatten and unflatten with datatypes is necessary for unrolling loops for performance.
Which is the correct logic for probabilistic logic, for expressions with frequentist or symbolic distributions as values? Are quantum logic and quantum statistical mechanics the appropriate or useful tools for all probabilistic logic?
dist_a1 <operator> dist_a2
uncertainties does mean±dev in Python with numpy types.
> W3C CSVW supports per-column schema. ( with URIs for datatypes )
> Serialize a dict containing a value with uncertainties and/or Pint (or astropy.units) and complex values to JSON, then read it from JSON back to the same types. Handle datetimes, complex values, and categoricals
IEEE-754 specifies NaN (null), ±0, three infinities (positive, negative, and unsigned), but IEEE-754 does not specify a representation for categoricals, datetimes (like ISO8601), or complex numbers.
XSD (XML Schema Datatypes), which RDFS vocabularies often use to specify the rdfs:range of an rdfs:Property, does not specify how to specify abstract complex numbers; but OpenMath RDF, and QUDT (Quantities, Units, Dimensions, and Types) and OM Ontology all have a way to save complex numbers to disk, too.
I was skeptical, but this looks genuinely useful. I can already think of some use-cases for this, e.g. a spreadsheet I was working on recently had a list of user, and then a comma-separated list of software apps they were using. It was a bit of a nightmare to parse, but the example in the article would definitely help with filtering the list.
It's funny how history repeats itself... from 61 years ago:
Pick OS had multi-value fields... Not quite the same, but it was the "Excel", and so much more, at the time.
I didn’t really appreciate excel fully until I worked at a company that forbid software development and had implemented a whitelist policy for executables. VBA was blocked too.
Excel on Windows was the only tool available, outside of offering sacrifices to the high priesthood of IT.
It is a supremely elegant tool capable of deep data integration and extraordinary analysis, if you approach it with an engineer’s mindset.
This was during the time when they started introducing lambda and related functions. Nowadays, Excel is even more of a superpower.
Unfortunately, Excel on Mac is not nearly as good. It has all the features, but it’s missing a lot of the UI needed to use them effectively.
I've worked at places like they. They did have a self-service app store you could use to install things. It also had an approval system for anything that cost real money for a license. Excel was the bread and butter for many engineers for a long time to make functional tools. The great part of Excel is you could make little GUIs with the tables, not exactly QT, but you could have labels and textboxes. We regularly used a tool up until 2020 that was originally created in Excel 97.
MATLAB was the runner up for our tools but the good part about Excel was that every PC had it whereas MATLAB wasn't and also needed network access for the license (or else your program/department had to buy a node license). Later, many people switched to python since not everyone loves MATLAB and it's more of a real software language (and it's free) than what's effectively a very expensive calculator.
Were you able to process truly large datasets? I worked at a very excel company once but we kept running into row limit issues when scaling workloads and eventually migrated almost everything away from it. What industry were you in at the time?
The same thing that works for databases also works for excel. You shard the data and run your analysis on the set of shards in excel. It's not elegant, but can solve many problems.
I’ve recently been experimenting with OnlyOffice as a non-excel alternative that can still support a broad formula set and I’ve been really pleasantly surprised. I want to be able to use an open source spreadsheet system and onlyoffice is surprisingly robust.
Sibling comment nailed my feeling on this: the UI of onlyoffice is modern and clean. To add on, it gives me a feeling of confidence that it can round-trip files back and forth from excel more reliably; a lot of people on my team also use excel and we need to exchange workbooks, so that was what prompted me to move on from LibreOffice when I lost confidence that files would be able to remain pretty stable going back and forth.
I’m a very occasional and casual user of office programs. Mostly I don’t use them.
What I like about OnlyOffice over LibreOffice is the UI. I like how it’s one program that can open all the documents rather than a collection of different programs as well. It feels clean, simple, and modern.
Excel now support lists and arrays as values in a cell, but it still thinks February 29th, 1900 is a thing because 40 year-old backwards compatibility?
Is that a contradiction? Adding list and arrays doesn't break backwards compatibility. In general, guaranteeing backwards compatibility doesn't prevent you from adding new features, and having both old quirks and new features is fairly common for any decently old software
But treesheets isn’t used by millions of office workers across the globe. I doubt treesheets is know by 2% of the HN audience. So it just doesn’t make the news.
Or was the point you knew an obscure fact about an obscure application?
I guess “so nothing”. The model is fundamentally broken. Adding a third dimension to certain cells by giving them a new type (‘tuple’, ‘list’?) whilst also having multiple sheets that aren’t (really) addressable is a disaster for the semantics.
The way to do mathematics on computers is via a CAS such as Mathematica. This is misguided pornography. Unfortunately as such it shall do what its implementers intended: for a while embrace, and if not extend, embolden.
And yes, I know Wolfram Language is proprietary too, and, yes, I know Stephen Wolfram is a massive tool, and yes, I know Mathematica licenses are expensive, and yes, I am aware of probably all the criticisms you can level my way and at it and then some in various permutations thereof, but heavens, at least it isn’t this dissolute disaster otherwise known as Excel, where “numbers have a place” but they don’t need to be numbers, and they don’t need to be in a place or have a place, but they break silently whilst you run your hedge fund.
EDIT: As soon as I get my hands on this monstrosity I shall embark upon a voyage to define several lambdas within the same cell as a list, and then make other cells depend upon it, and their type too, to see how far I can push this thing until it breaks.
Excel arrays are difficult to work with, exceedingly slow, and didn't have some basic formula support.
This looks like a very sane implementation, addresses some issues with traditional arrays (while extending them nicely) and implements those much-needed formulas.
> Throughout Excel's 40-year history, you've only been able to put one value per cell. In this announcement, we're excited to share how that's changing with the release of lists, arrays in cells, and nested arrays, initially to Microsoft Excel for Windows and Mac Beta Channels.
This seems like something I'd expect to already exist in Excel, but the way it's being presented makes it sound like they want to murder Excel.
Would anyone be shocked to find out that I've been smuggling JSON in spreadsheets for a long long time and regret nothing?
Users might see it as a good thing to have yet another feature, but this sort of type-softness is why Excel is bad. In general having every feature is a bad thing, you need constraints to design things, to have idioms.
Making everything flexible is what allows you to make spaghetti that nobody understands.
I shall embark upon a quest, and the quest’s object shall be thus: to define multiple lambdas within a list, and thereupon, to make cells downstream depend upon the lamda’s, and to make them in turn become lists or values, and so on, until the whole thing breaks.
Excel does not need to be as opinionated or portable as a programming language. This might actually be a lesser of two evils considering what type of user behavior it encourages. (I've heard a similar ethos behind certain design decisions of Go)
Microsoft is actively harming the laypersons comprehension of their data with 'features' such as this.
Reasoning about the basic shape of data with real estate managers using the Btrieve[0] database on DOS (and then XP) in years gone by was noticeably more straight forward than wrangling the monolithic excel monstrosities encountered today.
There is an argument to be made somewhere that Microsoft should’ve pressed much more hardly upon Access and the separation between data and operations thereupon than the conglomerate mess that is Excel.
Hah, AI-written summary? (Using Buzzfeed's 1-sentence-per-paragraph-for-fifth-grade-reading-skills style). The author is "msexcel, Bronze Contributor", and if I click the username I get a "Cannot find current user" (1).
Anyway, adding an extra dimension on a 2-dimensional spreadsheet (rows, columns, and now depth)? Good luck with that.
(1) OK it breaks for all usernames, I guess because it's Microslop...
Not really. I get what you are saying, and with discipline you could emulate depth with sheets. But it would only be by convention and I don’t think many functions worked that way.
A quote from the Baghavad Gita on this being a bad thing, is fine. But me pointing out all the infrastructure this will likely break, and how, is not?
Is it that I complained in the way I stated something? Because fine, if that's what keeps getting your attention (this isn't the first time), I'll try to Americanise the way I talk here.
You packed a lot of things in here! Let me try to tease them apart.
> But me pointing out all the infrastructure this will likely break, and how, is not?
Of course it's fine. It's a question of how you do it. There were two problems with your comment: (1) it was snarky, which we're trying to avoid and which HN's guidelines ask you not do do; and (2) you didn't provide much information, so it came across as shallow. The combination of snarky and shallow is bad for the conversation we're hoping for.
It sounds like you have experience in this domain. If so, you could write an interesting comment about your experience (e.g. with spreadsheets, VBA, how they control businesses) and how the current release will break things. If you did that by adding details from your personal experience (anecdotes are king!) and avoiding snark, that would be more than fine.
Such comments, of course, take time to write. It's taken me 37 minutes and counting to write this one. (Edit: 45 minutes.) If you don't want to or don't have time, that's ok—just please refrain from snarky/shallow/indignant one-liners.
> A quote from the Baghavad Gita on this being a bad thing, is fine
It's common (and understandable) that when people see comment A going unmoderated while their own comment B is scolded by a mod, they feel singled out for unfair treatment. I've described this in the past as "it always feels like the mods are against you" (https://hn.algolia.com/?dateRange=all&page=0&prefix=true&que...).
But there's a dirt-simple explanation: we don't see everything. Not even close! There's far too much for us to see even 10% of what gets posted here. So when you see a post that ought to have been moderated but hasn't been, the likeliest reason is that we didn't see it. You can always help by flagging it or emailing us at hn@ycombinator.com.
> Because fine, if that's what keeps getting your attention (this isn't the first time)
What gets my attention are comments breaking the site guidelines. It's nothing personal! I didn't remember replying to you before, though once you mentioned it, I looked it up.
It goes against every bone in my Aquarian body to regard myself as a policeman, but the analogy somewhat holds here. Say you get pulled over for speeding. It's easy to feel you're being singled out. What about all the cars that were just speeding past you? do they get a pass? But it's not personal. Policeperson is just sitting there doing their (no doubt rather boring) highway duty.
> I'll try to Americanise the way I talk here
I gather that you perceive HN's guidelines as somehow specifically American? I perceive them very differently. They are an attempt at figuring out how to manage a very large internet forum across national differences—and other differences—without degenerating into mutual clubbing (the caveman kind, not the dancing kind).
None of the HN moderators is American. The site was created by an American, but one who was born in England and has been living there for the last decade, happily ensconced. It's all so much more complex than one's quick assumptions are able to process, and when you fire those at people, even across anonymous internet space, it can really sting.
I recommend you read the article. It's short, illustrated, and does a good job of explaining what's new, how it works, and how it extends existing Array functionality.
It makes me gleeful to see Microsoft adding genuinely new and useful features to their standard products. Whether true or not, it feels like it's been such a long time..
And something that isn't AI or an advertising opportunity…
Though they have been slowly adding useful new features to Excel (auto- spill is one I occasionally find to be both a time saver and a mistake reducer) for a few years now, after a long time seemingly doing very little with it. While I'm all for things having a "done" state and after that not doing much with them so as to not break a good thing, there is plenty of room for little improvements like new functions (admittedly many of them likely a bit niche) in Excel, just as long as they don't break what already works at the same time.
What would be a revolution in excel is if we could have probability distributions in cells. Right now all spreadsheets are fairly deterministic and we think that tells us something about the real world. Having an ability to make cells distributions (and then all resultant cells would be distributions too) would represent the uncertainty in the world better (and expose lots of interesting things like distributions of tails)
Guesstimate (https://getguesstimate.com) has been around for years. I assumed Excel and Google would incorporate its features quickly, but it never seems to have taken off.
Features:
- All cells are named (auto named if you don't set them)
- Cells can have single values, many types of probability distribution, or sample data
- Formulas also produce distributions as first class outputs, because calculation is a Monte Carlo sim
- Each cell also has a pop-up box that invites you to explain your reasoning -- built in documentation
It got so much right. Sample data particularly useful because you can build a probabilistic bottom-up forecast and then update it with real-world data.
Wow, this is incredibly cool. I can't believe this stuff hasn't been ported into Excel.
Its a paid add-on but @Risk gives the functionality you're looking for
What would this look like? Whenever I need something like that, I just stick each parameter in its own cell and use functions from there.
I would love an easier way to communicate to tech/math-illiterate CEOs that worst case, average case, and best case are different things, but must all be planned for.
When I did Process Improvement we used MiniTab for this.
I honestly was not a fan of that program and would have loved to be able to use Excel, but there are so many statistical things you just can't do in it.
Would those then be tensors?
Matrices are Tensors but with the matrix product operator instead of the tensor product operator.
Pandas supports MultiIndex DataFrames but the pandas docs recommend xarray for 3D and N-Dimensional data.
xarray supports N-Dimensional data as for example NetCDF but not tensor arithmetic.
xarray_jax: https://github.com/google-deepmind/xarray_jax :
> This library solves that problem. It registers xarray data structures as custom JAX PyTrees. This allows JAX to seamlessly flatten xarray objects into their raw arrays for accelerated computation and then unflatten the results back into fully labeled xarray objects, preserving critical metadata like dimension names and coordinates.
flatten and unflatten with datatypes is necessary for unrolling loops for performance.
Which is the correct logic for probabilistic logic, for expressions with frequentist or symbolic distributions as values? Are quantum logic and quantum statistical mechanics the appropriate or useful tools for all probabilistic logic?
dist_a1 <operator> dist_a2
uncertainties does mean±dev in Python with numpy types.
From https://news.ycombinator.com/item?id=41411280 :
> W3C CSVW supports per-column schema. ( with URIs for datatypes )
> Serialize a dict containing a value with uncertainties and/or Pint (or astropy.units) and complex values to JSON, then read it from JSON back to the same types. Handle datetimes, complex values, and categoricals
IEEE-754 specifies NaN (null), ±0, three infinities (positive, negative, and unsigned), but IEEE-754 does not specify a representation for categoricals, datetimes (like ISO8601), or complex numbers.
XSD (XML Schema Datatypes), which RDFS vocabularies often use to specify the rdfs:range of an rdfs:Property, does not specify how to specify abstract complex numbers; but OpenMath RDF, and QUDT (Quantities, Units, Dimensions, and Types) and OM Ontology all have a way to save complex numbers to disk, too.
I was skeptical, but this looks genuinely useful. I can already think of some use-cases for this, e.g. a spreadsheet I was working on recently had a list of user, and then a comma-separated list of software apps they were using. It was a bit of a nightmare to parse, but the example in the article would definitely help with filtering the list.
I wonder what impact this will have on the World Championship of Excel
https://excel-esports.com/
Is copy-paste still broken in Excel after that "security update"?!
https://www.windowslatest.com/2026/09/17/microsoft-kb5002914...
The next step is to allow adding a spreadsheet into a cell, and introduce infinite zoom
Reminds me of Oppenheimer: "Now I am become Death, the destroyer of worlds"
it's the Baghavad Gita, which Oppenheimer quoted. there's a wikipedia link...
https://en.wikipedia.org/wiki/Bhagavad_Gita#/media/File:Trin...
When I read this post earlier, I immediately thought, "don't cross the streams."
Your scientists were so preoccupied with whether or not they could, they didn't stop to think if they should.
nooo Oppenheimer, you prevented needless world war
by having nukes we prevent world war 3, see british operation unthinkable
About time! Should have done this from the start instead of spill. That and being able to index into the multiple values in a cell.
This seems like it'd be some sort of April Fools announcement.
It's funny how history repeats itself... from 61 years ago: Pick OS had multi-value fields... Not quite the same, but it was the "Excel", and so much more, at the time.
https://en.wikipedia.org/wiki/Pick_operating_system
I guess I am dating myself!
> I guess I am dating myself!
at least you never have to worry about who pays
I didn’t really appreciate excel fully until I worked at a company that forbid software development and had implemented a whitelist policy for executables. VBA was blocked too.
Excel on Windows was the only tool available, outside of offering sacrifices to the high priesthood of IT.
It is a supremely elegant tool capable of deep data integration and extraordinary analysis, if you approach it with an engineer’s mindset.
This was during the time when they started introducing lambda and related functions. Nowadays, Excel is even more of a superpower.
Unfortunately, Excel on Mac is not nearly as good. It has all the features, but it’s missing a lot of the UI needed to use them effectively.
I've worked at places like they. They did have a self-service app store you could use to install things. It also had an approval system for anything that cost real money for a license. Excel was the bread and butter for many engineers for a long time to make functional tools. The great part of Excel is you could make little GUIs with the tables, not exactly QT, but you could have labels and textboxes. We regularly used a tool up until 2020 that was originally created in Excel 97.
MATLAB was the runner up for our tools but the good part about Excel was that every PC had it whereas MATLAB wasn't and also needed network access for the license (or else your program/department had to buy a node license). Later, many people switched to python since not everyone loves MATLAB and it's more of a real software language (and it's free) than what's effectively a very expensive calculator.
Excel on Mac does not have all the features. It does have most of them. It is also buggy.
Were you able to process truly large datasets? I worked at a very excel company once but we kept running into row limit issues when scaling workloads and eventually migrated almost everything away from it. What industry were you in at the time?
The same thing that works for databases also works for excel. You shard the data and run your analysis on the set of shards in excel. It's not elegant, but can solve many problems.
The console in browsers is also very useful
Especially since it uses your cookies by default.
> Unfortunately, Excel on Mac is not nearly as good. It has all the features, but it’s missing a lot of the UI needed to use them effectively.
Someone could just vibe code that. I'm not even kidding.
You underestimate the task by multiple orders of magnitude. It would be a significant effort even to build it on libreoffice.
I’ve recently been experimenting with OnlyOffice as a non-excel alternative that can still support a broad formula set and I’ve been really pleasantly surprised. I want to be able to use an open source spreadsheet system and onlyoffice is surprisingly robust.
Are you familiar with LibreOffice? Are there any advantages that OnlyOffice has over other open source spreadsheets?
Sibling comment nailed my feeling on this: the UI of onlyoffice is modern and clean. To add on, it gives me a feeling of confidence that it can round-trip files back and forth from excel more reliably; a lot of people on my team also use excel and we need to exchange workbooks, so that was what prompted me to move on from LibreOffice when I lost confidence that files would be able to remain pretty stable going back and forth.
I’m a very occasional and casual user of office programs. Mostly I don’t use them.
What I like about OnlyOffice over LibreOffice is the UI. I like how it’s one program that can open all the documents rather than a collection of different programs as well. It feels clean, simple, and modern.
Same thing
Excel now support lists and arrays as values in a cell, but it still thinks February 29th, 1900 is a thing because 40 year-old backwards compatibility?
This is a strange world we live in.
Backwards compatibility with Lotus 1-2-3: https://learn.microsoft.com/en-us/troubleshoot/microsoft-365...
Is that a contradiction? Adding list and arrays doesn't break backwards compatibility. In general, guaranteeing backwards compatibility doesn't prevent you from adding new features, and having both old quirks and new features is fairly common for any decently old software
- 404? https://techcommunity.microsoft.com/blog
Treesheets had this for over 15 years now. https://strlen.com/treesheets/
But treesheets isn’t used by millions of office workers across the globe. I doubt treesheets is know by 2% of the HN audience. So it just doesn’t make the news.
Or was the point you knew an obscure fact about an obscure application?
Same applies to many of the more elaborate usages of Excel I'd argue. Only few dive deep
I suppose it shows that it's not an outright innovation in this space, for whatever that is worth.
And Lotus Improv ‘solved’ spreadsheets about thirty-five years ago. So?
So?
I guess “so nothing”. The model is fundamentally broken. Adding a third dimension to certain cells by giving them a new type (‘tuple’, ‘list’?) whilst also having multiple sheets that aren’t (really) addressable is a disaster for the semantics.
The way to do mathematics on computers is via a CAS such as Mathematica. This is misguided pornography. Unfortunately as such it shall do what its implementers intended: for a while embrace, and if not extend, embolden.
And yes, I know Wolfram Language is proprietary too, and, yes, I know Stephen Wolfram is a massive tool, and yes, I know Mathematica licenses are expensive, and yes, I am aware of probably all the criticisms you can level my way and at it and then some in various permutations thereof, but heavens, at least it isn’t this dissolute disaster otherwise known as Excel, where “numbers have a place” but they don’t need to be numbers, and they don’t need to be in a place or have a place, but they break silently whilst you run your hedge fund.
EDIT: As soon as I get my hands on this monstrosity I shall embark upon a voyage to define several lambdas within the same cell as a list, and then make other cells depend upon it, and their type too, to see how far I can push this thing until it breaks.
I'm sure someone has already coined a law something like this:
The use of Excel expands until it fills the space of all use cases.
To my knowledge, you still can't write an email client in Excel.
OK, maybe with plug-ins, but probably not natively.
Probably not.
Maybe.
In a rigid lattice, aye.
This would violate 1NF in SQL.
Excel just got a z-axis. Cool.
They already had that with 3D formulas. (Not even kidding... you can sum the same range across multiple spreadsheet tabs)
Excel is a fractal of bad design
Weird, because I remember a job where we had arrays in Excel cells back in 2008.
Excel arrays are difficult to work with, exceedingly slow, and didn't have some basic formula support.
This looks like a very sane implementation, addresses some issues with traditional arrays (while extending them nicely) and implements those much-needed formulas.
You could call a named range or ctrl+shift+enter to run an array command. You couldn't put a defined array in a single cell, it would read at text.
These arrays are IN A SINGLE CELL
> Throughout Excel's 40-year history, you've only been able to put one value per cell. In this announcement, we're excited to share how that's changing with the release of lists, arrays in cells, and nested arrays, initially to Microsoft Excel for Windows and Mac Beta Channels.
This seems like something I'd expect to already exist in Excel, but the way it's being presented makes it sound like they want to murder Excel.
Would anyone be shocked to find out that I've been smuggling JSON in spreadsheets for a long long time and regret nothing?
I have, at the risk of being a meme, put spreadsheets in cells via OLE. It was glorious.
Can you extract values from the embedded spreadsheets to do math in the host sheet?
What was that syntax like?
Users might see it as a good thing to have yet another feature, but this sort of type-softness is why Excel is bad. In general having every feature is a bad thing, you need constraints to design things, to have idioms.
Making everything flexible is what allows you to make spaghetti that nobody understands.
I shall embark upon a quest, and the quest’s object shall be thus: to define multiple lambdas within a list, and thereupon, to make cells downstream depend upon the lamda’s, and to make them in turn become lists or values, and so on, until the whole thing breaks.
If you've got five minutes, you'll be able to crash their Python integration. Probably without trying to do so.
won't you get nested arrays not supported? or maybe you thunk it out, idk
I’m pretty sure I can make it recurse.
Excel does not need to be as opinionated or portable as a programming language. This might actually be a lesser of two evils considering what type of user behavior it encourages. (I've heard a similar ethos behind certain design decisions of Go)
The flexibility of Excel is a lot of its value. If it wasn’t flexible like this then how could it be so widespread as a general purpose business tool?
Excel allows and embraces whatever mess you want to make.
Microsoft is actively harming the laypersons comprehension of their data with 'features' such as this.
Reasoning about the basic shape of data with real estate managers using the Btrieve[0] database on DOS (and then XP) in years gone by was noticeably more straight forward than wrangling the monolithic excel monstrosities encountered today.
[0]https://en.wikipedia.org/wiki/Btrieve
There is an argument to be made somewhere that Microsoft should’ve pressed much more hardly upon Access and the separation between data and operations thereupon than the conglomerate mess that is Excel.
But can I use multiple slurp juices on a single cell?
Codd wept.
Excel gone SIMD
Hah, AI-written summary? (Using Buzzfeed's 1-sentence-per-paragraph-for-fifth-grade-reading-skills style). The author is "msexcel, Bronze Contributor", and if I click the username I get a "Cannot find current user" (1).
Anyway, adding an extra dimension on a 2-dimensional spreadsheet (rows, columns, and now depth)? Good luck with that.
(1) OK it breaks for all usernames, I guess because it's Microslop...
Is https://techcommunity.microsoft.com/blog/microsoft365insider... better? We could swap the URLs.
Edit: I swapped the URLs.
You already had sheets in the workbook for depth
I’d like to be able to make a cell into a sheet… like a subsidiary schedule
Not really. I get what you are saying, and with discipline you could emulate depth with sheets. But it would only be by convention and I don’t think many functions worked that way.
Index does at least, which is pretty huge.
Oh great. More stuff to break the two decade piplelines in the poorly maintained VBA-scripted and now AI-infested sheets that control businesses.
"Don't be snarky."
"Please don't post shallow dismissals, especially of other people's work. A good critical comment teaches us something."
https://news.ycombinator.com/newsguidelines.html
Not really sure on this, dang.
A quote from the Baghavad Gita on this being a bad thing, is fine. But me pointing out all the infrastructure this will likely break, and how, is not?
Is it that I complained in the way I stated something? Because fine, if that's what keeps getting your attention (this isn't the first time), I'll try to Americanise the way I talk here.
You packed a lot of things in here! Let me try to tease them apart.
> But me pointing out all the infrastructure this will likely break, and how, is not?
Of course it's fine. It's a question of how you do it. There were two problems with your comment: (1) it was snarky, which we're trying to avoid and which HN's guidelines ask you not do do; and (2) you didn't provide much information, so it came across as shallow. The combination of snarky and shallow is bad for the conversation we're hoping for.
It sounds like you have experience in this domain. If so, you could write an interesting comment about your experience (e.g. with spreadsheets, VBA, how they control businesses) and how the current release will break things. If you did that by adding details from your personal experience (anecdotes are king!) and avoiding snark, that would be more than fine.
Such comments, of course, take time to write. It's taken me 37 minutes and counting to write this one. (Edit: 45 minutes.) If you don't want to or don't have time, that's ok—just please refrain from snarky/shallow/indignant one-liners.
> A quote from the Baghavad Gita on this being a bad thing, is fine
It's common (and understandable) that when people see comment A going unmoderated while their own comment B is scolded by a mod, they feel singled out for unfair treatment. I've described this in the past as "it always feels like the mods are against you" (https://hn.algolia.com/?dateRange=all&page=0&prefix=true&que...).
But there's a dirt-simple explanation: we don't see everything. Not even close! There's far too much for us to see even 10% of what gets posted here. So when you see a post that ought to have been moderated but hasn't been, the likeliest reason is that we didn't see it. You can always help by flagging it or emailing us at hn@ycombinator.com.
> Because fine, if that's what keeps getting your attention (this isn't the first time)
What gets my attention are comments breaking the site guidelines. It's nothing personal! I didn't remember replying to you before, though once you mentioned it, I looked it up.
It goes against every bone in my Aquarian body to regard myself as a policeman, but the analogy somewhat holds here. Say you get pulled over for speeding. It's easy to feel you're being singled out. What about all the cars that were just speeding past you? do they get a pass? But it's not personal. Policeperson is just sitting there doing their (no doubt rather boring) highway duty.
> I'll try to Americanise the way I talk here
I gather that you perceive HN's guidelines as somehow specifically American? I perceive them very differently. They are an attempt at figuring out how to manage a very large internet forum across national differences—and other differences—without degenerating into mutual clubbing (the caveman kind, not the dancing kind).
None of the HN moderators is American. The site was created by an American, but one who was born in England and has been living there for the last decade, happily ensconced. It's all so much more complex than one's quick assumptions are able to process, and when you fire those at people, even across anonymous internet space, it can really sting.
This is a valid and well considered comment. It’s not your role to police opinion, dang.
Quite! And fortunately I don't know what the opinion is.
It turns out that, with practice, you can read comments along one axis and not another. And boy do we practice.
It’s good for the economy.
I didn't read this, but it could already hold tons of values in one cell? Can someone explain what they are 'supporting' now?
I recommend you read the article. It's short, illustrated, and does a good job of explaining what's new, how it works, and how it extends existing Array functionality.
It makes me gleeful to see Microsoft adding genuinely new and useful features to their standard products. Whether true or not, it feels like it's been such a long time..
And something that isn't AI or an advertising opportunity…
Though they have been slowly adding useful new features to Excel (auto- spill is one I occasionally find to be both a time saver and a mistake reducer) for a few years now, after a long time seemingly doing very little with it. While I'm all for things having a "done" state and after that not doing much with them so as to not break a good thing, there is plenty of room for little improvements like new functions (admittedly many of them likely a bit niche) in Excel, just as long as they don't break what already works at the same time.
So they added support for and a nice UI on JSON data types in database fields.
That may sound reductive and dismissive, but I think that's actually pretty cool and likely to make some things a lot easier.
Some day maybe excel will be a proper database. Anyway, who uses Excel?
The real question is if Google Sheets will get these features.