Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-23376

Mixed formatting in single cell in Excel document causes Confluence indexing errors

XMLWordPrintable

      NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.

      Steps to reproduce:

      1. Create an Excel spreadsheet and enter some text in a cell
      2. Select part of that cell and change its formatting (e.g. bold, italics, underline)
      3. Save this spreadsheet and upload to Confluence
      4. Rebuild search index

      Error in logs:

      2011-10-02 14:23:25,893 ERROR [Indexer: 1] [officeconnector.index.excel.ExcelXMLTextExtractor] endDocument expected [ 1 ] entries but read [ 2 ]
 -- referer: http://localhost:5350/admin/search-indexes.action | url: /admin/reindex.action | userName: admin | action: reindex

      An example .xlsx is attached.

      Here are the contents of sharedStrings.xml when the .xlsx is unarchived, which appears to contain the relevant data:

      <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" count="1" uniqueCount="1">
	<si>
		<r>
			<t>foo</t>
		</r>
		<r>
			<rPr>
				<u/>
				<sz val="10"/>
				<rFont val="Verdana"/>
			</rPr>
			<t>bar</t>
		</r>
		<phoneticPr fontId="1" type="noConversion"/>
	</si>
</sst>

        1. mixed_formatting.xlsx
          28 kB

            [CONFSERVER-23376] Mixed formatting in single cell in Excel document causes Confluence indexing errors

            Renata Dornelas made changes -
            Remote Link Original: This issue links to "Page (Atlassian Documentation)" [ 75265 ]
            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2889981 ] New: CONFSERVER Bug Workflow v4 [ 2982350 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2803424 ] New: JAC Bug Workflow v3 [ 2889981 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2736243 ] New: JAC Bug Workflow v2 [ 2803424 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2400241 ] New: JAC Bug Workflow [ 2736243 ]
            Alex Yakovlev (Inactive) made changes -
            Labels Original: affects-cloud affects-server bugfix loyalty searching/indexing st10 New: affects-cloud affects-server loyalty searching/indexing st10
            Alex Yakovlev (Inactive) made changes -
            Labels Original: affects-cloud affects-server bugfix searching/indexing st10 New: affects-cloud affects-server bugfix loyalty searching/indexing st10
            Damien Tan made changes -
            Affects Version/s New: 5.7.3 [ 51200 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2299586 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2400241 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2233998 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2299586 ]

              briosa Blake Riosa (Inactive)
              rchang Robert Chang
              Affected customers:
              56 This affects my team
              Watchers:
              64 Start watching this issue

                Created:
                Updated:
                Resolved: