search

zdavatz / spreadsheet

The Ruby Spreadsheet by ywesee GmbH
http://spreadsheet.ch
GNU General Public License v3.0
1.13k stars 240 forks source link

Formula type cells with values containing cross-sheet 'VLOOKUP's return @value of 0.00 #195

Closed dimanyc closed 6 years ago

dimanyc commented 7 years ago

I have a 40-sheet xls file. Header rows are generated using a VLOOKUP reference to a couple of 'master sheets'. When I try to fetch row.value from cell with Spreadsheet::Formula type, I get 0.00 instead of actual formula returns.

MS Excel, Google Speadsheet and OpenOffice Calc all return correct values calculated by the VLOOKUP.

zdavatz commented 7 years ago

Sample Script please with the output file.