How can I change the default that is toggled on (check box) for the page formatting on Sheets. Even if I turn it off, save and close the file, the next time I open it, the default is ‘checked’ again. This is a real pain in the ass. #english #print #zero #zero-value #default-setting #default
The answer remains the same:
In detail:
From now on, every new spreadsheet is made from this template.
For further changes to this template: File>Template>Manage [Ctrl+Shift+N], right-click your default template and “Edit”. Now you are editing the template rather than a new spreadsheet made from the template.
This ‘solution’ only works for the file when first created from the template and printed. Once you save the file with its new name and then open it at a later date, the Print Zero Values default is again selected on. The core coding for initiating any sheet must be re-worked to have the default for that print setting turned off.
Your answer was not fully posted?
Let’s check this on the attached file.
The contents of cell A1 (0) are not printed to me.
NoPrintZeroValues.ods (8.9 KB)
Maybe it’s about creating a new file?
Then we can configure the default template.
What I noticed was that the default stayed as a Null until I saved the file as an .xls . Then when it is re-opened, the Print Zero is again ‘checked’.
xls is a historic file format. xls is not even the native file format of the office suite you are using. Using Excel, you would not save spreadsheets as Open Document Spreadsheet (ods), would you? For the same reasons, you have to save spreadsheets as ods when working with Calc.
In other words, the ancient file format of xls does not support the feature.
This is an important note.
Excel formats do not have a separate parameter (property) for hiding zeros when printing. If you plan to save your document in MS Excel formats, it is recommended to familiarize yourself with this material.