Created attachment 66717 [details] décrit le bug Une colonne (A1;A5)comprend des données de nombre (chiffres) en valeurs "texte". Sur la colonne (B1:B5) voisine en B1est formulée la fonction suivante : CNUM(A1) Avec enter, la transformation se fait correctement. Cette cellule est sélectionnée, et une reproduction de la fonction est opérée avec la souris. Les cellules B1, B2, B3 ... sur le tableur affichent la valeur corrigée de B1. Paradoxalement les lignes de saisie de chacune des cellules apparaît comme suit : B2 =CNUM(A2) B3 =CNUM(A3) ... Pour effectuer l'opération recherchée, il faut se repositionner sur la cellule, simuler une modification et Faire Enter à nouveau
@Sophie Gautier: Can you please help with an English translation of this French bug report? Or do you know someone else who could translate it? Thank you very much!
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.
Possibly a DUP of other autofill bug reports ...
DUP of bug 54308 ?
Or not...seeing as that bug related to having to use and extra key press in order to get the fill paste to work.
Trying to reproduce just the first formula entry in B1 on daily build from master gives me an error message #NAME? Alex
I don't have CNUM in my list of functions, even under ALL, but I can use VALUE() instead. Was CNUM removed for some reason ? Alex
Regression over LO 3.3.4
Confirming also on OSX, resetting platform accordingly.
I notice that CNUM() is also missing from : LibreOffice 3.5.6.2 Build ID: e0fbe70-dcba98b-297ab39-994e618-0f858f0 Alex
Adding Markus and Kohei, perhaps they can shed more light on this. @Markus, Kohei, any idea ? At the moment, my main problem is that I can not test the bug report because CNUM is missing from the function list on Mac, which may well be a separate bug and unrelated to this particular users problem (autofill).
If CNUM and CTXT are missing, that would be a special bug in the French version. The corresponding English functions exist. Not knowing CNUM and CTXT might be connected with the setting "Use English function names" in Tools > Options > Calc > Formula. In the attached spreadsheet the feature AutoCalculate is disabled, therefor the formulas do not update when dragging. So please make sure Tool > Calculate > AutoCalculate has a check. The attached spreadsheet will not work, because the "numbers" in column F have spaces inside and therefore cannot be transformed to a number.
(Component should be “Spreadsheed”, shouldn’t it?)
(In reply to comment #12) Hi Regina, > If CNUM and CTXT are missing, that would be a special bug in the French > version. The corresponding English functions exist. > The daily LOdev build I'm using is en_US, no lang pack installed, so my problem might be Mac specific, in which case I'll open a separate report. It just means I can't test for the alleged buggy behaviour. > Not knowing CNUM and CTXT might be connected with the setting "Use English > function names" in Tools > Options > Calc > Formula. This setting is not activated by default in my LOdev daily build. > > In the attached spreadsheet the feature AutoCalculate is disabled, therefor the > formulas do not update when dragging. So please make sure Tool > Calculate > > AutoCalculate has a check. Alex
If I open the bug doc supplied by the original reporter, the formula I see is = =VALUE(CELLREF) and the formulae update themselves by clicking on Data > Autocalculate. As Regina has pointed out, a space or a hyphen now lead to an error message in the cell for which an integer value can not be calculated, e.g. cells F7 and F9 respectively. If they are removed, then the cell value in G7 and G9 is recalculated to display 0. Alex
(In reply to comment #15) > > and the formulae update themselves by clicking on Data > Autocalculate. > Sorry, that should read Tools > Cell Contents > Autocalculate
Hello No bug for me. As Regina pointed out the feature AutoCalculate is disabled. Pseudo-numbers in column F can be treated by a formula such as: =IF(NOT(ISERR(VALUE(F4)));VALUE(F4)) and a style with no leading zeroes (see ExampleNoBug.ods) @Alex VALUE is the english name for CNUM Regards Pierre-Yves
Created attachment 67210 [details] ExampleNoBug
Let's close this then as notabug.