Basically I was having problems copying formulas I had spent ages making, onto other sheets and documents and they ended up referencing all the wrong locations.
I have since solved this myself and then pasted the answer because don’t you just hate it when there is loads of questions out there, then it gets solved and the person doesn’t bother coming back to explain how it was solved…
Give something back to the community people its good enough to help you out.
Ask not what the forum can do for you, but what you can do for the forum.
skip to my answer now.
*Edit over ***
I was using OpenOffice where I can copy a selection of formulas from a multiple sheet calc file to another multisheet calc file and it will copy all the formulas correctly, also doesn’t matter if the $ is locking sheets it will copy them the same. I have switched to libreoffice as I think it has more functionality with using coded spreadsheets?
I am having a problem with libreoffice calc copying formulas from one sheet to another
My other sheets are coded to the sheet I am replacing so if I copy sheet from ods1 to ods2, ods2s sheets that correspond to the sheet I have added will not recognise the new sheet.
*** deleted examples as not needed anymore ***
I have about 15 ods files with 13 sheets all identical, apart from all of the products are different. At the moment I am altering formulas and changing some columns, so I have to copy these changes from the sheet and paste it to all of the other documents on the same sheet.
I am using example $sheet1.A1 because I thought if I moved a sheet or added a sheet all my formulas will stay connected to each other and not change the sheets.