<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span> changed
<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">bug 144521</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>erack@redhat.com
</td>
</tr></table>
<p>
<div>
<b><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#c10">Comment # 10</a>
on <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">bug 144521</a>
from <span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span></b>
<pre>(In reply to robert from <a href="show_bug.cgi?id=144521#c9">comment #9</a>)
<span class="quote">> Unzip all three ODS files, format the main "content.xml" of all three with
> xmllint, compare the files with WinMerge.</span >
LOL. Compare something like *that* with WinMerge? Not everyone has that much
time.
Every report should be reasonable, allowing one to see the problem.
Anyway, likely all that was about something as easy as:
1. Create a new spreadsheet.
2. Put "1" to C2.
3. Put "1" to D4.
4. Save and inspect content.xml, to see that:
a. It has first two rows with all four repeated columns:
<span class="quote">> <table:table-row table:style-name="ro1"</span >
table:number-rows-repeated="2">
<span class="quote">> <table:table-cell table:number-columns-repeated="4"/>
> </table:table-row></span >
b. It has second row with two trailing repeated columns:
<span class="quote">> <table:table-row table:style-name="ro1">
> <table:table-cell/>
> <table:table-cell office:value-type="float"</span >
office:value="1"
calcext:value-type="float">
<span class="quote">> <text:p>1</text:p>
> </table:table-cell>
> <table:table-cell table:number-columns-repeated="2"/>
> </table:table-row></span >
c. It has the third row without trailing repeated columns.
One might notice that all three rows have four elements each. One may conclude
that there is one algorithm, taking the used rectangle, and outputting the rows
one by one, merging completely empty rows and columns into a single "repeated"
element.
One may imagine that not having those in the file would be problematic. But (1)
having more code to avoid that would make more code that can have bugs; (2) it
is unclear how robust that would be, given that e.g. ODF tells [1]:
<span class="quote">> The behavior of a consumer when a cell is referenced but not declared is implementation-dependent.</span >
which means that there *might* be complications when some cells are not
declared in the file - if not for LibreOffice (are we sure in that?), then for
some other standard-compliand consumers that have their
"implementation-dependent" behavior for such case.
Anyway, I assume this issue in its current form, without anything specific,
filled with rant, emotions, subjective opinions, but no manageable stuff, to be
INVALID.
I'm not closing it; maybe erAck has something to say?
[1]
<a href="https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part3-schema/OpenDocument-v1.3-os-part3-schema.html#__RefHeading__1415630_253892949">https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part3-schema/OpenDocument-v1.3-os-part3-schema.html#__RefHeading__1415630_253892949</a></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>