-
-
Notifications
You must be signed in to change notification settings - Fork 1.7k
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
Feature Request: Support setting decimal precision values #1757
Comments
Thanks for your issue. This is similar to issues #80 and #189. Excelize library support sets custom Accounting number format or built-in number format for cells. |
Thanks for the quick response - unfortunately I don't think formatting alone is sufficient here. Right now, the only way to set numeric cell values is through using the For more context, this stack overflow question captures my concerns with trying to use a |
Could you show us a numeric precision problems case about this? The SetCellDefault function supports storage cell value as numeric by a given string data type value, but if you open the generated workbook, the display cell value is also related to the Excel accuracy limitation. |
Description
I am attempting to use excelize to record some financial data (in US Dollars). This requires using decimal values that have exactly 2 decimal places for cents. Excelize only supports numbers represented as
int
orfloat
. Upon closer examination of how cell values are set internally, it looks like they are stored as a combination of value (stored as astring
), and type. Is there anyway for excelize to support either:The text was updated successfully, but these errors were encountered: