<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Incorrect colors imported from XLS with conditional formatting (XLSX is okay)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=106734#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Incorrect colors imported from XLS with conditional formatting (XLSX is okay)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=106734">bug 106734</a>
from <span class="vcard"><a class="email" href="mailto:tom1williams@yandex.com" title="tom1williams@yandex.com">tom1williams@yandex.com</a>
</span></b>
<pre>I have a similar, maybe more serious problem. In my job I must add data to a
corporate XLSX file with color related conditional formatting. Every time I
saved that file as XLSX in any version of Libre Calc prior to 5.4, all of the
colors and conditional formatting were lost.
My work around was/is awful. I have to download the file on my Linux system,
yank out the cat5 cable, reboot into an unpatched copy of Windows, use an
unpatched copy of MS Office to enter the data, reboot into Linux, re-insert the
cat5 cable, upload the file, and repeat this process at least monthly.
In my daily work all other XLSX files have no issues, but then they have no
colors related conditional formatting. Recently I upgraded to Libre Office 5.4.
Then I accidentally edited and saved that one special corporate XLSX file. I
was shocked to find that the colors related conditional formatting seems to be
intact!
Could someone please confirm that there was a fix made to saving colors related
conditional formatting in XLSX files between 5.3 and 5.4? If confirmed this may
be my big chance to get rid of the old MS software.</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>