Description: I use multiple worksheets in a workbook, Usually about 50, sometimes more. So my Calc screen has a row of worksheets, some visible, some not. All normal operation. Scrolling works fine. Issue is, when working some of the final worksheets(say 40 through to 50, out of 50), wanting to keep worksheet 40 as the active one on re opening Calc, Calc re opens with Worksheet 40 at the end of the row, so 41-50 are hidden by the scroll bar. Is there a way to set a save last view, so that I can have worksheet 40 as the active sheet on opening Calc again, but also that the last worksheet in the row is my final worksheet(in the example above worksheet 50) Ie. if there is setting for saving Calc to view exactly as it was closed, rather than it defaulting to my active worksheet being the last one in the row. My current work around is that I edit my worksheet, then highlight the last worksheet as the active one. Would be nice if Calc could be set to open exactly as it was closed. Haven't used Excel for many years now, my last version was 2010 I think, but I do remember it opens a new session exactly as last saved and closed. TIA, Arthur. Actual Results: Editing sheet 40, but have worksheets 30-50 in view on the worksheet tab list. Preference is to view these last sheets, primarily 40-50. Save the work done on sheet 40, and would prefer Calc to maintain this view for the next session. Re open Calc, but now sheet 40 is the last sheet now in view in the worksheet tabs row, and it displays sheet 20-40, not XX through to final. Expected Results: Would hope that on re opening Calc it would display on screen, exactly as it was last saved/closed, but doesn't. Reproducible: Always User Profile Reset: No Additional Info: Not sure if this is a bug, or just not programmed in this manner. All other functions work as expected, saved worksheet is fine, no data loss .. just not respecting the last screen view on exiting the program.
Hello Arthur, LibreOffice opens the last sheet displayed while saving. Save the document before you close it. Closing as RESOLVED NOTABUG
Hi Xisco, You misunderstand the report description. And I think it's not a bug, but a programming anomaly anyhow. But the issue is that when I have any sheet open other than the last one and save my work, on re opening Calc, it's the worksheet scrollbar that doesn't display as it was closed. That is the specific issue is that if you have enough worksheets tabs where they scroll off Calc's window, the active sheet is always the final worksheet tab in the scroll list, and not the last tab itself, as I set the scroll area to show. eg. if I have 50 worksheets, and I can see 25 worksheet tabs any any one time due to my page sizing, when I work on worksheet #25 or 26, and manually scroll the worksheet tab scroll area so that Sheets 25 - 50 are in view, then save my work on sheet 25 .. on re opening Calc, the tab for sheet 25 is the last in the scrolling area, not sheet 50 as I had scrolled the bar to show! The window should display workeets 25 - 50 in the scrolling tab area, but what it does display is worksheets 1-25 instead. The program will respect all of the settings on save and exit except for the position .. exact position! .. of the worksheet scrolling area where it scrolls off the page view. So just to be sure, the opened page view is not an issue. As you say, last active sheet is opened again on resumption .. no problem there. But it is the scrolling area of the worksheet that doesn't display as it was saved and closed. If you would like, is there a way for me to upload screen shots of the issue?
I think this might confuse users. Imagine if you are sharing a Calc document with someone else. Now they would be like "where is the active tab??" as the tab list would show a completely different section of tabs. Let's ask UX if they agree to close this as WONTFIX
(In reply to Buovjaga from comment #3) > I think this might confuse users. Imagine if you are sharing a Calc document > with someone else. Now they would be like "where is the active tab??" as the > tab list would show a completely different section of tabs. > > Let's ask UX if they agree to close this as WONTFIX Yep, I get that, and this is why I specified in my OP, that it'd make more sense to have a user defined global setting that respected either as it currently stands, that is active worksheet reopens at the end of the tabs list, or the user can decide if they'd prefer to reopen the workbook as it was last closed(ie. my preferred option). And technically it would show a completely different section of tabs, the active sheet is usually the last thing someone would edit and then shut down, so it'd normally still be there as the last person left it. The difference is that if it were on the far left of the screen whilst being edited, then on next session it ends up on the far right of the sheet tabs .. this is 'confusing' ... when viewing the range of sheet tabs along the bottom, this is confusing .. ie. not where I left it last time! Most software I use(not all, but most) usually restarts the same way it was closed down.
We had a similar discussion for Writer where we store not only the cursor focus but the exact position (not working with flat ODT). I don't see a reason why Calc should behave differently. Vaguely remember the same argument about other readers, maybe it#s bound to the user profile.
(In reply to Heiko Tietze from comment #5) > We had a similar discussion for Writer where we store not only the cursor > focus but the exact position (not working with flat ODT). I don't see a > reason why Calc should behave differently. Vaguely remember the same > argument about other readers, maybe it#s bound to the user profile. +1 Is this info saved in the document or in the user profile for Writer documents?
(In reply to Buovjaga from comment #3) > I think this might confuse users. Imagine if you are sharing a Calc document > with someone else... Writer restores the position only when the author of the document matches the options. Should be the same in Calc.