5 ms·

It used to be the other way around, with Excel leading the way.

by hbossy 2y ago

brewdad 2y ago
This is one of those fringe features that 1% of users are clamoring for and 99% of users should never ever use. I’m not surprised it was never at the top of the Excel team’s TODO list.
- IshKebab 2y ago
  Yeah the problem is that those 1% of users are probably writing the most critical spreadsheets, and when companies using GSuite think about moving to Office365 the more pain it is to migrate spreadsheets the worse for Microsoft.
  - eb123 2y ago
    So why are only 2/3 of the formulas named the same? Excel's new REGEXTEST [1] is REGEXMATCH in Sheets [2] [1] https://support.microsoft.com/en-us/office/regextest-function-7d38200b-5e5c-4196-b4e6-9bff73afbd31 https://support.microsoft.com/en-us/office/regextest-functio... [2]https://support.google.com/docs/answer/3098292?hl=en https://support.google.com/docs/answer/3098292?hl=en
eb123 2y ago
I've been using Sheets's regex functions for over a year, they're really helpful for basic data transformation. Excel also got a "split" function much later than Sheets did. I was excited to read on the Sheets blog that Sheets finally will have a table functionality, which Excel has always had: https://workspaceupdates.googleblog.com/2024/05/tables-in-google-sheets.html?m=1 https://workspaceupdates.googleblog.com/2024/05/tables-in-go...
jgalt212 2y ago
Or Excel mimicking the broken calendar of Lotus 123.
- mnau 2y ago
  And it was an excellent decision, see rationale: https://www.joelonsoftware.com/2000/06/03/strategy-letter-iii-let-me-go-back/ https://www.joelonsoftware.com/2000/06/03/strategy-letter-ii... TBH, they should have dumped during switch to OOXML, that was a wasted opportunity. On the other hand, that's hard sell to business.
_factor 2y ago
Good ideas should have a provisional naming period where a standardize name can be agreed on. Anything else leads to fragmentation and lock in due to domain specific terminology.

It used to be the other way around, with Excel leading the way.

by hbossy 2y ago

It used to be the other way around, with Excel leading the way.

This is one of those fringe features that 1% of users are clamoring for and 99% of users should never ever use. I’m not surprised it was never at the top of the Excel team’s TODO list.

IshKebab 2y ago
Yeah the problem is that those 1% of users are probably writing the most critical spreadsheets, and when companies using GSuite think about moving to Office365 the more pain it is to migrate spreadsheets the worse for Microsoft.
- eb123 2y ago
  So why are only 2/3 of the formulas named the same? Excel's new REGEXTEST [1] is REGEXMATCH in Sheets [2] [1] https://support.microsoft.com/en-us/office/regextest-function-7d38200b-5e5c-4196-b4e6-9bff73afbd31 https://support.microsoft.com/en-us/office/regextest-functio... [2]https://support.google.com/docs/answer/3098292?hl=en https://support.google.com/docs/answer/3098292?hl=en

eb123 2y ago

I've been using Sheets's regex functions for over a year, they're really helpful for basic data transformation. Excel also got a "split" function much later than Sheets did. I was excited to read on the Sheets blog that Sheets finally will have a table functionality, which Excel has always had: https://workspaceupdates.googleblog.com/2024/05/tables-in-google-sheets.html?m=1 https://workspaceupdates.googleblog.com/2024/05/tables-in-go...

jgalt212 2y ago

Or Excel mimicking the broken calendar of Lotus 123.

mnau 2y ago
And it was an excellent decision, see rationale: https://www.joelonsoftware.com/2000/06/03/strategy-letter-iii-let-me-go-back/ https://www.joelonsoftware.com/2000/06/03/strategy-letter-ii... TBH, they should have dumped during switch to OOXML, that was a wasted opportunity. On the other hand, that's hard sell to business.

_factor 2y ago

Good ideas should have a provisional naming period where a standardize name can be agreed on. Anything else leads to fragmentation and lock in due to domain specific terminology.