Bug 150750 - LibreOffice Calc does not preserve zoom settings
Summary: LibreOffice Calc does not preserve zoom settings
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
7.3.5.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-09-02 07:14 UTC by Phaedrus
Modified: 2022-09-06 13:49 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Phaedrus 2022-09-02 07:14:29 UTC
Display zoom settings are not preserved.

This is quite annoying - requiring the user to use Ctrl+MouseWheel each time they close and reopen a sheet.

Clearly the setting made by the last Ctrl+Wheel adjustment should be saved and automatically reapplied.

This should be a global calc attribute (i.e. not for each workbook/sheet file).

It's easy to repro:

1. open an .xlsx sheet file
2. use Ctrl+wheel to modify zoom
3. close the sheet
4. reopen - the sheet is back to looking how it did prior to the adjustment
Comment 1 Phaedrus 2022-09-02 07:29:32 UTC
Further research reveals that the zoom setting *does* get preserved. But per file.

This is still little annoying. I have 100s of finance files based on very similar templates, I need to rezoom then resave each one in order that this setting persists.

Hmm.
Comment 2 Rafael Lima 2022-09-02 19:50:35 UTC
(In reply to Phaedrus from comment #1)
> Further research reveals that the zoom setting *does* get preserved. But per
> file.

Indeed this is a feature of LO Calc. It saves zoom settings in the file on a per sheet basis. TBH I find the current behavior very useful. Different sheets required different zoom levels and if they don't get saved to the file, then you'd have to zoom in/out again on the same file/sheet all the time.

My take -> WF
Comment 3 Heiko Tietze 2022-09-05 07:57:51 UTC
To restore the zoom factor per document you need to set a user name in Tools > Options > User Data first.

I wonder if this information should be added to https://help.libreoffice.org/latest/en-US/text/shared/01/03010000.html, for instance.
Comment 4 Phaedrus 2022-09-06 12:50:20 UTC
However, what I have also been noting, which is kinda related, is that when starting a "New" sheet, i.e. Untitled I'm always given a sheet with tiny cells that need zooming up.

Calc does not persist this "New" sheet setting. I appreciate this maybe trickier as its not something that can be associated with a docs properties, it is nonetheless an irritating feature.

Can this be fixed?
Comment 5 Rafael Lima 2022-09-06 13:49:12 UTC
(In reply to Phaedrus from comment #4)
> However, what I have also been noting, which is kinda related, is that when
> starting a "New" sheet, i.e. Untitled I'm always given a sheet with tiny
> cells that need zooming up.
> Can this be fixed?

Try this solution. It works for me.

https://askubuntu.com/questions/431817/calc-always-have-to-zoom-in