[Libreoffice-bugs] [Bug 130698] New: sum error when opening an xlsx in Calc

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 130698
           Summary: sum error when opening an xlsx in Calc
           Product: LibreOffice
           Version: 6.0.7.3 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: roberg at iafrica.com

Description:
 open a spreadsheet created by an Excel user. The =sum() total is not correct.


Steps to Reproduce:
1. open file
2. I copy the data to rows > row 30, included totalling
3. notice that =sum totals are wrong sometimes
but, the sum in the status bar is correct.

Actual Results:
 checked in MS Excel, does not have same problem

Expected Results:
Totalling should be correct


Reproducible: Always


User Profile Reset: Yes



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes

Version: 6.0.7.3
Build ID: 1:6.0.7-0ubuntu0.18.04.10
CPU threads: 4; OS: Linux 5.3; UI render: default; VCL: gtk3; 
Locale: en-GB (en_GB.UTF-8); Calc: group

I did a clean install of Linux Mint Cinnamon 19.3 - problem is the same 

Same problem in LO v7

-- 
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/20200216/ddf2b615/attachment-0001.htm>