[Libreoffice-bugs] [Bug 123533] New: CALC FORMATTING, AVERAGE FUNCTION

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=123533

            Bug ID: 123533
           Summary: CALC FORMATTING, AVERAGE FUNCTION
           Product: LibreOffice
           Version: 5.2.7.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: laf2005laurie at yahoo.com

Description:
Using AVERAGE across a row of 12 cells returns a different amount than using
SUM and dividing by 12. 
ie) =AVERAGE(B164,M164)  = 645,200.0
    =SUM(B164:M164) /12 = 645,116.7

The document was originally an Excel file (from a state data store). Opened in
LibreCalc Version: 5.2.7.2  
Build ID: 1:5.2.7-1+deb9u5
_Debian GNU Linux 9.7   

Steps to Reproduce:
1.Used:    =AVERAGE(B40,M40)
2. Noticed unequal answer to another cell with Sum (B40:M40) /12


Actual Results:
1. 52,200  (USING AVERAGE FUNCTION)
2. 52,467 (SUM same cells and dividing by 12--n of cells)

Expected Results:
= 52,466.67
data for your reference in one case- many other rows different numbers affected
the same in that average did not correctly work but sum and divide did.

53800+53700+53600+53500+53300+52900+52500+52000+51600+51200+50900+50600=629,600
629,600/12   = 52,466.67

AVERAGE SHOULD EQUAL SUM of cells divided by the nth number of cells added.


Reproducible: Sometimes


User Profile Reset: Yes



Additional Info:
The document was a State supplied excel sheet.  There were no functions in the
sheet, just numbers. Began using a formula to verify discrepancy all the way
thru the 40 year sheet, just outside of the table area that went to 258 N so
was putting formula in rows 1-258, column O, P and Q referencing the numbers in
the table. 

In the same sheet, copying the data to well below 258, the AVERAGE function
worked as did the sum /12 and after adding a new sheet, was able to paste the
numbers there and add the same average function but with correct answers.

It seems there is a compatibility issue with the data in the excel file.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190218/f9f72c76/attachment.html>