How to retrieve formula update cell value in light api aspose cell java
for example:
i want retrieve the result of the formula
if(A1=B1,“true”,“false”)
I want retrieve the result of the formula true or false
When processing workbook with LightCells, cells data may not exist in the memory for cells model, so you may not be able to get the expected result by calculating formula. LightCells is mainly for processing cells one by one in sequence for only one time with high performance(speed and memory cost). To calculate formulas which depend on other cells, you have to use normal mode.