Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ExcelHelper.ConvertWithFormat and validation #804

Closed
DavidBlaa opened this issue Sep 16, 2021 · 0 comments
Closed

ExcelHelper.ConvertWithFormat and validation #804

DavidBlaa opened this issue Sep 16, 2021 · 0 comments
Assignees
Milestone

Comments

@DavidBlaa
Copy link
Member

in excel there is the value in the cell and a format code.

The function in ExcelHelper converts the value from the cell with the format code so that the system receives the value that the user also entered in Excel.

Due to rounding errors in Excel, a
4.9 becomes 4.9000000001

The language was disregarded and as a result a 4.9 becomes a 4,9 or otherwise, which can no longer be used as a number by the system.

  1. check langue settings in the function ToString
  2. check validation - should throw errors is its wrong
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant