[sc-issues] [Issue 93057] saving files as .xls corru pts data
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93057 User mechtilde changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from [EMAIL PROTECTED] Fri Nov 7 20:26:31 + 2008 --- close the WORKSFORME issue - 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]
[sc-issues] [Issue 93057] saving files as .xls corru pts data
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93057 Issue #|93057 Summary|saving files as .xls corrupts data Component|Spreadsheet Version|OOo 2.4.1 Platform|Sun URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|formatting Assigned to|spreadsheet Reported by|safetybiker --- Additional comments from [EMAIL PROTECTED] Sat Aug 23 20:38:45 + 2008 --- I am attaching two very simple spreadsheets. One is saved in .xls, the other in .ods. When OpenOffice Calc opens the .xls file, the formula in cell E23 returns #N/A. The calculation is not performed. - 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]
[sc-issues] [Issue 93057] saving files as .xls corru pts data
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93057 --- Additional comments from [EMAIL PROTECTED] Sat Aug 23 20:40:24 + 2008 --- Created an attachment (id=55960) spreadsheet in .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]
[sc-issues] [Issue 93057] saving files as .xls corru pts data
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93057 --- Additional comments from [EMAIL PROTECTED] Sat Aug 23 20:41:10 + 2008 --- Created an attachment (id=55961) spreadsheet in .ods 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]
[sc-issues] [Issue 93057] saving files as .xls corru pts data
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93057 User regina changed the following: What|Old value |New value CC|''|'regina' Status|UNCONFIRMED |RESOLVED Keywords| |oooqa Priority|P2|P3 Resolution| |WORKSFORME Subcomponent|formatting|save-export --- Additional comments from [EMAIL PROTECTED] Sat Aug 23 21:55:32 + 2008 --- That is a limit in Excel. Up to Excel 2003 the AVERAGE function can have at most 30 arguments and your formula uses 32. So there is nothing OOo can do. Use ranges for those parts, where the cells are adjacent, to decrease the number of arguments. - 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]