<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 XLSX Conditional formatting range is lost if it is applied to a whole column"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113621">113621</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILESAVE XLSX Conditional formatting range is lost if it is applied to a whole column
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.2.2 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>Keywords</th>
<td>filter:xlsx
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Chart
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>kelemeng@ubuntu.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=137501" name="attach_137501" title="Example file from Excel 2013">attachment 137501</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=137501&action=edit" title="Example file from Excel 2013">[details]</a></span>
Example file from Excel 2013
The range of a conditional formatting applied to a whole column in Excel 2013
is lost when the XLSX file is opened in LibreOffice Calc and saved as XLSX.
Steps to reproduce:
1. Create a new spreadsheet in Excel 2013.
2. Select a whole column and apply a conditional formatting rule to it.
3. Save the file as XLSX and close Excel.
4. Open the file in LibreOffice Calc and save it as XLSX.
5. Reload the file.
Actual results:
While the rule for the conditional still exists, the range is lost, and
therefore it isn't applied anymore.
Expected results:
The conditional formatting rule and range should be fully preserved.</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>