Created attachment 197091 [details] sample file 1. Open attached document ( this document comes from sc/qa/unit/data/xlsx/complex_icon_set.xlsx ) 2. Save to ODS 3. Open the new generated file -> Conditional formatting has changed. See screenshot Reproduced Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 693b230aed7b1ca5b6f1a95ed1a76d938f5a6645 CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: gtk3 Locale: es-ES (es_ES.UTF-8); UI: en-US Calc: threaded
Created attachment 197092 [details] before vs after roundtrip
Version: 6.4.0.0.alpha1+ Build ID: 9bc848cf0d301aa57eabcffa101a1cf87bad6470 CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: gtk3; Locale: es-ES (es_ES.UTF-8); UI-Language: en-US Calc: threaded
The problem seems to be that, when importing (i.e. before even re-saving as ods), the specific icon set that is actually shown does not match the icon set that is selected in the drop-down list in the CF dialog. For example, the "3 arrows" icon set is displayed on the main area for cells B2:B6, but the CF dialog shows the "5 quarters" icon set in its drop-down list. Additionally, the specific values for the scale of icon set are not imported in the CF dialog, which makes the scale fail (i.e. the same icon would be shown for all values in the range of cells). For cells D2:D4, the drop-down list selects the "3 Gray Arrows" icon set, which is not what is being displayed on the main area. In this case, there are values for the scale of icons. I don't know whether the values are correct. I have no idea whether the problem is already created when generating the original xlsx file, or whether instead the problem is generated when importing/opening it with Calc. Between the specific icon set, and the values for the scale, there seem to be more than one problem (at least with attachment 197091 [details]).
repro Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 693b230aed7b1ca5b6f1a95ed1a76d938f5a6645 CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded Version: 5.2.0.0.alpha0+ Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53