Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

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)?

share|improve this question
add comment

3 Answers 3

up vote 5 down vote accepted
  • 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

share|improve this answer
add comment

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.

share|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 at 17:21
add comment

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.
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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