[Libreoffice-bugs] [Bug 126049] New: Copying a table in HTML from web browser to Calc, automatic data format correction is wrong (ignoring settings)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=126049

            Bug ID: 126049
           Summary: Copying a table in HTML from web browser to Calc,
                    automatic data format correction is wrong (ignoring
                    settings)
           Product: LibreOffice
           Version: 6.2.4.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: roberto.turturro at gmail.com

Description:
There's a table in HTML (with standard tags <tr> and <td>) that I copy and
paste in Calc with standard "Paste" command (CTRL + V).
The table is pasted correctly, with the right row/column structure.
By the way, there's a strange behavior with the interpretation of the pasted
text: Calc applies an automatic correction with text-type cells (even if I
previously set "Text" in cell format).
In detail, cells that contain the string format "Mar. xx" (eg. "Mar. 04", "Mar.
11", "Mar. 18", ...) are converted automatically to "01-March-xx", where XX is
interpreted as YEAR (eg. "01/03/2004", "01/03/2011", "01/03/2018").
Instead, "Mar. 04", in the site I am copyng from, should be intended as
"Martedì 04" (italian localization of "Tuesday, 04th March 2019"), not "March
01st, 2004".

This problem occurs only if copyng text from inside a HTML table (text:
"<tr><td>Mar. 04</td></tr>"). If I copy plain text "Mar. 04" no auto-correction
is applied (if I previously set "Text" in cells format).

Steps to Reproduce:
1. In a web browser, copy a HTML table that contains cells with text "Mar. XX"
(where XX is a two-digits number, from 00 to 31)
2. In Calc, paste (CTRL+V)

Actual Results:
Cells with text "Mar. XX" (eg. "Mar. 04") are interpreted as date and
automatically corrected to 01-March-XXXX (eg. "01/03/2004").

Expected Results:
If I previously set "Text" as cells format and then I paste, Calc should not
automatically interprete cells as date and should leave text as it is ("Mar.
04" --> "Mar. 04").


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Can't check if OpenGL is enabled.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190622/f2ec92ec/attachment.html>