Issue 8184 - save as MS excel gives formula errors when opened in excel
Summary: save as MS excel gives formula errors when opened in excel
Status: CLOSED DUPLICATE of issue 3724
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.1
Hardware: PC Windows 98
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2002-10-09 17:02 UTC by rpolson
Modified: 2004-10-22 12:27 UTC (History)
1 user (show)

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


Attachments
calc document saved as MS excel 2000 (8.50 KB, application/octet-stream)
2002-10-09 17:03 UTC, rpolson
no flags Details
calc document saved as MS excel 2000 (8.50 KB, application/octet-stream)
2002-10-09 17:09 UTC, rpolson
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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