Is Spreadsheet Editor expected to respect locale-dependent Excel formatting?

Technical Support WebViewer
, , ,
1

WebViewer Version: 11.13.0

Do you have an issue with a specific file(s)? Yes

Can you reproduce using one of our samples or online demos? Yes

Are you using the WebViewer server? No

Does the issue only happen on certain browsers? No

Is your issue related to a front-end framework? No

Is your issue related to annotations? No

Summary

Spreadsheet Editor does not appear to respect locale-dependent Excel formatting.

Description

Hi Apryse team,

We are testing locale-dependent Excel formatting in WebViewer 11.13 and noticed different behavior between two rendering modes.

Expected

Locale-dependent Excel formats (for example Date*, Time*, number separators, etc.) should follow the supplied locale, similar to Microsoft Excel.

Actual

When opening the same XLSX file using:

WebViewer.Modes.SPREADSHEET_EDITOR

locale-dependent formats are always rendered using US formatting, for example:

7/1/2026
July 1, 2026
1:00:00 PM
1,000,000.00

We pass the following option to UI.loadDocument:

officeOptions: {
  formatOptions: {
    locale: "da-DK"
  }
}

but it does not produce any visible change.

However, when opening the same XLSX file using:

WebViewer.Modes.DEFAULT

the locale is respected and locale-dependent formats are rendered correctly.

We also searched the WebViewer 11.13 typings and documentation but could not find any locale-related API for Spreadsheet Editor.

Questions

  1. Is Spreadsheet Editor expected to support locale-dependent Excel formatting?

  2. Or is locale support currently available only in the Office rendering pipeline (Modes.DEFAULT)?

Steps to reproduce

  1. Open the attached XLSX file.

  2. Load it using WebViewer.Modes.SPREADSHEET_EDITOR.

  3. Pass:

officeOptions: {
  formatOptions: {
    locale: "da-DK"
  }
}

  1. Observe that locale-dependent formats remain in US format.

  2. Open the same file using WebViewer.Modes.DEFAULT.

  3. Observe that locale-depend ent formats follow the supplied locale.

Thank you!

Excel formatting.xlsx (11.9 KB)

3

Hi Dch,

Thank you for reaching out.

I can confirm it’s currently the expected behavior, as this is currently not implemented yet.

We already have this on our roadmap. If you could provide some further information about the context behind your request for the feature, this may help prioritize its development. We would be interested to know:

  • What is the workflow in which you would use the requested feature?
  • Why is the feature valuable to you and your users?
  • How are you coping without it right now?

Best Regards,
Mickaël.

1 Like