index out of range exception

May 14, 2013 at 11:35 AM
hi,
i'm getting an index out of range exception when trying to import an xls file, the exception happens here:
case BIFFRECORDTYPE.MULRK:

                    XlsBiffMulRKCell _rkCell = (XlsBiffMulRKCell)cell;
                    for (ushort j = cell.ColumnIndex; j <= _rkCell.LastColumnIndex; j++)
                    {
                        _dValue = _rkCell.GetValue(j);
                        LogManager.Log(this).Debug("VALUE[{1}]: {0}", _dValue, j);
                        m_cellsValues[j] = !ConvertOaDate ? _dValue : tryConvertOADateTime(_dValue, _rkCell.GetXF(j));
                    }

                    break;
my file has 46 columns, but when max columns is set, it sets it to 45, and my last 2 columns are done in this loop, the only difference i have found from this file to the others ive tested is that the dims.isv8 is false, where as all others seem to be true, i'm not sure what this flag is set by (is it an excel version?), anyone have any ideas?
Developer
May 16, 2013 at 9:54 AM
Sounds like a bug but I'd have to look into it.

We'd need the Excel document and the code you are running to look into it but I'm way too busy too investigate this and I think the other devs are too. It'll be some time before I can look at a sample.