Date value appears empty in spreadsheet editor (file from MS Excel)

Docs
1

I want to report a bug.

  1. I create an Excel in MS Excel (in german) containing date fields and other stuff.
  2. All text fields are rendered fine so for excel date fields. These appear empty.
  3. Even when switching from viewing mode to edit mode, all date fields are empty.
  4. Even the formula input bar tells me that there is no data in them.
  5. When saving the file in OO, all date fields are emptied, also for MS Excel.
  6. When inputing a date field in OO, it appears afterwards in MS Excel.
  7. Then I can also add date fields in MS Excel, which then appear in OO.

Document Server version:

1 Like
2

Example file is here: Google Sheets wird geladen
The date value is in cell B2.
Opening in MS Excel will show a date value, but opening it in OO will not.

3

Hello @Tobias

Mind you sharing how this date field was added into provided document?

4

Hi @Constantine, I just type it in as 30.07.2024 and press enter.
Nothing unusual. Is save the Excel as xlsx, which is the default.

5

Hello @Tobias
Could you please record a video file with your test? I have checked the provided file on the K8s Document server (v.8.1.1), all things are OK.
We need the exact usage scenario to check it out.

8

Bug is still present in version 9.3.1.8. Fields have the following format:

2026-01-01T00:00:00.000

It seems to be related to regional formatting, Setting the region to US and reopening the file does show the fields.

The weird thing is that after changing the region back to one that uses coma for decimal separator, the file still opens correctly after it was opened once with US locale. Even though the file was opened in read only and not saved.

9

Nice that someone can prove it is affecting not just me.

Now I wonder, if the files in the cache (server side) are different in the broken and working state.

How did you change the reagion/locale exactly?

10

Hello @Tobias and @Quaint39
This is a really old thread. I believe we need to start from scratch.
Please provide us with a test file and exact steps how to reproduce the situation, we’ll check it out. If it’s possible, please record a videofile.
Also please let us know your exact Document server version and the installation type (docker, packages, exe).

11

Seems like I can not upload attachments as new user, but the file I encountered the error in was downloaded from https://si3.bcentral.cl/Siete/ES/Siete/Cuadro/CAP_PRECIOS/MN_CAP_PRECIOS/UF_IVP_DIARIO/UF_IVP_DIARIO - export to Excel button.

I don’t have excel to generate a test file, and when I try to generate one with libreoffice it changes “2026-01-01T00:00:00.000” to “2026-01-01T00:00:00,000” and that shows up correctly in ONLYOFFICE.

The Workaround described above (changing the locale setting and reopening the file) seems to work on Windows, but not on MacOS.

This is just using the standalone ONLYOFFICE programs with local files, no document server.

12

Well, so to be pretty clear to me then. The English decimal symbol is a dot, where in German it is a comma.

I’d guess that OnlyOffice isnt able to parse Datetimes, when it contains a dot while the locale state it should be a comma?

13

Exactly. Digging further into this, the problem occurs when the date is saved in ISO8601 format in the excel file. It can also be saved as numerical value, but in my example the generated excel file uses text in ISO8601 format.

Now, the ISO8601 standard seems to allow both “.” and “,” as decimal separators, but OO only reads it correctly if it matches its locale settings.

14

I changed them in advanced settings, but this only shows up when you have a file open.

There is also a global setting, but it’s named “Interface language”. Not sure if this affects locale setting too. Also, it seems to behave differently on windows and on MacOS. I’m trying to replicate the “fix” by changing the settings on a Mac now and I can’t get it to work the same way it worked in windows the other day.

15

image
image665Ă—738 49.6 KB

image
image683Ă—151 3.47 KB

Hello @Quaint39
I’ve downloaded file from the provided link, but all things are OK. Could you please share the exact steps to reproduce the issue? Also, let us know your regional settings in the app and the app version you’re using.
We’re looking forward to your reply.

16

Hi @Alexandre you can see the problem in the screenshot you uploaded. Column A has the date time data that is not shown in OO. Open the file with another office suite and you’ll see the values.

1 Like
18

Understood, we’re checking the situation.

1 Like
20

@Tobias and @Quaint39
Thank you so much for the provided data!
We have found a bug in the described scenario, we have started working on it. I will update this thread once we have something to share.

1 Like
21

Great news! Thank you for looking into it.

2 Likes
22

Hello,
We have released Docs v.9.4. This release contains a fix for the bug reported in this very thread.

1 Like
23

Awesome! It’s working fine in the 9.4 desktop app.

Thank you!

2 Likes
24

This topic was automatically closed 12 hours after the last reply. New replies are no longer allowed.