Bug 1314498

Summary: Calc adds cells together that shouldnt be added.
Product: Red Hat Enterprise Linux 6 Reporter: Bill Sanford <bsanford>
Component: libreofficeAssignee: Eike Rathke <erack>
Status: CLOSED NOTABUG QA Contact: Desktop QE <desktop-qa-list>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 6.8CC: dtardon, jkoten, tpelka, vbenes
Target Milestone: rc   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-03-04 12:53:18 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
screen capture of the cells being addad none

Description Bill Sanford 2016-03-03 18:53:10 UTC
Created attachment 1132894 [details]
screen capture of the cells being addad

Description of problem: 

In LO calc, I can add a text cell, a date cell and a currency cell and have the sum as an obfuscated total. When I edit the date field and change the days, months or years, the sum total changes to reflect the total that the date field thinks it is.

In each cell you format each one, respective of what they are. Format -> Cells -> Numbers Tab, in the Category box, select the format that each cell will represent. 


Version-Release number of selected component (if applicable):
RHEL-6.8-20160225.0
libreoffice-4.3.7.2-2

How reproducible:
100%

Steps to Reproduce:
1. See Above.
2.
3.

Actual results:


Expected results:


Additional info:

Comment 1 Bill Sanford 2016-03-03 20:58:39 UTC
A date will have the value (In days) from 01/01/1900 to <DATE_ENTERED> on the sheet. Using that figure as an operand as a default action, seems like the #VALUE error should be raised until a setting in Calc has changed.

Comment 2 Eike Rathke 2016-03-04 12:53:18 UTC
A date (+time) is just a numeric value, the number of days since null date (serial date number), formatted as date/time. You can see the underlying number when setting the number format to General. As it is a numeric value it can be calculated with as any other number. This is not a bug, this is how most spreadsheet applications handle date/time.