search

dhatim / fastexcel

Generate and read big Excel files quickly
Other
647 stars 116 forks source link

Values are not extracted as it is on the cell #299

Open Sid18build opened 1 year ago

Sid18build commented 1 year ago

When the values in the cell are populated by an underlying formula, the existing methods are not giving the value seen on the cell instead getting the calculated values. This creates problem when the cell is formatted to user expectations.

Eg: When the value in the cell is displayed as 8.123, the value retrieved is 8.12345678. This is based on the underlying formula evaluation.

d22 commented 1 year ago

I think this is related to this issue: #92