[Libreoffice-bugs] [Bug 53103] FILEOPEN INSERT 'Link to external data' 'Select the language to use for import' does not make a difference with dates/numbers

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Mon Aug 6 19:10:10 CEST 2012


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

--- Comment #1 from joaquin <narebeestjes at yahoo.com> 2012-08-06 17:10:10 UTC ---
Just found out that the situation described above is with the "global setting"

Load/Save -> HTML Compatibility -> Use English (USA) locale for number

Without that checked the choice 'Select the language to use for import' does
something:

- The first example is handled correctly with "Dutch/NL" and checking the box
for dates and numbers. But the imported text remains TEXT.
- The second example does not work, even when selecting English/UK: The date is
not swapped but the numbers are still TEXT and the VALUE function does not work
on other number-formats then your default locale (see bug 53173).


So I guess the real problem with this bug comes down to:

- The global setting "Use English (USA) locale for numbers" does not make sense
since it overrules locale choices on import, instead of just setting a default,
and messes with dates as well. 
- The choice "Select the language to use for import" can be improved a lot by
  - solving bug 47109, i.e. numbers should be treated as such and
    according to the locale-choice for import
  - make it possible to see and/or change this choice for an added link


Tested with LibreOffice 3.6.0 RC4

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.



More information about the Libreoffice-bugs mailing list