[Libreoffice-bugs] [Bug 48655] New: Pasting an HTML table into Calc should provide an option for avoiding automatic date detection

[bugzilla-daemon at freedesktop.org]

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

             Bug #: 48655
           Summary: Pasting an HTML table into Calc should provide an
                    option for avoiding automatic date detection
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.5.1 Release
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: myfdbug at binkmail.com


When you paste a formatted HTML table, there is no option for changing the
source language or disabling other options such as "detect special numbers".

This means that in locales such as France, pasting a table containing
fractional numbers (such as http://en.wikipedia.org/wiki/Density_of_air ) will
randomly convert some of them into dates (because "." is not a decimal
separator in French), without any way of fixing it after pasting since the
original numbers are mangled beyond recognition.

When pasting unformatted text with "Paste special", you have the option of
either changing the source language or leaving "Detect special numbers"
unchecked. But when selecting HTML in the "Paste special" dialog, no other
dialog appears and the table is pasted as if "Detect special numbers" was
checked and the language set to the system locale (regardless of the actual
HTML language attribute, I might add).

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