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.
