Issue 21149 - Excel filter: Array constants are not imported.
Summary: Excel filter: Array constants are not imported.
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 1.1
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: ms_interoperability, rfe_eval_ok
: 72660 (view as issue list)
Depends on: 32342
Blocks:
  Show dependency tree
 
Reported: 2003-10-14 08:07 UTC by daniel.rentz
Modified: 2013-08-07 15:14 UTC (History)
3 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Test document with array constants (13.50 KB, application/octet-stream)
2003-10-14 08:12 UTC, daniel.rentz 		no flags Details
Use new ScMatrix abilities, and remove O(n^2) code (11.37 KB, patch)
2007-05-23 14:50 UTC, jodygoldberg 		no flags Details | Diff
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description daniel.rentz 2003-10-14 08:07:46 UTC 
Array constants in Excel files are not imported.
See attached document for some examples.
Comment 1 daniel.rentz 2003-10-14 08:12:35 UTC 
Created attachment 10296 [details]
Test document with array constants
Comment 2 daniel.rentz 2003-10-14 09:11:18 UTC 
started
Comment 3 frank 2004-05-04 14:41:06 UTC 
Due to limited time ressources I re-Target this one to OOo Later
Comment 4 erwin.tenhumberg 2004-10-26 16:14:43 UTC 
enhanced summary, set keywords and reassigned issue according to RFE process
Comment 5 frank 2004-10-28 08:40:21 UTC 
Hi Dancer,

never touch an Issue assigned to a developer. Such Issues are worked on
especially if the have the staus started.

Frank
Comment 6 frank 2004-10-28 08:40:47 UTC 
reset started
Comment 7 frank 2007-01-16 13:25:24 UTC 
*** Issue 72660 has been marked as a duplicate of this issue. ***
Comment 8 jodygoldberg 2007-04-24 16:22:03 UTC 
The patch in 32342 supports xls in/out
Comment 9 jodygoldberg 2007-04-24 17:00:27 UTC 
The patch still has some issues with xls export.  After doing a recalc in XL the
value is incorrect for SUM({1,2}).  It looks like it's getting the wrong
operator class.

dr : do you have a write up of the new and improved mechanism for ptg classing ?
Comment 10 jodygoldberg 2007-05-23 14:50:01 UTC 
Created attachment 45344 [details]
Use new ScMatrix abilities, and remove O(n^2) code
Comment 11 jodygoldberg 2007-05-23 14:50:45 UTC 
dr : This patch is in jgarrays now.
Comment 12 daniel.rentz 2007-05-23 14:56:26 UTC 
jody: reviewed, ok with me
Comment 13 ooo 2007-05-23 17:11:50 UTC 
Implemented in CWS jgarrays.
Comment 14 ooo 2007-05-23 17:12:22 UTC 
Reassigning to QA.
Comment 15 oc 2007-06-13 08:54:00 UTC 
verified in internal build cws_jgarrays
Comment 16 oc 2007-08-01 07:39:23 UTC 
closed because fix available in SRC680_m221
Comment 17 Unknown 2010-10-23 07:01:06 UTC 
Created attachment 72372