Issue 40835 - Formulas exported to microsoft xls not recognized by microsoft excel
Summary: Formulas exported to microsoft xls not recognized by microsoft excel
Status: CLOSED DUPLICATE of issue 3724
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 1.1.4
Hardware: All Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-01-17 20:54 UTC by richpatak
Modified: 2005-01-19 14:50 UTC (History)
1 user (show)

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

Attachments
Contents of c65 to c75 not understood by microsoft in this xls file (14.00 KB, application/vnd.ms-excel)
2005-01-17 20:56 UTC, richpatak 		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 richpatak 2005-01-17 20:54:32 UTC 
When exporting a spreadsheet to Microsoft Excel 97/2000/XP (xls) some formulas 
are not recognized as formulas by Microsoft Excel. 
 
A spreadsheet made with OO 1.1.4 (and 1.1.3) which works correctly and is 
exported to xls format will not work with Microsoft Excel but DOES WORK when 
the xls file is opened in OO 1.1.4 
 
Simple formulas such as  COS(B59) work but anything more complex such as 
COS(B59)*(D52) fails. 
 
What's more, careful examination of the cell contents using the Microsoft 
product shows correct cell contents on the "equals line" above but the results 
show #VALUE! in the cell. Only if the cell contents is manually entered to 
exactly the same thing will the cell calculate the correct value.  Manually, 
means the hard way, by using the keyboard to copy text. 
 
I have a 14 KB xls formatted xls file which clearly indicates the problem but 
I don't know how to attach it to this report. 
Specifically, using Excel from Office 97 SR2 results in nonsense,
Comment 1 richpatak 2005-01-17 20:56:56 UTC 
Created attachment 21624 [details]
Contents of c65 to c75 not understood by microsoft in this xls file
Comment 2 frank 2005-01-19 14:50:27 UTC 
Hi,

this is a double to Issue 3724 which is fixed for OOo2.0 .

Frank

*** This issue has been marked as a duplicate of 3724 ***
Comment 3 frank 2005-01-19 14:50:49 UTC 
closed double^