Issue 8184

Summary:

save as MS excel gives formula errors when opened in excel

Product:

Calc

Reporter:

rpolson <rpolson4>

Component:

code

Assignee:

Status:

CLOSED DUPLICATE

QA Contact:

issues@sc <issues>

Severity:

Trivial

Priority:

CC:

issues

Version:

OOo 1.0.1

Target Milestone:

---

Hardware:

OS:

Windows 98

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
calc document saved as MS excel 2000	none
calc document saved as MS excel 2000	none

Description rpolson 2002-10-09 17:02:26 UTC

Hi-

I have a spreadsheet document with a few simple formulas.  When I use "save as microsoft excel" the formulas have errors when the document is 
opened in excel.  The excel cell has the error #VALUE.  If I then go to edit the forumla, make no changes, then hit enter, the value is calculated 
correctly.  I get the same error if I save as excel 5.0 or 2000.

-Randy

Comment 1 rpolson 2002-10-09 17:03:49 UTC

Created attachment 3101 [details]
calc document saved as MS excel 2000

Comment 2 rpolson 2002-10-09 17:09:02 UTC

Created attachment 3102 [details]
calc document saved as MS excel 2000

Comment 3 daniel.rentz 2002-10-10 12:46:58 UTC

Known issue. You can work-around this by deleting the parentheses
around single cell references, i.e.:
=$B$2*$B$2/(2*1,8*B4*1000)
instead of
=($B$2)*($B$2)/(2*1,8*B4*1000)

*** This issue has been marked as a duplicate of 3724 ***

Comment 4 daniel.rentz 2002-10-10 12:47:26 UTC

Duplicate

Comment 5 daniel.rentz 2004-10-22 12:27:47 UTC

fixed in OOo 2.0