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 /lib | |
| 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 'lib')
| -rw-r--r-- | lib/axlsx.rb | 1 | ||||
| -rw-r--r-- | lib/axlsx/workbook/worksheet/cell.rb | 2 |
2 files changed, 2 insertions, 1 deletions
diff --git a/lib/axlsx.rb b/lib/axlsx.rb index 6fce32b5..6e8f4e23 100644 --- a/lib/axlsx.rb +++ b/lib/axlsx.rb @@ -54,6 +54,7 @@ module Axlsx ref end + # returns the x, y position of a cell def self.name_to_indices(name) raise ArgumentError, 'invalid cell name' unless name.size > 1 v = name[/[A-Z]+/].reverse.chars.reduce({:base=>1, :i=>0}) do |val, c| diff --git a/lib/axlsx/workbook/worksheet/cell.rb b/lib/axlsx/workbook/worksheet/cell.rb index 91efa8d9..c58ede3a 100644 --- a/lib/axlsx/workbook/worksheet/cell.rb +++ b/lib/axlsx/workbook/worksheet/cell.rb @@ -296,7 +296,7 @@ module Axlsx when :string #parse formula if @value.start_with?('=') - str << 't="str"><f>' << @value.to_s.gsub('=', '') << '</f>' + str << 't="str"><f>' << @value.to_s.sub('=', '') << '</f>' else #parse shared if @ssti |