3 ms·
I can see why that would be annoying but it's a tradeoff between how many people would find the automatic categorization of a cell useful vs how many would find
by vimacs2 5y ago
I can see why that would be annoying but it's a tradeoff between how many people would find the automatic categorization of a cell useful vs how many would find it a nuisance. I'm not a spreadsheet wiz but I'm pretty sure it would allow you to set a column to interpret input as raw text.
- ZeroGravitas 5y agoApparently science found it easier to rename some genes! https://www.nature.com/articles/d41586-021-02211-4 https://www.nature.com/articles/d41586-021-02211-4
- hulitu 5y agoBut the only automatic characterization to a cell is always in a date. It has a 50 % hit rate and you always need a ritual to stop it: delete the contents of the cell, set the cell format to your desired format, insert the contents.
- saiya-jin 5y agoThe problem is, MS thinks they know better than you what you want, and even if they guess it 95% right (and they don't), the rest causes so much frustration that its not worth it for audience like HN. Its pain point with Office products since 90s, a classic example from that era (and 2000s) is doing a single newline in Word and reformatting whole 100 page document into useless mess. If they would make a clear easy option to just turn it off with 1 button, same for grammar corrections, it would make life easier for everybody. But no, MS knows better...
- vimacs2 5y agoYeah, I admit I find the tendency for MS products to autocorrect anything it can infuriating but I guess I'm just not their target audience which is why I stick to FOSS products and operating systems. I tend to use org-mode's table feature and if I need to export stuff to common formats, pandoc.