The plugin suffered from strict validations and logic mismatches when handling non-standard spreadsheets: Fragile String Matching: The GDAL compatibility check relied on an exact text match for geometry data. Modern GDAL versions format floats differently, causing this check to fail unexpectedly. Skipped Rows Mismatch: When users skipped top rows (like title blocks or banners), an off-by-one error occurred. The system read the wrong row for headers, and the OGR driver misclassified all columns as String types due to the text noise in the upper rows. Consequently, this locked and disabled the "Geometry Options" checkbox. 🛠️ Solutions Implemented Version 1.8 completely resolves these issues through three key architectural fixes: Universal GDAL Compatibility: Replaced the rigid text-based validation with a robust floating-point coordinate check. The plugin now runs flawlessly across different GDAL versions regardless of how decimal formatting varies. Precise Offset Calculations: Fixed the mathematical calculations behind row skipping. By correctly aligning indices with SQLite virtual tables, the plugin accurately distinguishes between ignored rows, the actual header, and the data block. Intelligent Field Type Inference: Implemented a dynamic scanner (inferFieldTypes) that samples the first 100 rows of actual data. This ensures that coordinate columns (like Latitude and Longitude) are correctly identified as numeric (Real/Integer) instead of being stuck as Strings. 📦 Final Result With these patches, the "Geometry Options" checkbox remains enabled and functional, and point generation works perfectly. The source code successfully passed syntax compilation and has been cleanly deployed into the production-ready archive GeoSpreadsheet-1.8.zip.
yes
carlosmartinnavarro
2026-06-27T10:09:33.131703+00:00
3.44.0
4.99.0
None
no
Plugin Tags