Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

In this tutorial ExcelTemplate is being used to populate data in a template set up with styles and formats. This part of the tutorial uses formulas and persists Excel styles.

Setting Up the Template

Warning

There is a unnecessary amount of coverage for setting up formulas. This was already covered in the Simple Expense Summary. The customer should be able to have a template that already has the data (starting template). They should just need to add number formats, conditional formatting, and styles.

Data Sheets

This sub-report makes use of a data sheet. This is where the data markers will go. It should look something like this:

...