[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Commented: (OFFICE-2379) 4.8 References -Additional description or additional rules?
[ http://tools.oasis-open.org/issues/browse/OFFICE-2379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17897#action_17897 ] Eric Patterson commented on OFFICE-2379: ---------------------------------------- Yes it's included, but more difficult to read. The syntax for whole row / whole column refs aren't included. The statement, "The optional "$" marking in sheet names, Column , and Row is used to identify absolute values; without the marking they are relative." is just pointing out that the opposite of Absolute is relative. > 4.8 References - Additional description or additional rules? > ------------------------------------------------------------ > > Key: OFFICE-2379 > URL: http://tools.oasis-open.org/issues/browse/OFFICE-2379 > Project: OASIS Open Document Format for Office Applications (OpenDocument) TC > Issue Type: Improvement > Components: OpenFormula > Reporter: Patrick Durusau > Assignee: Dennis Hamilton > Fix For: ODF 1.2 Part 2 CD 2 > > > Following the reference syntax we say: > "References always begin with '['; this immediately disambiguates cell addresses from function names and named expressions. SheetNames include single-quote(') characters by doubling them and having the entire name surrounded by single-quotes. Column labels shall be in uppercase. The syntax above supports whole-row and whole-column references, but they shall always have a range marker, e.g. [.A:.A] would be a reference to the whole first column and [.1:.1] a reference to the whole first row of the current sheet. The optional "$" marking in sheet names, Column , and Row is used to identify absolute values; without the marking they are relative. " > With the exception of the requirement for references to always have a range marker, isn't this already stated in the syntax? > With reference to the range marker, why isn't that reflected in the syntax? > I am not sure what "The optional "$" marking in sheet names, Column , and Row is used to identify absolute values; without the marking they are relative." may mean. If it is an absolute value, then it isn't relative. Yes? Or is there some other meaning at work here? -- 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]