Bug 157415 - Import & Export mechanism for the font substitution table
Summary: Import & Export mechanism for the font substitution table
Status: RESOLVED WONTFIX
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
7.6.0.3 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 158589 (view as bug list)
Depends on:
Blocks: Font-Substitution DoAsMacro
  Show dependency treegraph
 
Reported: 2023-09-24 16:25 UTC by Eyal Rozenberg
Modified: 2023-12-08 21:49 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Substitution table extension (4.40 KB, application/vnd.openofficeorg.extension)
2023-10-02 06:51 UTC, Jean-Francois Nifenecker
Details
Substitution table documentation (122.24 KB, application/vnd.oasis.opendocument.text)
2023-10-02 06:52 UTC, Jean-Francois Nifenecker
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Eyal Rozenberg 2023-09-24 16:25:16 UTC
Users may want to share a font substitution table. At the moment, the two possibilities seem to be:

1. Manual copying and insertion by the user.
2. Locating the physical store on disk of where this table is stored, figuring out its format, copying it out, and making sure it can be inserted instead of another one in the target profile.
3. Some kind of profile backup/export mechanism... is that even a thing? Plus, it might destroy the rest of the target profile.

None of these are adequate.

A user should be able to export their font substitution table to some simple format (CSV perhaps?) and import from CSV, either replacing the current table or performing a union of their current table with the table in a given file.
Comment 1 Heiko Tietze 2023-09-26 10:41:22 UTC
Have you checked Bugzilla for duplicates? I remember a discussion that concluded in https://design.blog.documentfoundation.org/2018/02/18/improvements-font-listing/ with some references.
Comment 2 Heiko Tietze 2023-09-27 05:14:51 UTC
Import/Export of the font substitution has not been requested before. But I doubt it is a common workflow.
Comment 3 Eyal Rozenberg 2023-09-27 06:40:55 UTC
(In reply to Heiko Tietze from comment #2)
> Import/Export of the font substitution has not been requested before. But I
> doubt it is a common workflow.

It's not common because using font substitutions is unfortunately not common.

Remember Italo's blog post about this?:

https://blog.documentfoundation.org/blog/2020/09/08/libreoffice-tt-replacing-microsoft-fonts/

how would someone adopt his suggestions?
Comment 4 Heiko Tietze 2023-09-27 06:47:25 UTC
I suggest to defer this to an extension. See also Justin's presentation at https://events.documentfoundation.org/libreoffice-conference-2023/talk/TCJAU7/
Comment 5 Eyal Rozenberg 2023-09-29 20:56:03 UTC
(In reply to Heiko Tietze from comment #4)
> I suggest to defer this to an extension. See also Justin's presentation at
> https://events.documentfoundation.org/libreoffice-conference-2023/talk/
> TCJAU7/

I... don't have a strong argument about that. An extension could work. Without an extension, one can in principle do it manually, inconveniently. I don't have a good enough notion of what should be relegated to an extension, so - you decide.

However - I don't see how any of the resolution modes describe the decision to relegate to extension. You could say it's WONTFIX, but - shouldn't there be some differentiation between that an extension relegation?
Comment 6 Jean-Francois Nifenecker 2023-10-02 06:51:43 UTC
Created attachment 189938 [details]
Substitution table extension
Comment 7 Jean-Francois Nifenecker 2023-10-02 06:52:42 UTC
Created attachment 189939 [details]
Substitution table documentation
Comment 8 Jean-Francois Nifenecker 2023-10-02 06:55:50 UTC
Starting from Italo's blog article I had created an extension for my own use and, primarily, for learning ("how to create a settings-only extension").
I have attached it to, along with some documentation. The font settings are in settings.xcu.

If anyone feels like adding import/export functionality, go for it!
Comment 9 Eyal Rozenberg 2023-10-02 08:03:21 UTC
(In reply to Jean-Francois Nifenecker from comment #8)

Hello JF,

Nice extension! But - I think it's better to post a link to the extension webpage than attach it here. Also, what happens if someone manually changes the font substitution table after having installed your extension, removing a substitution the extension has added?
Comment 10 Jean-Francois Nifenecker 2023-10-02 08:27:03 UTC
(In reply to Eyal Rozenberg from comment #9)

Eyal,

I can't point to any webpage, since there's none :)
As said, this was created for my own internal use and learning purposes. Thus, it was not published anywhere.

Removing (or changing) a substitution added by the extension is possible.

The only drawback of settings extensions is that -- when installed under user account -- its removal causes all settings to disappear even though manually modified.
Comment 11 Heiko Tietze 2023-10-02 08:32:17 UTC
Without having looked into the extension I suggest to make the patch work similar to the custom palette export [1]. Meaning what has been defined on a workstation is read from the registry and exported into an extension that can be read on every other system. Would be great if you take care, Jean-Francois.

[1] https://extensions.libreoffice.org/en/extensions/show/custom-palette-eport
Comment 12 Eyal Rozenberg 2023-10-02 08:40:57 UTC
(In reply to Jean-Francois Nifenecker from comment #10)
> I can't point to any webpage, since there's none :)
>
> As said, this was created for my own internal use and learning purposes.
> Thus, it was not published anywhere.

I would still consider publishing it and marking it as a beta, or 0.0.something version, on https://extensions.libreoffice.org/

Your call of course.
Comment 13 Heiko Tietze 2023-10-16 06:29:21 UTC
Jean-Francois submitted https://extensions.libreoffice.org/en/extensions/show/41990 meanwhile.
Comment 14 Jean-Francois Nifenecker 2023-10-16 14:53:32 UTC
Eyal, Heiko,
Yes, I've uploaded the table substitution extension.

It remains to create a new extension to export/import the substitution table settings. I'll think to this when I've got time, thus by the end of year, following the custom palette export example.
Comment 15 Jean-Francois Nifenecker 2023-10-29 12:38:16 UTC
Eyal, Heiko,

the extension has now been published: https://extensions.libreoffice.org/en/extensions/show/42001

Thanks again, Heiko, for your help.

Best regards,
Comment 16 V Stuart Foote 2023-12-08 21:49:26 UTC
*** Bug 158589 has been marked as a duplicate of this bug. ***