Create test for read vs read-write-read continuity

[zackteo]

Basically reading a file should produce the same output as that of reading-writing-reading again

[zackteo]

Cells behaving weirdly ...

  18. { :coord { :row 1, :col 0, :sheet "Sheet2" }, :value "6", :formula "TRUE()", :style { :font-colour :black, :col-size 10, :row-size 16 } }
  19. { :coord { :row 1, :col 2, :sheet "Sheet2" }, :value "7", :formula "FALSE()", :style { :font-colour :black, :col-size 10, :row-size 16 } }
  20. { :coord { :row 2, :col 0, :sheet "Sheet2" }, :value "8", :formula "1/0", :style { :font-colour :black, :col-size 10, :row-size 16 } }
  21. { :coord { :row 2, :col 1, :sheet "Sheet2" }, :value "9", :formula "#N/A", :style { :font-colour :black, :col-size 10, :row-size 16 } }
  22. { :coord { :row 2, :col 2, :sheet "Sheet2" }, :value "9", :formula "#N/A", :style { :font-colour :black, :col-size 10, :row-size 16 } }

The values are "1" "0" "6" "7" "7" first read

[zackteo]

Not sure about the value of 6 and 7 in the first read.

But this might suggest that #22 wasn't done perfectly after all - since I was using fxl to generate the file.

This might suggest that such special formulas are assigned a special value like so ...
6 -> TRUE()
7 -> FALSE()
8 -> 1/0
9 -> #N/A