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=16229#action_16229 ] 

Michael Brauer commented on OFFICE-1508:


I still we are talking past each other. Eike's and my examples show, I hope, that a relative range is interpreted relative to the current cell, as you request. The purpose of the base address is not to make the relative address absolute, but to provide a base for calculating the offset defined by relative range. If we would interpret the relative address as an offset itself, you could not reference cells to the left or to the top. So

<table:named-expression table:name='myExpression' table:expression='[.B3]' table:base-cell-address='$Sheet1.$A$1' />

does not reference B2, but a cell one to the left and two to the bottom of the cell where "myExpression" is referenced.

<table:named-expression table:name='myExpression' table:expression='[.A1]' table:base-cell-address='$Sheet1.$B$3' />

in contrast would reference a cell one to the right and two to the top of the cell where "myExpression" is referenced.

If you think the current wording is not clear in this regard, do you have a suggestion how to clarify it?

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