[SOLVED] After update to version 8.2, FIND() function crashes editor when searching for "+"

Docs
,
1

After update to version 8.2 (docker) documents crash while opening or upon recalculation. Certain formulas which work with no issues in MS Office and Onlyoffice prior to version 8.2 don’t work in version 8.2 anymore.

I have created an example document. This document loads. Any editing or calculation crashes the editor. This is only one example. There are more formulas that crash in version 8.2.

Calculation_Bug_1.xlsx (11.2 KB)

[EDIT]
Today I took the complex function apart and concluded that the FIND() function is responsible for the crash. This is only connected to certain characters. I used to look for the plus character “+”. After the update the plus character can only be used escaped “\+” in FIND().

2

I consider this a BUG. It should be addressed by the developers.

This “solution” only works for version 8.2. Escaping does not work in versions prior to 8.2.
Others like me can’t open their documents in version 8.2 and there is no transition back and forth. Documents have to be edited prior to the update (to 8.2) in version below 8.2 and don’t work as expected in versions below 8.2 anymore.

3

Hello @bermuda
Thank you for the provided file, we are checking the situation.

5

Dear @bermuda
We have found a bug in the described scenario. We have started working on it.
Thank you for the valuable data!