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); }