https://bugs.documentfoundation.org/show_bug.cgi?id=157973
Bug ID: 157973
Summary: cell data will not accept date format
Product: LibreOffice
Version: 7.4.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 190499
--> https://bugs.documentfoundation.org/attachment.cgi?id=190499&action=edit
sample data demonstrating this bug
sometimes when you import data into a spreadsheet, some cells get imported as
plain text, and it is subsequently impossible to convert those cells into the
correct format.
Please note: Any solution which involves different user input during the
import process, is not a solution to the present bug, because the original data
source may no longer be available therefore it may not be possible to try the
import process again.
The attached file provides an example of imported data. There is nothing
special about this data, but due to some bug, Libre Office is treating this
data differently than it normally does.
For whatever reason, it is not possible to format the attached data as a date.
When the cell containing Aug 27, 2016 is formatted as a date, the cell changes
to 'Aug 27, 2016 instead of changing to 08/27/16. If the user types Aug 27,
2016 into a random cell, then that random cell becomes formatted as a date.
However, if the user copies the cell containing Aug 27, 2016 and then pastes
the result into a random cell, then that random cell does not become formatted
as a date.
--
You are receiving this mail because:
You are the assignee for the bug.
