https://bugs.freedesktop.org/show_bug.cgi?id=54588
Alex Thurgood <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #2 from Alex Thurgood <[email protected]> 2012-09-12 09:04:59 UTC --- A first column (A1;A5) contains data as numbers (chiffres) formatted as "text". In neighbouring column (B1:B5) B1 has the following formula : CNUM(A1) If you then press enter after typing this formula, the transformation to a number occurs as it should. This cell is then selected and a drag and fill operation carried out with the mouse. Cells B1, B2, B3 ... display the corrected value of B1. However, the formulae for each line are displayed as : B2 =CNUM(A2) B3 =CNUM(A3) ... In order for the required operation to be correctly carried out, you have to click on the desired cell simulate a change/edit in the cell itself, and press enter again. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- 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
