At 23:24 03/09/2015 +0200, Martin F Krafft wrote:
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 instantiate 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?
For cell formatting, instead of making local changes to cell formats,
create cell styles as necessary and apply these to appropriate cell
ranges. When you need to change the formatting of a cell or cell
range, modify the style instead.
For function calls, you may be able to achieve what you need by
making those calls refer in some way back to a master sheet:
o If you need, say, identical function calls on your many sheets, you
could put the function call on the master sheet and have each
dependent sheet merely refer to the result expressed there.
o In other cases, it may be possible to create a more complicated
function call on the dependent sheets, where the parameters of the
function call themselves refer back to a controlling (and adjustable)
value on the master sheet. The master sheet would not itself have the
function calls but would have cells whose contents controlled the
function calls elsewhere.
But there is another trick that will help. Use Shift+click or
Ctrl+click on the sheet tabs to select multiple sheets. Changes that
you make whilst multiple sheets are selected apply to all those sheets.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@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
