With Excel sheets, cells with "0%" are converted to 'N/A' in the csv file.

[simofou]

Issue

Using Excel data with a percentage column. When converting to a CSV, all the values are properly casted as Floats such that '5.12%' becomes 0.0512. However, if the value in the cell is '0.0%' the value persisted in the CSV file is 'N/A'. It should just be 0.

Thanks,
simo

System configuration

Roo version: 'roo', '>= 2.8', '< 2.9'

Ruby version: ruby 2.6.10p210 (2022-04-12 revision 67958) [arm64-darwin23]