You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Although Creek is not intended to do any calculations or handling of formulas in cells, it is unfortunately corrupting the data in that type of cell as it's being read.
Cells with type Formula and content such as =HYPERLINK('https://some/link/or/other') get turned into number types with 0 as the content.
This makes it unusable even just for copying or merging files.
Expected behavior is just that the type and content of the cells are not changed on reading.
Even if that means the data for formula cells has to be represented as binary data blobs in Ruby, that would be preferable to having the data changed to 0.
Previously mentioned in #89
Although Creek is not intended to do any calculations or handling of formulas in cells, it is unfortunately corrupting the data in that type of cell as it's being read.
Cells with type Formula and content such as
=HYPERLINK('https://some/link/or/other')
get turned into number types with0
as the content.This makes it unusable even just for copying or merging files.
Expected behavior is just that the type and content of the cells are not changed on reading.
Even if that means the data for formula cells has to be represented as binary data blobs in Ruby, that would be preferable to having the data changed to
0
.Example:
Given an input file with content
and reader code
On the second iteration, the value for
row
should bebut actually is
The text was updated successfully, but these errors were encountered: