[Solved] Sheet tabs jump when selected

Help with installation and general system troubleshooting questions concerning the office suite LibreOffice.
Post Reply
Gonzo714
Posts: 47
Joined: Wed Nov 23, 2016 2:52 pm

[Solved] Sheet tabs jump when selected

Post by Gonzo714 »

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:
librecalctabissue1.png
librecalctabissue1.png (17.85 KiB) Viewed 7171 times

After Selecting Tab:
librecalctabissue2.png
librecalctabissue2.png (19.86 KiB) Viewed 7171 times

Im using Linux Debian 10 with Libre Office 7.5.5.2
Last edited by MrProgrammer on Fri Apr 26, 2024 6:33 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
LibreOffice 7.5, Debian 12
User avatar
Zizi64
Volunteer
Posts: 11412
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Sheet tabs jump when selected

Post by Zizi64 »

I have a calc file with 250+ sheets.
Are you sure, if this the optimal solution for you task?
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.
Gonzo714
Posts: 47
Joined: Wed Nov 23, 2016 2:52 pm

Re: Sheet tabs jump when selected

Post by Gonzo714 »

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..
LibreOffice 7.5, Debian 12
User avatar
RoryOF
Moderator
Posts: 34751
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Sheet tabs jump when selected

Post by RoryOF »

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
User avatar
Lupp
Volunteer
Posts: 3598
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Sheet tabs jump when selected

Post by Lupp »

1.
Gonzo714 wrote: Thu Aug 17, 2023 3:56 pm ...
Im using Linux Debian 10 with Libre Office 7.5.5.2
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
User avatar
Zizi64
Volunteer
Posts: 11412
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Sheet tabs jump when selected

Post by Zizi64 »

is it unusual for folks to have a spreadsheet with hundreds of sheets?
In my opinion it is uncomfortable to handle the too many 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.
Gonzo714
Posts: 47
Joined: Wed Nov 23, 2016 2:52 pm

[Solved}....kinda - Sheet tabs jump when selected

Post by Gonzo714 »

:crazy: 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?
LibreOffice 7.5, Debian 12
User avatar
Hagar Delest
Moderator
Posts: 32804
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Sheet tabs jump when selected

Post by Hagar Delest »

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
Post Reply