ruby on rails - OpenDocument Spreadsheet corrupt in Microsoft Excel -
i using gem write opendocument spreadsheet ( rspreadsheet ) once data written let user download it. spreadsheet works fine in openoffice calc , numbers mac. however, when try open spreadsheet in microsoft excel tells me spreadsheet corrupt. happens when write data it. can open via ruby , save , work fine. once write data it, becomes corrupt. i have tried gem ( rubiod ) , able open spreadsheet in excel after excel had 'recover' spreadsheet. in doing removed formulas , formatting. worse in openoffice , numbers although did retain formulas. i need user able download spreadsheet in ever program choose. have no idea why excel says sheet corrupt , have tried wrap head around hours. the spreadsheet saved ods extension , downloaded using mime type of application/x-vnd.oasis.opendocument.spreadsheet , character set of utf-8 examples: original = rspreadsheet.open 'blank.ods' sheet = original.worksheets 1 sheet.a1 = 'foobar' # without this, excel can open sp...