Skip to content
GitLab
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • gnumeric gnumeric
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 389
    • Issues 389
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 2
    • Merge requests 2
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages and registries
    • Packages and registries
    • Container Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • GNOMEGNOME
  • gnumericgnumeric
  • Issues
  • #505
Closed
Open
Issue created Jul 03, 2020 by Morten Welinder@welinderMaintainer

ODS Import Issues

sshangs1.ods

This file, a smaller version of the file from, #499 (closed) shows some ods import issues.

Currently, to load this a patch like this is needed: ppp That patch is for debugging purposes only.

Issues:

  1. Various xml fragments are not handled and warned about. For example:
Unexpected element 'draw:control' in state : 
	document-content -> body -> spreadsheet -> table -> table-row -> table-cell -> g
Unexpected element 'calcext:conditional-formats' in state : 
	document-content -> body -> spreadsheet -> table

I don't know if this is important.

  1. When loading this we end up with three sheets:
  <gnm:SheetNameIndex>
    <gnm:SheetName gnm:Cols="128" gnm:Rows="128">_LUT</gnm:SheetName>
    <gnm:SheetName gnm:Cols="1024" gnm:Rows="1048576">_PROTO</gnm:SheetName>
    <gnm:SheetName gnm:Cols="1024" gnm:Rows="1048576">AAPL</gnm:SheetName>
  </gnm:SheetNameIndex>

Note that one sheet has a different size than the others. While in principle we handle this, I think we should force all sheets to have the same size.

Assignee
Assign to
Time tracking