4 ms·
The others may have their own preferences to edit documents. It's like you edited one code file in a project, and you want everyone to switch to night IDE them
by deepsun 2y ago
The others may have their own preferences to edit documents.
It's like you edited one code file in a project, and you want everyone to switch to night IDE theme when they open that particular file.
- moring 2y agoThe meaning of a value (data type in programming lingo) is not a preference because it is objective, not subjective. It depends on the cell being displayed, not on the viewer in front of the screen.
- deleted 2y ago[deleted]
- dreghgh 2y agoIt's not a setting which determines how a value stored in a sheet is interpreted. It's a setting which determines how inputs are interpreted before being stored. When you type eg "4/4", "4-Apr", "2025-04-04" or whatever, it is converted to a number based on your local date format. The cell has a date format applied to it so that the number appears as a date. If you send the sheet to someone else, it will display the same numeric value, using their settings to display it as a date.
- deepsun 2y agoBut GP isn't talking about value, they are talking about process of entering the value, so that _their_ editor (Excel) wouldn't convert it to something weird.
- mrgoldenbrown 2y agoMore like I wrote some python code, and want to ensure the IDE doesn't change spaces to tabs. Night theme vs day theme is orthogonal to the code. Date parsing in Excel is not.
- prettymuchnoone 2y agohm i mean, python doesn't really care about indentation kind, as long as it's consistent... maybe writing a Makefile (which afaik really REALLY wants tabs), and want to ensure someone's IDE doesn't change it to spaces.
- mulmen 2y agoWell, no, it isn't because Excel actually changes the underlying data too. It's more like changing the formatting of all the files in the project and deleting all the characters after the 80th column.
- deepsun 2y agoDoes it? I think it only affects when you enter the value, it doesn't change the underlying data that someone else stored in a doc.
- deleted 2y ago[deleted]
- mulmen 2y agoI just tested it. The setting applies on data entry but opening a CSV or similar delimited file counts as “data entry”. So if you work strictly with xlsx files you are fine but it will irreversibly convert the values on open for delimited files unless you change the defaults.
- creatonez 2y agoCome on, there is no room for anyone to have a preference here when an excel document is meant to be storing the names of genes and would never need to have a date or time in it, and can very easily get corrupted beyond repair if someone turns date conversion on. (For context, genome research is the whole reason this toggle was added in the first place.) Even something like Vim lets you enforce file-specific settings with a header. At the same time, we're clearly shooting ourselves in the foot by using Excel for this. This feature is just a hodge-podge solution to the problem of Excel not having strict data types. There should be enough cautionary tales (https://eusprig.org/research-info/horror-stories/ https://eusprig.org/research-info/horror-stories/) for everyone to know to avoid Excel.
- dreghgh 2y agoThe setting only applies when you enter or edit a value. It doesn't convert values which are already stored in a cell.
- creatonez 2y agoYeah... a slow burn that is difficult to notice until it's too late.
- dreghgh 2y agoExcel is not designed to waste the time of frequent, experienced users while hand-holding casual users. It's designed to make power users very fast and accurate while possibly confusing casual and new users.