Hello Eike; Thank you for your concern & suggestions seeking clarification.
The problem is now solved, but I shall respond here to your questions, just
in case they are still relevant:
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?
It is just a typo. I left the "space" in my message simply to clarify my
formula & allow for a line break. I originally entered the first formula
directly by typing = in the input line, then clicking/ referencing the SUM
formula in the target sheet.
For the subsequent formulas across the columns, I copied my new formula
across the columns within the recipient sheet.
Not if it was another value different from zero?
Correct; the error occurred only when the SUM formula in the target sheet
'A' had produced a zero result .
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.
Yes; it is hard to believe. I did not type in my formulas so there should
be no errors there.
Now that I have saved & re-opened the documents, the error no longer exists.
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?
I copied the formulas across as stated above, but I had not first saved &
reloaded the documents.
Please see my relevant reply to Walter A. March appended below:
THank you Arnold & Walter; I am using Windows XP Home. I now see that my
previous error was in not first saving the target sheet 'A' before using it
as the source for the formulas in spreadsheet B. This morning, when I
re-opened my system and the Calc sheets, I answered 'Yes' to the Refresh
question & spreadsheet B came up with the expected/requested references &
results. In other words, it now seeks & finds the correct cells/SUM in 'A'
and my = formula in 'B' gives me the expected results.
Thank you for your help.
Regards, Royce G.
Thank you again Eike. Please accept my apologies for creating this small
maelstrom.
Regards, Royce G.
----- Original Message -----
From: "Eike Rathke" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, July 27, 2006 9:30 PM
Subject: Re: [users] CALC ERROR using (= formula from another spreadsheet)
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]
--
Internal Virus Database is out-of-date.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.3/395 - Release Date: 21/07/2006
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
