Hullo there - is this a bug, or an error between chair and keyboard? The problem may be better asked in an open office forum, but just in case anyone here has come across this problem:
I have an OO calc spreadsheet with a bunch of columns. The columns are summed in a final row using the SUM function button ("=SUM(A1:A10)" e.g.).
I open a second spreadsheet and wish to reference these cells from the new sheet.
First method tried: hit the equals button and click on the appropriate cell in the first sheet for each column. Result: some of the results show the correct value for the referenced cell, most do not.
Second method: name the final row from first file as a named range. In 2nd file, use the insert and link external data button, selecting the appropriate sheet and range from the proferred choice. Result: all values show 0 where referring to a cell that was a SUM of other cells.
I was playing with this on behalf of my other half, who wants to have a summary sheet of all his various site worksheets. For a start, it looks as though he would need the second link method as that is linked and therefore refreshes. Not much use if it shows 0 from summed cells however.
I was also very curious why the first method didn't show the correct values.
Thanks,
Jenny
Jenny Hopkins hopkins.jenny@gmail.com asked:
I have an OO calc spreadsheet with a bunch of columns. The columns are summed in a final row using the SUM function button ("=SUM(A1:A10)" e.g.).
I open a second spreadsheet and wish to reference these cells from the new sheet.
First method tried: hit the equals button and click on the appropriate cell in the first sheet for each column. Result: some of the results show the correct value for the referenced cell, most do not.
Second method: name the final row from first file as a named range. In 2nd file, use the insert and link external data button, selecting the appropriate sheet and range from the proferred choice. Result: all values show 0 where referring to a cell that was a SUM of other cells.
These both worked for me with simple test spreadsheets in OOo 2.3.1 on gobolinux which is probably old but it's what I had to hand. I suspect it's some bug in a particular version or something triggered by the spreadsheets.
Hope that helps,
Jenny Hopkins wrote:
Hullo there - is this a bug, or an error between chair and keyboard? The problem may be better asked in an open office forum, but just in case anyone here has come across this problem:
I have an OO calc spreadsheet with a bunch of columns. The columns are summed in a final row using the SUM function button ("=SUM(A1:A10)" e.g.).
I open a second spreadsheet and wish to reference these cells from the new sheet.
First method tried: hit the equals button and click on the appropriate cell in the first sheet for each column. Result: some of the results show the correct value for the referenced cell, most do not.
Second method: name the final row from first file as a named range. In 2nd file, use the insert and link external data button, selecting the appropriate sheet and range from the proferred choice. Result: all values show 0 where referring to a cell that was a SUM of other cells.
I was playing with this on behalf of my other half, who wants to have a summary sheet of all his various site worksheets. For a start, it looks as though he would need the second link method as that is linked and therefore refreshes. Not much use if it shows 0 from summed cells however.
I was also very curious why the first method didn't show the correct values.
Is one solution to use the indirect command? That's what I use to reference a cell in another sheet.
-
Chris Walker -
Jenny Hopkins -
MJ Ray