[Bug 123178] New: Time values not adding up correctly

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=123178

            Bug ID: 123178
        Issue Type: DEFECT
           Summary: Time values not adding up correctly
           Product: Calc
           Version: 4.0.0
          Hardware: PC
                OS: Windows XP
            Status: UNCONFIRMED
          Severity: minor
          Priority: P3
         Component: editing
          Assignee: issues@openoffice.apache.org
          Reporter: vistaennisclare@gmail.com
                CC: issues@openoffice.apache.org

Created attachment 81444
  --> https://issues.apache.org/ooo/attachment.cgi?id=81444&action=edit
See above in the description...straight forward.

See the attachment: This is a simple time sheet that I have been using for more
than two years. It has two weeks of data. The time is entered in hours and
minutes. One of the weeks added up correctly and the other did not. The format
for the cells has not changed. I have used this sheet a couple of times since I
put in release 4.0.0.
What could cause this. By the way, I took a fresh copy of the master for this
sheet and put in the same data...same result so that it is not a one in a
million I/O error or dirty hard drive sector.
...Howard

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 123178] Time values not adding up correctly

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=123178

Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |rainerbielefeld_ooo_qa@biel
                   |                            |efeldundbuss.de
         Resolution|---                         |IRREPRODUCIBLE

--- Comment #1 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
Effect is reproducible with  "AOO 4.0.0 – German UI / German locale 
[AOO400m3(Build:9702)  -  Rev. 1503704 2013-07-16 14:54:56 (Di, 16 Jul 2013)]"
on German German WIN7 Home Premium (64bit)", Common 4.0-dev User Profile

But reporter's problem has nothing to do with addition problems, the problem
simply is caused by contents of cell C20, what is "57600:00:00" instead of
"00:00", what is something "27. July 1906" instead of base date 
"31. December 1899". I doubt that that is caused by an AOO bug, most probable
is some small inattention.

so I close this one for now


@Howard Williams
Some general hints: Please always contribute useful information due to
<http://wiki.openoffice.org/wiki/QA/HowToFileIssue#Reporting%20a%20New%20Bug#Principles>
a) Precise Summary, what exactly is the problem?
b) contribute a precise description what problem you see like "In Cell B I
expect
   xxx because in Help yyyy I read zzz".
With such a little careful research you normally will find the real problem
within few minutes.

Please feel free to reopen the bug if you find evidence that the cell contents
of C20 has been damaged by an AOO bug and if you can contribute a step by step
instruction how to reproduce the bug.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.