You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When reading cells with custom number formats that use comma-based scaling (e.g., #,##0,, to divide by 1,000,000), excelize does not correctly apply the scaling transformation. Instead, it returns the raw value with thousand separators plus trailing literal commas.
Trailing commas in a number format pattern should indicate scaling, e.g.
#,##0, divides by 1,000
#,##0,, divides by 1,000,000
#,##0,,, divides by 1,000,000,000
But logic for this does not seem to exist in the number format parser numberHandler / getNumberFmtConf
Behaviour
Format: #,##0,,
Raw cell value: 9767948584
Expected formatted output: 9,768
Actual formatted output: 9,767,948,584,
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
When reading cells with custom number formats that use comma-based scaling (e.g.,
#,##0,,to divide by 1,000,000), excelize does not correctly apply the scaling transformation. Instead, it returns the raw value with thousand separators plus trailing literal commas.Trailing commas in a number format pattern should indicate scaling, e.g.
#,##0, divides by 1,000
#,##0,, divides by 1,000,000
#,##0,,, divides by 1,000,000,000
But logic for this does not seem to exist in the number format parser
numberHandler/getNumberFmtConfBehaviour
Format:
#,##0,,Raw cell value:
9767948584Expected formatted output:
9,768Actual formatted output:
9,767,948,584,Steps to reproduce
I encountered this issue parsing the following file:
Tryg_A_S_ADDITIONAL_DATA_2025Q1.xlsx
Using the following code:
All reactions