public void TestXFIndexForColumn() { short TEST_IDX = 10; short DEFAULT_IDX = 0xF; // 15 short xfindex = short.MinValue; InternalSheet sheet = InternalSheet.CreateSheet(); // without ColumnInfoRecord xfindex = sheet.GetXFIndexForColAt((short)0); Assert.AreEqual(DEFAULT_IDX, xfindex); xfindex = sheet.GetXFIndexForColAt((short)1); Assert.AreEqual(DEFAULT_IDX, xfindex); ColumnInfoRecord nci = new ColumnInfoRecord(); sheet.ColumnInfos.InsertColumn(nci); // single column ColumnInfoRecord nci.FirstColumn = ((short)2); nci.LastColumn = ((short)2); nci.XFIndex = (TEST_IDX); xfindex = sheet.GetXFIndexForColAt((short)0); Assert.AreEqual(DEFAULT_IDX, xfindex); xfindex = sheet.GetXFIndexForColAt((short)1); Assert.AreEqual(DEFAULT_IDX, xfindex); xfindex = sheet.GetXFIndexForColAt((short)2); Assert.AreEqual(TEST_IDX, xfindex); xfindex = sheet.GetXFIndexForColAt((short)3); Assert.AreEqual(DEFAULT_IDX, xfindex); // ten column ColumnInfoRecord nci.FirstColumn = ((short)2); nci.LastColumn = ((short)11); nci.XFIndex = (TEST_IDX); xfindex = sheet.GetXFIndexForColAt((short)1); Assert.AreEqual(DEFAULT_IDX, xfindex); xfindex = sheet.GetXFIndexForColAt((short)2); Assert.AreEqual(TEST_IDX, xfindex); xfindex = sheet.GetXFIndexForColAt((short)6); Assert.AreEqual(TEST_IDX, xfindex); xfindex = sheet.GetXFIndexForColAt((short)11); Assert.AreEqual(TEST_IDX, xfindex); xfindex = sheet.GetXFIndexForColAt((short)12); Assert.AreEqual(DEFAULT_IDX, xfindex); // single column ColumnInfoRecord starting at index 0 nci.FirstColumn = ((short)0); nci.LastColumn = ((short)0); nci.XFIndex = (TEST_IDX); xfindex = sheet.GetXFIndexForColAt((short)0); Assert.AreEqual(TEST_IDX, xfindex); xfindex = sheet.GetXFIndexForColAt((short)1); Assert.AreEqual(DEFAULT_IDX, xfindex); // ten column ColumnInfoRecord starting at index 0 nci.FirstColumn = ((short)0); nci.LastColumn = ((short)9); nci.XFIndex = (TEST_IDX); xfindex = sheet.GetXFIndexForColAt((short)0); Assert.AreEqual(TEST_IDX, xfindex); xfindex = sheet.GetXFIndexForColAt((short)7); Assert.AreEqual(TEST_IDX, xfindex); xfindex = sheet.GetXFIndexForColAt((short)9); Assert.AreEqual(TEST_IDX, xfindex); xfindex = sheet.GetXFIndexForColAt((short)10); Assert.AreEqual(DEFAULT_IDX, xfindex); }