LibreOffice Calc does not save the color code in “format cells”

kiowa · February 17, 2025, 2:05pm

Hi,
if I save I reopen my saved document with this uder-defined cell format [COLOR24]"▲";[COLOR64]"▼";[COLOR58]"▶" the format will be gone and shown as [>0]"▲";[<0]"▼";"▶"

Saved as:

After reopening:

Test.ods (64.5 KB)

Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: de-DE (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.8
Calc: threaded

Did I use the formatting options in the wrong way or is it a bug?

Flo

karolus · February 17, 2025, 2:27pm

Hallo
Formatcode:

[>0][GRÜN]"▲";[<0][ROT]"▼";[BLAU]"▶"

works for me and is persistent after reopen…

fpy · February 17, 2025, 2:34pm

maybe has to do with localization …
Number Format Codes - Color

kiowa · February 17, 2025, 3:16pm

Thanks for testing.

Like this it is persistant for me too.

But for some reasons I wanted to use those colorcodes like [COLOR64] or [FARBE64].

kiowa · February 17, 2025, 3:18pm

Maybe. Thanks for testing. I will test it on a diffrent system later.

karolus · February 17, 2025, 3:42pm

worse enough… but LO25.2 crashes immediatly on any try to apply these colorcodes