Skip to content

Error when importing an OpenOffice sheet #2201

@Teifion

Description

@Teifion

Description

When trying to import the following spreadsheet it generates an error:
expected element <wsDr> in name space http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing but have http://purl.oclc.org/ooxml/drawingml/spreadsheetDrawing

We were able to resolve it with a script, the key part of being the sed calls as a workaround. Ideally the underlying cause would be fixed first.

The sheet in question was supplied indirectly to us and so we cannot be certain but based on our analysis it appears to be one which was open/saved in OpenOffice.

Walliswood Village Hall SSM-no-pii.xlsx

Steps to reproduce the issue

Try to ingest the supplied "excel" file.

Describe the results you received

An error message

Describe the results you expected

A correctly ingested file

Go version

1.22.6

Excelize version or commit ID

github.com/xuri/excelize/v2 v2.8.2-0.20240904114702-aca04ecf57cd

Environment

Linux, tested several different variants with the same result. Also tested on Windows with same result.

Validations

  • Check that there isn't already an issue that reports the same bug to avoid creating a duplicate.
  • The provided reproduction is a minimal reproducible example of the bug.

Metadata

Metadata

Assignees

No one assigned

    Labels

    needs more infoThis issue can't reproduce, need more info

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions