At 10:58 27/10/2016 -0400, Andrew Pitonyak wrote:
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.
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")
Aha! Now my turn to smack head!
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
