Bug report #20588
ods tables are not loaded correctly in QGIS 3.4
Status: | Closed | ||
---|---|---|---|
Priority: | High | ||
Assignee: | Even Rouault | ||
Category: | Data Provider | ||
Affected QGIS version: | 3.5(master) | Regression?: | Yes |
Operating System: | Easy fix?: | No | |
Pull Request or Patch supplied: | No | Resolution: | up/downstream |
Crashes QGIS or corrupts data: | No | Copied to github as #: | 28408 |
Description
New description:
Add a table in ods format in QGIS 3.4.1, fields and column are not displayed correctly (try the attached dataset for example). It works in 2.18 and worked until 3.2.
Old description:
Hi, when loading ods tables, table data disappears. Only the header will be shown after opening the table. I load a qgz file original made with QGIS 3.2.2. In QGIS 3.2.2 everything is fine with this file. Table data are joined in qgz file with a shape file. In the table of the shape file ods data also disappears.
Many thanx for your help!
Steve
History
#1 Updated by Giovanni Manghi about 6 years ago
- Status changed from Open to Feedback
Please attach a sample project with data.
#2 Updated by Steve Grössl about 6 years ago
- File qgis-example.zip added
Hi Giovanni,
you will find the example in the attached zip-file. It contains:
- shape-File
- ods-table
- qgz-File example-qgis341.qgz (QGIS Version 3.4.1) :-(
- qgz-File example-qgis322.qgz (QGIS Version 3.2.2, where everything is fine..)
Many thanx!
Cheers Steve
#3 Updated by Giovanni Manghi about 6 years ago
- Regression? changed from No to Yes
- Operating System deleted (
windows 10) - Priority changed from Normal to High
- Status changed from Feedback to Open
- Category changed from Vectors to Data Provider
- Description updated (diff)
- Subject changed from ods table data disappears in QGIS 3.4 to ods tables are not loaded correctly in QGIS 3.4
#4 Updated by Peter Petrik almost 6 years ago
- Assignee set to Peter Petrik
- Status changed from Open to In Progress
- Affected QGIS version changed from 3.4.1 to 3.5(master)
can reproduce on Mac with 3.5 master
change caused upstream by https://github.com/OSGeo/gdal/commit/758dff893c1336e88fbbb6334da34b7d8d2e0226
INFO: Open of `qgis-example/testtable.ods' using driver `ODS' successful. ERROR 6: Invalid value for number-columns-repeated = 16376 1: Tabelle1 (None) ogrinfo --version GDAL 2.3.2, released 2018/09/21
#5 Updated by Peter Petrik almost 6 years ago
- Resolution set to up/downstream
upstream bug report: https://github.com/OSGeo/gdal/issues/1243
The workaround is to open the ods file with the newest Libre Office and resave it. With this I was able to open it in QGIS 3.5 without any problems.
#6 Updated by Peter Petrik almost 6 years ago
- Assignee deleted (
Peter Petrik)
#7 Updated by Peter Petrik almost 6 years ago
- Assignee set to Peter Petrik
#8 Updated by Even Rouault almost 6 years ago
- Assignee changed from Peter Petrik to Even Rouault
#9 Updated by Even Rouault almost 6 years ago
- Status changed from In Progress to Closed
Fixed in GDAL master per https://github.com/OSGeo/gdal/commit/ee6278f8dd1be7064db87be87fe31fa8943730ec and release/2.4 per https://github.com/OSGeo/gdal/commit/4e84cd44868e3b91def41057b7adf28767b4c273