[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Updated: (OFFICE-3340) SHEET function with noparameter undefined when experession is used outside table cell
[ http://tools.oasis-open.org/issues/browse/OFFICE-3340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Eric Patterson updated OFFICE-3340:
-----------------------------------
Proposal:
Update Last sentence of 6.13.31 as follows:
6.13.31 SHEET
Summary: Returns the sheet number of the reference or the string representing a sheet name.
Syntax: SHEET( [ Text|Reference R ] )
Returns: Number >= 1
Constraints: R shall not contain a Source Location (5.8 References)
Semantics: Returns the 1 based sheet number of the given reference or sheet name.
Hidden sheets are not excluded from the sheet count.
If no parameter is given, the result is the sheet number of the sheet containing the formula.
If a Reference is given it is not dereferenced.
If the reference encompasses more than one sheet, the result is the number of the first sheet in the range.
If a reference does not contain a sheet reference, the result is the sheet number of the sheet containing the formula.
anchor:SHEET
If the function is not evaluated within a table cell, an error is returned.
Added last sentence as agreed by SC
> SHEET function with no parameter undefined when experession is used outside table cell
> --------------------------------------------------------------------------------------
>
> Key: OFFICE-3340
> URL: http://tools.oasis-open.org/issues/browse/OFFICE-3340
> Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
> Issue Type: Bug
> Components: OpenFormula
> Affects Versions: ODF 1.2 CD 05
> Reporter: Eric Patterson
> Assignee: Eric Patterson
> Fix For: ODF 1.2 CD 06
>
>
> If a named-expression is defined to use the expression "=SHEET()", the result is currently undefined in the specification given that the formula does not exist in a sheet.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]