Bug 163765 - XLSX with conditional formatting saves styles under different names
Summary: XLSX with conditional formatting saves styles under different names
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, filter:xlsx, regression
Depends on:
Blocks: Calc-Styles
  Show dependency tree / graph
 
Reported: 2024-11-04 18:27 UTC by Timur
Modified: 2024-11-09 20:09 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Timur 2024-11-04 18:27:09 UTC 
Use XLSX attachment 197403 [details] from 163667.
On open, see that styles are named ConditionalStyle_1, ConditionalStyle_2 .. ConditionalStyle_41.
After save and reopen, the styles are named ConditionalStyle_35 .. ConditionalStyle_75.
Seems regression in LO 7.2.
Comment 1 Timur 2024-11-05 08:37:56 UTC 
Started from this useful fix, not sure if can be changed.

commit c1e156e16d3f2a0c1393332b3ad3a20a267ab936	[log]
author	Vasily Melenchuk <vasily.melenchuk@cib.de>	Thu Sep 30 17:50:16 2021 
committer	Xisco Fauli <xiscofauli@libreoffice.org>	Mon Oct 04 14:08:51 2021 

tdf#142578: xlsx export: use continuous numbering for dfx nodes

Since all dxf records are stored in one place it is required
from color filter and conditional formatting to use continuous
numbering for dxf structures to avoid id collision.
Comment 2 Gabor Kelemen (allotropia) 2024-11-09 20:09:24 UTC 
Confirming behavior in

Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 9e3803ae438ddcf91ec0e15431be379561d28ba6
CPU threads: 14; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: default

Since these names are generated at runtime in Calc, it would be better to keep the number written to the file at the same as before.