Skip to content
This repository has been archived by the owner on Mar 9, 2020. It is now read-only.

"%" sign in the number format string multiplies the value factor 100 #45

Open
ihorbach opened this issue Nov 2, 2017 · 0 comments
Open

Comments

@ihorbach
Copy link

ihorbach commented Nov 2, 2017

If there is a "%" sign in the format string for a cell, the value of it will be multiplied with factor 100. This is not quite correct.

Say you apply format #,##0.0"text and % sign". The cell value is 0.2.
The Excel shows the value of the cell as 0.2 text and % sign.
If you pick the EPPlus cell value - it gives 20 text % sing back.

Generally multiplying the cell value with 100 is correct only for percent values. Their format is 0.0% (Regex: 0.?0*%)

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

No branches or pull requests

1 participant