RHEL Engineering is moving the tracking of its product development work on RHEL 6 through RHEL 9 to Red Hat Jira (issues.redhat.com). If you're a Red Hat customer, please continue to file support cases via the Red Hat customer portal. If you're not, please head to the "RHEL project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs in the statuses "NEW", "ASSIGNED", and "POST" are being migrated throughout September 2023. Bugs of Red Hat partners with an assigned Engineering Partner Manager (EPM) are migrated in late September as per pre-agreed dates. Bugs against components "kernel", "kernel-rt", and "kpatch" are only migrated if still in "NEW" or "ASSIGNED". If you cannot log in to RH Jira, please consult article #7032570. That failing, please send an e-mail to the RH Jira admins at rh-issues@redhat.com to troubleshoot your issue as a user management inquiry. The email creates a ServiceNow ticket with Red Hat. Individual Bugzilla bugs that are migrated will be moved to status "CLOSED", resolution "MIGRATED", and set with "MigratedToJIRA" in "Keywords". The link to the successor Jira issue will be found under "Links", have a little "two-footprint" icon next to it, and direct you to the "RHEL project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/RHEL-XXXX", where "X" is a digit). This same link will be available in a blue banner at the top of the page informing you that that bug has been migrated.

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:

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.

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.