[Solved] Access Filename in Calc

nickdrums · Post by **nickdrums** » Mon Aug 03, 2009 1:40 pm

Hi,

I want to display part of the spreadsheet filename in a calc cell, and expected to find a function or "insert field" command to access the filename, but cannot find anything which does this. Does anyone know how to access the filename?

Cheers, Nick.

edit this topic's initial post · Post by **Villeroy** » Mon Aug 03, 2009 2:09 pm

The print header or footer is the "natural" place for this.
CELL("filename") returns the complete system independent URL including the sheet name: 'file:///path/document.ods'#$SheetX
=MID(CELL("filename");2;FIND("'#";CELL("filename"))-2) returns the URL alone.

nickdrums · Post by **nickdrums** » Mon Aug 03, 2009 2:22 pm

Perfect - thank you.

Bartlett · Post by **Bartlett** » Sat Sep 09, 2017 1:36 am

May I ask for additional help. I just want to display the name of the file without the path (for example "birthdays.ods").

Would you know how to do this?

Bob

Post by **Zizi64** » Sat Sep 09, 2017 7:35 am

By cell functions and regular expressions:
viewtopic.php?f=9&t=65936
viewtopic.php?t=79375&p=364778

by macro (usage of the text functions of the Tools library):
viewtopic.php?f=45&t=10728

[Solved] Access Filename in Calc

[Solved] Access Filename in Calc

Re: Access Filename in Calc

Re: [Solved] Access Filename in Calc

Re: [Solved] Access Filename in Calc

Re: [Solved] Access Filename in Calc