[Libreoffice-bugs] [Bug 65371] FILESAVE: Cell Styles applied on Conditional Formatting change after save as XLS & reopen file

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Aug 14 16:47:16 UTC 2017


https://bugs.documentfoundation.org/show_bug.cgi?id=65371

tom1williams at yandex.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |tom1williams at yandex.com

--- Comment #9 from tom1williams at yandex.com ---
Today is the first day I learned about Bugzilla and this whole process. I put
this same comment bellow into a different bug report. I hope that is not
against the rules.

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 my old MS software.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170814/9aa9468a/attachment-0001.html>


More information about the Libreoffice-bugs mailing list