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
