[Libreoffice-bugs] [Bug 32400] New: Copying a HTML table from a webrowser and pasting into a new sheet causes permanent auto-formatting and other strange behaviours

[bugzilla-daemon at freedesktop.org]

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

           Summary: Copying a HTML table from a webrowser and pasting into
                    a new sheet causes permanent auto-formatting and other
                    strange behaviours
           Product: LibreOffice
           Version: unspecified
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: critical
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: pedromorgan at gmail.com


Created an attachment (id=41127)
 --> (https://bugs.freedesktop.org/attachment.cgi?id=41127)
Paste autoformats bug table

Copying a html <table> into a new sheet causes auto-formatting of cell contents
into "something else".

Attached is a sample html document and also a link here
http://m2.daffodil.uk.com/ERES.html

The area of interest is the "data table" area, headers ignored.

First column ie "Code" ends up with all strange stuff, eg dates, calcs etc.

eg
Source - copy:
100-00-5
100-01-6
100-02-7

Paste -> after
100-00-5
-657431
07/02/00

>From some quick research:
 * The "text" is formatted on paste, ie one cannot un-format it after
 * I can't make head or tail of how it makes up some of the stuff
 * changing the "formatting", setting format before etc is unaffected
 * trying to setup all various preferences didn't work.
 * not tested on Libre Office, but confirmed via IRC (circa 1am 25/12/10)

What is expected is that the cell contents are in the least, "pasteable" (pun
intended) as "raw text", that can be formatted later.

This is a Show Stopper for me.

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