D 2021-06-24T14:12:32.116
L June\s2021\supdate
P 3b4a35697a58ee2b5bcb3c06898bdad0b85ee0c8
U sandro
W 2241
Back to main SpatiaLite page
news about June 2021 mid term updates
- Supporting FreeXL 2.0
- Freexl 2.0 is now able to directly access spreadsheets based on modern XML formats.
- this applies to MS Excel spreadsheets identified by the file suffix .xlsx
- but it applies also to Libre/Open Office Calc spreadsheets identified by the file suffix .ods
- Changes affecting SpatiaLite:
- Virtual Tables based on the VirtualXL driver can now indifferently access .xls, .xlsx or either .ods spreadsheets.
Format recognition is directly based on the file suffix.
- The same applies to the SQL Function ImportXLS()
- Removing any functional dependency between mod_spatialite and libsqlite3
- mod_spatialite being a loadable extension module to SQLite shouldn't have any functional dependency to libsqlite3
- however for historical reasons the extension module called few SQLite's API not supported by the mirrored API interface provided by the loading process
- this required the practical need for explicitly linking libsqlite3, a situation easily leading to logical conflicts and possible instability caused by two conflicting copies of the same library (may be of different versions or built by different compilers with different runtime support) in the same process.
- now any SQLite's API not supported by the mirrored API interface has been completely removed, and mod_spatialite no longer depends on libsqlite3.
this API cleanup interests the following facets of SpatiaLite:
- removing any reference to
- Supporting the brand new KNN2 module
Back to main SpatiaLite page
Z 4d1b6eb89e49996dbd253592543bf710