Openoffice Calc holds a lot more bang for the users' buck than you might think. Most people know the ins and outs of spreadsheets, but many don't realize just how powerful spreadsheets can be. And when I work in spreadsheets I work in OpenOffice. Now that I found the conditional formatting, I see that the $Config.$A$1 reference is as it should be, without external link.I do a lot with spreadsheets. In Libreoffice it works, but I cannot find the rules itself anymore in the conditional formatting dialogs There are some conditional formats that reference to $Config.$A$2$ as well. I have used OpenOffice before until recently. Is there any way where I can tick that I do not want external links to be generated when copy+paste between two files ? This can easily be tested and reproduced. Copy+Paste Special is no option because you can choose for formula’s and will get the external link or not paste formula’s and you will get values only. Removing the leading $ sign is not an option because then the sheet reference will change when you copy+paste between tabs. When I copy+past those cells to another file, the $Config.$A$1 will become an external link to the original file and becomes something like 'file:///C:/SomDir/SecondFile.ods'#$Config.$A$1. Now if I copy+paste that reference with dollar signs between the month sheets in one file, everything is fine. Therefore I must reference data to the Config sheet with the dollar signs like this $Config.$A$1 They look at the sheet name to know what month it is. The month sheets are setup to be universal.
All month sheets refer to the Config sheet for some general settings (thresholds for conditional formats, lookup tables for items with fixed price per year etc.) Besides those tabs I have a Config sheet. Similar to the poster in the link I have financial worksheets, one file per year, one sheet per month Jan, Feb. Because I do not have an answer, and I think this is indeed an issue, I am creating a new question for it.
I am facing exactly the same problem (I think) and I have made it reproducible.
0 kommentar(er)
