ExcelNumberFormat icon indicating copy to clipboard operation
ExcelNumberFormat copied to clipboard

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

Open baconliker opened this issue 1 year ago • 0 comments

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

baconliker avatar Mar 26 '23 17:03 baconliker