diff --git a/ClosedXML_Examples/Misc/Formulas.cs b/ClosedXML_Examples/Misc/Formulas.cs
index 729cb9e..8066a81 100644
--- a/ClosedXML_Examples/Misc/Formulas.cs
+++ b/ClosedXML_Examples/Misc/Formulas.cs
@@ -54,6 +54,7 @@
             // Just put the formula between curly braces
             ws.Cell("A6").Value = "Array Formula: ";
             ws.Cell("B6").FormulaA1 = "{A2+A3}";
+            ws.Range("C6:D6").FormulaA1 = "{TRANSPOSE(A2:A3)}";
 
             ws.Range(1, 1, 1, 7).Style.Fill.BackgroundColor = XLColor.Cyan;
             ws.Range(1, 1, 1, 7).Style.Font.Bold = true;
diff --git a/ClosedXML_Tests/Resource/Examples/Misc/Formulas.xlsx b/ClosedXML_Tests/Resource/Examples/Misc/Formulas.xlsx
index dea7693..c49d20a 100644
--- a/ClosedXML_Tests/Resource/Examples/Misc/Formulas.xlsx
+++ b/ClosedXML_Tests/Resource/Examples/Misc/Formulas.xlsx
Binary files differ
diff --git a/ClosedXML_Tests/Resource/Examples/Misc/FormulasWithEvaluation.xlsx b/ClosedXML_Tests/Resource/Examples/Misc/FormulasWithEvaluation.xlsx
index 7a93ddb..f1dde09 100644
--- a/ClosedXML_Tests/Resource/Examples/Misc/FormulasWithEvaluation.xlsx
+++ b/ClosedXML_Tests/Resource/Examples/Misc/FormulasWithEvaluation.xlsx
Binary files differ