public void TestBug57828_OnlyOneCommentShiftedInRow() { XSSFWorkbook wb = XSSFTestDataSamples.OpenSampleWorkbook("57828.xlsx"); XSSFSheet sheet = wb.GetSheetAt(0) as XSSFSheet; IComment comment1 = sheet.GetCellComment(new CellAddress(2, 1)); Assert.IsNotNull(comment1); IComment comment2 = sheet.GetCellComment(new CellAddress(2, 2)); Assert.IsNotNull(comment2); IComment comment3 = sheet.GetCellComment(new CellAddress(1, 1)); Assert.IsNull(comment3, "NO comment in (1,1) and it should be null"); sheet.ShiftRows(2, 2, -1); comment3 = sheet.GetCellComment(new CellAddress(1, 1)); Assert.IsNotNull(comment3, "Comment in (2,1) Moved to (1,1) so its not null now."); comment1 = sheet.GetCellComment(new CellAddress(2, 1)); Assert.IsNull(comment1, "No comment currently in (2,1) and hence it is null"); comment2 = sheet.GetCellComment(new CellAddress(1, 2)); Assert.IsNotNull(comment2, "Comment in (2,2) should have Moved as well because of shift rows. But its not"); wb.Close(); }
public void TestBug57828_OnlyOneCommentShiftedInRow() { XSSFWorkbook wb = XSSFTestDataSamples.OpenSampleWorkbook("57828.xlsx"); XSSFSheet sheet = wb.GetSheetAt(0) as XSSFSheet; IComment comment1 = sheet.GetCellComment(2, 1); Assert.IsNotNull(comment1); IComment comment2 = sheet.GetCellComment(2, 2); Assert.IsNotNull(comment2); IComment comment3 = sheet.GetCellComment(1, 1); Assert.IsNull(comment3, "NO comment in (1,1) and it should be null"); sheet.ShiftRows(2, 2, -1); comment3 = sheet.GetCellComment(1, 1); Assert.IsNotNull(comment3, "Comment in (2,1) Moved to (1,1) so its not null now."); comment1 = sheet.GetCellComment(2, 1); Assert.IsNull(comment1, "No comment currently in (2,1) and hence it is null"); comment2 = sheet.GetCellComment(1, 2); Assert.IsNotNull(comment2, "Comment in (2,2) should have Moved as well because of shift rows. But its not"); // OutputStream stream = new FileOutputStream("/tmp/57828.xlsx"); // try { // wb.Write(stream); // } finally { // stream.Close(); // } wb.Close(); }
/// <summary> /// Returns cell comment for the specified location /// </summary> /// <param name="ref1">cell location</param> /// <returns>return cell comment or null if not found</returns> public IComment GetCellComment(CellAddress ref1) { return(_sh.GetCellComment(ref1)); }
public IComment GetCellComment(int row, int column) { return(_sh.GetCellComment(row, column)); }