willtrnr / pyxlsb

Excel 2007+ Binary Workbook (xlsb) reader for Python
GNU Lesser General Public License v3.0
90 stars 21 forks source link

Wrong parse formula doubles values #47

Closed IdentySergey closed 1 year ago

IdentySergey commented 1 year ago

When loading a xlsb file with formulas, incorrect data is returned when using read_double function. Can you fix it? for example we have 0,645383342 value in excel but in code we have next hex b'h1\x12\xec\xc6\xa7\xe4?' and this value is 0.6454805956614509