Redmine

Thank you for reporting this issue. The problem occurs because, when using German language settings, Redmine allows the input of 1,5 (with a comma as the decimal separator) into numeric fields. However, this value is not properly converted to 1.5 (with a period as the decimal separator) before being saved in the custom_values table. As a result, the value remains as 1,5 in the database, causing errors during sorting or summation.

I have wroate a patch to address this issue. Once applied, the patch ensures that any new input like 1,5 is correctly converted to 1.5 before being saved to the database. However, please note that this patch does not automatically fix existing data that has already been saved with a comma as the decimal separator.

To correct existing data, you can do one of the following:
1. Open the issue edit page, manually change the decimal separator from `,` to `.` in the custom field value, and save the issue.
2. Apply the patch, then open the issue edit page and save it without making any changes. This will update the value to use a period as the decimal separator.

Setting the target version to 6.0.4.

Committed the fix in r23495.

Merged the fix into the 6.0-stable branch in r23501.