[Bug 163724] Missing autodetect functionality for number formats

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=163724

--- Comment #3 from Eyal Rozenberg <eyalroz1 at gmx.com> ---
(In reply to Heiko Tietze from comment #2)
> Nope, the data should rather be interpreted properly. And actually it is, or
> what example does not work for you?

Example 1
----------

1. Create a table in Writer with at least 2 cells in a column.
2. Type 18:30 and 19:30 respectively into those two cells
3. Select & Copy the two cells
4. Clear any selected range in Calc.
5. Paste

I see the date formatted as:

06:30:00 PM
07:30:00 PM

and no offer to choose the format. Weird.


Example 2
---------

Select the following two lines:

2001-12-30 17:30
2001-12-29 17:00

and paste them in a Calc sheet. A text import dialog comes up, suggesting the
use of ':' and ' ' as separators, with 3 standard columns. I would expect a
single datetime column, or two columns, one with date and the other wite time.

-- 
You are receiving this mail because:
You are on the CC list for the bug.