Reply to post: Not just Excel

Geneticists throw hands in the air, change gene naming rules to finally stop Microsoft Excel eating their data

Kanhef

Not just Excel

LibreOffice also likes to auto-detect data types, and then auto-format based on what it thinks you're doing.

One solution would be to have a setting for default cell formatting. Auto-detect can still be the default option, but let people set it so negative numbers are always red and in parentheses, for example.

POST COMMENT House rules

Not a member of The Register? Create a new account here.

  • Enter your comment

  • Add an icon

Anonymous cowards cannot choose their icon

SUBSCRIBE TO OUR WEEKLY TECH NEWSLETTER

Biting the hand that feeds IT © 1998–2020