To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=40835 Issue #:|40835 Summary:|Formulas exported to microsoft xls not recognized by |microsoft excel Component:|Spreadsheet Version:|OOo 1.1.4 Platform:|All URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|save-export Assigned to:|spreadsheet Reported by:|richpatak
------- Additional comments from [EMAIL PROTECTED] Mon Jan 17 12:54:32 -0800 2005 ------- 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, --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
