On 27.10.2016 00:00, Brian Barker wrote:
At 10:19 26/10/2016 -0400, Keith N. McKenna wrote:
On Oct 25, 2016, 8:03 PM, at 8:03 PM, Vince Bonly wrote:
I would like to include the full path or filename within a CALC cell
...
Andrew Pitonyak wrote:
I have no computer access right now, but I think you can insert a
field containing the current file name.
Insert -> Fields-> Other... on document tab under type click filename
and under Format click the format you want. That will insert the name
of the current document in the format specified. You must save the
document for the field to be populated.
Sorry, but this works - of course - in a text (Writer) document. The
questioner wants the same functionality instead in a spreadsheet
document.
Brian Barker
Thanks Brian, smack head.....
Now that I have computer access, I see that you are correct.
In Calc, you can use this, which includes the current sheet.
CELL("filename")
If you just want the URL without the sheet name, this will suffice:
=MID(CELL("filename");2;FIND("'#";CELL("filename"))-2)
I won't bother pulling out the filename without the path and URL.
