Wiki source code of Options d'export

Last modified by Aurelie Bertrand on 2025/11/14 11:59
Show last authors
1 {{ddtoc/}}
2
3 ----
4
5 You can change the settings for PPT, PDF, CSV and Excel exports.
6
7 = General export options =
8
9 You can limit the number of rows in tables when exporting.
10 ➡ If a table has more rows than the limit defined here, the extra rows will not be exported. A message will be displayed during export to warn the user.
11
12 = PDF export options =
13
14 |=(% scope="row" style="width: 323px;" %)Option|=(% style="width: 502px;" %)Description
15 |(% style="width:323px" %)Show header title in PDF|(% style="width:502px" %)Display the {{glossaryReference glossaryId="Glossary" entryId="Flux"}}Flow{{/glossaryReference}} name in the PDF header
16 |(% style="width:323px" %)Show page number in PDF footer|(% style="width:502px" %)Adds the page number to the footer
17 |(% style="width:323px" %)Use an alternative method (OpenHTMLToPdf)|(% style="width:502px" %)Uses the OpenHTMLToPdf library instead of the traditional PDF export method
18 |(% style="width:323px" %)Position the summary on the PDF filters|(% style="width:502px" %)By default, the list of filters applied to Flows is not displayed in the PDF. If you wish to display it, choose the position of the summary from the drop-down list: **Before** or **After**.
19 |(% style="width:323px" %)Page format in PDF|(% style="width:502px" %)Select the desired format from the drop-down list: A4 portrait, A4 landscape, US letter portrait or US letter landscape
20 |(% style="width:323px" %)Background colour|(% style="width:502px" %)If you want to add a background colour to the PDF document, enter a hexadecimal colour code.
21 |(% style="width:323px" %)ID of a factory used as a template|(% style="width:502px" %)Specify the ID of a {{glossaryReference glossaryId="Glossary" entryId="Fabrique PDF"}}PDF builder{{/glossaryReference}} that will be used as a template for exports. The template will allow you to add backgrounds, colours and elements from your graphic charter for all {{glossaryReference glossaryId="Glossary" entryId="Flux"}}Flow{{/glossaryReference}} exports in PDF.
22
23 = PPT export options =
24
25 |=(% style="width: 323px;" %)Option|=(% style="width: 502px;" %)Description
26 |(% style="width:323px" %)Show title in PPT header|(% style="width:502px" %)Displays the name of the {{glossaryReference glossaryId="Glossary" entryId="Flux"}}Flow{{/glossaryReference}} in the PPT header
27 |(% style="width:323px" %)Position summary on filters for PPT|(% style="width:502px" %)By default, the list of filters applied to Flows is not displayed in the PPT. If you wish to display it, choose the position of the summary from the drop-down list: **Before** or **After**.
28 |(% style="width:323px" %)ID of a factory used as a template|(% style="width:502px" %)Specify the ID of a {{glossaryReference glossaryId="Glossary" entryId="Fabrique PPT"}}PPT Builder{{/glossaryReference}} which will be used as a template when exporting. The template will allow you to add backgrounds, colours and elements from your graphic charter for all PPT {{glossaryReference glossaryId="Glossary" entryId="Flux"}}Flow{{/glossaryReference}} exports.
29
30 = (% style="color:inherit; font-family:inherit; font-size:29px" %)CSV export options(%%) =
31
32
33 |=(% scope="row" style="width: 323px;" %)Option|=(% style="width: 502px;" %)Description
34 |(% style="width:323px" %)CSV export separator character|(% style="width:502px" %)You can specify a character other than ';' as the column separator.
35 |(% style="width:323px" %)Encoding for CSV export|(% style="width:502px" %)Enter the desired encoding for the CSV export (by default, the encoding used is UTF-8).
36 |(% style="width:323px" %)Decimal separator character for CSV export|(% style="width:502px" %)Enter the character to be used as the decimal separator for CSV export.
37 By default, empty=auto.
38 |(% style="width:323px" %)Delete summary value lines from CSV exports|(% style="width:502px" %)By default, summary value lines (totals) are not added to the CSV. If you wish to add these rows to the CSV, uncheck the box **Delete summary value rows from CSV exports**.
39 |(% style="width:323px" %)Save {{glossaryReference glossaryId="Glossary" entryId="Tableau croisé"}}Cross table{{/glossaryReference}} CSV exports as raw data|(% style="width:502px" %)(((
40 //checked by default//
41
42 If ticked, the CSV export of a {{glossaryReference glossaryId="Glossary" entryId="Tableau croisé"}}Cross table{{/glossaryReference}} will be saved as raw data. The data will be unstacked so that it can be re-used as input for a new model.
43
44 If unchecked, the {{glossaryReference glossaryId="Glossary" entryId="Tableau croisé"}}Cross table{{/glossaryReference}} will be exported as a raw table.
45 )))
46
47 = Excel export options =
48
49 |=(% scope="row" style="width: 323px;" %)Option|=(% style="width: 502px;" %)Description
50 |(% style="width:323px" %)Export in XLSX format|(% style="width:502px" %)The default export format is XLS. Check the box to export in XLSX format.
51 |(% style="width:323px" %)Export visible levels of a hierarchical table as Excel groups|(% style="width:502px" %)Converts the levels of tree tables into Excel groups.
52 |(% style="width:323px" %)Position the filter summary for XLS|(% style="width:502px" %)Select the position of the filter summary: **None**, **Before **or **After**. If you select** Before **or **After**, a **Current Selection** page containing the list of filters is added before or after the export page.
53
54 == Save as Excel Fast {{id name="excel_without_styles"/}} ==
55
56 Saving as Excel Fast retains only some of the styles. This means you can have formatted data and still benefit from fast generation.
57 The following CSS classes are supported:
58
59 * .tdhHeader
60 * .tdvHeader
61 * .rowOdd
62 * .rowEven
63
64 (% class="box infomessage" %)
65 (((
66 ℹ The rowOdd and rowEven classes work with the tdvHeader class, but the tdvHeader class overwrites the styles of the rowOdd and rowEven classes.
67 )))
68
69 In these CSS classes, only the following attributes are supported:
70
71 * background-color
72 * colour
73 * border
74 * border-right
75 * border-left
76 * border-top
77 * border-bottom
78 * text-align
79 * font-style
80 * font-weight
81 * vertical-align
82 * font-size
83 * colWidth (if specified in the chart's specific stylesJSON attribute)
84
85 |=(% style="text-align: center;" %)Example Save as Excel Standard|=(% style="text-align: center;" %)Example Save as Excel Fast
86 |(((
87 [[image:1748001909941-531.png||alt="Avec les styles" data-xwiki-image-style-alignment="center"]]
88 )))|[[image:1748001971975-580.png||alt="Sans les styles" data-xwiki-image-style-alignment="center"]]