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+h...@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
