Re: [libreoffice-users] Re: Generic formulas or inverse scenarii

But still, using "non-copyback", the out-of-scenario-scope cells will be empty 
for a referer:
=Scenario1Name.C1
will show "0" if C1 is not a cell of the scenario on the mother-sheet.

What i really need is an option attached to the "Copy the whole sheet" option, 
which would be "as a shadow copy". And then a scenario would also contain all 
the sheet's data and remain synchronized to it. The scenario would just be a 
set of cells changing in a whole sheet in which all cells remain available 
when calling the scenario name.

But i surrenderred, i will do 3 sheets at the moment :)

Thank you everyone for digging into my problem.

Best regards,

Ninj

Le 15/03/2012 21:25, Andreas Säger a écrit :
> Scenarios have a property "Copy Back". If this option is unset, you can still
> edit the scenario but when you switch to another one this one will be preserved.
> So this type of "Don't Copy Back" scenario works like a template. You can edit
> the template, then create a new one from the edited range and preserve the
> original.

--
For unsubscribe instructions e-mail to: users+help@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