Bug 96911 - formulas not correct !
Summary: formulas not correct !
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.8.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-01-05 17:42 UTC by frank
Modified: 2016-09-03 09:12 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
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 frank 2016-01-05 17:42:42 UTC 
Dollar formula does not correctly show RED for -neg, ABS will not make a -neg total correctly, once a formula has been put in a block it seems not to take corrections.
Comment 1 frank 2016-01-05 17:44:45 UTC 
addition of a list of blocks =sum(B2:B12)sometimes not totaling.
Comment 2 m_a_riosv 2016-01-05 21:32:05 UTC 
Please could you attach a sample file, an explain a bit more in detail where to verify the issue.

Perhaps you are using numbers that are in cells as text?
Comment 3 frank 2016-01-07 01:55:43 UTC 
Problem found - CORRUPT csv file was used to start calc. The csv file changed the semicolon to a comma.
When sum a list of blocks a comma was put in by the csv file.