Sadly, the only way I’ll be able to use these features is if Microsoft bought them out and integrated them into Excel. It’s ubiquitous at almost every workplace you go to, but the only innovation of the past 20 years seems to be PQ (which is awesome), and xlookup.
https://support.microsoft.com/en-us/office/guidelines-and-ex...
There have actually been a couple of tries at them. The modern “dynamic” array formulas are a little less fiddly.
The obvious way to do it is as follows:
* Setup an excel sheet with "Name" and "Age" in A1 and B1, then put some sample data in. * Highlight the data and go insert -> table and hit 'ok' * Where it says Table Name: put in "Users"
If we want to refer to the array of names in that table, you would now say =Users[Name] in a formula.
As another example, if we wanted to find the average age, we could simply say =Average(Users[Age]) passing in the ages as an array.
If we made another two columns - MathsScore and EnglishScore, we can either automatically create a column adding these up ([@MathsScore]+[@EnglishScore]), or alternatively these ranges can then be used in spill formulas.
You must refer to a range of cells for it to work - in Excel this would be for instance =SUM(A:A).
In Google Sheets: generally you write a formula and hit Ctrl+Shift+Enter which will turn it into an array formula.
In Excel there are many more options in how to handle this, one of which is to define a table in Excel (Insert -> Table) and then refer to the table and column (=TableName[Column]).
LibreOffice is so, so far behind the curve already, and I’d be laughed out of the building.
Only in workplaces which use Windows. But granted, that's the large majority of them.
> so I can use the same workflows and templates
LibreOffice Calc opens Excel files well enough.
> and don’t have to raise a request to install some new app
It's not "some" new app. It has an estimated 200 Million users worldwide, and is probably the most popular FOSS application after browsers.
LivreOffice does not do PowerQuery, and while it ‘opens Excel files well enough’, it probably only has 70% feature parity at most.
They themselves claim that it has ‘tens of millions of users’…
I’m not saying it’s a bad - or new - product. It’s just yet another customer requesting to install something. Very, very few (exactly zero) workplaces I have visited in Oceania and South East Asia are using it.
Could you name the exact killer features you see in this one, compared to, say, etherpad or https://pad.envs.net ?