#VALUE! instead of the string in the cells

Docs
1

I’ve found quite ridiculous bug. I use array functions to create index and get the values recalculating the data in the neighbouring columns, eg

=INDEX(A:A;MATCH(1;(C:C=1)*(F:F="0123 456 789");0);1)

When saved, closed the document and opened again some of the cells contain #VALUE! value instead of the resulting string.

Looking at the formula I see that it changes to:

=INDEX(1;MATCH((C:C=1)*(F:F="0123 456 789");0);1)

I tried to play with it, saving the formula in other cells - that helped strangely, but not for other sheets containing the same formula.

Are any workarounds to use there?

2

Hello,
Please provide the file populated with data that you use for function testing with function itself positioned.
Also, clarify which version of the Document Server do you use?