Skip to content

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

@baconliker

Description

@baconliker

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions