Using autofilter and "D1" as worksheet name generates exception

[drsound]

Using "D1" or any uppercase letter followed by a number together with autofilter generates an exception. Lowercase initial letter is instead ok. Try this simple test code:

require 'rubygems'
require 'writeexcel'
workbook = WriteExcel.new(open('test.xls', 'w'))
worksheet = workbook.add_worksheet('D1')
worksheet.autofilter(0, 0, 0, 10)
workbook.close

I get:

Racc::ParseError:
parse error on value "!" (error)
from /home/drsound/.rvm/rubies/ruby-1.8.7-p352/lib/ruby/1.8/racc/parser.rb:350:in on_error' from /home/drsound/.rvm/rubies/ruby-1.8.7-p352/lib/ruby/1.8/racc/parser.rb:99:in_racc_do_parse_c'
from /home/drsound/.rvm/rubies/ruby-1.8.7-p352/lib/ruby/1.8/racc/parser.rb:99:in __send__' from /home/drsound/.rvm/rubies/ruby-1.8.7-p352/lib/ruby/1.8/racc/parser.rb:99:in do_parse'
from /home/drsound/.rvm/gems/ruby-1.8.7-p352/gems/writeexcel-0.6.8/lib/writeexcel/formula.rb:206:inparse' from /home/drsound/.rvm/gems/ruby-1.8.7-p352/gems/writeexcel-0.6.8/lib/writeexcel/formula.rb:40:in parse_formula'
from /home/drsound/.rvm/gems/ruby-1.8.7-p352/gems/writeexcel-0.6.8/lib/writeexcel/worksheet.rb:2952:instore_formula' from /home/drsound/.rvm/gems/ruby-1.8.7-p352/gems/writeexcel-0.6.8/lib/writeexcel/worksheet.rb:7237:in store_filters'
from /home/drsound/.rvm/gems/ruby-1.8.7-p352/gems/writeexcel-0.6.8/lib/writeexcel/worksheet.rb:264:inclose' from /home/drsound/.rvm/gems/ruby-1.8.7-p352/gems/writeexcel-0.6.8/lib/writeexcel/workbook.rb:1284:in calc_sheet_offsets'
from /home/drsound/.rvm/gems/ruby-1.8.7-p352/gems/writeexcel-0.6.8/lib/writeexcel/workbook.rb:1282:ineach' from /home/drsound/.rvm/gems/ruby-1.8.7-p352/gems/writeexcel-0.6.8/lib/writeexcel/workbook.rb:1282:in calc_sheet_offsets'
from /home/drsound/.rvm/gems/ruby-1.8.7-p352/gems/writeexcel-0.6.8/lib/writeexcel/workbook.rb:1143:instore_workbook' from /home/drsound/.rvm/gems/ruby-1.8.7-p352/gems/writeexcel-0.6.8/lib/writeexcel/workbook.rb:152:in close'
from (irb):136

[cxn03651]

Thanks.
Bug fixed. New gem v0.6.9 has been released.
Please try.

cxn03651

[drsound]

You were fast! :-) Now it works perfectly! Thanks for all of your effort in writeexcel!