https://bugs.freedesktop.org/show_bug.cgi?id=73222
--- Comment #1 from Dominique Boutry <dominique.bout...@laposte.net> ---
Hi. Investigations under libO 4.2.0.1 rc1 on Win7 :
- on my (english) system, the format of 02-01-2014 is "number", not "date"
neither "text" ; explanation in Tools/Options/Language Settings/Language, set
to "D/M/Y;D/M;D-M" : not "D-M-Y", so OK. Is it the same in your "language
dependant" settings ?
- I admit tha "number" is a questionnable choice, it should have been "text"
("number" only if the text is a well-formed number).
- the function VALUE(x) waits a "text" argument (see online doc), so it rightly
fails in "=value(A1)" in cell B1 containing "Err:502". Do you confirm ?
- no place in LibO documentation suggests that a cell in error should contain
in background the offending content, so the copy/paste from B1 to C1 had no
chance to result in a "date" or "number" format. The copy/paste special (value
only) rightly results in a blank cell.
IMHO, the current (and only) bug resides in the bad automatic formatting of
02-01-2014.
--
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
