4 files changed, 38 insertions, 0 deletions
diff --git a/test/ods/named-expression-sheet-local/check.txt b/test/ods/named-expression-sheet-local/check.txt
new file mode 100644
index 0000000..c6dbaed
--- /dev/null
+++ b/test/ods/named-expression-sheet-local/check.txt
@@ -0,0 +1,24 @@
+Sheet1/0/0:numeric:1
+Sheet1/0/1:numeric:6
+Sheet1/1/0:numeric:2
+Sheet1/1/1:numeric:7
+Sheet1/2/0:numeric:3
+Sheet1/2/1:numeric:8
+Sheet1/3/0:numeric:4
+Sheet1/3/1:numeric:9
+Sheet1/4/0:numeric:5
+Sheet1/4/1:numeric:10
+Sheet1/6/0:formula:SUM(MyRange):27
+Sheet1/6/1:formula:MyCalc:9
+Sheet2/0/0:numeric:10
+Sheet2/0/1:numeric:20
+Sheet2/1/0:numeric:11
+Sheet2/1/1:numeric:21
+Sheet2/2/0:numeric:12
+Sheet2/2/1:numeric:22
+Sheet2/3/0:numeric:13
+Sheet2/3/1:numeric:23
+Sheet2/4/0:numeric:14
+Sheet2/4/1:numeric:24
+Sheet2/6/0:formula:SUM(MyRange):74
+Sheet2/6/1:formula:MyCalc:-8
diff --git a/test/ods/named-expression-sheet-local/input.ods b/test/ods/named-expression-sheet-local/input.ods
new file mode 100644
index 0000000..b26f717
--- /dev/null
+++ b/test/ods/named-expression-sheet-local/input.ods
diff --git a/test/ods/named-expression/check.txt b/test/ods/named-expression/check.txt
new file mode 100644
index 0000000..e25d914
--- /dev/null
+++ b/test/ods/named-expression/check.txt
@@ -0,0 +1,14 @@
+Sheet1/1/1:formula:MyCalc:128
+Sheet1/1/4:numeric:7
+Sheet1/2/4:numeric:3
+Sheet1/3/2:formula:128/MyCalc:1
+Sheet1/3/4:formula:MyCalcWithRef:1024
+Sheet1/6/0:formula:INT(MyCalcWithRef2*PI()):65
+Sheet1/7/0:formula:INT(MyCalcWithRef2*PI()):50
+Sheet1/8/0:formula:INT(MyCalcWithRef2*PI()):28
+Sheet2/0/0:numeric:1
+Sheet2/0/1:numeric:4
+Sheet2/1/0:numeric:2
+Sheet2/1/1:numeric:5
+Sheet2/2/0:numeric:3
+Sheet2/2/1:numeric:6
diff --git a/test/ods/named-expression/input.ods b/test/ods/named-expression/input.ods
new file mode 100644
index 0000000..19a60e8
--- /dev/null
+++ b/test/ods/named-expression/input.ods