roo-rb/roo

Add support for boolean values in open office files exported via Google Sheets

patrickkulling opened this issue · 0 comments

Issue

Generated Open Office .ods files from a Google Sheet does not properly resolve boolean cell value types when using roo.
The generated file entry looks as follows:

<table:table-cell table:style-name="ce2" table:formula="of:=TRUE()" office:value-type="float" office:value="1" calcext:value-type="float">

It would be great if roo would support such an edge case and properly export these values as boolean strings ('true' | 'false') and not as integers.

System configuration

Roo version: 2.9.0

Ruby version: 2.7.0, 3.1.2

Example file

boolean-from-google-sheets.ods