Output PDF with custom group footer

Output PDF with custom group footer

Posted by: ntd119 on 21 April 2020, 8:21 am EST

• 

  ntd119

  • Post Options:
  • Link
    Copy

  Posted 21 April 2020, 8:21 am EST - Updated 3 October 2022, 4:06 pm EST

  Hi,
  
  I have some problems when outputing PDF
  
  Please help me

  1. In PDF, there is no background color
  2. The html tag displays in the PDF (5)
  3. The total value of the sales and expenses column is not displayed in PDF (11111111111111)
     
     https://jsfiddle.net/L98zafe4/3/
     
     Thanks
     

     759×273 25.1 KB
• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 22 April 2020, 12:28 am EST

  Hi,

  While exporting the PDF, simply set the customCellContent to true. Please refer to the sample attached.

  Regards,
  
  Ashwin

  flexgrid pdf.zip

• 

  ntd119

  • Post Options:
  • Link
    Copy

  Posted 22 April 2020, 11:50 pm EST - Updated 3 October 2022, 4:06 pm EST

  Thanks for your respond
  
  I have another problem
  
  I have a demo at the link https://jsfiddle.net/ykaej5Lh/10/

  1. When I use Japanese, press buton [Export] then output PDF broken font
     
     Even though I have registered the ‘ipaexg’ font before exporting the FlexGrid to PDF so that the Japanese characters are also exported properly
  2. The table cell border in PDF is changed (The border is bolded)
  3. Can you help me merge 3 cell ➀、②、③ together (like group header) ?
     
     Please help me
     
     Thanks
     

     760×300 32.1 KB
• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 23 April 2020, 2:41 am EST

  Hi,

  Regarding your 1st issue, if you have set the customCellContent to true, then the PDF will export the cells using the font provided in the CSS, instead of the cellStyles provided while exporting. So, simply set the font of the .wj-cell class as ‘ipaexg’. Since, this font will not be registered to the DOM, so setting it will not have any effect on the cells on the web page and will only affect the cells in the PDF.

  Regarding the formatting of PDF, it seems that there is an issue with the latest version regarding formatting. I have already forwarded this issue to the developers with internal tracking id 431292. I will update you as soon as the issue is fixed.

  Regarding the merging of cells, for this, you will need to override the getMergedRange method of the MergeManager class. In the sample attached, I have added comments for your reference.

  ~regards

  flexgrid pdf.zip

• 

  ntd119

  • Post Options:
  • Link
    Copy

  Posted 24 April 2020, 5:16 am EST - Updated 3 October 2022, 4:06 pm EST

  Thanks for your respond
  
  I have another problems
  
  I have a demo at the link https://jsfiddle.net/8rztfy7c/17/
  
  I want the group footer work as the group header
  
  Please refer to the attached files
  
  Please hepl me
  
  Thanks

  

  770×311 16.4 KB

  

  775×304 21.1 KB

  

  803×330 20.9 KB

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 27 April 2020, 1:01 am EST

  Hi,

  The group footer and the group header are different. The group header row is added internally FlexGrid so it is updated according to the data. But, the group footers row is added just to display the grouped items with a footer. So it is not as much as customizable as the header row.

  ~regards

• 

  ntd119

  • Post Options:
  • Link
    Copy

  Posted 27 April 2020, 11:33 pm EST

  Thanks for your respond
  
  I have another problem
  
  I have a demo at the link https://jsfiddle.net/ez5193mL/34/
  
  when [product] column has data larger than the cell size
  
  There is no 3 dot character in the PDF and it is not centered vertically
  
  Please refer to the attached file
  
  Please hepl me
  
  Thanks

• 

  ntd119

  • Post Options:
  • Link
    Copy

  Posted 27 April 2020, 11:41 pm EST

  I attach image.

  https://gccontent.blob.core.windows.net/forum-uploads/file-fc25f320-26dd-4b17-a32b-c4fa4f51fe74.jpg(image larger than 4 MB)

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 28 April 2020, 1:22 am EST

  Hi,

  The three dots (…) that are displayed whenever the data is large is done using CSS and cannot be reflected into PDF. I would suggest you display the complete data of the FlexGrid by resizing the rows and/or columns and then export the grid. Please refer to the updated sample below:

  https://jsfiddle.net/916oqkht/2/

  ~regards

• 

  ntd119

  • Post Options:
  • Link
    Copy

  Posted 28 April 2020, 8:52 am EST - Updated 3 October 2022, 4:06 pm EST

  Thanks for your respond
  
  I have another problem
  
  I have a demo at the link https://jsfiddle.net/ez5193mL/34/
  
  I want to hide the [country] column in pdf
  
  Please refer to the attached file
  
  Please hepl me
  
  Thanks

  

  750×354 27 KB

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 29 April 2020, 1:53 am EST

  Hi,

  Simply hide the column before exporting and display it again after the FlexGrid has been exported.

  https://jsfiddle.net/yhe85qLu/

  Also, please create a new thread regarding further issues as this thread is getting bigger and harder to maintain.

  ~regards

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 23 June 2020, 9:48 am EST

  Hello,

  The formatting issue (#431292) has been fixed in the latest build (5.20201.680). Please update your Wijmo to this version and let us know whether it resolves your issue.
  
  Let us know in case you run into any issues while upgrading.

  ~regards