2008/6/23, Brian Barker <[EMAIL PROTECTED]>: > > At 12:29 22/06/2008 +0200, Johnny Rosenberg wrote: > >> Is this a bug or am I just doing something wrong? >> >> I opened a new spreadsheet (OpenOffice 2.4.1, GNU/Linux Ubuntu 8.04) and >> in one cell the formula is: >> >> ='file:///home/guraknugen/Eget/Bil/Bilekonomi/Hyrbilskostnader.ods'#$'2008'.P9 >> >> The value of P9 in the Hyrbilskostnader.ods file is 627.83, so the cell in >> the new spreadsheet should be the same, right? So why is it 0 (zero)? >> >> Nothing is wrong spelled or something, since I had both files opened at >> the very same time, and I selected the cell in Hyrbilskostnader.ods using >> the mouse. >> > > Here are some thoughts: > > o If you change the value in the first file, it appears the effect cannot > be transmitted until you save that file. An open file with a changed value > will not produce the result you want. > Thanks. Yes, that was it!
I don't know about the quote marks in "2008", but I certainly didn't put them there, I just created the whole formula by klicking the cell in the other document. Johnny Rosenberg
