https://bugs.freedesktop.org/show_bug.cgi?id=44817
Bug #: 44817 Summary: na() on summation of more than 30 items in xls format Classification: Unclassified Product: LibreOffice Version: LibO 3.4.4 release Platform: x86 (IA32) OS/Version: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Spreadsheet AssignedTo: libreoffice-bugs@lists.freedesktop.org ReportedBy: lu...@mail.com Created attachment 55620 --> https://bugs.freedesktop.org/attachment.cgi?id=55620 Calc error with sum() in xls format Using SUM() function in a spreadsheet to sum up more than 30 items/cells will return an error (Value not available). The error occurs ONLY after the spreadsheet is saved and reopened. This error condition appears to be OK if it is saved in ods format. A sample error is attached for clarification. Cell E31 is the demonstration of the error. Just duplicate C31 and add one more cell in the sum(). The result will be good at this point. Save the file in the current xls format and then reopen it. #NA will replace the previous result. Thank you for your support. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs