Skip to content
This repository has been archived by the owner on Nov 20, 2024. It is now read-only.

Latest commit

 

History

History
31 lines (23 loc) · 721 Bytes

README.md

File metadata and controls

31 lines (23 loc) · 721 Bytes
Raw

Overview

For certain cell values the xlsx package yields different formatted display text than Excel.

Automated Tests

Running npm test will execute an automated test, contained in test/index.spec.js, which demonstrates this issue.

Example

The file in test/fixtures/test.xlsx contains three values:

  • 1.225
  • 100.665
  • 656.685

These are formatted to display at two decimal places, and consequently are displayed as follows in Excel:

  • 1.23
  • 100.67
  • 652.69

When parsed by the xlsx package the w property for each cell, which represents the formatted value, is as follows:

  • 1.23
  • 100.67
  • 652.68

The last value (C1 in the sheet) is 0.01 less than is displayed in Excel.