AgTalk Home
AgTalk Home
Search Forums | Classifieds | Skins | Language
You are logged in as a guest. ( logon | register )

ReCalculate in Libre Calc Spreadsheets
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
H3f
Posted 6/12/2022 14:16 (#9701894 - in reply to #9700458)
Subject: RE: ReCalculate in Libre Calc Spreadsheets


To clarify: You need to save the "empty" spreadsheet as a template, (File, Templates, Save as Template (Shift+F11)) not as a spreadsheet. This brings up a dialog to enter templates name and category. Next step is to set the new "empty" template as the default. Go to manage templates (File, Templates, Manage templates (Ctrl+Shift+N)) and right click on newly named template select "Set as Default". Now any time you open a new spreadsheet, the headers and footers should be gone. The newly opened spreadsheet should have a title in the window bar of Untitled # and if window is closed or you try to save the spreadsheet the dialog box "Save as" will allow you to name the new spreadsheet and choose its location.

I have done this with a template that has a sheet named Info as the first sheet. This Info sheet has space for general information, common formulas, and provides a landing space for information from a macro.

PS: I think if the view zoom factor (View, Zoom, Zoom) is set to something different before saving the new default template, a new spreadsheet (Ctrl+N) will have the new zoom factor when it opens. That may be the best way for consistent easier viewing rather than changing font size. A small change 110% versus 100% may make a big difference.
Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)