https://bugs.freedesktop.org/show_bug.cgi?id=38327
--- Comment #9 from [email protected] 2011-10-20 14:58:35 PDT --- Just tested Nikos 's idea, and as I expected, it works to prevent data like 22.1 being converted autmatically to 22/01/11, but it still doesn't work in my case because I need that 22.1 to be a number so I can do math with it. With Nikos's idea I can at best prevent calc from converting things the wrong way automatically, but I would need still to convert data to numbers AGAIN (it was numbers in the first place...). And I can't see any whay of doing this sustainably: I would have to replace the dot with a comma so "22.1" became "22,1" and only then put that string into a =value() formula. It is complicated, by definition it shouldn't be necessary and if I ever need these files to be opened by a client/worker in a place where the locale setting uses dot as decimal separator instead of comma, I would need to change all these formulas, right? And would need to know which locale setting the person who will open the file has. Or not? It's just my opinion, but I think the logical calculations (that have nothing to do with place or locale) in a spreadsheet should not depend upon the PLACE or the LOCALE where the spreadsheet is being used in order to work. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- 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
