Formula delay

Copper Contributor

Whenever I inputted a formula in a cell, the formula showed up with some delay. However, when I inputted number into the cell, it showed up with no delay. May I know how to fix it?

5 Replies

@terryli246 

Do you mean you see result of formula calculation with some delay, or you see formula itself instead of the result?

@SergeiBaklan It is the formula itself.

 

E.g. when I input "=sum", the text and formula suggestion show up with some delay. However, when I input "sum" without the equal sign, the text can show up with no delay.

@terryli246 

If to enter formula by default formula autocomplete starts working suggesting you existing functions and names. You may try to disable it

image.png

and check if there is the difference in behaviour or not. Usually it shall be now significant difference, but all depends on your configuration.

 

@SergeiBaklan your suggestion works well, thank you for your help.:happyface:

@terryli246 , you're welcome