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: Calc (show other bugs)
Version:
(earliest affected)
3.5.1 release
Hardware: All All
: low enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: HTML-Paste
  Show dependency tree / graph
 
Reported: 2012-04-13 10:20 UTC by myfdbug
Modified: 2018-10-14 09:28 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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 Buovjaga 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