3 ms·

LibreOffice blasts Microsoft for putting "commercial interests" over everything

26 points by bundie 8mo ago

daoboy 8mo ago
"Excel's default behavior is to convert certain text entries into dates. It makes sense for general spreadsheet use, but not for geneticists. Genes, like Membrane Associated Ring-CH-Type Finger 1, are given alphanumeric symbols (MARCH1) as a shorthand for their full, complex names. When a scientist would input "MARCH1" into an Excel spreadsheet, the software would automatically interpret this as a date and convert it to "1-Mar"[...]For a long time, Microsoft's position was that this was a niche issue affecting a small number of users" To be fair, this really is a niche issue. For all that I agree with the frustration for Microsoft's terrible behavior in so many other respects, it's hard to fault them for not being immediately responsive to something like this.
- fsflover 8mo ago
  Do you really think that auto converting MARCH1 to a date even helped anybody? Who is writing dates like this?
  - bundie 8mo ago
    The option to turn off the auto conversion stuff, should have been shipped way before 2023.
  - gus_massa 8mo ago
    I do from time to time, mostly for home budgets. I'm surprised every time it works.
  - bigstrat2003 8mo ago
    That's not really a counter argument to what was said. Daoboy said (and he's right!) that MS hasn't done anything because the behavior impacts very few users, not because it benefits very many users.
  - wolvoleo 8mo ago
    It's also less helpful because it's not very deterministic. A year is a short time and when it rolls over it will pick the current year even when you may have wanted last year.
- nolroz 8mo ago
  Ok, sure. Now open this .csv
- zzo38computer 8mo ago
  I think it does not make sense even for general spreadsheet use; it would be better to specify the type explicitly. (I also think a "zoned spreadsheet" would be better, although sometimes compatibility might still be needed with existing spreadsheets so a zoned spreadsheet cannot be the only implementation.)
aeuropean12 8mo ago
Yes. Microsoft is a company that is driven by its "commercial interest". That is true. Well done.

26 points by bundie 8mo ago

"Excel's default behavior is to convert certain text entries into dates. It makes sense for general spreadsheet use, but not for geneticists. Genes, like Membrane Associated Ring-CH-Type Finger 1, are given alphanumeric symbols (MARCH1) as a shorthand for their full, complex names. When a scientist would input "MARCH1" into an Excel spreadsheet, the software would automatically interpret this as a date and convert it to "1-Mar"[...]For a long time, Microsoft's position was that this was a niche issue affecting a small number of users" To be fair, this really is a niche issue. For all that I agree with the frustration for Microsoft's terrible behavior in so many other respects, it's hard to fault them for not being immediately responsive to something like this.

fsflover 8mo ago
Do you really think that auto converting MARCH1 to a date even helped anybody? Who is writing dates like this?
- bundie 8mo ago
  The option to turn off the auto conversion stuff, should have been shipped way before 2023.
- gus_massa 8mo ago
  I do from time to time, mostly for home budgets. I'm surprised every time it works.
- bigstrat2003 8mo ago
  That's not really a counter argument to what was said. Daoboy said (and he's right!) that MS hasn't done anything because the behavior impacts very few users, not because it benefits very many users.
- wolvoleo 8mo ago
  It's also less helpful because it's not very deterministic. A year is a short time and when it rolls over it will pick the current year even when you may have wanted last year.
nolroz 8mo ago
Ok, sure. Now open this .csv
zzo38computer 8mo ago
I think it does not make sense even for general spreadsheet use; it would be better to specify the type explicitly. (I also think a "zoned spreadsheet" would be better, although sometimes compatibility might still be needed with existing spreadsheets so a zoned spreadsheet cannot be the only implementation.)

aeuropean12 8mo ago

Yes. Microsoft is a company that is driven by its "commercial interest". That is true. Well done.