Hi :) The help pages are very out-of-date. It's a good 1st place to search for stuff but the proper guides are far better http://wiki.documentfoundation.org/Documentation/Publications Regards from Tom :)
________________________________ From: Luuk <luuk34@gmail.com> To: users@global.libreoffice.org Sent: Saturday, 20 October 2012, 12:07 Subject: [libreoffice-users] Re: Insert the filename in a cell On 19-10-2012 16:23, Samuele Zampini wrote:I solved it with this formula: =REPLACE(REPLACE(CELL("filename");FIND(".";CELL("filename");1);(LEN(CELL("filename"))-FIND(".";CELL("filename");1)+1);"");1;SEARCH("/[^/]*$"; CELL("filename"));"") I like it!its a bit too long .... i would like CELL("shortfilename") more CELL("Filename") should return just the name (without path) and CELL("path") to return the path but that is obviously not possible because Microsoft 'invented' it the other way.... ;( and why is there no mentioning in the help page that we can use a regular expression to search with SEARCH()...? -- 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
-- 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