[Issue 97669] Calc wrongly changes dates

[bu...@apache.org]

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

Gaurav Kamani <gk...@my.fit.edu> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |gkamani2011@my.fit.edu

--- Comment #10 from Gaurav Kamani <gk...@my.fit.edu> ---
I tried replicating the bug on Windows 8.1 Pro machine, and also on Mac OS X
10.9.4. On both these systems I ran OpenOffice 4.1.1
The steps were a little different that the reported way (probably due to the
different versions of software).

On Windows 8.1
1. Open a new Spreadsheet
2. Then on the Menu Bar we select:
   - Tools
   - Then -> Option 
   - Then from the left pane we expand -> OpenOffice Calc (by clicking the     
     little '+' sign next to it)
   - Then -> Calculate
   - Then we find 'Date' on the top right pane, and confirm that "12/30/1899  
     (default)" is selected. If not, we select it.
   - Then we hit -> OK at the bottom of the dialog box.
3. Enter a date into a cell of the spreadsheet. We will need to remember that 
   date.
4. Then we save and close this spreadsheet.

5. Open a new spreadsheet
6. Then on the Menu Bar we select:
   - Tools
   - Then -> Option 
   - Then from the left pane we expand -> OpenOffice Calc (by clicking the     
     little '+' sign next to it)
   - Then -> Calculate
   - Then we find 'Date' on the top right pane, and and now select 01/01/1900 
     (StarCalc 1.0)"
   - Then we hit -> OK at the bottom of the dialog box.
7. Then we close this spreadsheet (Saving it or not saving it will not affect
the outcome)

8. Then we reopen the first saved spreadsheet
9. When we compare the date it will be two days behind.

Another anomaly:

- We make some changes to the spreadsheet, but not to the date. For example
  type some text in any other cell.
- Save and close this spreadsheet.
- Reopen the spreadsheet.
After we reopen, the date decreases by two days again.

Similar process is undertaken in MAC OS X as well.
The only difference is in a part of step (2) and step (6).
Modification:

-> On the Menu Bar we select:
   - OpenOffice
   - Then -> Preferences
     (This will reveal the same dialog box as "Options" will do on Windows.

So the bug replicates as "ooo@wolfachtal.de" points out.

Also, opening a new spreadsheet and following the process and changing the date
back to "12/30/1899  
(default)" will fix this issue.

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