Apache OpenOffice (AOO) Bugzilla – Issue 15118
Inserting data from one spreadsheet into anopther
Last modified: 2003-09-08 16:55:29 UTC
I am having difficulty inserting data from one spreadsheet into another. I have two separate spreadsheets open and I want to have the cell of one reference a cell on the other spreadsheet so that it shows the value of the other. This function works in Excel by inserting the equal sign in a cell and then going to the other spreadsheet and clicking on the cell you want and pressing enter.
This works in OOo the same way as in MSExcel, but the source document must have a name and a location (it must be saved before it could be used as source).
Closed because not a bug