Peter Jon White wrote:
I've got a spreadsheet with product descriptions and prices. The prices
are derived from calculations on a different worksheet and linked from
that other worksheet. I need to do this so that I can easily change
prices as the dollar exchange rate changes, or shipping costs change,
etc. I'd like to make my changes in one file, and have the price list
update automatically. Then I'd like to be able to send out the price
list only, without the supporting calculations. But I can't figure out
how to copy and paste the worksheet into another file and maintain the
values in the price cells. Without the other worksheets in the file, the
data goes away.
How do I copy the spreadsheet to another file so that I just get the
calculated content of the cells?
Thanks!
Another alternative would be to use "save as" using the "Text csv"
format on the worksheet in question. This will create a copy of file
with only the selected worksheet("csv" can only have one worksheet).
You can then import the "csv" file back into Calc (File-Open, select the
"Text CSV" format). If you want to use the same formating, you then use
"copy" on the worksheet area being used on the original worksheet. Then
"paste special", formats only, on to the new worksheet.
TomW
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
