hr.ngs.templater

Interface DocumentFactoryBuilder.SpreadsheetConfigurationBuilder

Enclosing interface:

DocumentFactoryBuilder

public static interface DocumentFactoryBuilder.SpreadsheetConfigurationBuilder

This builder allows for customizing various Spreadsheet specific behaviors, such as formulas and limits.

Method Summary

Modifier and Type	Method and Description
DocumentFactoryBuilder	configure() Finish configuring the Spreadsheet configuration setup.
DocumentFactoryBuilder.SpreadsheetConfigurationBuilder	formulaWarnings(boolean ignore) In some cases Excel will warn about inconsistent formulas.
DocumentFactoryBuilder.SpreadsheetConfigurationBuilder	newSheetsLimit(int maximum) To prevent too large spreadsheets, specify maximum number of new sheets which can be added.
DocumentFactoryBuilder.SpreadsheetConfigurationBuilder	numberAsTextWarnings(boolean ignore) When text can be interpreted as numbers Excel will warn about number being displayed as text.

Method Detail

formulaWarnings

DocumentFactoryBuilder.SpreadsheetConfigurationBuilder formulaWarnings(boolean ignore)

In some cases Excel will warn about inconsistent formulas. While this setting can be set inside Office application, this configuration allows to disable such features on created spreadsheets.

By default formula warnings are not ignored and Excel will report suspicious ones.

Parameters:

ignore - ignore formulas on all changed sheets

Returns:

itself

numberAsTextWarnings

DocumentFactoryBuilder.SpreadsheetConfigurationBuilder numberAsTextWarnings(boolean ignore)

When text can be interpreted as numbers Excel will warn about number being displayed as text. While this setting can be set inside Office application, this configuration allows to disable such features on created spreadsheets.

By default numbers as text warnings are not ignored and Excel will report them.

Parameters:

ignore - ignore text on all changed sheets

Returns:

itself

newSheetsLimit

DocumentFactoryBuilder.SpreadsheetConfigurationBuilder newSheetsLimit(int maximum)

To prevent too large spreadsheets, specify maximum number of new sheets which can be added.

Sheets can be added through whole sheet resizing or whole workbook cloning.

By default sheet limits are not enabled.

Parameters:

maximum - maximum number of newly created sheets

Returns:

itself

configure

DocumentFactoryBuilder configure()

Finish configuring the Spreadsheet configuration setup.

Returns:

continue with document builder