combit List & Label 30 - .NET Help
combit.Reporting Namespace / LlExportOption Enumeration


LlExportOption Enumeration
Enumeration of available export options.
Syntax
'Declaration
 
Public Enum LlExportOption 
   Inherits System.Enum
 
Members
MemberDescription
DocxAllPagesOneFile

Enables creation of a separate Word document for each page.

Value

Meaning

0

A separate Word document is create per page.

1

All pages are created in the same Word document.

Default

1

DocxAuthor

Sets the Author property in the Word file. Default: empty.

DocxCellScalingPercentageHeight

Scaling factor (with decimal places) to correct the cell heights. Default: 100 (=100% cell height).

DocxCellScalingPercentageWidth

Scaling factor (with decimal places) to correct the cell widths. Default: 100 (=100% cell width).

DocxFloatingTableMode

Enables if tables will be linked. For a larger amount of pages with tables this option should be set to '0', because Microsoft Office Word can only link up to 86 (depending on the Word version) tables.

Value

Meaning

0

Table won't be linked.

1

Tables will be linked.

Default

1

DocxFontScalingPercentage

Scaling factor to correct font sizes. Default: 100 (=100% font size).

DocxKeywords

Sets the Tags property in the Word file. Default: empty.

DocxSubject

Sets the Subject property in the Word file. Default: empty.

DocxTitle

Sets the Title property in the Word file. Default: empty.

ExportAllInOneFile

Configures the export result format.

Value

Meaning

0

Every printed page will be exported in a single HTML file.

1

The result is a single HTML file (Export.File), containing all printed pages.

Default

1

ExportFile

File name of the first HTML page. Default: "index.htm". You may also use printf format strings like "%08d" in the file name (ex. "Export Page %d.htm"). In this case, the files for the pages will be named by replacing the placeholder with the correctly formatted page number. Otherwise, you will get a simple page numbering for the result files.

ExportInfinitePage

This "endlessly" increases the size of the page output, you get an export that is not divided by breaks (unless you work with "Pagebreak Before", then the page will still be wrapped there).

Value

Meaning

0

Single pages.

1

Endless page.

Default

1

ExportMailAttachmentList

Additional attachments (besides the export results) as tab-separated list ("\t", ASCII code 9).

ExportMailBcc

This address will receive a blind carbon copy. Multiple recipients can be separated by semicolons.

ExportMailBody

Mail body text.

ExportMailCc

This address will receive a carbon copy. Multiple recipients can be separated by semicolons.

ExportMailFrom

Specifies the sender of the email.

ExportMailGraphAuthType

Determines the authentication type (required).

Value

Meaning

0

Interactive

Based on all other parameters, a (user)specific token is generated with user interaction. The user needs appropriate rights to send mails.

1

Service

Based on ExportMailGraphSecretClientKeyId and ExportMailGraphSecretClientKeyValue and the other parameters, an (app)specific token is generated without user interaction. The app needs appropriate permissions to send mails on behalf of other users.

2

Userpassword

Based on ExportMailGraphUserName and ExportMailGraphUserPassword and the other parameters, a token is generated without user interaction. The user needs appropriate rights to send mails.

3

Token

The externally generated ExportMailGraphBearerToken passed here is used. The token must contain the rights necessary for sending.

Default

3 (Token)

 

ExportMailGraphBearerToken

The externally generated BearerToken is required for ExportMailGraphAuthType (3 = Token) (optional).

ExportMailGraphClientId

The application ID assigned in Azure AD (required).

ExportMailGraphRedirectUri

A redirection URI configured for the app is required (optional).

Default: http://localhost

ExportMailGraphScope

The access rights to be requested are required (optional).

Default: https://graph.microsoft.com/.default

ExportMailGraphSecretClientKeyId

This ID is only needed for ExportMailGraphAuthType (1 = Service) (optional).

ExportMailGraphSecretClientKeyValue

his value matching the ExportMailGraphSecretClientKeyId is only required for ExportMailGraphAuthType (1 = Service) (optional).

ExportMailGraphTenantId

The directory id assigned to the application (required).

ExportMailGraphUserName

The user name is required for ExportMailGraphAuthType (0 = Interactive and 2 = Userpassword) (optional).

ExportMailGraphUserObjectId

This Id can be used for ExportMailGraphAuthType (0 = Interactive) as an alternative to ExportMailGraphUserName (optional).

ExportMailGraphUserPassword

The password to ExportMailGraphUserName is required for ExportMailGraphAuthType (2 = Userpassword) (optional).

ExportMailHtmlBody

