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
https://we.tl/t-qNPQQ5eZe6
same bug on 7.1 and 7.3
@gregoryVDV
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.
Hi @gregoryVDV
We fixed the issue #61674 that you reported.
Fix will be included in version 7.4.
hey @gregoryVDV
I am writing to inform you that we have already launched the new version 7.4 of the Document Server