Re: Accuration Bug

[Konstantin Gribov <gr...@gmail.com>]

Hello,

Since it might be Apache POI issue you should ask on
user@poi.apache.org mailing
list. Also you can file a ticket to their bugzilla [1] attaching test file
and expected result.

to -= trademarks@apache.org
to += user@poi.apache.org

[1]: https://bz.apache.org/bugzilla/buglist.cgi?product=POI


ср, 28 сент. 2016 г. в 13:11, Sun, Ricky <He...@fmr.com>:

> Dear Sirs,
>
>
>
> Thank you for your poi jars working on Excel. I’m using it to develop
> project using java.
>
> I got an bug about accurate calculation. The result from java is 0.07 base
> on the formula in Excel, but actually, the result is 0.06 in Excel.
>
> I think the bug can be fixed by using BigDecimal type to calculate formula
> in java.
>
>
>
> Thanks,
>
> Ricky
>
-- 

Best regards,
Konstantin Gribov

Re: Accuration Bug

[Konstantin Gribov <gr...@gmail.com>]

Sorry for duplicate, gmail dropped one significant address when I clicked
reply-all.

ср, 28 сент. 2016 г. в 14:13, Konstantin Gribov <gr...@gmail.com>:

> Hello,
>
> Since it might be Apache POI issue you should ask on user@poi.apache.org mailing
> list. Also you can file a ticket to their bugzilla [1] attaching test file
> and expected result.
>
> to -= trademarks@apache.org
> to += user@poi.apache.org
>
> [1]: https://bz.apache.org/bugzilla/buglist.cgi?product=POI
>
>
> ср, 28 сент. 2016 г. в 13:11, Sun, Ricky <He...@fmr.com>:
>
>> Dear Sirs,
>>
>>
>>
>> Thank you for your poi jars working on Excel. I’m using it to develop
>> project using java.
>>
>> I got an bug about accurate calculation. The result from java is 0.07
>> base on the formula in Excel, but actually, the result is 0.06 in Excel.
>>
>> I think the bug can be fixed by using BigDecimal type to calculate
>> formula in java.
>>
>>
>>
>> Thanks,
>>
>> Ricky
>>
> --
>
> Best regards,
> Konstantin Gribov
>
-- 

Best regards,
Konstantin Gribov