I am trying to create a sheet in LibreOffice Calc where Column C will be populated by spin buttons linked to Column B. The spin button in C1 links to B1, the spin button in C2 links to B2, and spin button in C3 links to B3, and so on. I want to be able to quickly add new rows with their own spin buttons, so I want to avoid manually clicking through Design Mode > Right Click on Spin Button > Control Properties > Left Click on Data Tab > Enter Linked Cell.
I assumed I could just copy and paste the spin buttons and they would dynamically adjust their values, but when I do this, the spin button retains the Linked Cell of whichever spin button the button was copied from.
Is there any way to do this? If not, are there alternative form controls or macros I could use to get the result I’m looking for?
