Bug 48655 - Pasting an HTML table into Calc should provide an option for avoiding automatic date detection
Summary: Pasting an HTML table into Calc should provide an option for avoiding automat...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 3.5.1 release
Hardware: All All
: low enhancement
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-04-13 10:20 UTC by myfdbug
Modified: 2014-10-31 09:35 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:

Attachments

Description myfdbug 2012-04-13 10:20:53 UTC 
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).
Comment 1 Beluga 2014-10-31 09:35:12 UTC 
Confirmed, setting as enhancement.

Win 7 64-bit Version: 4.4.0.0.alpha1+
Build ID: 56019dcb79475606952a954fe732a3109441ffec
TinderBox: Win-x86@39, Branch:master, Time: 2014-10-30_07:27:11

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.