this post was submitted on 21 Oct 2023
398 points (97.8% liked)

Technology

59632 readers
2929 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
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
398
Microsoft fixes the Excel feature that was wrecking scientific data (www.theverge.com)
submitted 1 year ago by [email protected] to c/[email protected]
90 comments fedilink hide all child comments
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 2 points 1 year ago

Honestly, I'd say you shouldn't do that prompt method. The auto type is genuinely great for the use cases which Excel is supposed to be used for, from someone managing their household finances to charting the growth of a business.

By all means, it absolutely should make assumptions about your data by default, as that's incredibly convenient for the average user. You can always change the type of a cell afterwards if what you're doing is special.