Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index


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+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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.