Copy to Peter
-------- Original Message --------
From: TomW <[EMAIL PROTECTED]>
Date: Wed 14 Mar 2007 12:55:05 EST
> 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]
