Incorrect parsing when importing utf-16BE csv file

OS version: Arch Linux (kernel version 6.14.2-arch1-1)
App version: 8.3.2.19 (deb)
Downloaded from: AUR Package
Additional information:

When opening a utf-16BE csv file in OnlyOffice, some values are formatted / shown incorrectly. I have attached a sample file, which has the following issues in OnlyOffice:

  • A1 cell value isn’t interpreted as date (should be similar to A2).
  • E1 cell value is interpreted as a date whereas it should be a number like E2.

The values are shown correctly when opening the file in Google Sheets or neovim.

Sample file: utf16.csv - Google Drive

Hello @sujal, we are currently checking, please wait

Hello @sujal,
We’ve reproduced the issue on our end and registered a bug. I’ll post an update here as soon as a version with the fix is available

1 Like