<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, FORMATTING: xlsx file with conditional formatting created in Excel roundtripped by Calc does not look the same in Excel again"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124953">124953</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILESAVE, FORMATTING: xlsx file with conditional formatting created in Excel roundtripped by Calc does not look the same in Excel again
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.0.0.alpha0+ Master
</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>normal
</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>dennisfrancis.in@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
The attached file is created from scratch in Excel. Opening this in Calc and
saving it as another xlsx file and opening this new xlsx file in Excel shows
misplaced conditional formatting colors.
Steps to Reproduce:
1. Open the attached xlsx file in Calc
2. Notice that B5 and G2 have green background via conditional formatting.
3. Save this as a new xlsx file.
4. Open this new file in Excel.
5. Observe the background color of cells B5 and G2. Also observe background
color of B4.
Actual Results:
Cells B5 and G2 do not have green background anymore, where as B4 is now
colored green !
Expected Results:
Cells B5 and G2 must have retained the green background and B4 should not have
any background color for the round-tripped file when viewed in Excel.
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Version: 6.3.0.0.alpha0+
Build ID: 74a7b890524af4a52e711d8f0793ce844ded0948
CPU threads: 8; OS: Linux 5.0; UI render: default; VCL: gtk3;
Locale: en-US (en_US.utf8); UI-Language: en-US
Calc: threaded</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>