Issue 83570 - Date changes randomly when on certain row of a spreadsheet
Summary: Date changes randomly when on certain row of a spreadsheet
Status: CLOSED DUPLICATE of issue 76623
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: OOo 2.3
Hardware: All Windows, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-11-12 16:34 UTC by smeracing
Modified: 2007-11-13 11:35 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Date formatting issue cell A7 (64.00 KB, text/plain)
2007-11-12 16:36 UTC, smeracing 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description smeracing 2007-11-12 16:34:24 UTC 
Please see the attached spreadsheet.

The date entered in row A7 was 11/11/1967 (as it shows in the formula bar when 
you click on it) however, after any further changes are made to the 
spreadsheet, the cell contents display 10/11/67 and i can't for the life of me 
figure out why.

I have tried re ordering the sheet but the same issue occurs with whatever date 
is in that cell. i have tried typing all the data again manually and the same 
issue occurs.

Curiously, if you scroll through the data with the cursor keys, when you scroll 
down over the cell the incorrect (10/11/67) date is displayed in the formula 
bar, if you scroll up over the cell, it diplays the correct info in the formula 
bar (11/11/67).

Please let me know if you need any further information

Many Thanks
Comment 1 smeracing 2007-11-12 16:36:41 UTC 
Created attachment 49593 [details]
Date formatting issue cell A7
Comment 2 frank 2007-11-13 11:34:43 UTC 
Hi,

this seems to be a double to Issue 76623 which is fixed for the upcoming OOo2.3.1.

Frank

*** This issue has been marked as a duplicate of 76623 ***
Comment 3 frank 2007-11-13 11:35:05 UTC 
closed double