ONLYOFFICE Docs v7.3 released: enhanced forms, SmartArt, new security settings, Watch Window, and more
ONLYOFFICE Docs v7.3 released

Sumifs formula bug and misrepresentation in FR version at least

formulas SOMME.SI.ENS work fine when created,but when the file is saved , closed and reopened, they do only if the range that is used is in the same spreadsheet, and it truncates parameters … A nightmare to use.

We tried on cloud as well as desktop versions, 7.1 to 7.3, French version

let’s say we have « .=SOMME.SI.ENS(‘Synthèse cyber par activité’!I$2:I$98;‘Synthèse cyber par activité’!B$2:B$98;A6) »

if closed and reopened it shows as

« =SUMIFS(‘Synthèse cyber par activité’!$I$2:$B$98,A6) »

so missing arguments and doesn’t work anymore

on 7.1 to 7.3 not working both desktop and cloud

and again… how to submit a file for analysis?

Hello @gregoryVDV

how to submit a file for analysis?

You can upload it to some external storage and provide us with download link.

test here

same bug on 7.1 and 7.3

This is most likely a bug. Thank you for the file.
We are checking the situation. I will let you know when I get something.

Hello, @gregoryVDV

We have created bug report number 61674 based on this case.
Thank you for reporting this issue. Our team is already working on it.