Issue 104099 - second argument for SHEET function
Summary: second argument for SHEET function
Status: CLOSED DUPLICATE of issue 10896
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO310m11
Hardware: Other All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2009-08-08 10:29 UTC by risch
Modified: 2009-08-10 23:25 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description risch 2009-08-08 10:29:21 UTC 
Currently, TABLE always returns the table number to a given name or range

I suggenst to add a second optional argument, specifying the format of the 
return result as TABLE(range, format)
if format is missing or zero, the result returns the absolute table index
if format is 1, the result returns the relative table index as difference to 
the table of the current cell
if format is 2, the result returns the name of the specified table
Comment 1 risch 2009-08-08 10:37:02 UTC 
sorry, the english name of the function is SHEET, not TABLE
Comment 2 Oliver Brinzing 2009-08-09 10:11:29 UTC 
> the result returns the name of the specified table

you can use this workaround:

=MID(CELL("FILENAME");FIND("#$";CELL("FILENAME")&0*RAND())+2;256)

german:
=TEIL(ZELLE("FILENAME");FINDEN("#$";ZELLE("FILENAME")&0*ZUFALLSZAHL())+2;256)
Comment 3 Regina Henschel 2009-08-10 23:25:20 UTC 
The problem getting the sheet name is already tracked in issue 10896.

*** This issue has been marked as a duplicate of 10896 ***
Comment 4 Regina Henschel 2009-08-10 23:25:48 UTC 
closing duplicate