Test Cases & Chat
Part 1
current
Test 1
input:Excel(3,"C"), set(1,"A",5), get(1,"A")
expect:5
Test 2
input:Excel(3,"C"), set(1,"A",2), set(1,"B",3), get(1,"B")
expect:3
Test 3
input:Excel(3,"C"), set(2,"B",10), set(2,"B",20), get(2,"B")
expect:20
Test 4
input:Excel(3,"C"), get(1,"A") (unset cell)
expect:0
Test 5
input:set A1=2, B1=3, sum C1=[A1,B1], get C1
expect:5
Test 6
input:set A1=5, sum B1=[A1,A1], get B1 (same cell twice)
expect:10
Test 7
input:set A1=2, B1=3, sum C1, update A1=10, get C1
expect:13
Test 8
input:sum with unset cells (should be 0)
expect:0
Test 9
input:sum B1=[C1], sum A1=[B1], set C1=5, get A1
expect:5
Test 10
input:sum C1=[D1], sum B1=[C1], sum A1=[B1], set D1=7, get A1
expect:7
Test 11
input:overwrite formula with value: sum B1=[A1], set B1=99, update A1=10, get B1
expect:99
Test 12
input:overwrite formula with formula: B1=[A1] then B1=[C1], set C1=7, get B1
expect:7
Test 13
input:nested dependency: B1=sum(D1), A1=sum(B1,D1), set D1=5, get A1
expect:10
Test 14
input:negative values: set A1=-2, set B1=3, sum C1=[A1,B1], get C1
expect:1
Part 2
locked
Part 3
locked
Resume a session
Loading sessions...
or start fresh
Choose your coach
Pick a style and how you want to communicate
then
Loading...
OUTPUT
Run code to see output...
Part 1
current
Test 1
input:Excel(3,"C"), set(1,"A",5), get(1,"A")
expect:5
Test 2
input:Excel(3,"C"), set(1,"A",2), set(1,"B",3), get(1,"B")
expect:3
Test 3
input:Excel(3,"C"), set(2,"B",10), set(2,"B",20), get(2,"B")
expect:20
Test 4
input:Excel(3,"C"), get(1,"A") (unset cell)
expect:0
Test 5
input:set A1=2, B1=3, sum C1=[A1,B1], get C1
expect:5
Test 6
input:set A1=5, sum B1=[A1,A1], get B1 (same cell twice)
expect:10
Test 7
input:set A1=2, B1=3, sum C1, update A1=10, get C1
expect:13
Test 8
input:sum with unset cells (should be 0)
expect:0
Test 9
input:sum B1=[C1], sum A1=[B1], set C1=5, get A1
expect:5
Test 10
input:sum C1=[D1], sum B1=[C1], sum A1=[B1], set D1=7, get A1
expect:7
Test 11
input:overwrite formula with value: sum B1=[A1], set B1=99, update A1=10, get B1
expect:99
Test 12
input:overwrite formula with formula: B1=[A1] then B1=[C1], set C1=7, get B1
expect:7
Test 13
input:nested dependency: B1=sum(D1), A1=sum(B1,D1), set D1=5, get A1
expect:10
Test 14
input:negative values: set A1=-2, set B1=3, sum C1=[A1,B1], get C1
expect:1
Part 2
locked
Part 3
locked
Resume a session
Loading sessions...
or start fresh
Choose your coach
Pick a style and how you want to communicate
then