[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Commented: (OFFICE-2750) 5.8: Error Literalsin References
[ http://tools.oasis-open.org/issues/browse/OFFICE-2750?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=21602#action_21602 ]
Andreas Guelzow commented on OFFICE-2750:
------------------------------------------
I just noticed the last sentence in the resolution. I don't see how that could be correct if you read the #Ref! from a file.
Moreover this resolution does not seem to address the "Resulting formula =A1 + #REF!1" situation.
How does this need error interact with ERROR.TYPE (assuming that this reference error is in fact an error)?
Is #REF! an error in the sense of 5.12? If it is it probably should be added there.
Eike you stated:
"Current definition also says
QuotedSheetName ::= '$'? SingleQuoted | Error
implicating Error could be any error constant, that certainly is not the case."
What did you mean with "that certainly is not the case"? That surely was the case until the "resolution" of this issue.
> 5.8: Error Literals in References
> ---------------------------------
>
> Key: OFFICE-2750
> URL: http://tools.oasis-open.org/issues/browse/OFFICE-2750
> 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: Eike Rathke
> Fix For: ODF 1.2 CD 06
>
>
> When a part of a refence has been invalidated (ex. deleting a column) it is often useful to show an error literal as the part of the reference that was invalidated. The reference syntax seems to indicate that a reference can be used in place of the sheetname, but the exact syntax doesn't seem clear.
> For example, if you have a formula that adds cell A1 and B2 and then delete column B, what will the resulting formula be?
> In Excel:
> Original formula =A1 + B1
> Resulting formula =A1 + #REF!
> In Calc:
> Original formula =A1 + B1
> Resulting formula =A1 + #REF!1
--
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]