I updated to OpenOffice 4.1.9, resulting in an error in all the IFS functions of my existing .ods file.
The file worked in the previous OpenOffice version.
Opening the file in the new OpenOffice version changes the formula from =IFS… to =com.microsoft.ifs(…
My example file is attached below, too.
I’ve tried the following:
- manually replace =com.microsoft.ifs(… with =IFS which changes into =ifs after pressed ENTER
- create a new spreadsheet and type in a simple IFS formula results in =IFS being changed to =ifs after pressed ENTER
I tried @erAck’s solution to a similar problem, but it did not work for my problem: Importing IFS() and CONCAT() from Google Sheets into Calc
Does anybody have a solution?
Also, I do not find the IFS function in function Wizard. Does the current OpenOffice version got rid of the IFS function all together?
Thanks in advance as always