Replied 23 May 2019, 11:42 pm EST
Please refer to the following responses:>> Headers and Footers
You could use the header and footer properties of PdfDocument class to add header and footers.>> Calculations were not evaluated
To evaluate the calculations while exporting, you may handle the formatItem property of IFlexGridDrawSettings and evaluate the calculations manually.>> Shade headers and blank cells
For shading the headers, you may use the headerCellStyle property and set its backgroundColor property.
For shading blank cells, you will need to use the formatItem property again and shade those cells which are empty.>> More columns on a single page
There are various alternatives avalilable:
• You may adjust the left-right margins to increase available drawing space
• You may also change page orientation to landscape.
• When using FlexGridPdfConverter.draw() method, you may pass optional height/width parameters to fit the grid in the specified width/height.
API ref: https://www.grapecity.com/wijmo/api/classes/wijmo_grid_pdf.flexgridpdfconverter.html#draw
• Further if you need to adjust width of only some columns, then what you could do is save the current width of the column locally, then update the width of the column as would like them to export and export the grid, and finally restore the width to its original value.
Please refer to the following sample demosntrating the same:
•Modifying col width during export: https://stackblitz.com/edit/js-dxzutx
•Restricting grid width by passing width parameter to draw() method: https://stackblitz.com/edit/js-ex5at1