View original (French)

OpenOffice Calc: Extend a formula

Solved
Delphine01 -  
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   -
Hello,

I have a table open office calc that has been acting up since yesterday: a very simple formula (it worked just fine in Excel) works, but when I stretch it, it stops working.

The formula is as follows: If(P10="";"TO DO";"")

I have looked for some solutions on forums but without success. Open Office is up to date; I tried it in a new spreadsheet and it works; if I copy and paste it it works but only when I manually re-enter the number. The problem is that I need to create a pivot table based on this result and I have 1700 rows of important data.

Can you help me?

Thank you in advance.

3 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    try: Toolbar / Tool /
    in the Cell content list
    and check that: "calculate automatically" is checked.

    kind regards

    To err is human, to persist is diabolical.
    0