Imagine I have the cell A1 and A2. A1 contains a numeric value and A2 contains the formula "A1+10"
In the template A1 is blank which causes A2 to have the value "10". Then in apache poi I write the number "5" to A1 but sadly A2 does't update. I can force it to update by doing: cell.setCellFormula(cell.getCellFormula()); After looking through the code I think it's this line that does the trick: if(_cell.isSetV()) _cell.unsetV(); Can this clearing of pre calculated values be done automatically on all cels that references A1? Or if this is not possible is there a prettier solution than "refreshing" the formula? I'm using Apache POI 3.9 and I'm writing to an XLSX file. Regards Nicklas
