https://bz.apache.org/ooo/show_bug.cgi?id=127672
Issue ID: 127672
Issue Type: DEFECT
Summary: Xlsx with omitted cell references opens with empty
cells
Product: Calc
Version: 4.1.5
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: Normal
Priority: P5 (lowest)
Component: open-import
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 86329
--> https://bz.apache.org/ooo/attachment.cgi?id=86329&action=edit
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).
--
You are receiving this mail because:
You are the assignee for the issue.
