https://bugs.freedesktop.org/show_bug.cgi?id=34724
andréb <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- OS|Windows (All) |All --- Comment #12 from andréb <[email protected]> --- This problem, automatic translation to date of text in default formatted cell, still exists in Libo 3.5.7.2 I use the french locale (on Linux), and it doesn't even translate into a date format that I use. Worse still, when the format is reset to text, one gets a number not at all related to the original text. The only reasonable solution is to turn off all automatic (attempts to) date recognition. For the small minority that would appreciate this function, there could be a non-default option. If such an option is activated, the type of conversion should be configurable (it chooses the wrong date format in my case), and also explicitly reformatting the cell as text should revert to the text entered. A date in spreadsheet context is a form of text, not a number intended for calculation. The fact that dates are normally stored in number format should not affect the automatic treatment of values entered. This bug (at the very least in conception) has existed for years, going back to Openoffice days, as well as the refusal to fix it. Since when does one normally do calculations on dates ? -- 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
