Opening my Spreadsheet always resets Formulas

Do you want to: Report a Bug

Description:
When i open my spreadsheet, the formulas are removed and replaced with “VALUE!”. Once i click into the cell and press “ENTER”, the “VALUE” disappears and the calculation works.

It seems to happen with not every file but occasionally.

I attached screenshots of my spreadsheet with my Posting. I could also provide the Spreadsheet itself but as a new user i have not the permission.

OS version: MacOS Big Sur 11.7.10
App version: 8.2.2
Downloaded from: ONLYOFFICE website

Hello @sxhor1

I’d be nice if you could share the spreadsheet. You can upload it to any cloud storage and share a link to it.

Thanks, that’s a good idea!

Here is the file:

https://www.dropbox.com/scl/fi/s74uojuc0lydoet4ymzk6/2025-02-01-Ladestatistik-laufend-2024ffcopy.xlsx?rlkey=yi011tstk1ommxh7oc1ous3r4&st=f2dvilws&dl=0

Thanks in advance!

Thanks. In which app this file was created initially?

The file was created in onlyoffice but is also opened in Microsoft Excel.

We have registered a bug for this particular file and the issue with values upon opening for further investigation.

As of now I recommend setting up array of cells with dates to the Date format and then recalculating all formulas in the workbook to display other values.

Ok thanks so far. Do u have any idea where the problem originates?

I believe it comes from the regional settings. Which ones are set up in your file? You can find them in File tab > Advanced Settings > Regional settings - please share a screenshot.