https://bugs.freedesktop.org/show_bug.cgi?id=83116
ariel cornejo <arie...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |UNCONFIRMED
Ever confirmed|1 |0
--- Comment #5 from ariel cornejo <arie...@gmail.com> ---
(In reply to Owen Genat from comment #4)
> Unable to reproduce under GNU/Linux using v4.3.2.2. The initially imported
> values are displayed using a date-time format code of DD/MM/YY HH.MM however
> editing this to DD/MM/YYYY HH.MM.SS.0000000 reveals sub-second detail.
> Perhaps try highlighting the imported data and using the indicated format to
> see if it makes any difference?
I just tried with version 4.4.0.0.alpha0
(24fb87501ef9d5aa715d572de7eb5efe49a0d9c3). Values in rows 4,14,15,25,26,36-40
are imported as text:
* the cells show e.g. "2014-08-26 15:01:52.999609000" and are left aligned
* TYPE() evaluates to 2
* the format can't be changed
* interestingly, arithmetic expressions like =F2+1/24 work on these unconverted
cells. Apparently they're being converted automatically.
These are the results of three conversion methods:
File > Open > Column type = Date (YMD):
Paste > Column type = Text > Text to columns > Column type = Date (YMD):
Cells with fractional part < 0.9995 are imported as dates and the rest remain
as text.
Paste > Column type = YMD:
OK. TYPE() evaluates to 1 and the format can be changed.
> Status set to NEEDINFO. Please set back to UNCONFIRMED once the requested
> information is provided.
I'm attaching a spreadsheet with the results of all three cases.
Any idea on the relevant bits of source for conversion? I built from source
specifically to help tackle this.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
