Possible bug in Calc involving saving embedded fonts and filesize oddities

English
,
#1

Hi,

I’ve recently started using the features to embed fonts in a calc spreadsheet - selecting both options in the properties-fonts tab. Usually I get a filesize of ~12MB when saving this document. But every once in a while it will come out as ~1.3MB. If I resave without closing the document, it will save out the smaller size again. I have to exit out of the document, reopen it, then resave it - and it will then come out as ~12MB again.

Sadly, I have not been able to find a way to reproduce it on command though. So I haven’t tried filing a bug report yet.

I started using the feature around LO 24.2.4 or so, and it has been in every version since: LO 24.2.5, and even the beta LO 24.8.0.1. The main font I’m using is Calgary.

Is anyone else able to find such filesize oddities when saving embedded fonts?

#2

I wonder why you want to embed a font for a spreadsheet?

For me, embedding fonts increases the size of my test spreadsheet from 31 KB to 26163 KB as I have too many fonts installed. I suppose the checkbox to embed only the used fonts isn’t working properly. You should report a bug, How to Report Bugs in LibreOffice - The Document Foundation Wiki

I’m not sure whether embedding a font in a spreadsheets counts as a template but it sure increases to licence fee for Calgary if it does, it goes from $15 to $500

#3

Where did you get these strange versions from?

#4

Oops, I meant the beta 24.8… Corrected in OP.

#5

It’s a spreadsheet for public use, so I want to try and make sure it looks the way I intended - for wherever it might go.

#6

imho it is always better to publish a PDF.

#7

It needs to be a spreadsheet. It’s a calculator and database of sorts.

#8

I was about to try doing that, but it seems like they almost required reproducible steps - so I opted out of that.
For now, I’m going to try using just the one option for embedding all, as opposed to the “only fonts used in document” option. I think that might be what I want anyways since I’m under the suspicion that they mean only the characters of the fonts currently being used, if I would check that 2nd option. The filesize went from ~12MB to ~15MB. But, storage is cheap.

#9

No we don’t. We mean font files as they exist on your system (the only place where subsetting works is in PDFs).

Well, without these steps, you are free to file a bug of course - but it would be useless.

#10

I’m not up to par on font lingo. But there are a whole ton of fonts on my system. My document only uses two fonts. So why is there only a difference of about 3MB when I add the second option to it? I would think the file would be far bigger, as there seems to be about a hundred fonts on my system.

Those were my thoughts, exactly.

#11

Because neither option tells about all fonts of your system (why would somebody have an idea that we might grab all unrelated stuff from your computer inside the document!). Both are about fonts that are mentioned somewhere in your file; the difference is where: the second “Only embed fonts that are used in documents” option (what an awful name!) restricts the list to those that are not just mentioned in styles, but they must be applied to content (directly or through styles). I.e., if you have styles that are not applied to some content (e.g., cells) - like when you create templates, and have styles that could potentially be used, - then the fonts of those specific styles won’t be taken into account when embedding fonts, if the second option is enabled. Note that the content (like cells) doesn’t have to have actual text. The fact that an empty cell has some font applied, already makes that font used.

2 Likes
#12

Ah ok, I think I’m starting to get it now. I’ll have to digest this again later, as I’m about to go to bed - so I’m a bit fuzzy. And yeah, it certainly sounds like a bad name now.

Saw that you’re a developer, and I just got to thank you for what all you guys have done with LO. It’s quite breathtaking what has been accomplished. :+1:

1 Like
#13

Maybe change to Spectral (Extra Light) or Forum font from Google fonts

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.