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-1508) Named relative cellranges

    [ http://tools.oasis-open.org/issues/browse/OFFICE-1508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16133#action_16133 ] 

Michael Brauer commented on OFFICE-1508:

It seems to me that there is still a misunderstanding. I may be wrong, but my reading of Eike's explanation is that .B2 in the expression does not denote the cell that is one to the left and two to the bottom of the current cell directly, but still the cell B2. But the expression gets relative by calculating the offset to the cell denoted by the table:base-cell-address. Which means, that the two elements actually are equivalent:

 <table:named-expression table:name='myExpression' table:expression='[.B2]+[.B3]' table:base-cell-address='$Sheet1.$A$1' /> 
 <table:named-expression table:name='myExpression' table:expression='[.C3]+[.C4]' table:base-cell-address='$Sheet1.$B$2' /> 

If the cell addresses would be interpreted as offsets to current cell directly, then it actually would be impossible to refer to cells to the right or the top. Maybe a clarification in the specification is reasonable, but if my interpretation is correct, then the way relative cell ranges are specified seems to be reasonable to me.

> Named relative cell ranges
> --------------------------
>                 Key: OFFICE-1508
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-1508
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Improvement
>          Components: Table
>    Affects Versions: ODF 1.2
>            Reporter: Andreas Guelzow 
>            Assignee: Andreas Guelzow 
>            Priority: Minor
>             Fix For: ODF 1.2
> 17.638 currently contains the paragraph:
>  If the expression contains a relative cell range address, a table:base-cell-address attribute must also appear on the <table:named-expression> element.
> The spreadsheet program Gnumeric allows for named ranges that are interpreted relative. This is useful for situations were one wants to write many similar formulas that for example refer to a certain number of cells to the top right.

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]