From 4f448f203471a19a1444555a895f503515ad2fda Mon Sep 17 00:00:00 2001
From: Sergey Chebotar <s.chebotar@gmail.com>
Date: Wed, 22 Mar 2023 08:36:13 +0300
Subject: Add basic test

---
 RhSolutions.Tests/Tests.cs | 38 ++++++++++++++++++++++++++++++++++++++
 1 file changed, 38 insertions(+)
 create mode 100644 RhSolutions.Tests/Tests.cs

(limited to 'RhSolutions.Tests/Tests.cs')

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
-- 
cgit v1.2.3