Every time when I open new document in Libre Office Calc, the cells are too small so every time I have to zoom in with CTRL+scroll wheel UP; (See the picture below)

enter image description here

How can I set the most acceptable view for me (but not only for one document, I want larger cells every time I open new blank document)?

  • Close all CALC windows
  • open a new one
  • Go to bottom right slider and move it to 100% (or whatever value you need)
  • Close CALC
  • open it again; cells are now in correct size :)

you can also do it from Menu > View > Zoom

| improve this answer | |
  • that was easy :D – Wilf May 6 '15 at 21:46
  • @Wilf Anytime :) – Ahmadgeo May 11 '15 at 18:20

Go to Tools -> Options -> LibreOffice -> View and reset the Scaling option to 100%. Yours appears to be set at 22%.

To quickly reset the scaling for any open sheet, double-click on the display percentage at the bottom-right of the window (next to the scaling slider) to bring up the Zoom & View Layout dialog.

| improve this answer | |
  • - Minimum value for above mentioned option is 80% and it will affect scaling allover CALC. - Correct answer is to manually change Zoom level (not scaling) either manually from the slider or from Menu > View > Zoom – Ahmadgeo Mar 9 '14 at 17:21

What you describe makes me think of a broken template. I'd suggest to create a new one and set it as your default Calc template:

  • Open a Calc document, adjust the zoom level to 100%
  • Save the document by choosing File - Save As Template and saving the document in the My Templates category.
  • Choose File - New - Templates.
  • Double-click My Templates in the list. You will see the user-defined templates in the user directory specified under Tools - Options - LibreOffice - Paths. Select the template you have just saved.
  • Choose Set as default. The next time you open a new Calc document, the new spreadsheet will be based on the new default template.
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.