https://bugs.freedesktop.org/show_bug.cgi?id=34724
--- Comment #13 from andréb <[email protected]> --- (In reply to comment #4) > 1. We can't turn off number recognition for default cells. We can improve > the automatic recognition, but we can't turn it off. This issue has nothing to do with automatic number recognition. Rather it is about *not* automatically turning non-numeric text (or possibly numeric text) into dates. Dates do *not* have to be stored as numbers, and they are not displayed as such either. In any case, they are not normally entered as numbers. The only advantage of storing dates as numbers is to more readily compare the difference of 2 dates in days. Storing in ISO format allows relative comparison and is more compact and allows faster display. Many applications store dates in ISO-equivalent format. (Which reminds me of another idiosyncracy. In cells without a specific alignment format, entries beginning with with a number should not be right-aligned, but rather use the default global alignment, which is usually to the left. There is no way of knowing if entries are numbers until all characters are entered, and even for numbers it is less confusing to see it left-aligned during entry. Try entering a few hundred fields by hand to see. That could be made an option as well.) > 2. Setting the cell format to Text prior to entering a value turns off > automatic number recognition. That's an intended feature which can be used > to circumvent this problem. Putting ' in front was the old workaround. Please see response to point 1. > Unfortunately it's not easy to improve auto recognition since the number > format code is full of hacks piled up in many layers accumulated over many > years. So, please don't hold your breath for any solution anytime soon. However, it should be very easy to turn off automatic conversion to dates. Attempting automatic date recognition is evidently a complex process (which is not currently well done), so turning it off would simplify calc code. Any date recognition code, to be readily maintainable, should be cleanly separated from other code. If one chooses to keep such code as a non-default option, the option flag could be used to separate it from other code. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
