[Libreoffice-bugs] [Bug 53177] New: CONFIGURATION "Use 'English (USA)' locale for numbers" messes with dates and "insert link to external data"

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


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

             Bug #: 53177
           Summary: CONFIGURATION "Use 'English (USA)' locale for numbers"
                    messes with dates and "insert link to external data"
    Classification: Unclassified
           Product: LibreOffice
           Version: 3.6.0.4 rc
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: narebeestjes at yahoo.com


The global configuration setting 


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

causes the following:

- numbers with a "." as decimal separator are recognised and inserted in 
  "NUMBER" fields
- instead of just importing numbers as text this configuration messes with
dates:
  dates: day and month are swapped around if day-of-month < 13
- this function overrules the per-import choice for locale and recognising 
  numbers and dates (bug 53103)

I guess this setting does not make sense since in this form and with this
description: it offers only a partial solution for bug 47109 and as
disadvantages messes with dates and per-import choices.

-- 
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