To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=42721 Issue #:|42721 Summary:|Conversion of calculated field to Excel results in |certain cases in an error Component:|Spreadsheet Version:|OOo 1.1.4 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|save-export Assigned to:|spreadsheet Reported by:|wereldreis
------- Additional comments from [EMAIL PROTECTED] Mon Feb 14 04:30:53 -0800 2005 ------- If in calculated field a fieldreference is set between brackets without any operator, this will result in a #VALUE error in MS Excel-2000 (SP3). Example: in field B2 I calculate a value as =A4*B4/(C4) Because C4 is between brackets without any operator, this will result in an error. (Yes, I do know the brackets are useless in these cases, but sometimes they are still there after correcting the calculation) If between brackets is also an operator, the conversion is without failure. Example: in field B2 I calculate a value as =A4*B4/(C4+C3) I have saved the spreatsheet in Excel 97/2000/XP (xls)format. --------------------------------------------------------------------- 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]
