[Libreoffice-bugs] [Bug 38327] Pivot table converts text values to numbers in column headers

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=38327

--- Comment #9 from raf32 at operamail.com 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.