Insert into an empty template data, set up a formula one cell (code) exported template as shown in figure
Only double click and save the calculation formula is not effective, can only take effect after, how do I solve

CodePudding user response:

Poi generated formula, but was not able to drive the excel to calculate

CodePudding user response:

Need to be written into the file before setting, the content of the imported before to open the Excel, requirements change Excel to recalculate all the formulas in the workbook:
Sheet. SetForceFormulaRecalculation (true); Try

CodePudding user response:

Feel you it feels a bit like putting the cart before the horse, since you are formula, and display the results, it results in your code and the calculated in the input to the corresponding cell, rather than put expression in no?
Report to is a process rather than the result of the calculation, the formula of input make sense?

CodePudding user response:

The hyperlinks formula like me?=the HYPERLINK (" url ", "the View"), use EasyExcel nor shows that any good solution