Bug 135448 - In calc, =SUM function not working
Summary: In calc, =SUM function not working
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.4.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-08-04 19:23 UTC by Gary
Modified: 2020-08-04 19:53 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Screen shot of bug. (2.40 MB, image/jpeg)
2020-08-04 19:25 UTC, Gary 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Gary 2020-08-04 19:23:29 UTC 
Description:
Use of -sum function to tally a column of numbers does not add those numbers but rather returns zero.

Steps to Reproduce:
1.Have a column of multiple rows of numbers
2.use =sum function to add series  (ie. =sum(a1:a7)   )
3.result is zero every time

Actual Results:
zero

Expected Results:
a number 


Reproducible: Always


User Profile Reset: Yes



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Comment 1 Gary 2020-08-04 19:25:11 UTC 
Created attachment 163952 [details]
Screen shot of bug.
Comment 2 Aron Budea 2020-08-04 19:53:59 UTC 
The data in column K that looks like numbers isn't treated is numbers (they'd be aligned to the right, and not to the left), that's why the sum is zero. If you fix that, sum will work.