Calc: understanding styles (problem: style not expressed)

[eteb3]

I have started using styles in Calc thanks to advice on styles in Writer from @ajlittoz

One of my styles works, one does not.

My new style “3dp” should show numbers to 3 decimal places. I double click it to apply to my selection, but nothing changes. I clear direct formatting, and double click again, but same result.

What am I doing wrong?

Thanks

3dp styles query.ods (71.4 KB)

[ajlittoz]

No problem here: Fedora 40, LO 24.2.6.2.

Attach your file for analysis.

[eteb3]

Thanks, I’ve edited the OP

[ajlittoz]

I applied the 3dp style over every column containing numbers and everything is fine. So which is the failing cell coordinate?

[eteb3]

It’s at R1:R~1000

[eteb3]

Woah, I’ve just gone back to the doc and it’s now showing the style.

(I haven’t done anything)

So it must be a visual interface update issue. Any idea what that might be?
I’m on Mac OS 12.7.6

[karolus]

@eteb3

So it must be a visual interface update issue.

maybe again you did NOT understand the difference between text and numeric-value

[Villeroy]

I open your file, hit Ctrl+F8 to highlight the numbers, select some cell range(s) having numbers and double-click your style.
What I get in column T looks like this with German decimal comma:
148,420
148,144
149,318
149,113

If I change the style’s locale from “Default” to “English(UK)” with 3 decimals, the same cells look like:
148.420
148.144
149.318
149.113

P.S. In the original version of your file, column R had 3dp applied. The cells show 3 decimal digits in in default locale context (German with comma in my case):
-3,574
-0,733
-0,458
0,092

[eteb3]

Thank you: Interesting and useful learning, but not addressing the problem I had, I think?
Or is it?

[Villeroy]

@eteb3

I double click it to apply to my selection, but nothing changes.

All I wanted to say is that it works for me (and how).

[eteb3]

Thanks. I can repeat the problem by changing decimal places to 5dp. Nothing changes visually: numbers are still shown to 3dp.

I close the file and open it again, style has updated and numbers are shown to 5dp.

EDIT: If I save the file, nothing changes. Only close then open.

I am wondering if there is a delay between the style being applied and it being expressed, because of something on my computer - maybe LO doesn’t love Mac, or my graphics processing is underpowered, or something. Is this possible?

[Villeroy]

I turned off Data>Calculate>AutoCalculation and still can not reproduce this issue. Style changes apply immediately (which I expected, since formatting is unrelated to formula recalculation)
Please, try the following steps:

• Save your work
• menu>Help>Restart in safe mode… and confirm restart
• When the “Safe Mode” dialog pops up, do not check any options. Just click [Continue]
• Open your document and check if the problem still exists.
  When you now close and restart the application, all your settings and extensions are preserved. For now, this is just a test.

[mikekaganski]

I confirm, that starting with 24.8.0, changing decimal digits of the style doesn’t reflect on the sheet. This is the same in current development branch; but it was OK in 24.2.

And most interesting, is that there is no bug report about it.