https://bugs.freedesktop.org/show_bug.cgi?id=73222
--- Comment #2 from Fernando <[email protected]> --- Created attachment 91624 --> https://bugs.freedesktop.org/attachment.cgi?id=91624&action=edit Testcase Hi Dominique, thanks for your reply. I looked at my "language dependent" settings and they are "D-M-Y;D-M", corresponding to my regional settings (Portugal). My problem ocurred in a csv file with an account extract. Cell A1, with date ex.07-01-2014 was left alined and was not afected by changing number format, thus I suposed was text. Using the formula =value(A1) in cell B1 doesn't report "Err:502", instead, gives a value 41646. Formating B1 to date "DD-MM-AAAA" gives 07-01-2014 (=A1). When I copy de cell B1 (formated) and paste it to cell C1 with the option "paste only values", results in a blank cell. I send you a testcase. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
