To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=50000
User nn changed the following:
What |Old value |New value
================================================================================
Assigned to|nn |er
--------------------------------------------------------------------------------
Component|Formula editor |Spreadsheet
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Issue type|DEFECT |ENHANCEMENT
--------------------------------------------------------------------------------
OS/Version|Windows XP |All
--------------------------------------------------------------------------------
Priority|P2 |P3
--------------------------------------------------------------------------------
QA contact|[EMAIL PROTECTED] |[EMAIL PROTECTED]
--------------------------------------------------------------------------------
Platform|PC |All
--------------------------------------------------------------------------------
Summary|Opening Dutch Excel 2003- |Allow reference results in
|document with array's. |array formulas
--------------------------------------------------------------------------------
Target milestone|--- |OOo Later
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Thu Jun 2 07:32:34 -0700
2005 -------
In fact, the errors in the attached document are caused by three different
problems:
1. There are intermittent errors in string concatenation within arrays, seen in
C22:J22. This is now issue 50145, target 2.0.1.
2. The "Err:508" as well as the repeated values in column A are caused by the
use of the "range operator", which we don't have. This is issue 4904 and will be
one of the next things we add to the calculation engine (but nor for 2.0.x).
If, in the Excel file, you had used "Blad2!$A$23:$A$30" instead of
"Blad2!$A$23:Blad2!$A$30", it would be a single range reference instead, which
works fine in Calc.
3. The cells with the long formula have "Err:504" because they rely on having
cell reference results in an array formula (the combination of INDIRECT and
OFFSET). We don't support that.
Line feeds in formula results aren't supported, see issue 18302.
We'll keep this issue open as an enhancement issue for for reference results in
array formulas (point 3 above, the only thing that's not covered by other
issues), I'm adjusting the title. Other formula improvements seem more important
at the moment, so don't expect it very soon.
Summary: We need to be able to have cell range references as elements of a
matrix, so they can be used in array formulas.
---------------------------------------------------------------------
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]
