Issue 19199 - corrupt formula create with excel and open with openoffice
Summary: corrupt formula create with excel and open with openoffice
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC3
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-09-07 12:01 UTC by Unknown
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

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

Attachments
the formula in this file is corrupt (1.24 MB, application/octet-stream)
2003-09-07 12:07 UTC, Unknown 		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 Unknown 2003-09-07 12:01:06 UTC 
Problem with a spreadsheet:
I've generated it with Office 2000 excel.
I open it with openoffice 1.1 rc3 and the formula is corrupt.
Comment 1 Unknown 2003-09-07 12:07:52 UTC 
Created attachment 9070 [details]
the formula in this file is corrupt
Comment 2 Unknown 2003-09-07 12:09:40 UTC 
The formula for field n4 is corrupt
Comment 3 john.marmion 2003-09-08 10:19:15 UTC 
The content of the Formula looks identical in both Excel and Calc or
am I missing something obvious? What is different is in how Excel and
Calc display the result of the formula. Calc display a '#REF' error
because the formula itself contains a '#REF' entry. Removing this
invalid entry and Calc display the same result as Excel. The behaviour
of Calc appears to be more correct here. Calc displays a #REF result
because there is an invalid entry in the Formula. Excel simply ignores
this and displays the result as if this entry was not in the formula.
So, correcting the invalid formula will give the correct result in
both applications. I will close this as WORKSFORME
Comment 4 john.marmion 2003-09-08 10:21:20 UTC 
mark as closed
Comment 5 Unknown 2003-09-08 10:43:46 UTC 
Thanks, i just realized that i had an inavalid reference.
I's working now.