I am trying to set a formula to the cell and then trying to change the display format of the data, but i am not able to get the expected result.
Please find the code below:
Setting the foemula to the cell
cell.getRow(i).getCell(element).setFormula("="+ cell.getRow(i).getCell(element).getValue() + "/" + 1000);
Setting the display style of the data to the cell.
Style style = cell.getRow(i).getCell(element).getStyle();
Value in the cell: 4104644615,95/1000
Value in the cell after excel generation is: 4 1 04 645
Expected Formatted Data based on the style: 4 104 644,61 (Thousand seperated with spacs and after decimal only two digits)
When i try to get the format of the cell in the Excel, the format which i got is "#\ ## #00\ ", but the format which i have given is "# ###,00".
Please Suggest me the solution,