View original (French)

Open office auto sum icon
Luberonne -  
Hello,
My "auto sum" icon has disappeared on Open Office and I can't seem to find it again.
Thank you for your response
Luberonne

2 answers

  1.  PapyLuc51
    Good evening,

    Normally the icon Ʃ is located to the left of the formula bar between fx and =



    Best regards
    1
    1. Luberonne
      Thank you for your feedback, but is it not possible to place the icon in the toolbar?
      In fact, if you click on the location you mentioned, it does not display the sum but the formula: sum(A2:A8) for example, and not the result.
      0
  2. PapyLuc51
    Hi,

    What matters is not what appears in the input line but the result in the cell after confirming by pressing Enter following a click on the auto-sum icon.

    If the formula is displayed in the cell, you need to go to Tools / Options / Open Office Calc Development on the left side / Display / uncheck Formulas in the Display block on the right side.

    Best regards.
    0
    1. Luberonne
      Thank you very much for your help, it works.
      It's very kind of you to have assisted me.
      Have a great Sunday.
      0