public void TryGetCellInHiddenRow()
{
Sheet sheet = this.workbook.Sheet("Sheet1");
Cell cell = sheet.Cell(8, 3);
Assert.IsNull(cell);
}
public void TryGetCellInHiddenColumn()
{
Sheet sheet = this.workbook.Sheet("Sheet1");
Cell cell = sheet.Cell(2, 5);
Assert.IsNull(cell);
}
public void TryGetNonExistingCellByName()
{
Sheet sheet = this.workbook.Sheet("Sheet1");
Cell cell = sheet.Cell("A100");
Assert.IsNull(cell);
}
public void TryGetNonExistingCellByRowIndexAndColumnIndex()
{
Sheet sheet = this.workbook.Sheet("Sheet1");
Cell cell = sheet.Cell(100, 100);
Assert.IsNull(cell);
}
public void GetCellByName()
{
Sheet sheet = this.workbook.Sheet("Sheet1");
Cell cell = sheet.Cell("B2");
Assert.AreEqual("Banana", cell.Value);
}
public void GetCellByRowAndColumn()
{
Sheet sheet = this.workbook.Sheet("Sheet1");
Cell cell = sheet.Cell(2, 2);
Assert.AreEqual("Banana", cell.Value);
}
private void MoveRange(MoveData moveData)
{
var srcRng = Sheet.Range(moveData.SourceAddress).Unsubscribed();
_tempSheet.Clear();
_tempSheet.Cell(1, 1).Value = srcRng;
Sheet.Range(moveData.TargetAddress).Unsubscribed().Clear();
Sheet.Cell(moveData.TargetAddress.FirstAddress).Value = _tempSheet.Range(1, 1, srcRng.RowCount(), srcRng.ColumnCount()).Unsubscribed();
//TODO !!!Sheet.ConditionalFormats.Compress();
}
private void MoveRange(MoveData moveData)
{
var srcRng = Sheet.Range(moveData.SourceAddress);
_tempSheet.Clear();
_tempSheet.Cell(1, 1).Value = srcRng;
srcRng.Clear(XLClearOptions.AllContents);
Sheet.Range(moveData.TargetAddress).Clear();
Sheet.Cell(moveData.TargetAddress.FirstAddress).Value = _tempSheet.Range(1, 1, srcRng.RowCount(), srcRng.ColumnCount());
}
public SubtotalGroup[] ScanForGroups(int groupBy)
{
var grRanges = ScanRange(groupBy);
var result = new List <SubtotalGroup>(grRanges.Length);
var rows = Sheet.Rows(_range.RangeAddress.FirstAddress.RowNumber, _range.RangeAddress.LastAddress.RowNumber);
if (!rows.Any())
{
return(new SubtotalGroup[0]);
}
var level = Math.Min(8, rows.Max(r => r.OutlineLevel) + 1);
foreach (var moveData in grRanges)
{
if (moveData.Type != RangeType.DataRange)
{
continue;
}
var groupRng = Sheet.Range(moveData.SourceAddress);
var cuttingGroups = _groups.Select(g => g.Range.RangeAddress.LastAddress)
.Distinct()
.Where(address => moveData.SourceAddress.Contains(address))
.OrderBy(address => address.RowNumber)
.ToArray();
if (cuttingGroups.Any())
{
var startAddress = moveData.SourceAddress.FirstAddress;
foreach (var g in cuttingGroups)
{
groupRng = Sheet.Range(startAddress, g);
result.Add(new SubtotalGroup(level, groupBy, moveData.GroupTitle, groupRng, null, false));
startAddress = Sheet.Cell(g).WorksheetRow().RowBelow()
.Cell(startAddress.ColumnNumber).Address;
}
groupRng = startAddress.RowNumber <= moveData.SourceAddress.LastAddress.RowNumber
? Sheet.Range(startAddress, moveData.SourceAddress.LastAddress)
: null;
}
if (groupRng != null)
{
result.Add(new SubtotalGroup(level, groupBy, moveData.GroupTitle, groupRng, null, false));
}
}
_groups.AddRange(result);
return(result.ToArray());
}
