[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Commented: (OFFICE-2750) Needs-Discussion:5.8: Error Literals in References
[ http://tools.oasis-open.org/issues/browse/OFFICE-2750?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=19486#action_19486 ] Eike Rathke commented on OFFICE-2750: ------------------------------------- The original display format in Calc was chosen to give the user a hint what may have caused the invalid reference. For a reference Sheet1.A1 if Sheet deleted: #REF!.A1 Column deleted: Sheet1.#REF!1 Row deleted: Sheet1.A#REF! That doesn't play well with the current OpenFormula definition. Questions are, do we want to preserve that detailed information, or do we lump all together in one #REF!, and if so, with or without brackets, and with or without a leading '.' dot as a sheet name separator if no sheet was given? I propose to keep at least the surrounding brackets for easy identification, all references are enclosed in brackets. [#REF!] looks viable to me. Current definition also says QuotedSheetName ::= '$'? SingleQuoted | Error implicating Error could be any error constant, that certainly is not the case. > Needs-Discussion: 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 > > 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]