bad performance on google spreadsheets writes

[Mauricio Garavaglia]

Hi Guys

I'm trying to write about 500 rows in a google spreadsheet but it's taking forever (O(n) taking ~1sec per row). I'm using the set(row,col,value,sheet=nil) method as shown on roo.rubyforge.

I think the problem is in the Roo::Google#add_to_cell_roo method (called from set_value), as it is calling save on the worksheet. This triggers a roundtrip to google to update the whole sheet. Is there a reason to write the spreadsheet after setting each value? If this is a bug it would be nice to have a save method exposed to control when to write to google.  

Thanks!

Mauricio