Unplanned
Last Updated: 06 Oct 2026 12:28 by Todor
Todor
Created on: 06 Oct 2026 12:28
Category: SpreadStreamProcessing
Type: Bug Report
0
SpreadStreamProcessing: Custom format strings in culture other than en-US are not converted to invariant

Culture on generating computer: de-DE

  • Format string: #.##0,00  -> Output correct: 1,234,567.89 (on US) and 1.234.567,89 (on German)
  • Format string: #,##0.00  -> Output incorrect: 1,234,567.89 (on US) and 1.234.567,89 (on German)
  • Format string: #.##0,0  -> Output incorrect: 1234567.8901 (on US) and 1234567,8901 (on German)
  • Format string: #,##0.0  -> Output incorrect: 1,234,567.8 (on US) and 1.234.567,8 (on German)

The first string is an in-built string and is exported correctly. The other three strings are custom (not part of the in-built collection), are not converted to invariant culture and do not produce correct results when the file is opened in Excel.

0 comments