search

camptocamp / QGIS-SpreadSheetLayers

QGIS plugin to load layers from spreadsheet files (*.ods, *.xls, *.xlsx)
GNU General Public License v3.0
21 stars 7 forks source link

EXCEL file - all formatting and formulas are gone! #52

Open Diethart123 opened 8 months ago

Diethart123 commented 8 months ago

In the “Add spreadsheet layer” plugin for integrating EXCEL tables, when accessing the Excel file recursively, there is the problem that all formatting and formulas are saved in all ! Tabs are deleted. The tab then only contains the blank numbers/values. So if you change and save the Excel file from QGIS (there is direct access via the generated VRT file), all formatting and formulas are gone! Previously the problem only occurred when accessing the respective tab.

effjot commented 8 months ago

Although this is a GDAL problem, it might be a good idea if the Spreadsheet Layers plugin would add the layer readonly as default (might be possible with the qgis.core.QgsVectorLayer.setReadOnly() method) and allow write access only after checking a checkbox with warning message.