Hi
Some time ago I had to write a function that will display filename of current
Calc workbook. After some Googling and trial and error I came up with this
monster:
=RIGHT(MID(CELL("FILENAME";A1);2;
FIND("'#";CELL("FILENAME";A1))-2);LEN(MID(CELL("FILENAME";A1);2;
FIND("'#";CELL("FILENAME";A1))-2))-FIND("$$$";SUBSTITUTE(
MID(CELL("FILENAME";A1);2;FIND("'#";CELL("FILENAME";A1))-2);"/";"$$$";
LEN(MID(CELL("FILENAME";A1);2;FIND("'#";CELL("FILENAME";A1))-2)) -
LEN(SUBSTITUTE(MID(CELL("FILENAME";A1);2;FIND("'#";CELL("FILENAME";A1))-2);"/";"")))))
(Of course it could be shorter if only temporary cells were allowed; you can
clearly see that much of this function is multiplication of some formula set.)
Since I am beginner of Calc, I had really hard time working on this. That made
me wonder:
how do I effectively work with long formulas in Calc? What
tools/extensions/tips are there to ease my work?
How can I keep track of relevant parts of each function, their input and
output values etc?
How do you guys handle such things?
Thanks in advance for any tips.
--
Best regards
Mirosław Zalewski
--
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
