search

pythonicrubyist / creek

Ruby library for parsing large Excel files.
http://rubygems.org/gems/creek
MIT License
386 stars 109 forks source link

Load data is 0 when column content is result of sum in excel #89

Closed jaywangactive closed 4 years ago

jaywangactive commented 4 years ago

Screen Shot 2020-01-14 at 09 32 26

pythonicrubyist commented 4 years ago

Creek is not capable of handling formulas.

dannypurcell commented 1 year ago

This should really be noted on the readme. And it's kind of a major bug. Even if Creek is not doing anything with the formula, calculation-wise, it should not be altering the cell data.

As it is, this bug is converting formula cells with =HYPERLINK('https://some/link/or/other') into number types with 0 as the content.

Until this is fixed, and we're sure it's not altering any other types of cell data, Creek is unfortunately not usable for any actual data work.

Created issue https://github.com/pythonicrubyist/creek/issues/116 to look at this one again.