|
|
|
|
|
|
|
|
|
|
- Overview
- Operating mode
- Principle
- Printing the report created by the developer
- Directly print the content of the Spreadsheet control
- Customizing the Spreadsheet control print settings window
Printing the content of a Spreadsheet control (AAF)
Spreadsheet controls include an automatic context menu that allows users to perform different actions on the data displayed in the control. One of the options found in this context menu allows the user to print the content of Spreadsheet control ("Print" option). Principle Several cases may occur: - If a report was created on this Spreadsheet control by the developer, this report is printed. For more details, see Spreadsheet control in a report.
- If no report is linked to this Spreadsheet control, the user can print the content of the Spreadsheet control found in the window.
Remarks: - The "Print" option in the Spreadsheet control context menu requires the WINDEV framework print libraries.
- Through programming:
- AAFExecute associated with the aafPrintSpreadsheet constant is used to print the specified Spreadsheet control.
- AAFDisable associated with the aafPrintSpreadsheet constant removes the "Print" option for the specified Spreadsheet control.
- AAFChangeCaption with the affPrintSpreadsheet constant is used to change the text of the "Print" option for the specified Spreadsheet control.
Printing the report created by the developer If the developer has created a report on the Spreadsheet control, the "Print" option will allow this report to be printed directly.. No specific programming is required. Directly print the content of the Spreadsheet control If the Spreadsheet control contains several pages, a window will appear with the following options: - orientation used for printing.
- document scaling.
The content of the Spreadsheet control is viewed in the report viewer. If the number of lines in the Spreadsheet control is too high (over 10,000 lines), the application asks the user for confirmation (printing can be relatively long and consume memory resources). The print characteristics are as follows: - The current worksheet displayed in the Spreadsheet control is printed.
- The print title corresponds to the title of Spreadsheet control. The window title is used if no title was specified for the control.
- The column titles are printed on each page.
- The printout respects the background colors used for the different cells in the Spreadsheet control..
- Today's date is printed in the upper-right corner.
- The number of the current page and the total number of pages are printed in the lower-right corner.
Customizing the Spreadsheet control print settings window WINDEV allows you to include Spreadsheet control print settings window used by the AAF in your application. You will have the ability to customize: - the appearance of this window (modification of skin template for example),
- the languages supported by this window. This feature is very useful when translating this window into the different languages available in the application.
To include the window for configuring the print in your application: - On the "Proyecto" tab, in the "Proyecto" group, expand "Importar" and select "WINDEV elements and their dependencies".
- Select the subdirectory that contains the elements to import. The print configuration window is in the "Programs\Data\Preset Windows\EN\AAF" subdirectory of the WINDEV installation directory.
- WINDEV lists the elements of the directory. This directory contains the different elements corresponding to the customizable AAFs. The window to import is named "WinDevAaf_ConfigSpreadsheetPrint.wdw".
- Validate. The window is included in the project and it can be modified. This custom window will be automatically taken into account when running the application.
Remarks: - The window must not be renamed.
- If this window is included in your application, you may not benefit from the improvements made to this window during the different updates. Don't forget to check whether this window has evolved.
- Warning: To modify this window, the corresponding file must not be read-only.. Modify the characteristics of the file in Windows if necessary.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|