<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - FILESAVE: No Data Validation in Saved XLS and XLSX"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=41425#c17">Comment # 17</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - FILESAVE: No Data Validation in Saved XLS and XLSX"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=41425">bug 41425</a>
from <span class="vcard"><a class="email" href="mailto:tdf@mspacek.mm.st" title="Martin Spacek <tdf@mspacek.mm.st>"> <span class="fn">Martin Spacek</span></a>
</span></b>
<pre>This comment by Aron Budea sounds like a promising start at narrowing down the
root cause in the code:
<a class="bz_bug_link
bz_status_NEW "
title="NEW - FILESAVE XLSX: Validity setting not saved for otherwise empty rows"
href="show_bug.cgi?id=106720#c5">https://bugs.documentfoundation.org/show_bug.cgi?id=106720#c5</a>
Quoting:
The bug seems to be in XclExpCellTable::XclExpCellTable( const XclExpRoot&
rRoot ).
<a href="http://opengrok.libreoffice.org/xref/core/sc/source/filter/excel/xetable.cxx#2437">http://opengrok.libreoffice.org/xref/core/sc/source/filter/excel/xetable.cxx#2437</a>
This is where validation data is collected:
if( ScfTools::CheckItem( rItemSet, ATTR_VALIDDATA, false ) )
<a href="http://opengrok.libreoffice.org/xref/core/sc/source/filter/excel/xetable.cxx#2641">http://opengrok.libreoffice.org/xref/core/sc/source/filter/excel/xetable.cxx#2641</a>
However, the large loop in that function ends with the last row where there's
data, and in this case there's no more data in rows 4-5, so they aren't
considered: the application exits the loop before being able to take care of
the validation data there.</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>