Hello, I append using pdf operations i may have several pages per append, ive followed the tutorial for page numbering but its not working, each append is starting from 1, i cant find an example of page numbering using pdf is this possible using jsreport?

Kind regards
Michael

Hi, I have a template that contains 3 other append templates Template 0 + append Template 1,2 and 3 can i remove an unwanted template from the pdf util operation before render? if i dont send the data for template 3 i just get a blank pdf page, id like to remove this.

Regards
Michael

Found a solution, best doing it in script instead of markup

Is there a way i can assign {{Code}} to the pdfformfield name property, it doesnt seem to like just putting {{Code}} is as name, and all names must be unique.

{{#each Items}}
        <tr>
            <td><span>{{{pdfFormField name='Code' type='combo' value='Yes' items='Yes,No' width='100px' height='20px'}}}</span></td>
            <td><span>{{Code}} - {{Title}}</span></td>
            <td>{{Quantity}}</td>
        </tr>
{{/each}}

regards
Michael

Is there a checkbox type or only the types listed at https://jsreport.net/learn/pdf-utils#forms

Yes that worked thanks, i was pressing download in the pdf display.

regards

How do we save the template as a pdf, im able to render the form fields but when i save it wants to save as an html file.

Im using handlebars, chrome-pdf

<div>
<span>Name:</span>
<span>
{{{pdfFormField name='firstName' type='text' width='200px' height='20px'}}}
</span>
</div>

regards
Michael

Hi, thanks for the reply, I done what you suggested, seems the content types were needing removed and the definedNames
The content types are in order so removing at the array index works ok but the defined names are not in any order, how can I use xlsxRemove to target a specific localSheetId.

the xml looks like this
<definedNames>
<definedName name="_xlnm._FilterDatabase" hidden="1" localSheetId="5">ARCS!$A$4:$C$4</definedName>
<definedName name="_xlnm._FilterDatabase" hidden="1" localSheetId="4">'Digital Publications'!$A$4:$H$4</definedName>
<definedName name="_xlnm._FilterDatabase" hidden="1" localSheetId="2">'Paper Charts'!$A$4:$F$4</definedName>
<definedName name="_xlnm._FilterDatabase" hidden="1" localSheetId="3">'Paper Publications'!$A$4:$H$4</definedName>
<definedName name="_xlnm._FilterDatabase" hidden="1" localSheetId="1">Subscriptions!$A$4:$F$4</definedName>
<definedName name="_xlnm._FilterDatabase" hidden="1" localSheetId="0">Vessel!$A$4:$H$4</definedName>
</definedNames>

and im using this to remove the sheet, content types and defined names
{{#compare Valid false}}
{{#xlsxRemove "xl/workbook.xml" "workbook.sheets[0].sheet" 1}}
{{/xlsxRemove }}
{{#xlsxRemove "[Content_Types].xml" "Types.Override" 1}}
{{/xlsxRemove}}
{{#xlsxRemove "xl/workbook.xml" "workbook.definedNames[0].definedName" 3}}
{{/xlsxRemove}}
{{/compare}}

regards

Hi, im using {{xlsxRemove "xl/workbook.xml" "workbook.sheets[0].sheet" 1}} to remove a sheet, it removes ok but the pdf has errors when I try and open it, the error its giving me is "Named range from /xl/workbook.xml part (Workbook)" I have checked a few solutions online none of them work, if I don't remove the sheet the excel opens perfectly.

whats the best way to remove a sheet and references

regards

Hello, im using the html to xlsx multiple sheets example, id like to add a filter in the table headers, is there a way to do this?

regards