<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - LibreOffice Calc does not read its own HTML export attributes."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116720">116720</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>LibreOffice Calc does not read its own HTML export attributes.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.0.0.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>mmmr7ckl@yahoo.co.uk
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>