How to make Dynamic?

I finally have my layout done just so in Open Office Calc.
I have read what the Open Office says about making Dynamics. They do not go into much detail.

I would like to make mine Dynamic so that I can print out the pages without having to change the date and day and later the month. Maybe I'm just lazy :)

Any suggestions exactly how to go about it?

Once I am over that hurdle I will add it to the collections here. I may add it while it is static anyway.

It is 2 page per day in Classic size with 2 page month starting on Monday with Thursday - Sunday on one page.

Syndicate content

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Details, please

I have read what the Open Office says about making Dynamics. They do not go into much detail.

What, exactly, are you talking about ?

I Googled "openoffice dynamic" and I got a bunch of hits about some Microsoft thing called Dynamics Ax. That does not sound to me like it is talking about incrementing the date on a planner page.
-----------------------------------
"I think the surest sign that there is intelligent life out there in the universe is that none of it has tried to contact us." (Calvin and Hobbes/Bill Waterson)

How about...

Not sure I understand what is meant by 'Dynamics' but it seems like you just want the date to increment when you print. I also use a Calc/Excel layout, 2 pages per day or day to an opening (DTO) but on A5.

I normally print 7 pages or days at a time. To that end my my layout consists of those 7 pages. I have not hardcoded the date on those pages but have instead formatted one of the cells on each page as a date cell and have chosen the day and date in the form: Sunday, 30 May 2010. I have also formatted a couple of other cells to do week and day number calculations.

Each date cell on pages 2-7 is populated with a calculation function of =cell+1 where cell is the cell Identifier of the corresponding cell on the previous page. Simply this date equals the previous page date plus one.

I have also set up a page zero where I enter the date I want to start with and do a basic =cell calculation on the date cells for page one of the layout.

Once I enter the start date on page zero, the date cell on the first page gets get propogated with that date, page two the page one date plus one, page three withthe page two date plus one an so on.

Hope this helps.

BobH

Dynamic

BINGO! Thanks Bob. I knew it was something simple but I could not for the life of me think of what it was.

I don't want to have to enter each date individually on 365 pages.

Thanks again

Gypsy

This might help

http://www.diyplanner.com/node/7134

Also, if you could provide a link to "what the Open Office says about making Dynamics", it would help us help you.
-----------------------------------
"I think the surest sign that there is intelligent life out there in the universe is that none of it has tried to contact us." (Calvin and Hobbes/Bill Waterson)

Mail Merge?

Hi.

If you mean by 'dynamic' a mail merge so you have a 'form' file and a 'data' file separately, then you 'merge' them together when it's time to print, I can help with that.

Try this:
Link to Mail Merge thread

shris