Mail body text in HTML format (SMTP and XMAPI only!). Optional, otherwise the eMail will be sent with the text defined in ExportMailBody.

ExportMailPop3ProxyAddress

Proxy server address.

ExportMailPop3ProxyPassword

Proxy server password.

ExportMailPop3ProxyPort

Proxy server port, default 1080.

ExportMailPop3ProxyUser

Proxy server user name.

ExportMailPop3SenderDomain

Login domain, default: current name of the computer.

ExportMailPop3ServerAddress

URL/IP address of POP3 server, default: "localhost".

ExportMailPop3ServerPassword

Password for authentication.

ExportMailPop3ServerPort

Default: 110.

ExportMailPop3ServerUser

User for authentication.

ExportMailPop3SocketTimeout

Timeout for socket connection in milliseconds, default: 10,000 ms.

ExportMailProvider

This option can be used to switch the mail provider. All options apart from MSMAPI need the cmmx0?.dll.

Value

Description

SMAPI

Simple MAPI

XMAPI

Extended MAPI

SMTP

SMTP

MSMAPI

System MAPI (using the default MAPI client)

GRAPH

Microsoft Graph API, e.g. for the Office365 Cloud

Hint: Requires optional modules. Please refer to the file Redist.txt in your List & Label installation directory.

Default

The default value depends on the system's or application's settings (see below)

If the DLL cannot be found, the mail will be sent using system Simple MAPI (MSMAPI).

The provider is selected by either setting it explicitly using this option or letting the user choose in the LsMailConfigurationDialog().

List & Label first of all tries to retrieve the application-specific mail settings from the registry. These can be set using LsMailConfigurationDialog. If your application wants to support sending report results by email then you should provide the end-user a menu-item (or similiar) in which's handler you call LsMailConfigurationDialog to enable the end-user to specify the mail settings. Note: Please set both export options "Export.Mail.@Configuration.User" and "Export.Mail.@Configuration.Computer" with the help of LlXSetParameter to the identical value with which you called LsMailConfigurationDialog to save the settings for mail sending individually in the registry.

ExportMailSecureConnection

Connection security.


Value


Meaning


-1


Automatic (use TLS when server supports it)


0


Turn TLS off (even when it is supported by the server)


1


Force SSL (Cancellation when server does not support SSL)


2


Force TLS (Cancellation when server does not support TLS)


Default


-1


ExportMailSendResultAs

Allows the result of an HTML export to be sent directly as HTML mail text.

Value

Meaning

text/html

If SMTP or XMAPI is chosen as mail provider, the export result is used as HTML content of the mail. All other mail providers will ignore this option.

Empty

The HTML result is sent as attachment.

Default

Empty

Especially when sending via SMTP there are more options available. Usually these do not need to be set explicitly, but can be selected by the user in an application-specific dialog using LsMailConfigurationDialog.

ExportMailShowDialog

Selection for sending the mail without any further user interaction.

Value

Meaning

0:

The mail is sent directly without any further user interaction (at least 1 TO recipient must be given)

1:

The standard "Send mail" dialog is displayed. The values passed are preset there.

Default:

0

ExportMailSignatureNameThe name of an Outlook signature or the path and file name (without file name extension!) of a signature file. Depending on body text type, the file name extension txt, rtf or htm will be appended.
ExportMailSmtpOAuth2BearerToken

Authentication token if the SMTP server supports authentication via OAuth2.

ExportMailSmtpPassword

SMTP server password (if necessary).

ExportMailSmtpPopBeforeSmtp

Some SMTP server need a login via POP before SMTP connection (0=no POP connection will be established, 1= POP connection will be established)

ExportMailSmtpProxyAddress

Proxy IP address or URL.

ExportMailSmtpProxyPassword

Proxy password (only Socks5).

ExportMailSmtpProxyPort

Proxy port.

ExportMailSmtpProxyType

Proxy type (0=none, 1=Socks4, 2=Socks5).

ExportMailSmtpProxyUser

Proxy user name (only Socks5).

ExportMailSmtpReplyTo

Reply to address (optional).

ExportMailSmtpSenderAddress

Mail sender's address (ex. xyz@abc.def) – is also used for the SMTP protocol.

ExportMailSmtpSenderName

Real sender's name.

ExportMailSmtpServerAddress

SMTP server IP address or URL.

ExportMailSmtpServerPasswordSMTP server password (if necessary).
ExportMailSmtpServerPort

SMTP server port.

ExportMailSmtpServerTimeOut

Socket timeout, in milliseconds.

ExportMailSmtpServerUser

SMTP server user name (if necessary).

ExportMailSmtpUser

SMTP server user name (if necessary).

