Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Number formats mm:ss.0 and mm:ss.00 do not round to the correct number of decimal places #37

Open
baconliker opened this issue Mar 26, 2023 · 0 comments

Comments

@baconliker
Copy link

baconliker commented Mar 26, 2023

Hi

Thanks for providing this library, which in addition to ExcelDataReader is brilliant for lightweight reading of Excel spreadsheets.

I think I've found an issue with the number formats mm:ss.0 and mm:ss.00; they don't round the fractions of a second to the correct number of decimal places.

mm:ss.0

Used in columns F and K of the attached spreadsheet, NumberFormat.Format returns 00.12.340 and 09:48.340 respectively, whereas in Excel they're displayed as 00.12.3 and 09:48.3.

mm:ss.00

Used in column G of the attached spreadsheet, NumberFormat.Format returns 00.12.350, whereas in Excel it's displayed as 00.12.35.

Regards
Colin
DataTypes.xlsx

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant