public void FindMatchAfterColumnShifting() { using (var wb = new XLWorkbook()) { var ws = wb.Worksheets.Add("Sheet1") as XLWorksheet; var index = FillIndexWithTestData(ws); ws.Column(3).InsertColumnsBefore(2); var address = new XLAddress(ws, 102, 6, false, false); Assert.True(index.Contains(in address)); } }
public void FindNonExistingMatches() { using (var wb = new XLWorkbook()) { var ws = wb.Worksheets.Add("Sheet1") as XLWorksheet; var index = FillIndexWithTestData(ws); for (int i = 1; i <= TEST_COUNT; i++) { var address = new XLAddress(ws, i * 2 + 1, 3, false, false); Assert.False(index.Contains(in address)); } } }
public void FindMatchAfterRowShifting() { using (var wb = new XLWorkbook()) { var ws = wb.Worksheets.Add("Sheet1") as XLWorksheet; var index = FillIndexWithTestData(ws); ws.Row(10).InsertRowsBelow(3); var address = new XLAddress(ws, 103, 4, false, false); Assert.True(index.Contains(in address)); } }
internal IXLPicture CopyTo(XLWorksheet targetSheet) { if (targetSheet == null) { targetSheet = Worksheet as XLWorksheet; } IXLPicture newPicture; if (targetSheet == Worksheet) { newPicture = targetSheet.AddPicture(ImageStream, Format); } else { newPicture = targetSheet.AddPicture(ImageStream, Format, Name); } newPicture = newPicture .WithPlacement(XLPicturePlacement.FreeFloating) .WithSize(Width, Height) .WithPlacement(Placement); switch (Placement) { case XLPicturePlacement.FreeFloating: newPicture.MoveTo(Left, Top); break; case XLPicturePlacement.Move: var newAddress = new XLAddress(targetSheet, TopLeftCellAddress.RowNumber, TopLeftCellAddress.ColumnNumber, false, false); newPicture.MoveTo(newAddress, GetOffset(XLMarkerPosition.TopLeft)); break; case XLPicturePlacement.MoveAndSize: var newFromAddress = new XLAddress(targetSheet, TopLeftCellAddress.RowNumber, TopLeftCellAddress.ColumnNumber, false, false); var newToAddress = new XLAddress(targetSheet, BottomRightCellAddress.RowNumber, BottomRightCellAddress.ColumnNumber, false, false); newPicture.MoveTo(newFromAddress, GetOffset(XLMarkerPosition.TopLeft), newToAddress, GetOffset(XLMarkerPosition.BottomRight)); break; } return(newPicture); }
public new IEnumerable <T> GetIntersectedRanges(XLAddress address) { return(base.GetIntersectedRanges(address).Cast <T>()); }