I am unable to open any worksheets created after the first three in a workbook - the only workaround I have found to date is to create a new sheet following the one I wish to open and then delete it which leaves the previous sheet open but un-editable.
Based on your terminology I assume you are coming from the MS-universe. You may also have saved your spreadsheet document(s) in an alien “format” (.xls ?, .xlsx of any year / version). This is a rather good way to bad experiences. If you want to work with old Excel files in LibreOffice, convert them once to the native format (.ods in this case), and only re-export them after editing additionally to an Excel format if you need to pass a file to a remote user not knowing LibO, but still using Excel.
Somehow what you reported also sounds as if user-profile corruption might have occurred.
See LibreOffice user profile - The Document Foundation Wiki .
Thanks for response but this is not an issue. I updated Libra office from the previous version and further investigation shows that I have a hidden object in the form of a square box that covers the fourth to sixth sheet tabs and surrounding area. This appears across the Libra office products and can’t be selected. All files have been previously saved in odd format and worked ok before the upgrade. Since the upgrade I am also unable to print any files (but that may be a different issue).
Please ignore previous posts - this is now an issue across all products and may be a hardware fault
- If you have a non-Apple keyboard, you should be able to use ctrl+PgUp/PgDn to cycle through the tabbed sheets.
With MacOS on an Apple keyboard you may be able to use up/down arrow keys with a combination of modifier keys (Option/Command/shift). I don’t remember exactly. - Do you also have trouble creating new sheets, or are they only impossible to open after creation?
Post back with your findings, and also tell us your operating system and any “special setup” you may have (small screen or large zoom setting, onscreen keyboard or other accessibility setup, screen zones/virtual screens).