I am processing an .xlsx using Java and Apache POI. I read a .xlsx row, process the data, store it in an object then do operations on it. Then, I do that to another sheet. I use multiple ways to read the rows, including formula evaluator. For some reason, when I get to the next sheet it recalculates the values of the formulas and I want them to stay the same.

I have tried setting the excel file to read only & copying the xlsx file to a static xlsx file, then reading the new xlsx file. I cannot set the xlsx file to manual as that is not what I want.