Issue 12842 - data exchange between excel, OO, and gnumeric
Summary: data exchange between excel, OO, and gnumeric
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: john.marmion
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-03-30 19:03 UTC by mdsale
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

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

Attachments
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 mdsale 2003-03-30 19:03:44 UTC 
I have transferred a spreadsheet from gnumeric to OO with some manual
intervention to fix formulas and formats that did not transfer properly.
Now I'm attempting to read the resulting .xls file produced by OO 1.1Beta
into Excel.  Excel 2000 crashes when one cell is selected.  The formula
in that cell is:

=INDEX(Base;MATCH(Width;Widths;0);MATCH(Length;Lengths;0))*(1+CIndex)

Where "Base" is defined as:  $tables.$B$33:$tables.$R$42
Width is:   CostEstimator.$H$6
Widths is:  $tables.$A$33:$tables.$A$42
Length is:  CostEstimator.$H$7
Length is:  $tables.$B$32:$tables.$R$32
CIndex is:  $CostEstimator.$E$5

I can supply the .xls file, but it does need to be treated as confidential
data.

I am also working with the gnumeric developers to see if we can resolve
problems I've encountered from their side.

I need to be able to share data with users of Excel and OO, but I presently
prefer gnumeric for its speed and ease of use.

Thank you,

Matt
Comment 1 frank 2003-03-31 08:20:39 UTC 
Hi Daniel,

this seems to be your construction site.

So I've assigned this one to you.

Frank
Comment 2 john.marmion 2003-03-31 09:38:43 UTC 
Assuming ownership. 
Matt, I presume that this problem is a progression of the earlier
issue 8821 that you submitted. If you can re-create the problem with
that attached spreadsheet table-bug.xls, then please re-attach it
here. I notice that all your stated variables exist except for CIndex.
Comment 3 mdsale 2003-04-01 00:31:55 UTC 
I'd be glad to send the file to you directly, but I don't want it
posted for public view in the issue list.

I attempted saving the file as a 97/2000 template, that causes
Excel 2000 to crash as soon as the sheet is opened.

Thanks,

Matt
Comment 4 john.marmion 2003-04-01 15:02:34 UTC 
received the doc from the submitter and will look into this reported
problem.
Comment 5 mdsale 2003-04-01 16:37:35 UTC 
Appears to be a result of Excel's poor handling of an erroneous formula.
This formula resulted from a problem between gnumeric export and OO
import.
Comment 6 john.marmion 2003-04-01 16:48:27 UTC 
I have got agreement with the submitter(Matt) that this issue is a
result of invalid formula data on a particular sheet. But I need to
close this with the correct status. Marking is as fixed, means that QA
will want to know where the code fix is. The correct status is that is
closed because it is invalid.
Comment 7 john.marmion 2003-04-01 16:49:55 UTC 
closing because it is invalid.
Comment 8 john.marmion 2003-04-01 16:51:53 UTC 
mark as closed