<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><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> changed
<a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - if I open an MS Excel XLSX file in Calc, dropdowns in cells do not show"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=94393">bug 94393</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;">Status</td>
<td>RESOLVED
</td>
<td>REOPENED
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>tdf@mspacek.mm.st
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>WORKSFORME
</td>
<td>---
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - if I open an MS Excel XLSX file in Calc, dropdowns in cells do not show"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=94393#c16">Comment # 16</a>
on <a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - if I open an MS Excel XLSX file in Calc, dropdowns in cells do not show"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=94393">bug 94393</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 bug is NOT fixed. I've tried it on two Ubuntu machines running 5.4.0.3,
one Ubuntu machine running 5.3.4.2, and a Mac running 5.0. As described
elsewhere, using LO Calc to add a validity rule of any kind (not just a list)
to a cell in an empty column, then saving it to .xlsx, then re-opening it
(whether in Excel or LO Calc), reveals that the validity rule wasn't saved at
all. However, putting e.g. a space on line 1000 of that column before saving to
.xlsx prevents the bug from arising. Presumably, for .xlsx, LO Calc doesn't
bother saving anything past the last non-empty cell in a column, even if
formatting or validity rules are applied to those subsequent cells.
This isn't a problem when saving to .ods, and I don't think it ever was.
This post sums it up nicely, and also confirms the bug still exists in 5.4.0.3:
<a href="https://ask.libreoffice.org/en/question/77843/validity-rules-are-missing-when-a-calc-file-is-re-opened/">https://ask.libreoffice.org/en/question/77843/validity-rules-are-missing-when-a-calc-file-is-re-opened/</a>
I think this is part of a more general problem: LO Calc doesn't save any types
of formatting to .xlsx, such as cell colour, after the last "empty" row, where
empty means no values entered.</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>