Bug report #20588

ods tables are not loaded correctly in QGIS 3.4

Added by Steve Grössl almost 2 years ago. Updated over 1 year ago.

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

qgis-example.zip (202 KB) Steve Grössl, 2018-11-26 08:42 AM

History

#1 Updated by Giovanni Manghi almost 2 years ago

  • Status changed from Open to Feedback

Please attach a sample project with data.

#2 Updated by Steve Grössl almost 2 years ago

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 almost 2 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 over 1 year 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 over 1 year 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 over 1 year ago

  • Assignee deleted (Peter Petrik)

#7 Updated by Peter Petrik over 1 year ago

  • Assignee set to Peter Petrik

#8 Updated by Even Rouault over 1 year ago

  • Assignee changed from Peter Petrik to Even Rouault

Also available in: Atom PDF