-------- Original Message -------- From: Peter Jon White <[EMAIL PROTECTED]> Date: Wed 14 Mar 2007 06:45:10 EST
> 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! > If your recipients do not need to edit the data, would "File -> Export As PDF" or "File -> Send -> Email as PDF" work for you. Hope this helps. Dave -- This is a mailing list which exists to support users of OpenOffice.org All answers are given by other users who volunteer their time. If you are not subscribed to this mailing list you may not see all the replies to your query. Please reply to [email protected] only and include some indication that you are not subscribed to this list. (eg. "I am not subscribed to this list, please CC: me.") For on-line support see: http://support.openoffice.org/index.html For a knowledge base see: http://mindmeld.cybersite.com.au/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
