extrame / xls

Pure Golang xls library
Apache License 2.0
329 stars 207 forks source link

数值读取错误 #54

Closed flyin9 closed 5 years ago

flyin9 commented 5 years ago

读取-3244847.30 会变成 7492570.94

-1184955 -> 1072556869 -1487365 -> 1072254459

sergeilem commented 5 years ago

Hello @flyin9. Can you attach your xls file? We will try to reproduce and fix problem. Also you can try this fork: https://github.com/sergeilem/xls.

flyin9 commented 5 years ago

Hello @flyin9. Can you attach your xls file? We will try to reproduce and fix problem. Also you can try this fork: https://github.com/sergeilem/xls.

test.xls.zip

thanks for your reply,fork: https://github.com/sergeilem/xls has the same issue

flyin9 commented 5 years ago

Hello @flyin9. Can you attach your xls file? We will try to reproduce and fix problem. Also you can try this fork: https://github.com/sergeilem/xls.

test.xls.zip

thanks for your reply,fork: https://github.com/sergeilem/xls has the same issue

image

将 rk >> 2 改成 int32(rk)>>2 解决问题

sergeilem commented 5 years ago

Yes, i also found problem is here. Nice solution. Pushed to https://github.com/sergeilem/xls.