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

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.


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