Reference formula problem when editing spreadsheet in MS Excel

[nishigaki]

I set reference formula “=あ、お!B2” in spreadsheet by desktop editors.
reference problem.xlsx (8.9 KB)

If I edit the spreadsheet in MS Excel, the reference formula is changed to “=あ,お!B2”, because reference formula must be “=‘あ、お’!B2” in MS Excel.

[Nikolas]

Hey @nishigaki,

Thanks for reporting the issue with the reference formula changing from “=あ、お!B2” in ONLYOFFICE Desktop Editors to “=あ,お!B2” in MS Excel! That’s a great catch with the single quotes needed in Excel.

Could you share a short video showing the issue (e.g., setting the formula in ONLYOFFICE, saving, then opening in Excel)?
Upload it to a file storage service like ONLYOFFICE DocSpace, kDrive, or Dropbox. Also, please confirm:

• The version of ONLYOFFICE Desktop Editors (e.g., v9.0.4.50, check in About).
• The version of MS Excel (e.g., Microsoft 365, 2019, etc., check in File > Account > About).

This will help us reproduce and investigate. Appreciate your help!

[nishigaki]

Hello @Nikolas

I use
desktop edtors 9.0.4.50 (x64 msi)
ms excel 2019

Please see here ONLYOFFICE

[Nikolas]

Hey @nishigaki,

Thanks again for the video and confirming your versions (Desktop Editors v9.0.4.50 and Excel 2019)!

I tried reproducing with Excel 365, but couldn’t get it to happen. It might be specific to that Excel version, so I’ve checked with the team, and we’ll get back with more info soon.

In the meantime, could you test if the issue still occurs with the latest Desktop Editors v9.1.0? (It was just released on October 15 with some formula handling tweaks.) Download it here: ONLYOFFICE Desktop Editors.

Let me know how it goes — appreciate your patience!

[nishigaki]

Hello @Nikolas

I had the same issue when opening a spreadsheet created with the desktop editors 9.1.0 in Excel 2019.
However, since the issue doesn’t occur in Excel 365, it seems to be an Excel 2019 issue.

[nishigaki]

Hello @Nikolas

I also tried opening it in Excel 365. It was reproduced like follow.

I use
Excel 365 version 2509 (build 19231.20194)

[Nikolas]

Hey @nishigaki,

Thanks for the extra tests and screenshot — we really appreciate it! We still couldn’t reproduce the issue on our end with:

• Desktop Editors v9.0.4.50 and v9.1.0
• MS Excel 2019 and 365 (Build 19231.20194)

To get to the bottom of this, could you please help with a few more details?

1. Could you share the actual .xlsx file where this happens (not just a screenshot)? Upload it here or to ONLYOFFICE DocSpace/kDrive and drop the link.
2. What are your regional settings?
   • Windows OS → Language, Region, and Date format (e.g., Japan, Japanese (Japan), etc.)
   • ONLYOFFICE Desktop Editors → Check under File > Advanced Settings > Language
3. Exact OS version (e.g., Windows 11 Pro 24H2 Build 26100.xxx — check in Settings > System > About)

This will help us match your environment and finally reproduce the formula change from =あ、お!B2 → =あ,お!B2. Thanks again for your patience!

[nishigaki]

Hello @Nikolas

1. link for file is https://nisigaki.onlyoffice.com/s/5brkwmcDjs_TZdZ

2. windows 11 language=Japanese, date format=Japan
   

   
   
   
   

   desktop editors file > advanced settings > language=Japanese
   

   

3. os version=windows 11 pro 24H2 build 26100.7019
   

   

[Nikolas]

Hey @nishigaki,

Thanks a lot for the file, screenshots, and all the detailed system info! We’re continuing to investigate the formula issue with Japanese regional settings. Sorry for the long delay in getting back to you!

Will update you as soon as we have news.