ozlerhakan/poiji

Issue with Negative numbers

savinaysinha opened this issue · 3 comments

In my excel we have some coulmns that can be negative, but while converting excel into pojo, it assigns 0 instead of negative number:

let say my excel is this :

image

values column contains negative and positive numbers.

this is pojo class
image

and the output I am getting is like this

image

Is there something I am missing out or doing it wrong?

Hi @savinaysinha ,

Thank you bringing this up. I will take a look at this case.

vaa25 commented

@savinaysinha You can use Poiji2. It works with negative numbers properly.

Hi again @savinaysinha ,

I couldn't reproduce this problem with both xls and xlsx excel formats. BTW you should use float not long if you have decimal numbers. Feel free to add you comments If you have still this problem.

all the best