https://bugs.freedesktop.org/show_bug.cgi?id=56457
--- Comment #4 from joaquin <[email protected]> --- System: Mac OS X 10.7.4 System Locale is Dutch (or whatever non-English), LO will follow this. Using Version 3.6.2.2 (Build ID: da8c1e6) and the preferences (tools -> options): - UI US English (that is not the point, see 53177) - Preferences -> Language Settings -> Languages -> Locale Setting [Default - Dutch (Netherlands)] - Preferences -> Load/Save -> HTML Compatibility [v] Use English (USA) locale for numbers No problem when opening the attachment #69146. Now go back to the preferences: - Preferences -> Load/Save -> HTML Compatibility [ ] Use English (USA) locale for numbers Now refresh the link, in the Macintosh version: - Edit -> Links.. Select the link and press [Update] Now the spreadsheet has the broken numbers as reported. So it seems impossible to import numbers with a decimal dot when using a decimal comma in your locale unless you select: - Preferences -> Load/Save -> HTML Compatibility [v] Use English (USA) locale for numbers (this is the point!) What nobody seems to get is that this solution behaves wrong. It messes with dates as well. Also it is questionable if such a setting should exist. A question on import about number- and date-format is a lot more robust. So I do not understand why bug 53177 is closed as being a duplicate from this one. It is not! The problem described in this bug does not occur when using the "HTML Compatibility" setting. -- 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
