I am using Apache POI to update an existing sheet which has bunch of sheets and formulas in them. All I need to create a new at every data sheet and refresh chart in charts' sheet and save the file.
But I am getting an exception * NotImplementedException: Error evaluating cell COMPdata!AC2* while saving the workbook while at below /XSSFFormulaEvaluator.evaluateAllFormulaCells((XSSFWorkbook) workbook);/ If I comment the above line it saves but the formula in other sheets not getting updates (One sheet values are referred in other sheets using formulas) 1. How do I solve this problem. 2. How can refresh my charts to reflect the newly data row I really appreciate your help. Thanks, YA -- View this message in context: http://apache-poi.1045710.n5.nabble.com/NotImplementedException-Error-evaluating-cell-COMPdata-AC2-tp5710705.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
