[gdal-dev] Problem writing with ODS and XLSX drivers

[Stephen Woodbridge]

Try exporting to CSV and check the that the records do not have any 
embeded <CR> or <LF> chars. One simple way to do this is to compare the 
record count of the shp file to the line count of the CSV file. Try 
importing the CSV file into EXCEL  or Libreoffice and see if it reports 
a problem. This may give you a better idea of what the problem is.

-Steve W

On 9/12/2020 11:20 AM, Hernán De Angelis wrote:
> Hi everyone
>
> I am experiencing an odd and stubborn problem when trying to export 
> attribute tables from both shp and spatialite to ods or xlsx. ogr2ogr 
> finishes work silently with no reported errors but the generated 
> output files cannot be opened with Libreoffice, which says the file is 
> corrupted and is even unable to repair it.
>
> The input files are good from what I can see using QGIS and OGR but it 
> is clear that something isn't right in my installation, my procedure 
> or somewhere else. I am missing something? Have other users 
> experienced this?
>
> I am using GDAL/OGR 3.1.2 in openSUSE Tumbleweed, compiled against 
> expat 2.2.9-1.12 (devel packages installed too, of course).
>
> Any hint is appreciated!
>
> Hernán
>
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev