May 18 2024 09:25 AM
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?
May 18 2024 11:25 AM
Do you mean you see result of formula calculation with some delay, or you see formula itself instead of the result?
May 19 2024 12:42 AM
@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.
May 19 2024 05:50 AM
If to enter formula by default formula autocomplete starts working suggesting you existing functions and names. You may try to disable it
and check if there is the difference in behaviour or not. Usually it shall be now significant difference, but all depends on your configuration.
May 19 2024 06:06 AM
@SergeiBaklan your suggestion works well, thank you for your help.