Can I import data from one spreadsheet to another.

[watcher]

I want to enter data (e.g. paid miles, fuel, actual miles, etc) into one spreadsheet then be able to use that data in different spreadsheets to make different reports. I have been cutting and pasting the data I need from one to the other but it gets cumbersome when the second spreadsheet needs to have the data in a different order than the first.

I found this formula at wiki =DDE(“soffice”;“C:\My Documents\LibreOffice\MyFile.ods”;“Sheet.A1”) but when I tried it, it didn’t work. I might have entered my info incorrectly, can you explain in simple language what I need. I under the C:/my documents. . . but what about the “soffice” and “Sheet.A1” should I use those exact phrases?

Also will the data transfer if the original data is gathered from a formula? IOW, if the data I want to import is the mpg and in the original spreadsheet that is calculated by dividing the mile cell by the gallons cell will the actual mpg be imported or will it just import the formula.

Thanks for any help.

[Ratslinger]

The construction and usage of the DDE function can be found in the off-line help if installed (F1) or on this page - click here.

Briefly, “soffice” is the LibreOffice server name and must remain as is. “Sheet.A1” is from the document where the cell information is located (name of the sheet and specific cell). The return is the value in the cell and not the formula (if present).