How-to change the default font in spreadsheets (xlsx docs)

Docs
,
1

How do I change the default font for my spreadsheet documents?
For docx, the instructions are to update the default font in the ‘new’ template. Do I do the same for xlsx docs? My “opt” folder is empty. Should I create a “new.xlsx” with my desired font and create the following directories: “/opt/onlyoffice/desktopeditors/converter/empty”?
I’m using onlyoffice 8.2.2 on a Mac with OS v.16.2.
I appreciate your help.

2

Hello @killkill

Can you share this instruction for better understand of what you are referring to?

In general, yes, it works the same way as with DOCX documents.

3

I found directions at this forum link for updating the default font in the ‘new’ template, and they worked for me in the past for .docx docs: Permanently change default font - #2 by Alexandre

V.1

  1. In a terminal as root (sudo) I backed up the original /opt/onlyoffice/desktopeditors/converter/empty/pt-BR/new.docx to new.docx.orig.
  2. I then opened new.docx.orig in OnlyOffice, changed it to the settings I want and then tried to save, but it wouldn’t let me.
  3. I closed without saving.
  4. I opened a terminal window and started OnlyOffice as root (sudo onlyoffice-desktopeditors).
  5. I opened new.docx.orig.
  6. I then was able to save the file as new.docx.
  7. After I closed OnlyOffice as root and opened it again as a non-root user, the new document opened fine with the new settings.

V.2
I think there’s a shorter way to achieve it;

  1. sudo chmod -R 775 /opt/onlyoffice/desktopeditors/converter/empty/
  2. Copy new.docx file to another location > edit it and replace back.It worked this morning during the tests, but your way seems to work too.
4

These are for Linux and derivatives. Pretty much the same procedure, but on macOS these files are located inside the application folder. You can access them like that:

  1. Open Finder > Applications;
  2. Find ONLYOFFICE.app > right-click it > Show Package Contents;
  3. Move to Contents/Resources/converter/empty.

Then you can choose for which locale you’d like to change default templates.

Note: upon an update the package will be reset, make sure to store copies of your custom templates somewhere else too.