[Libreoffice-bugs] [Bug 124712] New: LibreCalc sum function returns a 0 when used to sum data from an imported csv file.
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Fri Apr 12 22:39:28 UTC 2019
https://bugs.documentfoundation.org/show_bug.cgi?id=124712
Bug ID: 124712
Summary: LibreCalc sum function returns a 0 when used to sum
data from an imported csv file.
Product: LibreOffice
Version: 6.0.7.3 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs at lists.freedesktop.org
Reporter: mallardw at gmail.com
Description:
I imported a csv file from bank and it was properly imported into calc - all
data was there and properly formatted. However, the SUM function when used to
total columns of numeric data, returned a 0. Other simple operations like add,
subtract, etc work fine. The SUM function works fine on a new worksheet or a
Microsoft Office Excel file but not the CSV imported file.
Steps to Reproduce:
1.Import a CSV file into Calc
2.Choose a column of numbers and use the SUM function to total values.
3.All other operations like add, subtract seem to work fi
Actual Results:
ne.
Expected Results:
SUM of data was always 0
Reproducible: Always
User Profile Reset: No
Additional Info:
Returned the sum of the chosen numbers.
--
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/20190412/9654f98f/attachment.html>
More information about the Libreoffice-bugs
mailing list