LibreOffice Spreadsheet Column Width - Number Display Inconsistency

[cpf]

Issue Description:

1. The column width of case 7 is smaller than that of case 1 but larger than that of case 2.
2. However, case 2 displays numbers in scientific notation, while case 7 displays ###.
3. If we slightly increase the width of case 7, it displays like case 1.
4. If we slightly decrease the width of case 7, it displays like case 2.
5. Case 7 only displays ### at a specific width.

Additional Notes:

• It is understandable that cases 5 and 6 display ### because their column widths are insufficient.
• However, case 7 should at least display like case 2 if its width is not as wide as case 1.

Is this a bug? Or is there a specific reason for this inconsistency?

column-width-issue.xlsx (11.1 KB)

[EarnestAl]

What version of LibreOffice are you using? Click Help > About LibreOffice and click the icon just after Version Information to copy the details, paste into your question.
.
For me it works as expected

Version: 24.8.4.2 (X86_64) / LibreOffice Community
Build ID: bb3cfa12c7b1bf994ecc5649a80400d06cd71002
CPU threads: 8; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win
Locale: en-NZ (en_NZ); UI: en-GB
Calc: CL threaded

.
[Edit]
I see you are using Noto Sans CJK HK font. I think there might be some issues with that font from memory.

[mikekaganski]

No problem using Version: 25.2.0.2 (X86_64) / LibreOffice Community
Build ID: 62af784cc06624122f17ee71c7cf13d906cbaed0
CPU threads: 24; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-GB
Calc: CL threaded

and the font from

notofonts/noto-cjk/blob/main/Sans/OTF/TraditionalChineseHK/NotoSansCJKhk-Regular.otf

[cpf]

Thanks for reply @EarnestAl @mikekaganski

Version: 24.8.0.2 (X86_64) / LibreOffice Community
Build ID: 57ceca7d2eefdf83e7c9b4135a017f3361a8133f
CPU threads: 8; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

I tried a few other fonts.

Arimo is ok.

But Carlito is not ok, which I think is a commonly used font.

Is there a guide like which fonts to avoid?