search

roo-rb / roo

Roo provides an interface to spreadsheets of several sorts.
MIT License
2.78k stars 501 forks source link

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

Closed patrickkulling closed 1 year ago

patrickkulling commented 1 year ago

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