To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49863
------- Additional comments from [EMAIL PROTECTED] Thu May 26 08:01:20 -0700 2005 ------- Attached is subtotaltest.csv. Highlight the whole sheet and select Data->Subtotal. Subtotal the first three colums and group by the Fourth Column. You should then get SUM subtotals for Group A and Group B and then a Grand Total. Save to .xls and open .xls and you get =#NA where the subtotals were. Do the above again and save to .ods. Reopen .ods and then save to .xls and reopen .xls and the =SUBTOTAL functions are now there. --------------------------------------------------------------------- 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]