I again Ian
I tried the Template approach and it seemed to work fine, but when I looked further into it, the Template was in fact the whole multi-spreadhseet, so for every report I am saving my entire database which includes details of hundreds of other customers not involved with the report.
I tried making just that sheet into a Template, but all the formula cells then contained the REF? error. I could run both spreadsheets side by side and link them but the formulas become horrifically long.
I think I will have to stay with using my VLOOKUP sheet, printing out the report, and then clearing it ready for the next one.
Masny thanks for your interest, James Elliott
----- Original Message ----- From: "Ian Laurenson" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, February 21, 2005 3:00 PM
Subject: Re: [users] Saving Calc spreadsheets.?
On Mon, 2005-02-21 at 19:38, James Elliott wrote:1. Export as PDF ... that experts the whole workbook - ie the three sheets,
not just the report, otherwise it would be good. I could keep each report
in a folder and access it by hyperlink from my Jobs sheet. Pity you cannot
export a selection, rather than the whole worksheet (together with other
sheets in the workbook).
Using File > Export allows you to create a pdf of the current selection.
2. Macro's - I haven't gotten around to writing my own macro's in OOo yet
I can probably assist here.
3. Template ... that might be the answer. As you say, it can be saved as a
separate file. I will have to remember to have my OOo calc workbook running
when I use the template, and I wonder how it will be saved as many of the
cell contents are the products of formula's. I will try it and see.
Keep us posted on progress.
Thanks, Ian
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.1.0 - Release Date: 18/02/2005
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
