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