public void SetFontBold_WithInactive_SetsBoldStyle()
{
// Arrange
bool expectedToBeBold = false;
ExcelRange excelRange = ExcelTestBuilder.CreateExcelRange();
// Act
excelRange.SetFontBold(expectedToBeBold);
// Assert
excelRange.Style.Font.Bold.Should().BeFalse();
}
public void SetBorder_WithDirectionBottom_SetStyleOnBottomBorder()
{
// Arrange
ExcelRange excelRange = ExcelTestBuilder.CreateExcelRange();
BorderStyle expectedBorderStyle = BorderStyle.DashDot;
// Act
excelRange.SetBorder(BorderDirection.Bottom, expectedBorderStyle, _fixture.Create <Color>());
// Assert
excelRange.Style.Border.Bottom.Style.Should().Be((ExcelBorderStyle)expectedBorderStyle);
}
public void Address_WithValidExcelRange_ReturnsAddressOfExcelRange()
{
// Arrange
var excelRange = ExcelTestBuilder.CreateExcelRange();
var sut = new ExcelRangeWrapper(excelRange);
// Act
ICellAddress result = sut.Address;
// Assert
result.ToString().Should().Be(excelRange.Address);
}
public void Constructor_WithValidWorksheet_SetsCurrentCellToTopLeft()
{
// Arrange
var worksheet = ExcelTestBuilder.CreateExcelWorksheet();
// Act
_sut = new ExcelSpreadsheetWriter(worksheet);
// Assert
_sut.CurrentPosition.X.Should().Be(1);
_sut.CurrentPosition.Y.Should().Be(1);
}
public void SetBorder_WithDirectionDiagonalUp_SetStyleOnDiagonalUpBorder()
{
// Arrange
ExcelRange excelRange = ExcelTestBuilder.CreateExcelRange();
BorderStyle expectedBorderStyle = BorderStyle.DashDot;
// Act
excelRange.SetBorder(BorderDirection.DiagonalUp, expectedBorderStyle, _fixture.Create <Color>());
// Assert
excelRange.Style.Border.Diagonal.Style.Should().Be((ExcelBorderStyle)expectedBorderStyle);
excelRange.Style.Border.DiagonalUp.Should().BeTrue();
}
public void Value_WithValidExcelRange_ReturnsValueOfExcelRange()
{
// Arrange
var expectedValue = _fixture.Create <string>();
var excelRange = ExcelTestBuilder.CreateExcelRange();
excelRange.Value = expectedValue;
var sut = new ExcelRangeWrapper(excelRange);
// Act
string result = sut.Value;
// Assert
result.Should().Be((string)excelRange.Value);
}
public void SetBorder_WithDirectionAround_SetBorderStylingOnAllSideBorders()
{
// Arrange
ExcelRange excelRange = ExcelTestBuilder.CreateExcelRange();
BorderStyle expectedBorderStyle = BorderStyle.DashDot;
Color borderColor = _fixture.Create <Color>();
// Act
excelRange.SetBorder(BorderDirection.Around, expectedBorderStyle, borderColor);
// Assert
excelRange.Style.Border.Top.Style.Should().Be(expectedBorderStyle);
excelRange.Style.Border.Bottom.Style.Should().Be(expectedBorderStyle);
excelRange.Style.Border.Left.Style.Should().Be(expectedBorderStyle);
excelRange.Style.Border.Right.Style.Should().Be(expectedBorderStyle);
}
public void SetBorder_WithDirectionNone_SetNoBorderStyling()
{
// Arrange
ExcelRange excelRange = ExcelTestBuilder.CreateExcelRange();
BorderStyle expectedBorderStyle = _fixture.Create <BorderStyle>();
// Act
excelRange.SetBorder(BorderDirection.None, expectedBorderStyle, _fixture.Create <Color>());
// Assert
excelRange.Style.Border.Top.Style.Should().Be(ExcelBorderStyle.None);
excelRange.Style.Border.Bottom.Style.Should().Be(ExcelBorderStyle.None);
excelRange.Style.Border.Left.Style.Should().Be(ExcelBorderStyle.None);
excelRange.Style.Border.Right.Style.Should().Be(ExcelBorderStyle.None);
excelRange.Style.Border.Diagonal.Style.Should().Be(ExcelBorderStyle.None);
excelRange.Style.Border.DiagonalUp.Should().BeFalse();
excelRange.Style.Border.DiagonalDown.Should().BeFalse();
}
public void Initialize()
{
_fixture = new Fixture();
_worksheet = ExcelTestBuilder.CreateExcelWorksheet();
_sut = new ExcelSpreadsheetWriter(_worksheet);
}
