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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
