HERE IS A MAJOR ISSUE (or is it just me making an error?) 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.) 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 ) 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) then spreadsheet B will display the result of the SUM in A at cell H66 (say $250.00) instead. 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.
This error does not occur in = a formula from another page/sheet in the same spreadsheet file as the recipient. That task still works correctly, as it did in OO 1. Has anyone else struck this problem; or can someone tell me how to overcome it, please? Kind regards, Royce Green 28 Durran Street TUGUN QLD 4224 AUSTRALIA
