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

Eike Rathke <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|REOPENED                    |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #4 from Eike Rathke <[email protected]> ---
This is not an error, it is on purpose that the guessing of strings to
interpret them that works only in one locale and gives errors or wrong values
in all other locales is not supported anymore. Newer versions of OO (i.e. 3.4)
also don't do it.

You can fix it by re-entering the value into the cell (provided that the cell
is not formatted as Text) such that it gets interpreted. This can be automated
with selecting the cells to convert and Find&Replace by searching for .* and
replacing with $0 and enabling regular expressions. Another and more
sophisticated way is to use the extension Convert Text to Number (CT2N)
http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-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

Reply via email to