setting a formula with DATEVAL results in exception

xzel23 / meja

A library for manipulating and displaying spreadsheet (Excel) and other data in Java

http://xzel23.github.io/meja/

Apache License 2.0

2 stars 0 forks source link

setting a formula with DATEVAL results in exception #13

Closed xzel23 closed 6 years ago

xzel23 commented 6 years ago

DATEVAL is not supported in Apache POI (current version 3.17), thus a NotImplementedException is thrown. Changed setFormula(String) method to catch and log that exception, and flag the workbook as needing recalculation of formluas by calling poiWorkbook.setForceFormulaRecalculation(true).