Hi,
“-0” is actually calculated as “-0.30” in excel, as it’s decimal places setting is Zero, it is showing “0” in excel. If I perform getValue() operation on this cell I get “-0.3” and if I perform getStringValue() operation on this cell I get “-0”. But on the screen I want to display “0” instead of “-0”. Please let me know what can be done. I have attached a sample simulation application.
The above issue is not completely fixed. I have attached a couple of test cases along with reference template. Please read my comments in the attached Java code for information on the test case.
Can you please fix this?
Thanks! Shashi
Note: Looking at the current behavior, I guess you are using the java DecimalFormatter to format the values which does not behave like Excel does.