It appears that the existing "Excel 2003 XML" cell parsing algorithm doesn't end up with the correct row and column numbers when merged cells (across or down) are present. Ditto for "Span" rows, which Excel appears to use to identify missing or sparse rows.
See attached files for demonstration. (My intent with these files
was to test-drive support of for fonts and colors, but happened to also discover that the cell addressing was broken on the way).
ms-ati
commented
6 years ago
It appears that the existing "Excel 2003 XML" cell parsing algorithm doesn't end up with the correct row and column numbers when merged cells (across or down) are present. Ditto for "Span" rows, which Excel appears to use to identify missing or sparse rows.
See attached files for demonstration. (My intent with these files was to test-drive support of for fonts and colors, but happened to also discover that the cell addressing was broken on the way).
font_colors.xml.zip