Re: [libreoffice-users] [Calc] How to work with long formulas?

2013/3/22 T. R. Valentine <trvalentine@gmail.com>:
> On 22 March 2013 05:08, Mirosław Zalewski <miniopl@poczta.onet.pl> wrote:
>
> > To put it other way around, imagine that I have received file with mentioned
> > formula in cell. I know what it outputs, but I don't know how. I would like to
> > debug it and understand what exactly it is doing.
> >
> > What are my options? Is separating repeating parts of formula onto other cells
> > the only way?
>
> My preferred way for analysing a complicated/long formula is to copy
> the formula to a text editor and break it apart there. For instance, I
> find nested IFs much easier to understand/analyse if arranged in a
> programmatic layout.
>
> And, of course, if the cells a formula references can all be seen
> simultaneously, there is always the F2 key to help get some idea of
> what the formula is doing.

You mean Ctrl+F2, right?


Johnny Rosenberg

> --
> T. R. Valentine
> Your friends will argue with you. Your enemies don't care.
> 'When I get a little money I buy books; and if any is left I buy food
> and clothes.' -- Erasmus
>
> --
> 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

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