[Solved] Save spreadsheet width to open to same size

tmihalic · Post by **tmihalic** » Wed Sep 01, 2021 4:25 pm

When I open a spreadsheet and size it for the width of the spreadsheet and save it, the size stays the same until I open another spreadsheet with a different size and then the original one opens to the latest spreadsheets size. How can I save a spreadsheet to always open to the same width (size)?

Tmihalic

Post by **Zizi64** » Wed Sep 01, 2021 9:10 pm

Do you mean the ZOOM-factor?

Fill-in the personal data in the settings, and the Calc will remember the last zoom value of the documents.

tmihalic · Post by **tmihalic** » Wed Sep 01, 2021 9:17 pm

Sorry, I'm new to Open Office. Where is personal data? I filled in Preferences/OpenOffice/User Data. Is that what you are referring to? I don't see anything about ZOOM values..

Post by **Hagar Delest** » Thu Sep 02, 2021 7:58 am

tmihalic wrote:I filled in Preferences/OpenOffice/User Data. Is that what you are referring to?

Yes, that's it.
There is no filed for the zoom value. User data are stored in the files (see menu File > Properties) based on the application user data you've filled-in. When then match, the "custom settings" like zoom level is restored at its latest stored value.

tmihalic · Post by **tmihalic** » Thu Sep 02, 2021 1:45 pm

I'm sorry. I'm confused. Where is the zoom level set. This isn't making sense. Please bear with me, I'm new to Open Office and haven't figured this out. Please help.

Post by **robleyd** » Thu Sep 02, 2021 1:53 pm

Zoom is modified via View | Zoom; or by using the slider on the right of the status bar at the bottom of your AOO window; or by right clicking on the zoom percentage shown to the right of the slider.. Use View | Status Bar if the status bar is not displayed.

: oocalc_zoom.jpg (9.84 KiB) Viewed 3195 times

tmihalic · Post by **tmihalic** » Thu Sep 02, 2021 2:46 pm

It might be that my question isn't clear. I have one spreadsheet that is 5 columns wide. Another that is 10 columns wide and another that is 22 columns wide. If I open the wide one, modify it and save it, then open the first 5 column wide spreadsheet, the window open as wide as the window for the 22 column spreadsheet. How can I set it to open to just the 5 columns wide? After using that 5 column wide shee. Then go back to the 22 column wide sheet, the whole spreadsheet doesn't show until I drag the right side of the window all of the way to the right side of the sheet.. Adjusting the size in the lower right corner adjusts the size of the columns, type size, etc. I want to save the physical size(left to right) of the spreadsheet so that it opens the same everytiome, yet doesn't affect other spreadsheets. Hopefully this helps. (By the way, this is the way it works in Excel). Thanks for your help.

Post by **Zizi64** » Fri Sep 03, 2021 7:28 am

I have one spreadsheet that is 5 columns wide. Another that is 10 columns wide and another that is 22 columns wide.

Do you mean the filled-in columns, or the visible columns in the (resized and/or zoomed) application window, or the hided/unhided columns??

(All of the Sheets are 1024 columns wide really in the AOO Calc.)

[Solved] Save spreadsheet width to open to same size

[Solved] Save spreadsheet width to open to same size

Re: Save spreadsheet width to open to same size

Re: Save spreadsheet width to open to same size

Re: Save spreadsheet width to open to same size

Re: Save spreadsheet width to open to same size

Re: Save spreadsheet width to open to same size

Re: Save spreadsheet width to open to same size

Re: Save spreadsheet width to open to same size