[Libreoffice-bugs] [Bug 116720] New: LibreOffice Calc does not read its own HTML export attributes.

Sat Mar 31 11:44:06 UTC 2018

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

            Bug ID: 116720
           Summary: LibreOffice Calc does not read its own HTML export
                    attributes.
           Product: LibreOffice
           Version: 6.0.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mmmr7ckl at yahoo.co.uk

Description:
I'm trying to find out how to create HTML tables which can be read back by
Libreoffice consistently.

I've created cells with numbers, applied various formatting rules, e.g. date,
currency.

Libreoffice will save the cell value in the <td sdval="xx"> attribute, and save
the formatting e.g. "0.00; [RED] -0.00" in the <td sdnum="xx"> attribute.
However it does not re-read the sdnum values consistently. If sdnum is simple
"3081;0;0.00" it is parsed in. If sdnum is a custom string like
"3081;0;"Rs" 0.00" then it is ignored. 

Steps to Reproduce:
1. Create simple spreadsheet with numbers
2. Format numbers with variety of formats (especially "custom string
formatting")
3. Export to html
4. Close Calc, reopen calc, open html

Actual Results:  
1. Some formatting is lost

Expected Results:
1. Either all formatting is lost, or all valid formatting is retrieved!

Reproducible: Always

User Profile Reset: No

Additional Info:
Libreoffice could choose to save metadata in a [CDATA[]] format if it wished

User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:60.0) Gecko/20100101
Firefox/60.0

-- 
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/20180331/f816a966/attachment-0001.html>