Apache OpenOffice (AOO) Bugzilla – Issue 127672
Xlsx with omitted cell references opens with empty cells
Last modified: 2018-01-23 19:26:41 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).