ruby on rails - AXLSX formula for date shows only number signs -

i trying work on spreadsheet in-house application. far going pretty well. while, not worst thing can happen, since can fixed clicking on cell , pressing enter, annoying me.

i using axlsx gem on ruby-on-rails 3.2.13.

my format code is:

date_cell = s.add_style :format_code=>"mm/dd/yy", :bg_color=>"ffffcc" 

my cell has, in array, formula:

"=e#{row.to_s}+g#{row.to_s}*30" 

i've tried adding formula_values, no avail:

 :formula_values=>["05/01/12","05/01/12",...] # same 

i've done following:

• checked make sure format being applied specific cell
• made sure formula_values filled output log file

i'm not sure if missing step or what. appreciated.

without wrapping, when cell not wide enough content spills on (if text) or fills hash signs (if numeric) – or widens suit. seems if column width has been adjusted automatic widening not repeat. anyway, column width problem , understand solved sheet.column_widths *args - all’s ends well.