Please make the cells smart and detect data types on entry. For example: if I enter “123” the cell will automatically prefix with the “=” sign and covert to integer. If I enter “1-jan-2001” it will automatically convert to date, and so on. This not only improves productivity especially when copy/paste from text sources but makes it much easier for those migrating from Excel.
Hello @oocool
By default cells have “general” type, which accepts all kinds of values (basically text), but automation raises some issues with data that only starts with specific characters. Have you encountered a processor that has such feature?
Excel has this feature on by default
just to clarify…when entering 123+123 directly into the cell Calc will automatically insert an “=” sign and apply the correct computation.
It seems to be a setting, because typing “123+123” into a cell with General format, it does not calculate it (no equal sign is added) and displays it as plain text. Unfortunately, I cannot find it in the preferences.