Apache OpenOffice (AOO) Bugzilla – Issue 10896
need SheetName/DocumentName in a spreadsheet as formula
Last modified: 2013-08-07 15:13:10 UTC
Hi, I would like to have two more formulars in calc: - SheetName(SheetNo) -> returns the sheetname as string - DocumentName(Index) -> returns the document name as string with the options: path, name, name + ext maybe same as in the header/footer content ? At the moment the SheetNo (=Tabelle()) and SheetCount (=Tabellen()) are present as formulars ... At the moment I use macros to do this but I noticed two major problems with these basic functions: 1. Please have a look at Issue #8869 2. When the user changes the sheet/documentname or copies a sheet over the GUI the basic functions still show the old names, cause they do not notice the change. I have to use oDocument.calculateAll() to update the functions ... Manuall updates with <F9> seems not to work here ... regards Oliver
May be added to the CELL function
Hi Bettina, one4you
Hello Niklas, please give approval for this evaluated OO.o 2.0 flagged issue. If you confirm with the target OO.o 2.0, then please keep it on your owner (or the owner of the concerning developer) for implementation. In case you want this issue for 'OOo Later', then please reset the target milestone. If you decline the issue finally, please set the resolution to 'Wontfix' (but do not close). In case of 'OOo Later' or 'Wontfix' please reset it on Bettina's owner. Thank you.
This is not on the list of features that we're going to do for 2.0. We need to focus on the enhancements from the PCD document.
And how about 2.3?
There is a workaround for this one. =cell("filename") gives the complete path and the sheetname in one string. Then, using regular expresions, find the position of the "$" character, at this positon the sheetname starts. Thus: a1: = cell("filename") a2: = RIGHT(P6;LEN(P6)-SEARCH("[$]";P6)) (be sure you selected to use regular-expresions: tools > options > enable regulare expresions
confirmed
*** Issue 78819 has been marked as a duplicate of this issue. ***
the workaround =ZELLE("filename";C9) =RECHTS(C9;LÄNGE(C9)-SUCHEN("[$]";C9)) will fail, if one changes the sheetname so is there a chance to make the =Cell() function aware of sheet/document name changes ?
*** Issue 104099 has been marked as a duplicate of this issue. ***
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".