Hi Royce, On Thu, Jul 27, 2006 at 19:20:16 +1000, Royce & Faye Green wrote:
> OO version 2.0 Calc (using = 'file://.....) will now reference another > Calc file to bring in the results of a formula from there. (Version > 1 would not do this, it only worked from another sheet within the same > file.) Also OOo1.x already knew references to sheets of other documents. > However, if there is a zero result (say, formatted $0.00) in the > target cell, it is ignored and Calc 2.0 now picks up the result of the > formula in the next adjacent cell of the target. Thus in spreadsheet > B, if I enter( ='file:///C:/Doc..../spreadsheetA.ods' #$pagename.G66 The space between the file's URL and #$... is just a typo in your mail, I guess. Did you copy the formula from another sheet/cell? Or did you type it in? > ) where spreadsheet A/pagename has a number of columns being SUM > totalled on Row 66, and if the result of that formula in G66 on A was > $0.00 (zero) Not if it was another value different from zero? > then spreadsheet B will display the result of the SUM in > A at cell H66 (say $250.00) instead. Hardly to believe.. if you can't spot an error in your formulas and it's reproducible please file an issue and attach the faulty documents. See http://qa.openoffice.org/issue_handling/pre_submission.html But please try with the current OOo2.0.3 release first if the behavior still occurs. > Similarly, if I then copy this > formula/ reference into all following columns to the right in > spreadsheet B, they each give a result which is 1 column out of place. > To make matters worse, the cells in spreadsheet B display the correct > (sought after) reference in their formula on the input line, even > though they are producing the results of a formula from a different > column in A. Which again opens the question if you copied the first formula from some other cell or typed it in. And how is the behavior if the document is saved and reloaded? Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
