On Feb 21, 2005, at 5:18 AM, James Elliott wrote:
James,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,Using File > Export allows you to create a pdf of the current selection.
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).
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
It's time, I believe, for you to consider changing from spreadsheets to a relational database (MySQL or PostgresQL) before this gets much larger. You'll soon run into the 32,000 record limit in the spreadsheets, which (I think) is growing to 65,000 in v. 2.0. These addressing problems will go away. They'll be replaced by database problems, but the time you spend solving those problems will be well invested and will be more nearly permanent solutions.
Jim Plante <[EMAIL PROTECTED]>
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
