Using the configuration sheet – EXFO FastReporter 2 User Manual
Page 304
Generating, Previewing and Printing Reports
294
FastReporter 2
Using Excel Report Templates
Using the Configuration Sheet
The configuration sheet contains three parts.
Flags
Sheet Details
Filter Details
Flags are used to specify to Excel how to handle specific behavior as well
as data display. By default, you have access to two different flag settings,
Apply Thresholds and Cell Merging. These flag settings are visible in the
Configuration sheet. The table below contains details for each flag setting.
Setting
Purpose
Note
Apply Thresholds Apply pass/fail thresholds
from FastReporter 2, that is
change font and
background color used in
the application.
True = will use threshold
from FastReporter 2
False = no threshold
applied. It can use
conditional formatting from
Excel.
Cell Merging
Merges cells with matched
records. For example, if the
FiberID is the same for 3
measurements, they are
merged into a single cell
To improve the
performance, this option is
always to "False" in all the
report templates, except in
the FiberCharacteration
template. This should be set
to "True" when extra
processing is done with
Excel's Pivot table.