[libreoffice-users] 12 instances of the same sheet

Hi guys (and girls),

I need to create a spreadsheet with a sheet for each month of the
year. This per-month sheet is actually quite complex, involving
a lot of formatting, DDE(), and VLOOKUP() calls etc.. Therefore,
I would really like to create one master sheet that has the month
parametrised (which I know how to do).

But how can I instantiated 12 sheets from a master sheet such that
changes to the master apply to all 12 sheets? For instance, if
I change the formatting of a cell, or the DDE() function call, how
can I make sure that I don't have to make this change 12 times?

Have you had any experienced with the like?

I've considered creating just one sheet for all 12 months, but it
just gets too wide and isn't really nice to deal with anymore. I've
also considered providing 12 forms as "views" into the sheet, but
that does seem like overkill too.

Does anyone know what I should best do?

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
"and the sea isn't green
 and i love the queen
 and what exactly is a dream?
 and what exactly is a joke?"
                                                        -- syd barrett
 
spamtraps: madduck.bogus@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted