I’ve found that Cell.setNumber() method designing to change a cell format. But it really didn’t work. I write a method to recognize if cell value is Integer or Double. In case of Integer I set:
Style style = asposeCell.getStyle();
style.setNumber( 1 );
asposeCell.setStyle( style );
and if the value with floating point:
style.setNumber( 2 );
The result excel file still has a small green rectangle and excel suggest to convert cell value to a number. What I did wrong?
Thank you for reply. It helped me.