In a spreadsheet using version 7.4.7.2 I had arial 10 font and a seven digit number like 1234567 fit into a column width of 0.57" after upgrading to version 25.2.3.2 the same numbers no longer fit in the columns.
arial wasn’t installed in 7.4.7.2 and localc used another font to substitute.
Nor is it installed in 25.2.3.2 so again localc is substituring but not with the same font.
How do I determine which font is being used for the substitution?
Thanks,
Mike
For Arial, the substitution is hardcoded: it’s Liberation Sans.
Otherwise, there is a programmatic way.
This is likely a bug.
Please upload a fragment of this file that demonstrates the problem.
Here is your demo.
Arial10.ods (25.9 KB)
I’ll be curious what you see.
I found that Liberation fonts weren’t loaded by default in Trixie but installing them didn’t seem to make the difference.
Cheers,
Mike
No relation to Arial (or font substitution in general). I use 25.8.3.1 on Windows, with Arial of course, and I see that at 100%, the situation that you describe happens. It indeed depends on the zoom level.
I had a hard time finding a Linux instance where the cell contents of your file were fully visible.
Taking @mikekaganski 's comment into account, I replaced the Arial font with Liberation Sans. The difference in cell visibility between Linux and Windows remains.
Version: 25.2.6.2 (X86_64) / LibreOffice Community
Build ID: 729c5bfe710f5eb71ed3bbde9e06a6065e9c6c5d
CPU threads: 6; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: CL threaded
Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.10
Calc: threaded
The version 7.4.7.2 is on a RaspberryPI running RPI’s version of Debian bookworm, the version 25.2.3.2 is running under RPI’s version of Debian trixie.
The zoom is the same in both cases yet they don’t display the same.
I’ll compare the font files after I get back to trixie. At the moment I’m again on bookworm due to having broken trixie’s ability to get to the web while trying to replace network-manager with ipupdown access.
I’ll keep exploring because the stocks.ods file where this is really a problem has many sheets of many years data where many cells aren’t readable without changing column width.
Thanks for the feedback.
Mike
Here’s your file, with the Arial font replaced with the native Liberation Sans font. The cell contents of this file are visible in the Linux version of LO (mentioned in my previous message) but not in the Windows version mentioned above.
LS10.ods (43.5 KB)
@fpy , of the several available to me LO configurations for Linux, I have only found one in which the numbers are fully visible.
