Bug xmsx null column

Dec 29, 2010 at 11:23 AM

Format xlsx
If first column contains null column, last column is lost and null column is added to data set. Excel dimension returs dimension, for example B1:L4, when first column is null. Probably progammer waited there will be range A1:L4 including null column.

if (col - 1 < _cellsValues.Length)
_cellsValues[col - 1] = o;

replace with

if (col - sheet.Dimension.FirstCol < _cellsValues.Length)
_cellsValues[col - sheet.Dimension.FirstCol] = o;