Bug 83675

(In reply to comment #0)
> If this spreadsheet is saved with fonts embedding enabled,

Presumably this is a reference to saving as ODS because File > Properties > Fonts tab > "Embed fonts in the document" option[1] only applies to this file format.

> those fonts are embedded but not used in that document:

Here is a quick grep of fonts used in the provided XLSX (contents of file extracted to xlsx/ directory):

$ grep --no-filename -ore "rFont[^/]*" xlsx/ | sort -u
rFont val="Arial"
rFont val="Futura Lt BT"
rFont val="Segoe UI"
rFont val="Tahoma"
$ grep --no-filename -ore "name val=[^/]*" xlsx/ | sort -u
name val="Arial"
name val="Calibri"
name val="Futura Lt BT"
name val="Segoe UI"
name val="Tahoma"
name val="WenQuanYi Zen Hei"

So both Arial and Calibri are listed as either used somewhere in the document or defined in a default style. Some of the other fonts (Segoe UI and Tahoma) seem to be used in comments.

> The font that is used in whole document is !not! embedded (Futura Lt BT)

I have tested saving the XLSX to ODS under GNU/Linux using v4.3.1.2 with the font embedding option turned on and this does indeed appear to be a problem. Fonts embedded:

- Liberation Sans
- Liberation Sans Bold
- Liberation Sans Italic
- Liberation Sans Bold Italic
- DejaVu Sans
- DejaVu Sans Bold
- FreeSans
- FreeSansOblique

Liberation Sans is the metric equivalent of Arial, so it will be a substitution (as I do not presently have Arial installed). The others I am unsure about and I am also not sure why the Futura Lt BT TTF font is not embedded (this I can confirm). Overall I feel this report is likely a duplicate of bug 65353. Platform set to All/All. Bug 65353 added to See Also list for now.

[1] This location may change, refer bug 64357.

As Unconfirmed, this cannot be in MAB, so I delete from mab4.3.
Please do not add your own unconfirmed bugs to MAB.

(In reply to squeezechart from comment #0)
> The font that is used in whole document is !not! embedded (Futura Lt BT)

Does that particular font have the embedding permission? If not, LibreOffice won’t embed it as it’d be illegal.

To check a font’s permissions, use this tool: https://www.microsoft.com/typography/property/fpedit.htm

(In reply to Adolfo Jayme from comment #3)
> (In reply to squeezechart from comment #0)
> > The font that is used in whole document is !not! embedded (Futura Lt BT)
> 
> Does that particular font have the embedding permission? If not, LibreOffice
> won’t embed it as it’d be illegal.

In my test (comment 1) the version of this TTF I used (v1.52 / 1993 from Bitstream) has, in FontForge, the Embeddable field set to "Editable Document" with both options No Subsetting and Only Embed Bitmaps unchecked. That would seem to imply it is possible to embed the version I tested with, yes? This may mean that at least in terms of this font not being embedded, this bug is confirmed. I can email the font Adolfo if that will assist.

I had the Problem with the font 'Segoe UI light'. All .ttf-Files of the Segoe UI family are marked 0x0008 (editable embedding, http://www.microsoft.com/typography/otspec/os2.htm#fst), and some segoeui?.ttf files are embedded, but not the segoeuil.ttf.

thx!