Roo set method doesn't works for ODS file. anyway to set the value in ODS file? about roo

[SP8890]

Hi please find the details,

require 'roo'
xls = Roo::Spreadsheet.open('spreadsheet_test.ods') do
sheet = xls.sheet(0)
puts sheet.cell(1, 1)
sheet.set(3, 3, "test")
end

2. Roo version : 2.8.3
3. Ruby version : 2.5.3

(Tried with ruby version - Ruby 2.7.1 which isn't works as well)

4. MIMP : The test is not failing , but it is nothing writing in the cell of the spreadsheet.

I am attaching the spreadsheet please find.

5. 0> xls.officeversion
   => "1.2"

please let me know further. Thanks

[patrickkulling]

Hey @SP8890
roo is not design to write to sheets but purely parse and read the entries.

There are other libraries that do support writing sheets with some support but as far as I understand this is not planned for roo in the near future.