When exporting, the CSV file is created using the windows default regional settings.
So, a completion activity in my configuration is reported as “100,00”.
But when importing, the same activity is expected to be “100.00”, and import fails.
*GRAVE: Failed to parse number from assignment cell=0:100,00 of task=4 *
For input string: “100,00”
I think a fix is needed, because the only workaroud is not easy to apply.
Attached exported file
test_gantt_project.csv (782 Byte)
Huh, thanks for reporting. Seems to be reproducible. I have filed a new ticket to the issue tracker:
Apparently, this happens in resource assignment column only. Other numeric columns, such as task cost or resource payment rate always use dots, that is, ignore the locale data. This might be an issue per se, however, with respect to this particular problem with importing CSV it makes more sense to use dot always in the assignments column as well.
This issue is fixed in build 2.99.2910 of GanttProject 3.0 beta. If you don’t use it yet, I encourage you to try. You can download build 2906 from this Dropbox folder: https://www.dropbox.com/sh/ijzr7s7ozxqexls/AADlRUGq667XQjEK8j4StEp2a?dl=0
It will suggest to update to build 2910 after installing and launching.