4 ms·
Why would spreadsheet software try to differ in formula names? You want users to be able to switch to your platform with little friction.
by filcuk 2y ago
Why would spreadsheet software try to differ in formula names?
You want users to be able to switch to your platform with little friction.
- hbossy 2y agoIt used to be the other way around, with Excel leading the way.
- brewdad 2y agoThis 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 agoYeah 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 agoSo 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 agoI'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 agoOr Excel mimicking the broken calendar of Lotus 123.
- mnau 2y agoAnd 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 agoGood 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.
- Akronymus 2y agoWell, excel translates the formula names... (One of the many reasons I switched over to using windows in english, rather than german)