Branch
Hash :
bf4f7bfa
Author :
Date :
2020-03-10T14:59:46
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104
Sales!B2
'Winter sales'!B2
[Sales.xlsx]Jan!B2:B5
D:\Reports\[Sales.xlsx]Jan!B2:B5
'[Sales.xlsx]Jan sales'!B2:B5
'D:\Reports\[Sales.xlsx]Jan sales'!B2:B5
SUM([Sales.xlsx]Jan!Jan_sales)
----------------------------------------------------
[
["reference", [
["sheet", "Sales"],
["operator", "!"]
]],
["cell", "B2"],
["reference", [
["punctuation", "'"],
["sheet", "Winter sales"],
["punctuation", "'"],
["operator", "!"]
]],
["cell", "B2"],
["reference", [
["file", [
["punctuation", "["],
"Sales.xlsx",
["punctuation", "]"]
]],
["sheet", "Jan"],
["operator", "!"]
]],
["range", [
["cell", "B2"],
["operator", ":"],
["cell", "B5"]
]],
["reference", [
["path", "D:\\Reports\\"],
["file", [
["punctuation", "["],
"Sales.xlsx",
["punctuation", "]"]
]],
["sheet", "Jan"],
["operator", "!"]
]],
["range", [
["cell", "B2"],
["operator", ":"],
["cell", "B5"]
]],
["reference", [
["punctuation", "'"],
["file", [
["punctuation", "["],
"Sales.xlsx",
["punctuation", "]"]
]],
["sheet", "Jan sales"],
["punctuation", "'"],
["operator", "!"]
]],
["range", [
["cell", "B2"],
["operator", ":"],
["cell", "B5"]
]],
["reference", [
["punctuation", "'"],
["path", "D:\\Reports\\"],
["file", [
["punctuation", "["],
"Sales.xlsx",
["punctuation", "]"]
]],
["sheet", "Jan sales"],
["punctuation", "'"],
["operator", "!"]
]],
["range", [
["cell", "B2"],
["operator", ":"],
["cell", "B5"]
]],
["function-name", "SUM"],
["punctuation", "("],
["reference", [
["file", [
["punctuation", "["],
"Sales.xlsx",
["punctuation", "]"]
]],
["sheet", "Jan"],
["operator", "!"]
]],
"Jan_sales",
["punctuation", ")"]
]
----------------------------------------------------
Checks for references.