GitHub user sawyna opened a pull request:
https://github.com/apache/poi/pull/101
Adding a wrapper to evaluate all xssf formula cells "in cell"
There is `XSSFFormulaEvaluator.evaluateAllFormulaCells` already present.
But that doesn't remove the formulas from the cells. This wrapper loops over
all the cells in all sheets in the workbook, calls `evaluateInCell` which
removes the formulas from the cells containing formulas and puts the result.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sawyna/poi XSSFFormulaEvaluatorUtil
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/poi/pull/101.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #101
----
commit 84af98f6e1aecea57dd9932d2fe83bff774019ec
Author: yaswanth <pyaswanth@...>
Date: 2018-02-13T10:09:07Z
Adding a wrapper to evaluate all xssf formula cells "in cell"
----
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
