To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=48761
Issue #:|48761
Summary:|cell range syntax A1:B2 does not support formulas for
|the cell reference
Component:|Spreadsheet
Version:|OOo 2.0 Beta
Platform:|PC
URL:|
OS/Version:|Windows XP
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|editing
Assigned to:|spreadsheet
Reported by:|sinewalker
------- Additional comments from [EMAIL PROTECTED] Thu May 5 03:05:14 -0700
2005 -------
When entering a cell range into calc for the SUM() function, it does not parse
the colon syntax if I use a reference function such as INDIRECT(). Non-range
formulas do work however.
I first saw this in OOo 1.1.1 and recreated in OOo 1.9.m100 (downloaded today).
The attached calc spreadsheet shows an example formula using
INDIRECT(ADDRESS(CELL("ROW";A8);3)) to return a cell reference as both parts of
the range description:
SUM(INDIRECT(ADDRESS(CELL("ROW";A8);3)):INDIRECT(ADDRESS(CELL("ROW";A10);3)))
which results in Err508 (missing parameter). However if I replace the colon
with a semicolon, this will parse (although it only sums the 1st and 3rd cell,
not all three).
This syntax does work in M$-Excel (I am attempting to convert a sheet to calc).
An example of the Excel formula is attached too. Although it uses different
functions to achieve the same aim, it is the range syntax that is the issue.
I was unsure if I should classify this as a DEFECT. It could also be treated as
an ENHANCEMENT request: a new spreadsheet function that can take cell
references as arguments and return a range would be a suitable fix for this.
i.e. if this proposed new function was called RANGE():
SUM(RANGE(INDIRECT(ADDRESS(CELL("ROW";A8);3));INDIRECT(ADDRESS(CELL("ROW";A10);3))))
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
