Re: [xml-dev] Re: ***SPAM*** [xml-dev] I used Excel Save As to generate XML but some rows in the XML are missing cells ... which cells?

On 13.07.2021 21:09, Liam R. E. Quin wrote:
> On Tue, 2021-07-13 at 17:51 +0000, Roger L Costello wrote:
>> Hi Folks,
>>
>> I noticed ss:Index="9" in one of the <Cell> elements and not any of
>> the others. My guess is that it is trying to tell me that, "Hey, this
>> <Cell> corresponds to column 9 (column I) of the spreadsheet, the
>> previous <Cell> (column H) was dropped". Is that what it's saying?
> 
> Or more than one, possibly. This would be what i would guess, too. You
> could look at the spec, or at XSLT that handles this format, perhaps?

https://docs.microsoft.com/en-us/previous-versions/office/developer/office-xp/aa140066(v=office.10)?redirectedfrom=MSDN

Attribute: 	ss:Index

Description: 	Specifies the column index of this cell within the 
containing row. If this tag is not specified, the first instance of a 
Cell element within a row has an assumed Index="1". Each additional Cell 
element has an assumed Index that is one higher.

Indices must appear in strictly increasing order. Failure to do so will 
result in an XML Spreadsheet document that is invalid. Indices do not 
need to be sequential, however. Omitted indices are formatted with 
either the default format, the column's format, or the table's format 
(depending on what has been specified).

Indices must not overlap. If duplicates exist, the behavior is 
unspecified and the XML Spreadsheet document is considered invalid.

If the previous cell is a merged cell and no index is specified on this 
cell, its start index is assumed to be the first cell after the merge.