search

roo-rb / roo

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

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

Open simofou opened 5 months ago

simofou commented 5 months ago

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]