Hi, I am using Libreoffice 5 (it is the newest version that my Mint package manager has approved, and following the advice of other Mint users, I am sticking to those versions) and am having a problem with my form controls re: spin buttons.
I originally spent a great deal of time creating a worksheet that has a single column of almost 100 spin buttons in it for easy incrementation of observed real-time actions. Each spin button is referenced to the same cell in which it is anchored. I created it as a template with the intention of copying the list of incrementable/observable action labels, along with their buttons, to new places in the page, as well as to other tabs and eventually other worksheets, with only some small changes to labeling between all these things as necessary.
However, this is not so easy. I was able to use this advice
to manage to copy the original template a couple of times within the original tab (so now the finished “template” has three columns of ~100 spin buttons), but now that I need to copy the entire, larger tab template over to a new tab, no matter what I do, the buttons end up getting pasted such that they’re no longer anchored to their cells. I mean, it says they’re anchored to their cells, but visually they are not. At this point, when I save, close, and reopen the worksheet, the cells are once again visually anchored to their cells, but as I scroll down the page I can see each row of buttons getting smaller and smaller until by the last row they are small enough to be hard to access quickly, which is a problem. Not to mention the fact that visually it gives me night terrors, even aside from practical concerns. And this is how it gets saved. (If I just try to copy using a more conventional way than that given in the linked instructions, I run into the “spin button not referencing its own cell on the new page” problem).
I need to make about 18 tabs in each worksheet, each with the three columns of ~100 spin buttons. I just want to be able to copy pages and/or columns to new pages such that the copied spin buttons reference their own, new respective cells, but otherwise remain the same. Can this really be so stupidly difficult to accomplish? Can anybody help me solve this, or at the very least provide a shoulder to cry on as I look forward to hours of right-clicking and manually adjusting literally thousands of spin buttons? I’ve already spent so much time on this it’s hard to conceive of starting over with different software or something.
Thank you in advance for whatever help anyone can provide.