diff options
| author | Randy Morgan <[email protected]> | 2012-05-12 00:34:11 +0900 |
|---|---|---|
| committer | Randy Morgan <[email protected]> | 2012-05-12 00:34:11 +0900 |
| commit | 88b67ba036c038be9d2cb116bb70eac720f3e40b (patch) | |
| tree | 8f760b13cb257fb07c910a9805d167b97a9e50be /test/workbook/worksheet/tc_cell.rb | |
| parent | ac0600f12fb15d1b3fe0cce1ca7a2dced4cf5285 (diff) | |
| download | caxlsx-88b67ba036c038be9d2cb116bb70eac720f3e40b.tar.gz caxlsx-88b67ba036c038be9d2cb116bb70eac720f3e40b.zip | |
patch formula parsing.
#92 many thanks to @alexei-lexx for not only finding this, but taking time to report the problem.
Diffstat (limited to 'test/workbook/worksheet/tc_cell.rb')
| -rw-r--r-- | test/workbook/worksheet/tc_cell.rb | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/test/workbook/worksheet/tc_cell.rb b/test/workbook/worksheet/tc_cell.rb index edb3ae85..6a93fc58 100644 --- a/test/workbook/worksheet/tc_cell.rb +++ b/test/workbook/worksheet/tc_cell.rb @@ -251,6 +251,16 @@ class TestCell < Test::Unit::TestCase assert_equal(c_xml.xpath("/c[@s=1]").size, 1) end + def test_to_xml_string_formula + p = Axlsx::Package.new + ws = p.workbook.add_worksheet do |ws| + ws.add_row ["=IF(2+2=4,4,5)"] + end + doc = Nokogiri::XML(ws.to_xml_string) + assert("//f[text()=['IF(2+2=4,4,5)']") + + end + def test_to_xml # TODO This could use some much more stringent testing related to the xml content generated! row = @ws.add_row [Time.now, Date.today, true, 1, 1.0, "text", "=sum(A1:A2)"] |