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 <[email protected]> >To: [email protected] >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: [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 > > > > -- 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
