2013/3/22 T. R. Valentine <[email protected]>: > On 22 March 2013 05:08, Mirosław Zalewski <[email protected]> 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: [email protected] > 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: [email protected] 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
