{"name": "GeoSpreadsheet", "package_name": "GeoSpreadsheet", "version": "1.8", "experimental": false, "qgis_min": "3.44.0", "qgis_max": "4.99.0", "downloads": 50, "uploaded_by": "carlosmartinnavarro", "upload_datetime": "2026-06-27T05:09:33.131703", "changelog": "The plugin suffered from strict validations and logic mismatches when handling non-standard spreadsheets:\r\nFragile 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.\r\nSkipped 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.\r\n\ud83d\udee0\ufe0f Solutions Implemented\r\nVersion 1.8 completely resolves these issues through three key architectural fixes:\r\nUniversal 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.\r\nPrecise 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.\r\nIntelligent 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.\r\n\ud83d\udce6 Final Result\r\nWith 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.", "external_deps": null, "download_url": "https://plugins.qgis.org/plugins/GeoSpreadsheet/version/1.8/download/"}