Obviously Formula support is the single most wanted feature for Ruby-Spreadsheet. This will come, we just do not know when. In the meantime we fixed two bugs:
check it out at: http://scm.ywesee.com/?p=spreadsheet/.git;a=summary
The Ruby Spreadsheet Gem is not acting as expected with the formula of cell A2 in: http://www.kangarooit.com/test/test_input.xls When copying this formula into another spreadsheet (and writing that spreadsheet to disk using the ruby Spreadsheet API), the resultant spreadsheet (test_output.xls) shows ‘#REF!’ in mac excel and ‘#NAME?’ in openoffice for cell A2 instead of ‘365’ How can this script be modified so that the resultant spreadsheet ‘test_output.xls’ has ‘365’ visible in cell A2 when opened in a spreadsheet program (eg. excel, open office)?? To test this behavior, copy this script into a file called ‘spreadsheet_spec.rb’ & run: > spec spreadsheet_spec.rb
The Ruby Spreadsheet 