Issue 31257 - exporting array functions to excel doesn't work
Summary: exporting array functions to excel doesn't work
Status: CLOSED DUPLICATE of issue 3724
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.2
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: frank
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-07-08 18:12 UTC by andrejk
Modified: 2004-10-22 12:31 UTC (History)
1 user (show)

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

Attachments
Testdoc in sxc format (5.42 KB, application/octet-stream)
2004-07-09 11:08 UTC, frank 		no flags Details
Testdoc in xls format (7.00 KB, application/octet-stream)
2004-07-09 11:08 UTC, frank 		no flags Details
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 andrejk 2004-07-08 18:12:42 UTC 
When opening an excel spreadsheet created using open office, in excel xp 2002,
all cell containing array functions display error messages. I have to go to
every single cell, press ctrl+shift+enter and then it works. The array functions
displayed by excel in edit mode look ok, but somehow cause errors.
Comment 1 frank 2004-07-09 09:22:33 UTC 
Hi,

using a document created by myself does not show the described behaviour, so
this is not reproducible. Please attach a document showing the problem. Best
would be an Excel and an OOo Calc version of the doc.

Frank
Comment 2 andrejk 2004-07-09 09:44:26 UTC 
How do i add an attachment? The 'attachments:' label in the issue is not a link.
Comment 3 frank 2004-07-09 09:54:17 UTC 
Just use the link 'create a new attachment' next to the Attachments: sign.

Frank
Comment 4 andrejk 2004-07-09 09:57:06 UTC 
I don't see that link.
Comment 5 frank 2004-07-09 10:10:50 UTC 
Hhhhm, you have to be logged in to create an attachment but you have to be
logged in to add a comment. The link is to the right of the Attachments: section
right under the Keywords input line and directly left of the (proposed patch,
testcase, etc.) text. 

Frank
Comment 6 frank 2004-07-09 11:08:00 UTC 
Created attachment 16346 [details]
Testdoc in sxc format
Comment 7 frank 2004-07-09 11:08:49 UTC 
Created attachment 16347 [details]
Testdoc in xls format
Comment 8 frank 2004-08-06 11:30:30 UTC 
No answer since July 9 and not reproducible. So I close this one as wfm

Frank
Comment 9 frank 2004-08-06 11:30:46 UTC 
closed wfm
Comment 10 andrejk 2004-08-06 12:02:38 UTC 
Answer to what?

It doesn't work, and it's very easily reproducable: open the test doc in sxc
format, then save it as an xls document from openoffice, and then open the xls
document in excel. You'll see a bunch of error messages: #VALUE!
Comment 11 frank 2004-08-06 13:26:59 UTC 
Sorry AndrejK,

my fault, I thought that the documents are my testdocs but forgot that I
attached them from your PM.

Nevertheless, Daniel and I found out that this is a double to Issue 3724.

Again sorry for any inconvenience.

Frank

*** This issue has been marked as a duplicate of 3724 ***
Comment 12 frank 2004-08-06 13:27:20 UTC 
closed double
Comment 13 daniel.rentz 2004-08-06 13:30:26 UTC 
additional note: even if issue 3724 looks completely unrelated to this one, it
is the same place in the source code.

I will attach this bugdoc to the old issue.
Comment 14 andrejk 2004-08-06 13:35:41 UTC 
Ok, no problem, thanks
Comment 15 daniel.rentz 2004-10-22 12:31:55 UTC 
fixed in OOo 2.0