[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Updated: (OFFICE-2750) 5.8: Error Literals inReferences
[ http://tools.oasis-open.org/issues/browse/OFFICE-2750?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eike Rathke updated OFFICE-2750: -------------------------------- Fix Version/s: ODF 1.2 CD 06 (was: ODF 1.2) > 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]