ExportMailSubject

Email subject.

ExportMailTo

Recipient address. Multiple recipients can be separated by semicolons.

ExportMailXmapiDeleteAfterSend

Defines, if the eMail after sending should be deleted.

Value Description
0 Mail will not be deleted after sending.
1 Mail will be deleted after sending.

 

ExportMailXmapiServerPassword

Password for authentication.

ExportMailXmapiServerUser

Profile name for authentication.

ExportMailXmapiSuppressLogonFailure

Defines, if a dialog should be displayed for login error.

Value Description
0 No dialog will be displayed.
1 Dialog will be displayed.

 

ExportOnlyTableData

Only data from table lines will be exported.

Value

Meaning

0:

All objects are exported.

1:

Only table cells and their data are exported.

Default:

0

ExportPath

Path where the exported files should be saved. If this option is empty, a file selection dialog will always be displayed.

ExportQuiet

Use this option to configure the possibility of exporting without user interaction.

Value

Meaning

0:

Export with user interaction (dialogs)

1:

No dialogs or message boxes will be displayed (only if Export.Path was specified).

Default:

0

ExportSaveAsZip

Activates the compression of exported data. If this option is set, the ZIP-Filter will be selected in the dialog.

Value

Meaning

0

Compression is not performed

1

The export data will be compressed into a ZIP archive

Default

0

Please note, that the user can modify the default settings via the dialog. If this is to be inhibited, set the option "Export.Quiet" to "1".

ExportSaveAsZipAvailable

Here you can hide the ZIP archive filter within the file select dialog.

Value

Meaning

0

Filter hidden

1

User selection possible

Default

1

ExportSendAsMail

Activates sending of export files via email. This option corresponds to the checkbox "Send exported files by email" for the end user.

Value

Meaning

1:

The exported files are sent via the specified provider (see below)

Default:

0

ExportSendAsMailAvailable

Enables you to hide the respective checkbox in the dialog.

Value

Meaning

0:

Checkbox will be hidden

1:

Checkbox will be available

Default:

1

ExportShowResult

Specifies whether the export result will be displayed automatically. The program that displays the result will be determined by the registered file extension.

Value

Meaning

0:

Result will not be displayed automatically

1:

Calls ShellExecute() with Export.File.

Default:

0

ExportShowResultAvailable

Enables you to hide the respective checkbox in the dialog.

Value

Meaning

0

Checkbox will be hidden

1

Checkbox will be available

Default:

1

ExportSignatureFormat

Can be used to choose the signature format. The available values depend on the file type and signature software.

Value

Meaning

pk7

Signature in pk7 format (container format that contains the signed file and signature). Available for Multi-TIFF, TXT and PDF (the latter only for SignCubes). The resulting file has the extension "pk7".

p7s

Signature in p7s format. An additional file *.p7s is created during the export process. Available for Multi-TIFF, TXT and PDF (the latter only for SignCubes). If the export result is sent via email, both files are attached.

p7m

Signature in p7m format (container format that contains the signed file and signature). Available for Multi-TIFF, TXT and PDF (the latter only for SignCubes). The resulting file has the extension "p7m".

PDF

PDF signature. Available for PDF and Multi-TIFF (only for digiSeal® office and B/W-Tiffs). A Multi-TIFF is converted to a PDF and signed with a special Barcode that allows verifying the signed document even after printing the PDF.

Default

p7s for TXT and Multi-TIFF, PDF for PDF

ExportSignatureProvider

Allows selection of the software to be used if more than one of the supported products are installed.

Value Meaning
0 Default, no explicit choice of signature software
1 Sign using secrypt digiSeal® office
2 Sign using OPENLiMiT® SignCubes software (not supported anymore)
3 Sign using esiCAPI® V 1.1 (not supported anymore)
4 Sign using secrypt digiSeal® server 2
Default 0

ExportSignatureProviderOption

Additional options for the signature provider selected by ExportSignatureProvider.

Options for the "esiCAPI" provider:

Allows to select the used connector to use. Information on the diverse selectors is available from e.siqia.

Value

Meaning

0

Default, i.e. the first available connector is used

1

Sign using SignLive! CC® 4.1.2

2

Sign using SecSigner® 3.5.X

Default

0

 

Options for the signature provider "digiSeal® server 2":

This option has only one value and contains the connection data for digiSeal® server 2. The single values are separated with a pipe character each. The following structure applies:

<ServerHost>:<ServerPort>|<File path to the software certificate for identification and authentication >|<Password for the software certificate>

Example:

localhost:2001|secrypt_Testcertificate_D-TRUST_test.pfx|test

