Add RhSolutions formula test

2 files changed, 44 insertions, 14 deletions

diff --git a/RhSolutions.Tests/RhSolutionsCheckTest.cs b/RhSolutions.Tests/RhSolutionsCheckTest.cs
new file mode 100644
index 0000000..a3a6460
--- /dev/null
+++ b/RhSolutions.Tests/RhSolutionsCheckTest.cs
@@ -0,0 +1,30 @@
+namespace RhSolutions.Tests;
+
+[ExcelTestSettings(AddIn = @"..\..\..\..\RhSolutions.AddIn\bin\Debug\net6.0-windows\RhSolutions-AddIn")]
+public class RhSolutionsCheckTest : IDisposable
+{
+    private Workbook workbook;
+
+    public RhSolutionsCheckTest()
+    {
+        workbook = Util.Application.Workbooks.Add();
+    }
+
+    [ExcelFact]
+    public void RhSolutionsFunctionWorks()
+    {
+        var ws = workbook.Sheets[1];
+
+        ws.Range["A1"].Formula = "=RHSOLUTIONS(\"гильза 16\")";
+        Util.Application.CalculateFull();
+
+        var result = ws.Range["A1"].Value;
+
+        Assert.Equal("Загрузка...", result);
+    }
+
+    public void Dispose()
+    {
+        Util.Application.ActiveWorkbook.Close(SaveChanges: false);
+    }
+}
diff --git a/RhSolutions.Tests/WorkbookCheckTests.cs b/RhSolutions.Tests/WorkbookCheckTests.cs
index f5fe66c..997134b 100644
--- a/RhSolutions.Tests/WorkbookCheckTests.cs
+++ b/RhSolutions.Tests/WorkbookCheckTests.cs
@@ -1,16 +1,16 @@
-namespace RhSolutions.Tests;
+//namespace RhSolutions.Tests;
 
-[ExcelTestSettings(AddIn = @"..\..\..\..\RhSolutions.AddIn\bin\Debug\net6.0-windows\RhSolutions-AddIn")]
-public class WorkbookCheckTests : IDisposable
-{
-    [ExcelFact(Workbook = @".\Workbooks\EmptyTestTable.xlsx")]
-    public void WorksheetIsCorrect()
-    {
-        Assert.True(true);
-    }
+//[ExcelTestSettings(AddIn = @"..\..\..\..\RhSolutions.AddIn\bin\Debug\net6.0-windows\RhSolutions-AddIn")]
+//public class WorkbookCheckTests : IDisposable
+//{
+//    [ExcelFact(Workbook = @".\Workbooks\EmptyTestTable.xlsx")]
+//    public void WorksheetIsCorrect()
+//    {
+//        Assert.True(true);
+//    }
 
-    public void Dispose()
-    {
-        Util.Application.ActiveWorkbook.Close(SaveChanges: false);
-    }
-}
\ No newline at end of file
+//    public void Dispose()
+//    {
+//        Util.Application.ActiveWorkbook.Close(SaveChanges: false);
+//    }
+//}
\ No newline at end of file