3/28/2023 0 Comments Hourguard export of excelThis is the only export method that is supported by printing links. With this export mode, the layout of a control’s cells is retained in the resulting Excel documents while specific data shaping options may not be retained. Printing links (in WinForms and WPF) do not support this export mode and to use the data-aware export, it is required to call the corresponding methods of specific controls (e.g., GridControl). Various data shaping options that are applied within the control are retained in the output XLS-XLSX documents (such as native Excel grouping, sorting and filtering settings, as well as improved support for Excel formulas). This export mode is optimized for subsequent data analysis within Microsoft Excel. The following two modes of Excel export are available. When both these properties are set to true, this enables the “ Fit Sheet on One Page“ option in the Print dialog of an Excel document. To enable the “ Fit All Rows on One Page“ option available in the Print dialog of an Excel document, use the XlExportOptionsBase.FitToPrintedPageWidth property. To enable the “ Fit All Columns on One Page“ option available in the Print dialog of an Excel document, use the XlExportOptionsBase.FitToPrintedPageHeight property. The encryption is supported for both the WYSIWYG and DataAware export modes. To learn more, see the following topic in MSDN: Office Document Cryptography Structure. XLS files support only ARC4 encryption (except for RC4CryptoAPI) and the XlEncryptionOptions.Type property is ignored for such files. Make sure that only trusted parties have access to report definition files. Excel passwords are saved with report definitions in clear text.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |