Uploaded image for project: 'Keikai'
  1. Keikai
  2. KEIKAI-671

Excel importer doesn't support absolute relationship paths

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 6.0.0
    • 5.12.0
    • None
    • Security Level: Jimmy
    • None
    • None

      Steps to Reproduce

      Load attached sample file in Keikai

      Open it in Excel

      Current Result

      Excel opens the file

      File renders empty in Keikai

      Expected Result

      File renders in both excel and keikai

      Debug Information

      caused by importer not recognizing absolute file path in relationships

      Excel saves relationship relative to folder

      however, the ooxml documentation here shows a relationship using absolute path:

      https://learn.microsoft.com/en-us/office/open-xml/spreadsheet/structure-of-a-spreadsheetml-document?tabs=cs

      "/xl/worksheets/sheet.xml"

      <?xml version="1.0" encoding="utf-8"?>
          <Relationships xmlns="https://schemas.openxmlformats.org/package/2006/relationships">
              <Relationship Type="https://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" Target="/xl/worksheets/sheet.xml" Id="Rddc7711f116045e5" />
          </Relationships>
      

      Workaround

      open file in excel and save it.

            rebeccalai rebeccalai
            MDuchemin MDuchemin
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: