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

At 11:08 22/03/2013 +0100, Miroslaw Zalewski wrote:
> At first, thanks for your reply. Unfortunately, it misses the point. 
> My question isn't "how can I get filename of current workbook in 
> Calc?" but "how can I effectively work with long formulas?". This 
> problem is much more generic.
>
> 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?

Well, yes: that's what I did.  As you take the formula apart, you 
will begin to see what it does and how.  No, I don't see any clever 
way to analyse a formula.  Fundamentally, I think you need the 
formula's author to explain how it works - which is what I tried to 
do with mine.

Brian Barker


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