Add basic test

1 files changed, 38 insertions, 0 deletions

diff --git a/RhSolutions.Tests/Tests.cs b/RhSolutions.Tests/Tests.cs
new file mode 100644
index 0000000..3d1e988
--- /dev/null
+++ b/RhSolutions.Tests/Tests.cs
@@ -0,0 +1,38 @@
+namespace RhSolutions.Tests
+{
+    [ExcelTestSettings(AddIn = @"..\..\..\..\RhSolutions.AddIn\bin\Debug\net6.0-windows\RhSolutions-AddIn")]
+    public class CalculationTests : IDisposable
+    {
+        Workbook _testWorkbook;
+
+        public CalculationTests()
+        {
+            // Get hold of the Excel Application object and create a workbook
+            _testWorkbook = Util.Application.Workbooks.Add();
+        }
+
+        public void Dispose()
+        {
+            // Clean up our workbook without saving changes
+            _testWorkbook.Close(SaveChanges: false);
+        }
+
+        [ExcelFact]
+        public void NumbersAddCorrectly()
+        {
+            // We'll just do our test on the first sheet
+            var ws = _testWorkbook.Sheets[1];
+
+            // Write two numbers to the active sheet, and a formula that adds them, together
+            ws.Range["A1"].Value = 2.0;
+            ws.Range["A2"].Value = 3.0;
+            ws.Range["A3"].Formula = "= A1 + A2";
+
+            // Read back the value from the cell with the formula
+            var result = ws.Range["A3"].Value;
+
+            // Check that we have the expected result
+            Assert.Equal(5.0, result);
+        }
+    }
+}
\ No newline at end of file