Bug 83077 - FORMATTING: Problem converting date formats
Summary: FORMATTING: Problem converting date formats
Status: CLOSED DUPLICATE of bug 33962
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Reported: 2014-08-26 01:15 UTC by Anton Lodder
Modified: 2014-09-04 09:55 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Anton Lodder 2014-08-26 01:15:45 UTC
Problem description: 

Steps to reproduce:
1. Set date pattern to 'Y-M-D;M-D'
2. copy-paste a text date value from a text document into a cell, e.g. '2014-08-26'
3. press the 'format as date' button

Current behavior:

Puts an ` character in front of the text, does not recognize it as a date. This means you can't paste dates into a spreadsheet and have them recognized / sorted with dates that you manually entered into the spreadshit

Expected behavior:
Should read the string and recognize it as a date.

Operating System: Ubuntu
Version: release
Comment 1 Joel Madero 2014-09-04 08:00:57 UTC
While the technical details are beyond me this is well known (and happens on other office suites). That being said: http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates

I've already requested that this be added in core so I'm going to close this bug as a duplicate of mine. There are reasons to not implement it (again, the technical reasons are beyond me) but the request is out there.

*** This bug has been marked as a duplicate of bug 33962 ***
Comment 2 Eike Rathke 2014-09-04 09:55:02 UTC
It would already help to check the option "Detect special numbers (such as dates)" when pasting such string from an external application. And for the ISO 8601 dates in the format YYYY-MM-DD you don't have to change the date acceptance patterns, they are always recognized.