Bug report #18963
Can not write a decimal in a real field of a layer spatialite
|Affected QGIS version:||3.0.2||Regression?:||Yes|
|Operating System:||Windows 10||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:||fixed/implemented|
|Crashes QGIS or corrupts data:||Yes||Copied to github as #:||26794|
I am working on a spatialite database with layers with real fields.
In QGIS 2.18 they work perfectly, but in QGIS 3 impossible to manually enter decimal number(impossible to write a comma) whereas if i uses the calculator of fields with the fontion area, the result given is a decimal ...
#1 Updated by Jesahel Benoist about 2 years ago
Same issue here, but not only on spatialite, also on geopackage. The already existing data is not affected, and can be edited with comma or dot, but new data cannot be entered with decimal value, only integer. I have tried to change field type, and field size : after editing and saving, size appears as 0 in spatialite format, BUT already existing decimal data is still there (happily!). Please note that a similar bug (thread going nowhere, badly) has been signaled there : https://issues.qgis.org/issues/18679
#5 Updated by Regis Haubourg about 2 years ago
- Status changed from Feedback to Open
Ok, issue confirmed on Windows only.
The text widget is the faulty one.
The range widget works fine.
First issue, real field are not automatically assigned with a range widget.
Second issue, on windows, if you have a locale decimal set to comma (French here), you can type any dot or comma in a text widget if it applies to a real field. Kind of blocking stuff.
#8 Updated by Alessandro Pasotti almost 2 years ago
- Category changed from Data Provider/SpatiaLite to Edit widget
Windows users (in particular those with non-english locales): please test the snapshot and give me some feedback:
Unzip it somewhere and launch qgis.exe (no installation required, just delete the folder to uninstall, no python available)
What to test:
- real/floating point fields are displayed according to system settings ( comma or dot )
- real/floating point fields can be entered with comma or dot according to locale (both should be supported if using the default text widget)
#12 Updated by Alessandro Pasotti almost 2 years ago
- Resolution set to fixed/implemented
- Status changed from In Progress to Closed
Fixed with https://github.com/qgis/QGIS/commit/4e37f381dee1e8a54144776c55bedbdf4df14b9b
please test it and report any issue assigning it to me