<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 - FILESAVE: Stop storing empty cells"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144521">144521</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILESAVE: Stop storing empty cells
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.2.0.4 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>enhancement
</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>robert@prino.org
</td>
</tr></table>
<p>
<div>
<pre>This is not a bug, and it's very well hidden by the fact that ODS files are
effectively ZIP files.
When working with a test file, I inserted columns/rows, deleted columns/rows,
changed the format of entire columns/rows, and eventually decided to have a
look at "content.xml" and where the XML writer does some (pretty minimal)
optimisations, for storing repeated cells, but it misses out on plenty cases,
where the resulting "content.xml" contains code like:
<table:table-cell table:number-columns-repeated="11"/>
<table:table-cell table:number-columns-repeated="45"/>
<table:table-cell table:number-columns-repeated="724"/>
</table:table-row>
In other words, a row that ends with 780 empty columns, that are still "stored"
in the file, and need to be parsed when reading it in. Same happens for rows,
with is an order of magnitude worse, as there can be a million of them.
It would/might be nice if the XML writing code could stop this from happening.</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>