as i said in the title, im new to using OnlyOffice (Community Version, Windows Version), but im not really a big fan of the default look of the spreadsheet’s cells.
rather than manually changing the border colors every time, is there a way for me to change the default color automatically?
Hello @DBManga
Do I understand it right that you’re using the Desktop app? If so, this guide will help: Changing the default document templates in the Desktop Editors
The point is that the app uses pre-made template each time you create a new file, so you can modify this template.
thanks. though its a bit annoying i cant change the default for existing files i openned with OO after i made them, but i understand that’d be more complicated
Yes, unfortunately, we cannot change such settings for existing files since they are opened ‘as is’.
However, probably there’s a workaround. For example, if you’re confident that some new incoming files (existing files) share certain patterns (for example, same font, font size or background color of a cell, etc.) and you want to modify them, you could use docBuilder methods before opening the files in the editor to rebuild them without using the editor itself in your way. or you could apply changes immediately when a file is opened for the first time using macros.
Useful links:
Overview | ONLYOFFICE - general information
Text document API | ONLYOFFICE - samples of methods for docx files
Spreadsheet API | ONLYOFFICE - for xlsx files
P.S. I’m not sure how useful this way would be, since I understand that the incoming files would need to have similar formatting to be modified this way.