Issue 127672 - Xlsx with omitted cell references opens with empty cells
Summary: Xlsx with omitted cell references opens with empty cells
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 4.1.5
Hardware: All All
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-01-23 08:17 UTC by Alexander Korolev
Modified: 2018-01-23 19:26 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Example file with omitted cell references (6.89 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-01-23 08:17 UTC, Alexander Korolev 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Alexander Korolev 2018-01-23 08:17:30 UTC 
Created attachment 86329 [details]
Example file with omitted cell references

See attached example. If I open this file in MS Excel, i see four cells filled by some data (A2, B2, A3 and B3). In OpenOffice Calc, only one cell (A2) has data, all others is empty.

In this xlsx package, the sheet data file (sheet1.xml) contains following fragment:

<sheetData>
  <row r="2" spans="1:2" ht="12.75">
    <c r="A2" s="1" t="s"><v>0</v></c>
    <c s="1" t="s"><v>1</v></c>
  </row>
  <row r="3" spans="1:2" ht="12.75">
    <c s="7"><v>42781</v></c>
    <c s="8" t="s"><v>2</v></c>
  </row>
</sheetData>

Standard ECMA-376 define attribute "r" of type "CT_Cell" as optional (see xsd schema, [Annex A.2 SpreadsheetML]).

MS Excel on cells with omitted references assumes that next cell has same row and increased column number from previous cell. A similar algorithm used for rows with omitted Row Index (also optional attribute "r" of <row> element).