View original (French)

Open office auto sum icon

Luberonne Posted messages 85 Status Member -  
 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 Posted messages 4569 Registration date   Status Member Last intervention   1 512
     
    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 Posted messages 4569 Registration date   Status Member Last intervention   1 512
     
    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