[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=21601#action_21601 ]
Andreas Guelzow commented on OFFICE-2750:
------------------------------------------
Dennis: you wrote: "because of a particular reference having been invalidated by actions that occured after the formula was validly created." If you encounter [#REF!] in a file you cannot know that. A user could have typed that expression into a cell directly. The only thing you really know is that the reference is invalid. That is exactly as much as you would know with an error: #REF! or any other error.
I am somewhat surprised that nobody else wonders why we are adding this feature at this time when other issues of a similar nature raise the "no new features" 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]