[Libreoffice-bugs] [Bug 141697] Conditional Formatting being randomly undone when files are saved

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Thu Apr 15 11:06:58 UTC 2021


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

--- Comment #4 from lcfreitasf at gmail.com ---
(In reply to Uwe Auer from comment #2)
> (In reply to lcfreitasf from comment #0)
> > Description:
> > I have a spreadsheet with 5 different types of conditional formatting in
> > some columns.
> > 
> > The program simply does not save the styles you choose for each condition.
> > When you close and open the software again, your choices are preserved, but
> > the styles you picked/created are substituted by at style with the same
> > characteristics named "ConditionalStyle_1" (and subsequent numbers).
> > 
> 
> 
> "ConditionalStyle_1" - this makes me assume you save using .xlsx (MS Excel)
> format or at least your file has a history with MS Excel (Created by Excel /
> converted from Excel format)? If yes - then your observation is a
> consequence of the conversion process from one document mode into the other
> and from my perspective not a bug.
> 
> Did you try so save in LibreOffice ODF format (.ods)?

You are correct that it is a .xlsx file, but I never used MS Excel to create,
open or edit the document, only Libre Office. I will try saving in .ods.

-- 
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/20210415/00474ce9/attachment.htm>


More information about the Libreoffice-bugs mailing list