I have this really weird thing going on.
I have a calc file with 250+ sheets.
If i choose any sheet tab within the first 20 or so tabs, the tab will remain in whichever position on my screen as it was when choosing.
The further down the file (say sheet tab #200), if the sheet tab is on the left of my screen, when I click said tab, it will instantly jump to the FAR RIGHT of the screen.
This is extremely annoying since this is my main program.
I have searched Libre's setting without success.
I have even removed all macros for testing, without success.
Included are screenshots demonstrating my issue (Sheet Tab #9269)
Any wisdom you can shed on this matter would be appreciated.
Before Selecting Tab:
After Selecting Tab:
Im using Linux Debian 10 with Libre Office 7.5.5.2
[Solved] Sheet tabs jump when selected
[Solved] Sheet tabs jump when selected
Last edited by MrProgrammer on Fri Apr 26, 2024 6:33 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
LibreOffice 7.5, Debian 12
Re: Sheet tabs jump when selected
Are you sure, if this the optimal solution for you task?I have a calc file with 250+ sheets.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Sheet tabs jump when selected
it is my invoicing program, which means it will grow larger in time.
why? - is it unusual for folks to have a spreadsheet with hundreds of sheets?
does a certain number of sheets screw with the programming of Libre Calc?
btw - i didnt have this problem until I upgraded from Calc Ver 5. ....so much for improving oneself..
why? - is it unusual for folks to have a spreadsheet with hundreds of sheets?
does a certain number of sheets screw with the programming of Libre Calc?
btw - i didnt have this problem until I upgraded from Calc Ver 5. ....so much for improving oneself..
LibreOffice 7.5, Debian 12
Re: Sheet tabs jump when selected
An invoicing system might be better handled using a database and reports, but it is your decision how to handle your task.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Sheet tabs jump when selected
1.
2. I can't reproduce the described behaviour with any of the few LibreOffice Portable versions I tried nor with my current "production" version 7.5.3.2 on Windows.
3. Using numbers or strings containing special characters as sheet names is a bad idea.
4. You already got the advice to consider using a database for your data and a form file for the invoices.
Anyway: Also if you want to stick to Calc for the data keeping in your case for the sake of more experience, you should keep data sets of same type in ONE sheet per record type, ONE row per record.
The invoices should be printed then based on ONE (per design if changing) sheet pulling the specific data by formulas based on a simple KEY designating the respective order or job.
Your signature tells LibreOffice 5.0.6.3 on open Suse 13.2.
2. I can't reproduce the described behaviour with any of the few LibreOffice Portable versions I tried nor with my current "production" version 7.5.3.2 on Windows.
3. Using numbers or strings containing special characters as sheet names is a bad idea.
4. You already got the advice to consider using a database for your data and a form file for the invoices.
Anyway: Also if you want to stick to Calc for the data keeping in your case for the sake of more experience, you should keep data sets of same type in ONE sheet per record type, ONE row per record.
The invoices should be printed then based on ONE (per design if changing) sheet pulling the specific data by formulas based on a simple KEY designating the respective order or job.
On Windows 10: LibreOffice 24.8.2 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
---
Lupp from München
Re: Sheet tabs jump when selected
In my opinion it is uncomfortable to handle the too many sheets.is it unusual for folks to have a spreadsheet with hundreds of sheets?
The uncomfortability is one of the sources of errors.
For example:
There are many similar sheet names. Maybe you will copy-paste some data into a wrong place...
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
[Solved}....kinda - Sheet tabs jump when selected
after endless attempts, i figured out the cause.
I had about a dozen sheets hidden, once they are "shown', the problem goes away.
now.... can you tell me WHY?
I had about a dozen sheets hidden, once they are "shown', the problem goes away.
now.... can you tell me WHY?
LibreOffice 7.5, Debian 12
- Hagar Delest
- Moderator
- Posts: 32804
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Sheet tabs jump when selected
I'm not sure we can but developers may be able to do so: [Tutorial] Reporting bugs or suggestions.
LibreOffice 24.2 on Xubuntu 24.04 and 7.6.4.1 portable on Windows 10