Bug 66515 - Formula not updating after setCellFormula
Summary: Formula not updating after setCellFormula
Status: NEEDINFO
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: unspecified
Hardware: PC Linux
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-03-07 19:49 UTC by Sergejzr
Modified: 2023-03-11 08:01 UTC (History)
0 users


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Sergejzr 2023-03-07 19:49:28 UTC 
This is more a workaround report as a bug report.
In our corporate document I was not able to change a formula particular in a particular cell/column.

saldoCell.setCellFormula("H1"); //this did not work

However it workes after I deleted the formula from cell:

saldoCell.setCellFormula(null);
saldoCell.setCellFormula("H1"); //this worked

I am not expert on Excell, but surely it can be helpful for someone in similar situation. 
If you would like to have a closer look on this issue, I could provide you with the file, but I can not make it public, I guess.
Comment 1 Dominik Stadler 2023-03-11 08:01:51 UTC 
Can you maybe provide a sample document and a unit-test which reproduces the problem? This would make it much easier for others to take a look and see if there is a fix possible.