https://bugs.documentfoundation.org/show_bug.cgi?id=148489
Bug ID: 148489 Summary: Conditional Formatting with Styles creates bad style on FILESAVE Product: LibreOffice Version: 7.3.2.2 release Hardware: All OS: Windows (All) Status: UNCONFIRMED Severity: minor Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: kenneth.w.hightowe...@outlook.com Description: Simple conditional format with formula ISEVEN(ROW()) applied to range A1:AMJ1048576 (entire sheet) to apply style "Alternate" Style "Alternate" is duplicate of default with Color Light Gray 5 (#eeeeee) for background. Saveas filename.xlsx Close and reopen file. New style is created "ConditionalStyle_1" Why is a new style created at all? Steps to Reproduce: 1.Enter data in multiple cells extending a couple rows. 2.Duplicate default Style changing only background color, name Style "Alternate" 3.Apply conditional formatting 4.Save and close using xlsx extension 5.Open file and find generated Style "ConditionalStyle_1" applied to Conditional Formatting Actual Results: Style "Alternate" still exists but is no longer used by Conditional Formatting. Deleting "ConditionalStyle_1" and applying "Alternate" in Conditional Formatting creates new "ConditionalStyle_1" on filesave with white font. Fixing of font color on Style "ConditionalStyle_1" followed by filesave creates new Style "ConditionalStyle_1 1" with white font. Style "Alternate" is no longer in use. New Style generation appears after fileopen. Expected Results: Conditional Formatting retain application of original generated Style without creation of other Style. Reproducible: Always User Profile Reset: Yes Additional Info: [Information automatically included from LibreOffice] Locale: en-US Version: 7.3.2.2 (x64) / LibreOffice Community Build ID: 49f2b1bff42cfccbd8f788c8dc32c1c309559be0 CPU threads: 24; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL OS: Windows 10Pro 21H2 19044.1586 Windows Feature Experience Pack 120.2212.4170.0 OS is 64bit: yes OpenGL possible (enabled for application:unknown) 12.1 Shader 6.5 Unable to install OpenGL Extensions Viewer: Blocked by Windows SmartScreen OpenCL available and allowed -- You are receiving this mail because: You are the assignee for the bug.