Some formula calculation results are displayed incorrectly when previewing Excel online

Docs
1

In the current example, the cells T831 and T832 are both formulas 【=SUM(SUMIF(I:I,{“农村移民安置补偿费”,“企业补偿费”,“专项设施补偿费”,“库底清理费”,“移民安置数字孪生业务应用建设费”,“限价房屋及附属物补偿费”,“限价集中居民点基础设施建设费”},U:U))-SUM(SUMIF(I:I,{“限价前房屋及附属物补偿费”,“限价前集中居民点基础设施建设费”},U:U))】, but when previewed, the two values are different, and sometimes the displayed values are also incorrect, while the file shows correctly when opened in Microsoft Excel.

2

Hello,

Please update ONLYOFFICE Docs (Document Server) to the latest available version and re-check the same XLSX file there, as outdated versions may contain spreadsheet calculation issues.

If the behavior remains the same after the update, please provide:

  1. The XLSX file that reproduces the issue.
  2. Screenshots showing the mismatch (the same cells/values in ONLYOFFICE vs MS Excel).
  3. Your integration details: what platform you use (Nextcloud/ownCloud/Alfresco/custom app, etc.), and the exact versions of your platform and the ONLYOFFICE connector/app.
  4. Your ONLYOFFICE Docs version/edition and installation type.