OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[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]