Issue 10896 - need SheetName/DocumentName in a spreadsheet as formula
Summary: need SheetName/DocumentName in a spreadsheet as formula
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 3.1
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 78819 104099 (view as issue list)
Depends on:
Reported: 2003-01-23 19:39 UTC by Oliver Brinzing
Modified: 2013-08-07 15:13 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description Oliver Brinzing 2003-01-23 19:39:20 UTC

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 ...


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
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.
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.
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 


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".