[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=16240#action_16240 ] Andreas Guelzow commented on OFFICE-1508: ------------------------------------------ Michael, I understand your and Eike's example to show that the relative range is interpreted relative to the table:base-cell-address (which must be absolute), not with respect to the current cell (current with respect to the use of the name) i.e I want to define "leftthree" to refer to the three cells to the right. So when I am entering =sum(leftthree) in the cell .E6 it calculates effectively .B6+.C6+.D6 when I am entering =sum(leftthree) in the cell .X8 it calculates effectively .U8+.V8+.W8 In your examples, the expression is always calculated relative to the table:base-cell-address which is is stated to be absolute so I can't appear to be able to define such a "leftthree". The definition of a name is done for a spreadsheet (ie. inside a table:named-expression inside an office:spreadsheet. But it is used inside an expression entered in various cells. I am talking about interpreting the expression relative to each cell in which it is used. > 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]