In version 2 of Numbers you used to be able to display the file name in a cell. If you copied a worksheet and gave it a new file name, that new name would automatically appear in the cell, so at a glance you could see which version of the worksheet you were looking at. As far as I can see that facility has gone in Version 3. Unless I have missed something?
iMac, OS X Mavericks (10.9)
This feature was dropped. Apple did announce it will be adding featurs back in. You can review the announcment here:
http://support.apple.com/kb/HT6049
You can also provide your opinion by selecting the menu item "Numbers > Provide Numbers Feedback"
You are correct, it's gone. So is Insert Date and Time.
Jerry
Hi Xabianblanca,
Not *quite* as convenient but of course there is an easy partial workaround for this.
Step 1. Click the triangle next to the document title:
Step 2. Command-c. (the document name has already been selected for you).
Step 3. Select the cell where you want to insert the document name and command-v.
As for the Insert Date and Time menu pick there is a workaround that is just as easy to use as the original menu pick, after a quick one-time setup.
See the other workarounds in that thread for some of the other features that weren't included in Numbers 3.0.
SG
SG,
The basic issue would be that the workaround won't update if you move or rename the file.
Jerry
Hi Jerry,
Agreed. It's an easy "partial workaround." I think there may be full workaround via an Automator Service but haven't had time to think through whether that's possible with just GUI scripting.
Since the current document name is displayed prominently on screen, I would guess this falls into the "nice but not necessary" category for a lot of people. I can see how it would be useful for printing in some cases, though.
SG
curious how you did this in the old version?
Thanks
Jason
Jason,
I checked that out before posting my "partial workaround." In 2.3 you click in a cell and choose Filename from the Insert Menu.
It looks just like text in the cell. But when I tried duplicating the document it would update when I renamed, as Jerry suggested. At least I think it did. Strangely, I can't get it to update now.
SG
Thanks SG,
In excel you have to do something like this:
=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)nice to see such a simple process in Numbers (2.3). I am usually on my ipad now so i dont get to the desktop much anymore at home, now i have to go try it. 🙂
Hi Jason,
On the iPad this seems a little more complicated. It turns out you can't just tap the document title and copy.
What works here is tap Spreadheets upper left to close the document and go to where your documents are listed, tap the document title there, select it all, copy, tap Done, double-tap the document to open it again, select cell, paste.
Maybe a little easier than that Excel formula of yours.🙂
SG
Sad that it's 2017 and it's still not there . . . unless I missed it. If I did, let me know. Seems like a basic header/footer thing, or at least a calculation.
you can always post feedback to Apple using the Numbers menu item "Numbers > Provide Numbers Feedback"
Displaying the File Name in a Cell