View original (French)

Open Office Calc, calculation issue

Solved
Wolf -  
 Steph -
Hello,

I'm still having my issue with Open Office Calc: the formulas are displayed in the cells but do not execute.

- I uninstalled and then re-downloaded the suite without success.
- The default cell formatting doesn't change anything.

The "automatic calculation" function in Tools/Cell Contents is checked, I don't know what else to do, Please help!

Have a good day
Configuration: Windows XP Firefox 2.0.0.11

13 answers

  1. gym40
     
    Hello,
    I had the same problem today. It's very simple. In the spreadsheet, in the menu, click on tools - options - open office calc - display and uncheck the formula box, because if the formula box is checked, the formula appears in the cell instead of the result, and everything will be back in order. Good luck.

    Gym 40
    10
  2. Wolf
     
    Even for a simple addition, like: =SUM(A2:A3), it doesn't work...
    8
    1. gozet
       
      I have the same problem, did you find a solution?
      Thank you in advance.
      0
    2. 185645
       
      biennn
      0
  3. gredin
     
    Go to Tools>Options>Openoffice.org.calc>View>Show>uncheck "Formulas"
    3
    1. bella
       
      Thank you scoundrel! You just saved me! In my case, that was indeed the problem because not even a simple addition was working!
      0
    2. Steph
       
      It still works in 2015, and with LibreOffice Calc!
      0
  4. lundi
     
    Hello
    THANK YOU THANK YOU
    I was looking for the mistake I made for an hour, thanks again
    have a nice day
    1
  6. Anonymous user
     
    that's office syntax, not open office... Check it!
    0
  8. Anonymous user
     
    On Open Office, we formulate it like this: "=SUM(A1:G5; Z1:Z5)"
    0
  9. Wolf
     
    Here’s what displays if I want to, for example, add 5 (C3) to 2 (C4), the formula displays but does not execute:

    5
    2
    =SUM(C3:C4)
    0
  10. Anonymous user
     
    avec un espace entre somme et la parenthèse ?
    0
  11. OOo Forum
     
    See this thread:
    http://www.forum-openoffice.org/forum/setopic_5754-formule.html+display+calculation
    0
  13. Tmi
     
    Hi

    Actually, like everyone else, you've changed an option to have the decimal point on the numeric keypad
    so in Calc, the comma is used in the syntax between the whole number and the cents.
    That's why the simple SUM formula doesn't work with the point.

    See you soon
    But nothing prevents you from installing version 3

    Tmi
    0
  14. Anonymous user
     
    You probably have a syntax error, check it!
    -1