Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||need SheetName/DocumentName in a spreadsheet as formula|
|Product:||Calc||Reporter:||Oliver Brinzing <oliver.brinzing>|
|Component:||ui||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
Description Oliver Brinzing 2003-01-23 19:39:20 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
Comment 1 daniel.rentz 2003-01-24 11:32:13 UTC
May be added to the CELL function
Comment 2 oc 2003-09-17 09:41:31 UTC
Hi Bettina, one4you
Comment 3 bettina.haberer 2003-12-01 13:31:07 UTC
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.
Comment 4 niklas.nebel 2004-01-26 11:31:49 UTC
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.
Comment 5 gercokees 2007-03-06 15:20:59 UTC
And how about 2.3?
Comment 6 gercokees 2007-03-07 08:32:31 UTC
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
Comment 7 gercokees 2007-03-07 08:33:51 UTC
Comment 8 frank 2007-08-06 13:20:55 UTC
*** Issue 78819 has been marked as a duplicate of this issue. ***
Comment 9 Oliver Brinzing 2009-05-19 07:08:22 UTC
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 ?
Comment 10 Regina Henschel 2009-08-10 23:25:19 UTC
*** Issue 104099 has been marked as a duplicate of this issue. ***
Comment 11 bettina.haberer 2010-05-21 15:08:13 UTC
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".