https://bugs.freedesktop.org/show_bug.cgi?id=73222
--- Comment #5 from Dominique Boutry <dominique.bout...@laposte.net> --- I deepened my analysis. I was wrong when saying "on my (english) system, the format of 02-01-2014 is number" : I set "Tools/Options/Calc/View/Display value highlighting" and saw it was effectively a text. On your testfile.ods, cell B4 (containing =value(A4)) computes as "41641", but if I set another cell to the same formula, it computes to "Err:502". If I change "02-01-2014" to "02/01/2014", my cell computes to 41641. So I suppose that the "value()" function interprets its text argument through formats (like the auto-formatting when typing a cell content), and that the text "02-01-2014" in your cell A4 keeps the memory of an anterior interpretation with the portuguese "D-M-Y" date format... but I cannot see any place where this initial characteristic of "portuguese" appears. Further debugging needed to qualify the bug. PS: just to be sure : "copy/paste special (value only)" doesn't exist as such ; we have : - paste special, which opens a pop-up windows with around twenty fields, - or paste only, which opens a submenu with "Text/Number/Formula", Do you have the same on LibO 4.1.4.2 Portuguese ? In your initial Description : - "Paste only values to cell C1" : not a provided feature, - Paste only text to cell C1: rightly pastes nothing (= blanks the cell) when the copied cell is numeric (whichever format it shows : number, date, ...). -- 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