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: | |
Severity: | Trivial | ||
Priority: | P3 | CC: | issues |
Version: | OOo 3.1 | ||
Target Milestone: | --- | ||
Hardware: | All | ||
OS: | All | ||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
Oliver Brinzing
2003-01-23 19:39:20 UTC
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". |