ExportSignResult

Activates the signature of export files. This option corresponds to the checkbox in the export target dialog. The value is disregarded if no supported signature software is found on the machine.

Value

Meaning

0

No digital signature

1

Exported files will be signed digitally

Default

1

ExportSignResultAvailable

Can be used to suppress the checkbox for digital signature in the export target dialog.

Value

Meaning

0

Hide checkbox

1

Show checkbox

Default

1

ExportTarget

Returns the default export destination (for example "RTF", "HTML", "PDF", etc.) to be used (or shown in the print dialog).

ExportZipFile

(Default-)Name of the ZIP file to be created e.g. "export.zip". For the file names in the ZIP archive the following rules apply:

  • if "Export.File" is not assigned, the name of the ZIP archive is used with a corresponding file extension (e.g. "export.htm")
  • if "Export.File" is assigned, this will then be used. If an export format generates one file per page, the placeholder "%d" can be used for the page number e.g. "Invoice Page %d.bmp" for the bitmap exporter
ExportZipPath

Path of the created ZIP files.

HtmlFormFooter

This option defines a certain HTML form tag indicating the end of the form. Default: "</form>".

HtmlFormHeader

Defines a certain HTML form tag such as "<form method="POST" action=...". If this option has been specified, all object names are analyzed with regard to special tags used for the form extension (see chapter ‘HTML form creation'). Default: Empty, no form creation.

HtmlTitle

Specifies the title of the generated HTML document. Default: Title used with LlPrintWithBoxStart().

LayouterFixedPageHeight

Configures whether all pages should be forced to have the same page height.

Value

Meaning

0

Layout can shrink on the last page (e.g. if no objects have been placed in the page footer)

1

The page height is set as configured

Default

1

LayouterPercentaged

This option configures whether the layout should be defined in absolute values or with values expressed as percentage.

Value

Meaning

0

Layout of the X coordinates in absolute values (pixel)

1

Layout of the X coordinates with values expressed as percentage

Default:

0

PdfAuthor

Specifies the author of the generated PDF document. Default: empty.

PdfConformance

If this parameter is set, the PDF version to be used can be defined. If encryption is activated (see PdfEncryptionEncryptFile) the encryption strength will be automatically selected. Various options are available, which are explained below.

Value

Meaning

pdf14

PDF version 1.4 (corresponds to Acrobat 5)

pdf15

PDF version 1.5

pdf16

PDF version 1.6 (corresponds to Acrobat 7)

pdf17

PDF version 1.7 (ISO 32000-1)

pdf20

PDF version 2.0 (ISO 32000-2)

pdfa1b

PDF/A-1b (ISO 19005-1, Level B compliance)

pdfa1a

PDF/A-1a (ISO 19005-1, Level A compliance)

pdfa2b

PDF/A-2b (ISO 19005-2, Level B compliance)

pdfa2u

PDF/A-2u (ISO 19005-2, Level U compliance)

pdfa2a

PDF/A-2a (ISO 19005-2, Level A compliance)

pdfa3b

PDF/A-3b (ISO 19005-3, Level B compliance)

pdfa3u

PDF/A-3u (ISO 19005-3, Level U compliance)

pdfa3a

PDF/A-3a (ISO 19005-3, Level A compliance)

Default

pdf17

 

PdfCreator

Specifies the creator of the generated PDF document. Default: empty.

PdfEncryptionEnableAnnotating

If this parameter is set, comments can be used/inserted in the PDF file despite encryption. Only effective if PdfEncryptionEncryptFile is set to "1".

Value

Meaning

0

Commenting is not possible

1

Commenting is possible

Default

0

Note: Once the option is allowed, filling of form and signature fields (see also PdfEncryptionEnableFillingForms) is also automatically allowed according to the PDF security attributes.

PdfEncryptionEnableChanging

If this parameter is set, the file can be changed even if it is encrypted. Only effective if PDF.Encryption.EncryptFile is set to "1".

Value

Meaning

0

Changing is not enabled

1

Changing is enabled

Default

0

PdfEncryptionEnableCopying

If this parameter is set, the file can be copied to the clipboard even if it is encrypted. Only effective if PDF.Encryption.EncryptFile is set to "1".

Value

Meaning

0

Copying is not enabled

1

Copying is enabled

Default

0

PdfEncryptionEnableFillingForms

If this parameter is set, any form fields and also signature fields can be filled in and used in the PDF file despite encryption. Only effective if PdfEncryptionEncryptFile is set to "1".

Value

Meaning

0

Filling forms and signing is not possible

1

Filling forms and signing is possible

Default

0

PdfEncryptionEnablePrinting

If this parameter is set, the file can be printed even if it is encrypted. Only effective if PDF.Encryption.EncryptFile is set to "1".

Value

Meaning

0

Printing is not enabled

1

Printing is enabled

Default

0

PdfEncryptionEncryptFile

If this parameter is set, the result file is encrypted. The encryption type is automatically determined by the selected PDF version (see PdfConformance). There are several other options available, which are explained below.

Value

Meaning

0

Do not encrypt file

1

Encrypt file

Important notes on encryption of the selected PDF version:

pdf10, pdfa[x]: no encryption

pdf11, pdf12, pdf13: RC4 with a key length of 40

pdf14: RC4 with a key length of 128

pdf15, pdf16, pdf17: AES with a key length of 128

pdf20: AES with a key length of 256

Default

0

PdfExcludedFonts

Determines which fonts should not be embedded. Some fonts (e.g. Arial, Courier) can be identically replaced by PostScript fonts. This option can be used to explicitly exclude individual fonts from embedding - e.g. "Arial;Courier;...". Default: "Arial".

Note: If "*" is specified, no fonts are embedded, only the name of the fonts contained. This activates the Windows font mapping of the used PDF viewer, which then uses the most suitable font in the system for displaying. Thus the file size can usually be kept very small.

PdfFileAttachments

With this parameter, additional files can be added to the PDF container. Pass them as follows:
<MyAdditionalFile1>|<MyAdditionalFileDescription1>;<MyAdditionalFile2>|<MyAdditionalFileDescription2>

PdfKeywords

Specifies the keywords of the generated PDF document. Default: empty.

PdfOwnerPassword

The owner password for the encrypted file. This password is needed to edit the file. If no password is given, a random password will be assigned. We recommend that you always explicitly choose a suitable password.

PdfSubject

Specifies the subject of the generated PDF document. Default: empty.

PdfTitle

Specifies the title of the generated PDF document. Default: title passed to LlPrintWithBoxStart().

PdfUserPassword

The user password for the encrypted file. This password is needed to access the encrypted file. If no password is given, access is possible without a password, but may be limited (see above).

PdfUseSimpleFrames

Specifies that the simple default border lines for tables and objects such as dotted, dashed, dashed-dotted and dashed-dotted-dotted should be drawn more effectively by Windows (different rendering possible). This can lead to higher overall performance and smaller export files when creating reports.

Value

Meaning

1

Simplified drawing of the frame lines deactivated.

0

Simplified drawing of the frame lines activated.

Default

0

 

PdfZUGFeRDConformanceLevel

Set the ZUGFeRD Conformance Level.

Value

Description

BASIC

Simple invoices with structured data. Additional information possible as free text.

EXTENDED

Intersectoral invoice exchange with extended structured data.

COMFORT

Fully automated invoice processing with structured data. Only relevant for ZUGFeRD 1.0. For ZUGFeRD 2.0/2.1 please use "EN 16931".

EN 16931

Fully automated invoice processing with structured data. Only valid for ZUGFeRD 2.0/2.1. Identical with XRechnung 1.0.

BASIC WL

The profile is also included in ZUGFeRD 2.0/2.1 for reasons of consistency between the two standards ZUGFeRD and Factur-X, but in Germany it does not constitute a full invoice within the meaning of the German UStG (VAT Act).

MINIMUM

The profile is also included in ZUGFeRD 2.0/2.1 for reasons of consistency between the two standards ZUGFeRD and Factur-X, but in Germany it does not constitute a full invoice within the meaning of the German UStG (VAT Act).

XRECHNUNG

The profile meets the specific requirements of public administration in Germany. It meets the requirements of the European standard EN16931 and also the national business rules and administrative provisions of the XRechnung standard. Requires ZUGFeRD 2.1.

Default

BASIC

PdfZUGFeRDVersion

Set the ZUGFeRD version.

Value

Description

0 In the specified XML file (see PdfZUGFeRDXmlPath), an attempt is made to automatically determine which ZUGFeRD version and which ZUGFeRD conformance level (see PdfZUGFeRDConformanceLevel) are involved and this is then applied. If the information cannot be determined automatically, the ZUGFeRD version is set to "2.0" and the ZUGFeRD conformance level to "BASIC".

1.0

ZUGFeRD version 1.0 is forced.

2.0

ZUGFeRD version 2.0 is forced.

2.1

Factur-x is forced which corresponds to ZUGFeRD in version 2.1 and also required by the profile XRECHNUNG.

Default

0

PdfZUGFeRDXmlPath

Defines the path to a ZUGFeRD compliant XML file, which should be embedded in the final PDF. The file name must correspond to the ZUGFeRD version set (see PdfZUGFeRDVersion). The XML file must be created before by the application itself.

PictureBitsPerPixel

Specifies the color depth of the generated graphic. The value of 256 colors is normally sufficient for XML. Please note that values such as 24 bit or higher can result in very large graphic files.

Value

Meaning

1:

Monochrome

4:

16 colors

8:

256 colors

24:

24bit True Color

32:

32bit True Color

Default:

8

PictureCropFile

Removes dispensable white frame. Supported export formats: PNG, JPEG and TIFF. This option is not supported when used in services (e.g. IIS) as GDI+ is not available there.

Value

Meaning

0

Image will not be cropped

1

Image will be cropped

Default

0

 

PictureCropFrameWidth

Defines the border of a cropped file in pixel.

PictureJpegEncoding

Specifies how to encode JPEG images

Value

Meaning

0:

Save JPEGS as (external) files

1:

Include pictures MIME encoded into the XML file

2:

Ignore JPEG images

Default:

0

PictureJpegQuality

Specifies the quality and the corresponding compression factor of the generated JPEG graphic. The value lies between 0..100, with 100 representing the highest quality (least compression). Default: 100

PptxAnimation

Defines the used Transition for a slide change.

Value

Meaning

0

No Animation

1

Cut-Animation

2 Fade-Animation
3 Push-Animation
4 Cover-Animation
5 Wipe-Animation

Default

0

 

PptxFontScalingPercentage

Scaling factor to correct font sizes.

Default: 100 (=100% font size)

Resolution

Defines the resolution in dpi for the generation of pictures. Default: 300 dpi.

SvgTitle

Defines the title within the SVG file.

TiffCompressionQuality

Specifies the compression quality for the TIFF export. Default: 75

TiffCompressionType

Specifies the compression type for the TIFF export. Please note that not all viewers support compression. For CCITTRLE, CCITT3 and CCITT4 PictureBitsPerPixel must be set to 1 or to 24 for JPEG.

Value

Meaning

None

No compression

CCITTRLE

CCITT Modified Huffman RLE

CCITT3

CCITT Group 3 Fax encoding

CCITT4

CCITT Group 4 Fax encoding

JPEG

JPEG DCT compression

ZIP

ZIP compression

Default:

None

TtyAdvanceAfterPrint

Specifies the behavior when the print job is finished.

Value

Meaning

FormFeed

Form feed

ToNextLabel

Advances to the next label

AfterNextLabel

Leaves one blank label as separator

TtyDefaultFilename

Default file name for this dialog.

TtyDestination

Export target. Possible values are "LPT1:", "LPT2:",..."FILE:" or "FILE:<Filename>". If "FILE:" is used, a file selection dialog will be displayed.

TtyEmulation

Specifies the emulation used for the export.

Value

Meaning

ESC/P

ESC/P emulation

ESC/P 9Pin

ESC/P emulation for 9-pin dot matrix printers

TxtCharset

Specifies the character set of the result file. If Export.OnlyTableData is set to "0", the target code page needs to be passed in addition (e.g. 932 for Japanese) using LL_OPTION_CODEPAGE.

Value

Meaning

ANSI

Ansi character set

ASCII

Ascii character set

UNICODE

Unicode character set

Default:

ANSI

TxtFrameChar

Specifies the framing character for the columns. Only effective in the data only mode.

Value

Meaning

NONE

No framing

"

" as framing character

‘ as framing character

TxtIgnoreGroupLines

Allows group header and footer lines to be ignored in the resulting text file. Only effective in the data only mode.

Value

Meaning

0

Group lines are exported

1

Group lines are ignored

Default:

1

TxtIgnoreHeaderFooterLines

Allows header and footer lines to be ignored in the resulting text file. Only effective in the data only mode.

Value

Meaning

0

Header and footer lines are exported

1

Header and footer lines are ignored

Default:

1

TxtSeparatorChar

Specifies the separator character. Only effective in the data only mode.

Value

Meaning

NONE

No separator

TAB

Tab as separator

BLANK

Blank as separator

,

, as separator

;

; as separator

UsePosFrame

Switches the text positioning method.

Value

Meaning

0

Text boxes used for positioning

1

Position frames used for positioning

Default

0

VerbosityBarcode

Configures how barcode objects should be exported.

Value

Meaning

0:

Ignore object

1:

Object as picture

Default:

1

VerbosityDrawing

Configures how picture objects should be exported.

Value

Meaning

0:

Ignore object

1:

Object as picture

Default:

1

VerbosityEllipse

Configures how ellipse objects should be exported.

Value

Meaning

0:

Ignore object

1:

Object as picture

2

Object as shape object (e.g. Word 97)

Default:

2

VerbosityLine

Configures how line objects should be exported.

Value

Meaning

0:

Ignore object

1:

Object as picture

2

Object as shape object (e.g. Word 97)

Default:

2

VerbosityLLXObject

Configures how LLX objects (e.g. chart object) should be exported.

Value

Meaning

0

Ignore object

1

Object as JPEG

Default:

1

VerbosityLLXObjectHtmlObject

Configures how the HTML object should be exported.

Value

Meaning

0

Ignore object

1

Object as JPEG

2

Object as embedded HTML. Only the HTML text between the <BODY> and </BODY> tags will be exported. Please note the hint on exporting restrictions.

Default:

2

VerbosityRectangle

Configures how rectangle objects should be exported.

Value

Meaning

0:

Ignore object

1:

Object as frame

Default:

1

VerbosityRtf

Configures how RTF objects should be exported.

Value

Meaning

0:

Ignore object

1:

As formatted RTF text

2:

Object as picture

Default:

1

VerbosityRtfFrames

Configures how RTF object frames should be exported.

Value

Meaning

0

Single frames for top, bottom, left, right (uses CSS)

1

Complete frame as box

Default

0

VerbosityTable

Configures how table objects should be exported.

Value

Meaning

0:

Ignore object

1:

As a table object

Default:

1

VerbosityTableCell

Configures how table cells should be exported.

Value

Meaning

0:

Ignore cell

1:

As a cell object using the verbosity settings of the object types specified in the cell.

2:

Cells as JPEG

Default:

1

VerbosityTableFrames

Configures how table frames should be exported.

Value

Meaning

0:

Ignore table frame

1:

Only horizontal lines of table frames

2:

The whole table line including all frames

3:

Cell-specific frames (uses CSS)

Default:

3

VerbosityText

Configures how text objects should be exported.

Value

Meaning

0:

Ignore object

1:

Object as text object

2:

Object as picture

Default:

1

VerbosityTextFrames

Configures how text object frames should be exported.

Value

Meaning

0

Single frames for top, bottom, left, right (uses CSS)

1

Complete frame as box

Default

0

XhtmlEnableAccessibility

Enables the accessibility.

Value

Meaning

0

Accessibility is deactivated.

1

Accessibility is activated.

Please note that the files will be minimally larger and insufficient contrasts will be compensated by brightness changes.

Default

1

XhtmlFixedHeader

The header is fixed and remains visible while scrolling.

Value

Meaning

0

Header is not fixed.

1

Header is fixed.

Default

0

XhtmlTitleSpecifies the title of the generated XHTML document. Default: Title used with the LlPrintWithBoxStart Method.
XhtmlToolbarType

Specifies if an additional toolbar will be created.

Value

Meaning

0:

No toolbar will be created.

1:

A toolbar with color scheme Skyblue will be created.

2:

A toolbar with color scheme Blue will be created.

3:

A toolbar with color scheme Black will be created.

4:

A toolbar with color scheme Web will be created.

Default:

1

XhtmlUseAdvancedCss

Allows the usage of non-standard CSS formatting styles.

Value

Meaning

0:

No non-standard CSS formatting styles are used

1:

Non-standard CSS formatting styles may be used, e.g. to create a gradient fill.

Default:

0

XhtmlUseSeparateCss

Specifies if a separate CSS file will be created.

Value

Meaning

0:

CSS will be added to the HEAD area of the XHTML file.

1:

CSS will be created in a separate file.

Default:

0

XlsAllPagesOneSheet

Enables the creation of a separate XLS worksheet for each page.

Value

Meaning

0

Create separate worksheet for each page

1

All pages are added to the same worksheet

Default

1

XlsAutoFit

 When exporting data only, the column widths are automatically adjusted so that the content is completely visible.

Value

Meaning

0

No adjustment.

1

Column widths are adjusted. Can significantly reduce the speed of the export, so use the option if the priority is optimised design and not processing speed.

Default

0

XlsAutoFormula

 Allows automatic conversion of Excel formulas.

Value

Meaning

0

No automatic conversion.

1

Texts that start with "=" are automatically transferred to Excel as a formula.

Default

0

XlsConvertNumeric

Allows switching of the automatic conversion of numeric values in the created Excel sheet.

Value

Meaning

0

No automatic conversion

1

Numeric values are formatted according to the setting in the Designer (Project > Options)

2

Only columns which actually contain a numeric value (e.g. a price) will be converted. If a numeric column is explicitly formatted in List & Label (e.g. Str$(price,0,0)), then it will not be converted.

3

List & Label tries to transform the output formatting configured in the Designer to Excel as exact as possible. If the "Format" property in the designer is not used, the content will be passed as Text to Excel.

Default

3

XlsFileFormat

 Configures the file format.

Value

Meaning

0

Format is recognized automatically by the file extension.

1

Office XML (XLSX) format will be used.

2

Excel (XLS) format will be used.

Default

0

XlsFontScalingPercentage

Scaling factor for the font sizes. Necessary in order to compensate for the increased text height in Excel. Default: 89

XlsFooterContent

This can be used to specify the content of the footer. The text can be up to 255 characters long and can contain special commands, e.g. a placeholder for the page number, the current date or text formatting attributes. See LlExportOption.XlsHeaderContent for possible commands.

XlsFooterMargin

Margin of the footer in inches for LlExportOption.XlsFooterContent.

XlsHeaderContent

This can be used to specify the content of the header. The text can be up to 255 characters long and can contain special commands, e.g. a placeholder for the page number, the current date or text formatting attributes. The following commands are possible:

Wert

Bedeutung

&L

Beginning of left section.

&P

Current page number.

&N

Total page number.

&\d{1,3}

Font size in points (e.g. &9 or &36).

&S

Text strikethrough.

&X

Text superscript.

&Y

Text subscript.

&C

Beginning of middle section.

&D

Date.

&T

Time.

&U

Text underlined.

&E

Text double underlined.

&R

Beginning of right section.

&Z

Path of a workbook file.

&F

Name of a workbook file.

&A

Name of a worksheet.

&"fontname"

Text font (e.g. &"Comic Sans MS").

&B

Text bold.

&I

Text italic.

&&

Ampersand character (&).

XlsHeaderMargin

Margin of the header in inches for LlExportOption.XlsHeaderContent.

XlsIgnoreGroupLines

Allows group header and footer lines to be ignored in the resulting Excel file. Only effective if Export.OnlyTabledata has been set (see below).

Value

Meaning

0

Group lines are exported

1

Group lines are ignored

Default:

1

XlsIgnoreHeaderFooterLines

Allows header and footer lines to be ignored in the resulting Excel file. Only effective if Export.OnlyTabledata has been set (see below).

Value

Meaning

0

Header and footer lines are exported

1

Header and footer lines are ignored

Default:

1

XlsIgnoreLineWrapForDataOnlyExport

Allows line wraps to be ignored. Only effective if Export.OnlyTabledata has been set (see below).

Value

Meaning

0

Line wraps are exported to Excel

1

Line wraps are ignored

Default

1

XlsPrintingZoom

Scaling factor for the printout of the project. Necessary in order to compensate for the inability to place any objects in the non-printable area. Default: 88(=88% zoom)

XlsProtectionProtectSheets

Allows to prevent various manipulations such as deleting, inserting or formatting of spreadsheets by password protection.

Value

Meaning

0

No protection.

1

All spreadsheets are protected against editing.

Default

0

XlsProtectionProtectSheetsMode

Type of protection if LlExportOption.XlsProtectionProtectSheets is set to "1". Here either -1 or a mixture of the following flags combined by "or" can be passed.

Value

Meaning

-1

Default protection.

0

All spreadsheets are protected against editing.

1

Objects are locked.

2

Scenarios are locked.

4

Formatting of cells is allowed.

8

Formatting of columns is allowed.

16

Formatting of rows is allowed.

32

Inserting columns is allowed.

64

Inserting rows is allowed.

128

Inserting hyperlinks is allowed.

256

Deleting columns is allowed.

512

Deleting rows is allowed.

1024

Selection of locked cells is locked.

2048

Sorting is allowed.

4096

Autofilters are allowed.

8192

Pivot tables are allowed.

16384

Selection of unlocked cells is locked.

Default

-1

XlsProtectionProtectSheetsPassword

Specifies the password for LlExportOption.XlsProtectionProtectSheets, which can be used to unprotect the Excel file later. Default: empty

XlsShowGridlines

Allows to show or hide the grid lines.

Value

Meaning

0

Grid lines are hidden.

1

Grid lines are shown.

Default

1

XlsWorksheetName

Configures the name of the worksheet(s). You can use the format identifier "%d" in the name. It will be replaced by the page number at runtime (ex. "Report page %d").

XmlTitle

Specifies the title of the generated XML document. Default: Title used with LlPrintWithBoxStart().

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         combit.Reporting.LlExportOption

Requirements

See Also