='file:///C:/Users/fjcc/Desktop/LastValue.ods'#$Sheet1.A1
=AA.ODS#$Sheet1.$A1+BB.ODS#$Sheet1.A1
RusselB wrote:Welcome to the Forums.
First off, please understand that Calc is not Excel or Numbers. They are similar, but not the same.
Now to answer your question, the simplest method is as follows:
1) Open both AA.ODS and BB.ODS
2) Pick one of the spreadsheets... you can choose which one in the Window menu.
3) Go to cell A5
4) Enter the formula
- Code: Select all Expand viewCollapse view
=AA.ODS#$Sheet1.$A1+BB.ODS#$Sheet1.A1
Please note that if you have renamed the sheets, you'll have to change Sheet1 in above code to the appropriate sheet name.
5) Pick the other spreadsheet using the Window menu and repeat steps 3 and 4.
Note: Calc uses the information from the last saved version of a spreadsheet to generate the results for a linked calculation.
ie: If you change A1 in AA,ODS, the link in A5 will show the updated information, but the link in A5 of BB.ODS will not reflect the updated information until AA.ODS has been saved with the updated information and the links have been updated (possibly using Edit -> Links -> Update)
FJCC wrote:The formula to bring a value in from one file to another looks like
- Code: Select all Expand viewCollapse view
='file:///C:/Users/fjcc/Desktop/LastValue.ods'#$Sheet1.A1
The source data is in the file LastValue.ods and the cell is Sheet1.A1.
Does that get you what you need?
RusselB wrote:No idea... but it's along the same lines of you entering =2+2 in Calc and getting 4, which you would expect.... but, on rare occasions, you might get 3.999999999999999 or 4.0000000000000001
Neither one, of those two, is exactly 4, but I have seen that kind of display.... and 2+2=4 is a much older idea.
bbc0 wrote:RusselB wrote:No idea... but it's along the same lines of you entering =2+2 in Calc and getting 4, which you would expect.... but, on rare occasions, you might get 3.999999999999999 or 4.0000000000000001
Neither one, of those two, is exactly 4, but I have seen that kind of display.... and 2+2=4 is a much older idea.
Reminder to myself: Never allow Calc to perform any calculations hahahahaha So funny
Villeroy wrote:bbc0 wrote:RusselB wrote:No idea... but it's along the same lines of you entering =2+2 in Calc and getting 4, which you would expect.... but, on rare occasions, you might get 3.999999999999999 or 4.0000000000000001
Neither one, of those two, is exactly 4, but I have seen that kind of display.... and 2+2=4 is a much older idea.
Reminder to myself: Never allow Calc to perform any calculations hahahahaha So funny
Same with Excel and any other application that performs decimal floating point arithmetics. There are inaccuraciees due to the conversion between internal bytes and displayed decimals. In most cases the application is smart enough to handle this properly. Sometimes you need explicit rounding as in =ROUND(A1+B1;12)
bbc0 wrote:I have 2 spreadsheets AA.ODS and BB.ODS I would like to add the the value in cell A1: AA.ODS to A1: BB.ODS and dipslay the value in A5 in both AA.ODS and BB.ODS and have them linked so that if any of the values are changed in A1 in either .ODS the A5 value in each document will update. I can do this in Excel but can't seem to get it to work in Numbers.
Any help would be appreciated.
Users browsing this forum: Majestic-12 [Bot] and 11 guests