Page tree

Versions Compared

Key

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

...

Modifier

Behavior

Additional references

Continue

The continue modifier allows data to be imported onto multiple slides in a presentation. Set DataBindingProperties.MaxRowsPerSlide to limit the number of rows that can be imported on a slide and then use the continue modifier to continue importing the additional rows.

Fitting Data on to Multiple Slides

Image

The image modifier is used to import an image into a presentation. The image modifier has parameters that can control the dimensions and aspect ratio settings of the imported image.

Importing Images

...

The PowerPointTemplate object evaluates several different formulas that can be combined with data markers using the format %%=FORMULA_NAME(DataSource.ColumnName). Each of the formulas will perform a specific operation on the values referenced in the data column. Formulas are evaluated for all values of the column in the data source, regardless of how many of the values are actually displayed in the document.

PowerPointWriter supports the following data marker formulas:

AVERAGE

Calculates the average of the column values

COUNT

Returns the number of values (that is, the number of rows in the data source) of the column

COUNTA

Returns the number of non-null values of the column

MAX

Returns the maximum value from the column

MIN

Returns the minimum value from the column

PRODUCT

Calculates the product of the column values

STDEV

Returns the standard deviation of the column values, treating the values as a sample

STDEVP

Returns the standard deviation of the column values, treating the values as a population

SUM

Calculates the sum of the column values

VAR

Returns the variance of the column values, treating the values as a sample

VARP

Returns the variance of the column values, treating the values as a population