Bug 59692 - Date change automatic after paste from excel
Summary: Date change automatic after paste from excel
Status: RESOLVED DUPLICATE of bug 37501
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.4.3 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-01-22 02:27 UTC by Rungsan
Modified: 2013-01-22 08:48 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Rungsan 2013-01-22 02:27:01 UTC 
step.

1. create new spreadsheet.
2. change locale to English and date acceptance to d/m/y.
3. enter date 15/11/2012.
4. create new spreadsheet in excel 2007 thai. 
5. set calendar type to western.
6. enter date 30/11/2012.
7. copy date from excel and paste to other cell in Calc.
8. date in Cale as 15/11/2012 change to 13/11/2012.
Comment 1 Rainer Bielefeld Retired 2013-01-22 08:48:39 UTC 
User error, so INVALID!

@Rungsan:
In reality you only copy numbers instead of Dates. You can see that if you change cell format from date to number in cell.

Shown date depends on setting in menu 'Tools -> Options -> Calc -> Calculate - Date' an somewhere in Excel. It is user's responsibility to make sure that both documents use same date base.

*** This bug has been marked as a duplicate of bug 37501 ***