I have a simple spreadsheet which totals three values (I'm using this for testing POI before working on a large spreadsheet).
Using JAVA and POI I change one of the cell values. However, when outputting the total of the three values it remains the same. I save the file as another name and open it in Excel. I then see the total updating after the file is opened
Is there a way to force the spreadsheet to recalculate ( I need to read/write to an excel spreadsheet WITHOUT Excel or any other Microsoft installed on the PC)
Or is there an alternative way to do this without POI?