.
Intro
| Excerpt |
|---|
By using Excel's existing internal calculator, ExcelWriter allows you to make calculations in your report. |
In order to calculate values in some cells of a report, simply format those cells in the template file to have the desired formula..new wording...
Technical overview information.
...
| icon | false |
|---|---|
| title | Requirements |
Then, when the data is bound to the template and the report is open, the cells with formulas in them will be updated.
In this example we have a sample loan calculator. By simply binding the loan amount, annual interest rate, loan period and the start date of the loan, we can create a report with a plan for how to pay off the loan in the given loan period.
| Excerpt |
|---|
This sample requires OfficeWriter Enterprise Edition to be installed because the OfficeWriter Grouping and Nesting is only available in the Enterprise Edition of the product. |
| Note |
|---|
Code
| Code Block |
|---|
Insert code here |
...