https://bugs.freedesktop.org/show_bug.cgi?id=47109
--- Comment #5 from joaquin <[email protected]> 2012-08-31 18:58:35 UTC --- (In reply to comment #1) > Also numbers are imported as TEXT, with one exception: > > - Global setting > Load/Save -> HTML Compatibility -> Use English (USA) locale for number > changes this behaviour for numbers with a "." as decimal separator > (but swaps month and day around if day < 13) > - Withouth this global setting all numbers in all formats and (manipulated) > dates > are imported as TEXT > > Tested with LibreOffice 3.5.4 & 3.6.0 RC4 Use this global setting, automatic on import and import some numbers with two or three decimals: http://beurs.fd.nl/aandelen/amsterdam/aex/ Then the "," decimal separator is lost in the TEXT() fields with more than two decimals, e.g. ArcelorMittal 11,855 Becomes: ArcelorMittal 11855 While Royal Dutch Shell A 27,81 gets the same characters "27,81" in the second TEXT-field. -- 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
