this post was submitted on 21 Oct 2023
359 points (98.1% liked)

Technology

59377 readers
6041 users here now

This is a most excellent place for technology news and articles.

Our Rules

  1. Follow the lemmy.world rules.
  2. Only tech related content.
  3. Be excellent to each another!
  4. Mod approved content bots can post up to 10 articles per day.
  5. Threads asking for personal tech support may be deleted.
  6. Politics threads may be removed.
  7. No memes allowed as posts, OK to post as comments.
  8. Only approved bots from the list below, to ask if your bot can be added please contact us.
  9. Check for duplicates before posting, duplicates may be removed

Approved Bots

founded 1 year ago
MODERATORS
L3s@lemmy.world
L3s@fry.gs
L4s@fry.gs
L4s@lemmy.world
enu@lemmy.world
359
Microsoft fixes the Excel feature that was wrecking scientific data (www.theverge.com)
submitted 1 year ago by misk@sopuli.xyz to c/technology@lemmy.world
86 comments fedilink hide all child comments
you are viewing a single comment's thread
view the rest of the comments
[โ€“] RunningInRVA@lemmy.world 13 points 1 year ago (1 children)

In order to do that I think they would first have to ratify a standards change to the Excel format, which is open.

[โ€“] Black616Angel@feddit.de 1 points 1 year ago

Uh, I mean kinda...

Excel implements two Microsoft file format standards:

  • ECMA-376
  • ISO 29500

Those are not the same and even incompatible in parts. It is correct, that Microsoft tries to use ISO 29500 more, but most files (2007) still are ECMA-376.

But yes, they kinda would have to change their shitty, ISO-incompatible ISO "standard" to fix this issue this way.

Or use the formula field, idk. ๐Ÿ˜