Enum LlExportOption

Namespace

combit.Reporting

Assembly

combit.ListLabel31.CrossPlatform.dll

Specifies options for export configurations. The syntax typically combines the export format with the particular option, where general options start with "Export".

public enum LlExportOption

Fields

ExportFile = 0

Specifies the file to be exported.

ExportInfinitePage = 19

Enables export with an infinite page.

Possible Values: 0 = Pages will be exported in with Pagebreaks depending on thier Page Size, 1 = The Exported Page will have infinite height (so much as needed)

ExportOnlyTableData = 17

Exports only table data. Defaults to 0, so export with full formatting.

Possible Values: 0 = Export all Objects with full formatting , 1 = Only Export Table cell content. No other formatting excep Bold and Italic Font properties

ExportPath = 1

Specifies the path where the export should be saved.

ExportQuiet = 3

Enables quiet mode during export.

ExportShowResult = 4

Indicates whether to show the export result.

ExportTarget = 2

Specifies the export target.

PdfAuthor = 8

Sets the author for PDF export.

PdfCreator = 9

Sets the creator for PDF export.

PdfKeywords = 7

Sets the keywords for PDF export.

PdfSubject = 6

Sets the subject for PDF export.

PdfTitle = 5

Sets the title for PDF export.

Resolution = 10

Specifies the export resolution.

TxtCharset = 11

Specifies the charset for text export.

TxtFrameChar = 12

Specifies the frame character for text export.

TxtSeparatorChar = 13

Specifies the separator character for text export.

XlsAllPagesOneSheet = 16

Exports all pages into one sheet in XLS. Default is 1, so all pages will be exported on one sheet.

Possible Values: 0 = Every page is rendered on thier own sheet, 1 = All Pages will be rendered on one sheet

XlsAutoFit = 26

Enables auto-fit in XLS export. Default is 0, so column widths will be the default width of spreadsheets.

Possible Values; 0 = Columns have the default width of spreadsheets, 1 = Column width depends on the space the longest text in the colum needs to be shown without any cuts

XlsAutoFormula = 25

Enables auto-formula generation in XLS export. Default is 0, so all texts will be exported normally without being converted to formulas.

Possible Values: 0 = Export everything normally, 1 = Convert all texts starting with "=" to a formula

XlsConvertNumeric = 24

Converts numeric values during XLS export.

Possible Values; 0 = Export everything as text, 1 = Check text with heuristic if they are numbers and show them with the number of decimals as declared in the project settings, 3 = Take format from Format option. If none is set, save them depending on the number heuristic

XlsFontScalingPercentage = 18

Specifies the font scaling percentage for XLS export.

Multiplies the Font by this factor. Default is 0.95

XlsFooterContent = 29

Specifies the footer content for XLS export.

Declares the Content of the Footer. Max. 255 characters

XlsFooterMargin = 30

Specifies the footer margin for XLS export.

The margin of the Footer from the bottom in inches. Max: 5.7

XlsHeaderContent = 27

Specifies the header content for XLS export.

Declares the Content of the Header. Max. 255 characters.

XlsHeaderMargin = 28

Specifies the header margin for XLS export.

The margin of the Header from the top in inches. Max: 5.7

XlsIgnoreGroupLines = 14

Ignores group lines in XLS export. Default is is 1, so group header and footer will not be exported.

Possible Values: 0 = GroupHeader and GroupFooter will be exported, 1 = GroupHeader and GroupFooter will not be exported

XlsIgnoreHeaderFooterLines = 15

Ignores header and footer lines in XLS export.

Possible Values: 0 = Header and Footer will all be exported, 1 = Header and Footer will not be exported, 2 = Only the first Occurance of Header and Footer will be exported

XlsIgnoreLineWrapForDataOnlyExport = 21

Ignores line wrap for data-only export in XLS. Default is 0, so line breaks will be exported as they are.

Possible Values: 0 = Export linebreaks, 1 = LineBreaks will be replaced with whitespaces

XlsPrintingZoom = 20

Specifies the printing zoom level for XLS export.

Multiplies the Printing Zoom by this factor. Default is 0.95

XlsProtectionProtectSheets = 31

Protects sheets in XLS export. Default is 0, so no protection will be applied.

Possible Values: 0 = No protection, 1 = All Cells on all tables are protected

XlsProtectionProtectSheetsMode = 33

Specifies the protection mode for sheets in XLS export.

This is kind of a bitmask. The value is a number. The number you want is a addition of the numbers that fit what you want: 0 = Allow no actions, 1 = Don't allow Objects edit, 2 = Dont allow scenario edit, 4 = Allow formating of cells, 8 = Allow formating of columns, 16 = Allow formating of rows, 32= Allow adding columns, 64 = Allow adding rows, 128 = Allow adding Hyperlinks, 256 = Allow deleting columns, 512 = Allow deleting rows, 1024 = Non editable Cells can not be selected, 2048, = Allow sorting, 4096 = Allow filtering, 8192 = Allow using pivot tables 16384 = Editable Cells can not be selected

XlsProtectionProtectSheetsPassword = 32

Specifies the password for protecting sheets in XLS export.

This specifies the password for the protection of the sheets. Only used when XlsProtectionProtectSheets is set to 1

XlsShowGridlines = 23

Shows gridlines in XLS export. Default is showing.

Possible Values; 0 = Don't show Gridlines, 1 = Show Gridlines

XlsWorksheetName = 22

Specifies the worksheet name for XLS export.

This specifies the Name of the exported Worksheet. Default is "Table: %d" (%d is replaced with the sheet number)