public static void CopyStylesFrom(this IXLRangeBase trgtRow, IXLRangeBase srcRow)
{
trgtRow.Style = srcRow.Style;
var srcCells = srcRow.Cells(true, true).ToArray();
for (int i = 0; i < srcCells.Length; i++)
{
var rela = srcCells[i].Relative(srcRow.RangeAddress.FirstAddress);
var trgtCell = trgtRow.RangeAddress.FirstAddress.Offset(rela);
trgtCell.Style = srcCells[i].Style;
//trgtCells[i].Style = srcCells[i].Style;
}
//trgtRow.CopyConditionalFormatsFrom(srcRow);
}
public static IXLCells CellsWithoutFormulas(this IXLRangeBase range, Func <IXLCell, bool> predicate)
{
return(range.Cells(c => predicate(c) && !c.HasFormula));
}
public static IXLCells CellsWithoutFormulas(this IXLRangeBase range)
{
return(range.Cells(c => !c.HasFormula));
}
public IEnumerable <IDataSheetCell> Cells()
{
// TODO: Cache the cells
return(_row.Cells().Select(c => new DataSheetCell(c)));
}