Issue 19199

Summary:

corrupt formula create with excel and open with openoffice

Product:

Calc

Reporter:

Unknown <non-migrated>

Component:

code

Assignee:

Status:

CLOSED IRREPRODUCIBLE

QA Contact:

issues@sc <issues>

Severity:

Trivial

Priority:

CC:

issues

Version:

OOo 1.1 RC3

Target Milestone:

---

Hardware:

OS:

Windows XP

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
the formula in this file is corrupt	none

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.