ananthakumaran / paisa

Paisa – Personal Finance Manager. https://paisa.fyi demo: https://demo.paisa.fyi
https://paisa.fyi
GNU Affero General Public License v3.0
2.24k stars 111 forks source link

Import bug when the amount is in scientific notation #206

Open TMaddox opened 3 months ago

TMaddox commented 3 months ago

Describe your Environment OS: Windows 10 Paisa Version: 0.6.6 App Variant: Desktop

Describe the bug Some of my csv files have the amount in scientific notation. e.g. "3.66e-04". The feature import does not convert "3.66e-04" to 0.000366.

To Reproduce Steps to reproduce the behavior:

  1. Have any csv file with the amount in scientific notation
  2. Import it with any script
  3. See the import preview

Expected behavior "3.66e-04" should be converted automatically to 0.000366 or when using the function amount.

Screenshots image