using Sbroenne.ExcelMcp.ComInterop.Session;
using Sbroenne.ExcelMcp.Core.Commands.Chart;
using Sbroenne.ExcelMcp.Core.Tests.Helpers;
using Xunit;
namespace Sbroenne.ExcelMcp.Core.Tests.Commands;
/// <summary>
/// Integration tests for Chart appearance operations (SetChartType, SetTitle, SetAxisTitle, ShowLegend, SetStyle, Get/SetAxisNumberFormat).
/// </summary>
public partial class ChartCommandsTests
{
[Fact]
public void SetChartType_ExistingChart_ChangesType()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data and chart
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B4"].Value2 = new object[,] {
{ "Cat", "Val" },
{ "Q1", 100 },
{ "Q2", 150 },
{ "Q3", 200 }
};
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B4", ChartType.ColumnClustered, 50, 50);
Assert.Equal(ChartType.ColumnClustered, createResult.ChartType);
// Act - Change to Line chart
_commands.SetChartType(batch, createResult.ChartName, ChartType.Line);
// Assert - Verify type changed
var readResult = _commands.Read(batch, createResult.ChartName);
Assert.Equal(ChartType.Line, readResult.ChartType);
}
[Fact]
public void SetTitle_ValidTitle_SetsChartTitle()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data and chart
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B3"].Value2 = new object[,] {
{ "X", "Y" },
{ 1, 10 },
{ 2, 20 }
};
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B3", ChartType.Pie, 50, 50);
// Act
_commands.SetTitle(batch, createResult.ChartName, "Sales by Quarter");
// Assert - Verify title set
var readResult = _commands.Read(batch, createResult.ChartName);
Assert.Equal("Sales by Quarter", readResult.Title);
}
[Fact]
public void SetTitle_EmptyString_HidesTitle()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data and chart with title
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B3"].Value2 = new object[,] { { "X", "Y" }, { 1, 10 }, { 2, 20 } };
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B3", ChartType.BarClustered, 50, 50);
_commands.SetTitle(batch, createResult.ChartName, "Initial Title");
// Act - Hide title with empty string
_commands.SetTitle(batch, createResult.ChartName, "");
// Assert - Verify title hidden
var readResult = _commands.Read(batch, createResult.ChartName);
Assert.Null(readResult.Title);
}
[Fact]
public void SetAxisTitle_CategoryAxis_SetsTitleSuccessfully()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data and chart
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B4"].Value2 = new object[,] {
{ "Month", "Sales" },
{ "Jan", 100 },
{ "Feb", 150 },
{ "Mar", 200 }
};
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B4", ChartType.ColumnClustered, 50, 50);
// Act & Assert - void operation, no exception means success
_commands.SetAxisTitle(batch, createResult.ChartName, ChartAxisType.Category, "Months");
}
[Fact]
public void SetAxisTitle_ValueAxis_SetsTitleSuccessfully()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data and chart
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B4"].Value2 = new object[,] {
{ "Product", "Revenue" },
{ "A", 1000 },
{ "B", 1500 },
{ "C", 2000 }
};
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B4", ChartType.BarClustered, 50, 50);
// Act & Assert - void operation, no exception means success
_commands.SetAxisTitle(batch, createResult.ChartName, ChartAxisType.Value, "Revenue ($)");
}
[Fact]
public void ShowLegend_WithPosition_DisplaysLegendAtPosition()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data and chart
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:C4"].Value2 = new object[,] {
{ "X", "Series1", "Series2" },
{ "A", 10, 20 },
{ "B", 15, 25 },
{ "C", 20, 30 }
};
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:C4", ChartType.Line, 50, 50);
// Act - Show legend at bottom
_commands.ShowLegend(batch, createResult.ChartName, true, LegendPosition.Bottom);
// Assert - Verify legend visible
var readResult = _commands.Read(batch, createResult.ChartName);
Assert.True(readResult.HasLegend);
}
[Fact]
public void ShowLegend_HideLegend_RemovesLegend()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data and chart
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B3"].Value2 = new object[,] { { "X", "Y" }, { 1, 10 }, { 2, 20 } };
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B3", ChartType.Area, 50, 50);
_commands.ShowLegend(batch, createResult.ChartName, true, LegendPosition.Right); // Show first
// Act - Hide legend
_commands.ShowLegend(batch, createResult.ChartName, false);
// Assert - Verify legend hidden
var readResult = _commands.Read(batch, createResult.ChartName);
Assert.False(readResult.HasLegend);
}
[Fact]
public void SetStyle_ValidStyleId_AppliesStyle()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data and chart
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B4"].Value2 = new object[,] {
{ "Cat", "Val" },
{ "A", 10 },
{ "B", 20 },
{ "C", 30 }
};
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B4", ChartType.ColumnClustered, 50, 50);
// Act & Assert - void operation, no exception means success
_commands.SetStyle(batch, createResult.ChartName, 10);
}
[Fact]
public void SetStyle_InvalidStyleId_ReturnsError()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data and chart
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B3"].Value2 = new object[,] { { "X", "Y" }, { 1, 10 }, { 2, 20 } };
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B3", ChartType.Pie, 50, 50);
// Act & Assert - Invalid style ID should throw exception
var exception = Assert.Throws<ArgumentException>(() =>
_commands.SetStyle(batch, createResult.ChartName, 999));
Assert.Contains("between 1 and 48", exception.Message, StringComparison.OrdinalIgnoreCase);
}
[Fact]
public void SetChartType_MultipleTypes_AllWorkCorrectly()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data and chart
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B5"].Value2 = new object[,] {
{ "X", "Y" },
{ 1, 10 },
{ 2, 20 },
{ 3, 30 },
{ 4, 40 }
};
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B5", ChartType.ColumnClustered, 50, 50);
// Act & Assert - Test multiple chart type changes
var chartTypes = new[] { ChartType.Line, ChartType.Area, ChartType.BarClustered, ChartType.XYScatter, ChartType.Pie };
foreach (var chartType in chartTypes)
{
_commands.SetChartType(batch, createResult.ChartName, chartType);
var readResult = _commands.Read(batch, createResult.ChartName);
Assert.Equal(chartType, readResult.ChartType);
}
}
[Fact]
public void ShowLegend_DifferentPositions_AllWorkCorrectly()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data and chart
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:C4"].Value2 = new object[,] {
{ "X", "S1", "S2" },
{ "A", 10, 20 },
{ "B", 15, 25 },
{ "C", 20, 30 }
};
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:C4", ChartType.ColumnClustered, 50, 50);
// Act & Assert - Test all legend positions
var positions = new[] {
LegendPosition.Bottom,
LegendPosition.Top,
LegendPosition.Left,
LegendPosition.Right,
LegendPosition.Corner
};
foreach (var position in positions)
_commands.ShowLegend(batch, createResult.ChartName, true, position);
}
[Fact]
public void GetAxisNumberFormat_ValueAxis_ReturnsCurrentFormat()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data and chart
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B4"].Value2 = new object[,] {
{ "Month", "Revenue" },
{ "Jan", 1000000 },
{ "Feb", 1500000 },
{ "Mar", 2000000 }
};
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B4", ChartType.ColumnClustered, 50, 50);
// Act
var format = _commands.GetAxisNumberFormat(batch, createResult.ChartName, ChartAxisType.Value);
// Assert - Default format is typically "General"
Assert.NotNull(format);
}
[Fact]
public void SetAxisNumberFormat_ValueAxis_SetsFormatSuccessfully()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data and chart
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B4"].Value2 = new object[,] {
{ "Month", "Revenue" },
{ "Jan", 1000000 },
{ "Feb", 1500000 },
{ "Mar", 2000000 }
};
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B4", ChartType.ColumnClustered, 50, 50);
// Act - Set millions format
_commands.SetAxisNumberFormat(batch, createResult.ChartName, ChartAxisType.Value, "$#,##0,,\"M\"");
// Assert - Verify format was set
var format = _commands.GetAxisNumberFormat(batch, createResult.ChartName, ChartAxisType.Value);
Assert.Equal("$#,##0,,\"M\"", format);
}
[Fact]
public void SetAxisNumberFormat_CategoryAxis_SetsFormatSuccessfully()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data with dates
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B4"].Value2 = new object[,] {
{ "Date", "Sales" },
{ 45658, 100 }, // Jan 1, 2025
{ 45689, 150 }, // Feb 1, 2025
{ 45717, 200 } // Mar 1, 2025
};
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B4", ChartType.Line, 50, 50);
// Act - Set date format on category axis
_commands.SetAxisNumberFormat(batch, createResult.ChartName, ChartAxisType.Category, "mmm-yy");
// Assert - Verify format was set
var format = _commands.GetAxisNumberFormat(batch, createResult.ChartName, ChartAxisType.Category);
Assert.Equal("mmm-yy", format);
}
[Fact]
public void SetAxisNumberFormat_PercentageFormat_SetsFormatSuccessfully()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B4"].Value2 = new object[,] {
{ "Item", "Rate" },
{ "A", 0.25 },
{ "B", 0.50 },
{ "C", 0.75 }
};
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B4", ChartType.BarClustered, 50, 50);
// Act - Set percentage format
_commands.SetAxisNumberFormat(batch, createResult.ChartName, ChartAxisType.Value, "0%");
// Assert - Verify format was set
var format = _commands.GetAxisNumberFormat(batch, createResult.ChartName, ChartAxisType.Value);
Assert.Equal("0%", format);
}
[Fact]
public void SetAxisNumberFormat_NonExistentChart_ThrowsException()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Act & Assert - Non-existent chart should throw
var exception = Assert.Throws<InvalidOperationException>(() =>
_commands.SetAxisNumberFormat(batch, "NonExistentChart", ChartAxisType.Value, "#,##0"));
Assert.Contains("not found", exception.Message, StringComparison.OrdinalIgnoreCase);
}
[Fact]
public void GetAxisNumberFormat_NonExistentChart_ThrowsException()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Act & Assert - Non-existent chart should throw
var exception = Assert.Throws<InvalidOperationException>(() =>
_commands.GetAxisNumberFormat(batch, "NonExistentChart", ChartAxisType.Value));
Assert.Contains("not found", exception.Message, StringComparison.OrdinalIgnoreCase);
}
[Fact]
public void SetAxisNumberFormat_MultipleFormats_AllWorkCorrectly()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data and chart
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B4"].Value2 = new object[,] {
{ "X", "Y" },
{ 1, 1000000 },
{ 2, 2000000 },
{ 3, 3000000 }
};
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B4", ChartType.ColumnClustered, 50, 50);
// Act & Assert - Test multiple format changes
var formats = new[] { "#,##0", "$#,##0", "#,##0.00", "$#,##0,,\"M\"", "0.0E+0" };
foreach (var fmt in formats)
{
_commands.SetAxisNumberFormat(batch, createResult.ChartName, ChartAxisType.Value, fmt);
var result = _commands.GetAxisNumberFormat(batch, createResult.ChartName, ChartAxisType.Value);
Assert.Equal(fmt, result);
}
}
// === PLACEMENT TESTS ===
[Fact]
public void SetPlacement_MoveAndSize_SetsPlacementMode()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data and chart
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B4"].Value2 = new object[,] {
{ "X", "Y" },
{ 1, 100 },
{ 2, 200 },
{ 3, 300 }
};
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B4", ChartType.ColumnClustered, 50, 50);
// Act - Set placement to MoveAndSize (1 = xlMoveAndSizeWithCells)
_commands.SetPlacement(batch, createResult.ChartName, 1);
// Assert - Verify placement changed
var readResult = _commands.Read(batch, createResult.ChartName);
Assert.Equal(1, readResult.Placement);
}
[Fact]
public void SetPlacement_MoveOnly_SetsPlacementMode()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data and chart
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B4"].Value2 = new object[,] {
{ "X", "Y" },
{ 1, 100 },
{ 2, 200 },
{ 3, 300 }
};
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B4", ChartType.Line, 50, 50);
// Act - Set placement to Move (2 = xlMove)
_commands.SetPlacement(batch, createResult.ChartName, 2);
// Assert - Verify placement changed
var readResult = _commands.Read(batch, createResult.ChartName);
Assert.Equal(2, readResult.Placement);
}
[Fact]
public void SetPlacement_FreeFloating_SetsPlacementMode()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data and chart
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B4"].Value2 = new object[,] {
{ "X", "Y" },
{ 1, 100 },
{ 2, 200 },
{ 3, 300 }
};
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B4", ChartType.Pie, 50, 50);
// Act - Set placement to FreeFloating (3 = xlFreeFloating)
_commands.SetPlacement(batch, createResult.ChartName, 3);
// Assert - Verify placement changed
var readResult = _commands.Read(batch, createResult.ChartName);
Assert.Equal(3, readResult.Placement);
}
[Fact]
public void SetPlacement_InvalidValue_ThrowsException()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data and chart
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B4"].Value2 = new object[,] {
{ "X", "Y" },
{ 1, 100 },
{ 2, 200 },
{ 3, 300 }
};
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B4", ChartType.ColumnClustered, 50, 50);
// Act & Assert - Invalid placement value should throw
var exception = Assert.Throws<ArgumentException>(() =>
_commands.SetPlacement(batch, createResult.ChartName, 5));
Assert.Contains("placement", exception.ParamName, StringComparison.OrdinalIgnoreCase);
}
[Fact]
public void SetPlacement_NonExistentChart_ThrowsException()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Act & Assert - Non-existent chart should throw
var exception = Assert.Throws<InvalidOperationException>(() =>
_commands.SetPlacement(batch, "NonExistentChart", 1));
Assert.Contains("not found", exception.Message, StringComparison.OrdinalIgnoreCase);
}
// === FIT TO RANGE TESTS ===
[Fact]
public void FitToRange_ValidRange_ResizesChartToMatchRange()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data and chart
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B4"].Value2 = new object[,] {
{ "X", "Y" },
{ 1, 100 },
{ 2, 200 },
{ 3, 300 }
};
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B4", ChartType.ColumnClustered, 50, 50, 400, 300);
// Act - Fit chart to a specific range
_commands.FitToRange(batch, createResult.ChartName, "Sheet1", "E5:J15");
// Assert - Verify chart position/size changed (can verify via Read that chart still exists)
var readResult = _commands.Read(batch, createResult.ChartName);
Assert.NotNull(readResult);
// TopLeftCell should now be E5 (or close to it, depending on exact positioning)
Assert.NotNull(readResult.TopLeftCell);
}
[Fact]
public void FitToRange_DifferentSheet_ThrowsOrMovesChart()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data, chart, and a second sheet
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B4"].Value2 = new object[,] {
{ "X", "Y" },
{ 1, 100 },
{ 2, 200 },
{ 3, 300 }
};
// Create second sheet
dynamic newSheet = ctx.Book.Worksheets.Add();
newSheet.Name = "Sheet2";
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B4", ChartType.ColumnClustered, 50, 50);
// Act - Try to fit chart to range on same sheet
_commands.FitToRange(batch, createResult.ChartName, "Sheet1", "E5:H10");
// Assert - Verify chart moved
var readResult = _commands.Read(batch, createResult.ChartName);
Assert.NotNull(readResult);
}
[Fact]
public void FitToRange_NonExistentChart_ThrowsException()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Act & Assert - Non-existent chart should throw
var exception = Assert.Throws<InvalidOperationException>(() =>
_commands.FitToRange(batch, "NonExistentChart", "Sheet1", "A1:D10"));
Assert.Contains("not found", exception.Message, StringComparison.OrdinalIgnoreCase);
}
[Fact]
public void FitToRange_InvalidRangeAddress_ThrowsException()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data and chart
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B4"].Value2 = new object[,] {
{ "X", "Y" },
{ 1, 100 },
{ 2, 200 },
{ 3, 300 }
};
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B4", ChartType.ColumnClustered, 50, 50);
// Act & Assert - Invalid range should throw
Assert.ThrowsAny<Exception>(() =>
_commands.FitToRange(batch, createResult.ChartName, "Sheet1", "InvalidRange!!!"));
}
// === ANCHOR CELLS TESTS ===
[Fact]
public void Read_ChartCreatedAtPosition_ReturnsAnchorCells()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data and chart at specific position
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B4"].Value2 = new object[,] {
{ "X", "Y" },
{ 1, 100 },
{ 2, 200 },
{ 3, 300 }
};
return 0;
});
// Create chart at position left=50, top=50
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B4", ChartType.ColumnClustered, 50, 50, 400, 300);
// Act
var readResult = _commands.Read(batch, createResult.ChartName);
// Assert - Anchor cells should be populated
Assert.NotNull(readResult.TopLeftCell);
Assert.NotNull(readResult.BottomRightCell);
// TopLeftCell should be a valid cell address (e.g., "$A$1", "$B$2", etc.)
Assert.Matches(@"\$[A-Z]+\$\d+", readResult.TopLeftCell);
Assert.Matches(@"\$[A-Z]+\$\d+", readResult.BottomRightCell);
}
[Fact]
public void Read_ChartAfterFitToRange_ReturnsUpdatedAnchorCells()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data and chart
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B4"].Value2 = new object[,] {
{ "X", "Y" },
{ 1, 100 },
{ 2, 200 },
{ 3, 300 }
};
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B4", ChartType.ColumnClustered, 50, 50);
// Get initial anchor cells
var initialRead = _commands.Read(batch, createResult.ChartName);
var initialTopLeft = initialRead.TopLeftCell;
// Act - Fit chart to a different range
_commands.FitToRange(batch, createResult.ChartName, "Sheet1", "F10:K20");
// Assert - Anchor cells should have changed
var afterRead = _commands.Read(batch, createResult.ChartName);
Assert.NotEqual(initialTopLeft, afterRead.TopLeftCell);
// The new TopLeftCell should reflect the new position (around F10)
Assert.NotNull(afterRead.TopLeftCell);
Assert.NotNull(afterRead.BottomRightCell);
}
[Fact]
public void Read_ChartWithPlacement_ReturnsPlacementValue()
{
// Arrange
var testFile = _fixture.CreateTestFile();
using var batch = ExcelSession.BeginBatch(testFile);
// Create test data and chart
batch.Execute((ctx, ct) =>
{
dynamic sheet = ctx.Book.Worksheets.Item(1);
sheet.Range["A1:B4"].Value2 = new object[,] {
{ "X", "Y" },
{ 1, 100 },
{ 2, 200 },
{ 3, 300 }
};
return 0;
});
var createResult = _commands.CreateFromRange(batch, "Sheet1", "A1:B4", ChartType.ColumnClustered, 50, 50);
// Act
var readResult = _commands.Read(batch, createResult.ChartName);
// Assert - Placement should be populated with a valid value (1, 2, or 3)
Assert.NotNull(readResult.Placement);
Assert.InRange(readResult.Placement.Value, 1, 3);
}
}
