Sheets array formula not updating in iOS

Mobile apps
1

Report a bug
I have an Excel file that contains matrix formulas, which worked perfectly a few months ago. However, since the latest versions of OnlyOffice, when I open this file, the matrix formula no longer calculates automatically.

I need to go to the affected cell and press CTRL+SHIFT+Enter to update the formula. As long as the file remains open, the formula works correctly. But if I close and reopen the file, the error reoccurs.

I have attached an example file for your reference.

In the “Input” tab, when entering a value greater than 10 in cell B2, you can observe the results in cells B5 and C5. No matter what value is entered in B2, the results in B5 and C5 are not updated.

OS:18.7
APP version Only office documents : 9.1

Example of sheet with formula :
Nouvelle feuille de calcul.xlsx (10.7 KB)

Additional info :The issue does not occur in Excel, only when opening the file in OnlyOffice.

2

Please note that on the web borwser, I can use F9 to Recalculate.
How should I do on the app on an iPad ?

3

Hello @iraza

We are checking the situation. Please await my feedback.

5

We have found the root of the issue, it is now registered. Once it is resolved, I will provide a notification.

6

Hello
Do you have a workaround in order to work on ipadOS ? As there is no F9 key, what can be done ?
I have tried to add an automatic macro to refresh the sheet and formula but macro do not work on iPadOS.
Many thanks for your help.
Kind regards,

7

There is no simple workaround. In the session you can use the following:

  1. Open Calcul sheet, select E1 cell;
  2. Click on formula bar to open formula editor;
  3. Without making any changes press green ✓ to save the formula.

After that the value should be able to change in Input sheet by using the same green ✓ button.

8

It does not work : the formula are not updated

9

In that case only the fix of the found issue will help. As I mentioned, I will provide an update once this situation is resolved.

Sorry for the inconvenience.