pdfmake RTL

abdosaeed

i did all steps described in
https://datatables.net/forums/discussion/62113/how-to-reverse-excel-pdf-columns-order-to-rtl#latest
but not worked for me as i attashed to you

i did it as discribed

columnDefs: [
{
targets: '_all',
render: function(data, type, row) {
if (type === 'PDF') {
return data.split(' ').reverse().join(' ');
}
return data;
}
}

but not worked for me

kthorngren

The code you posted is only part of the solution. Colin's example also has this:

      exportOptions: {
        orthogonal: "myExport"
      }

The orthogonal string myExport is to match the type have in the if statement. If you still have problems please provide a link to your page or a test case showing the issue. Or you can update Colin's test case to show the problem.
https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

Kevin

abdosaeed

Yes i did it

exportOptions: {
orthogonal: "PDF"
},

abdosaeed

next is all my script

var table=$('<?php echo $id; ?>').DataTable({
dom: 'Bfrtip',
"order": [[ 0, "desc" ]],
"ordering": false,
buttons: [
{
extend: 'pdfHtml5',
exportOptions: {
orthogonal: "PDF"
},
customize: function (doc) {
doc.defaultStyle.font = 'Roboto';
}

                },
                'excelHtml5','csvHtml5','copyHtml5',
            ],
            columnDefs: [
               {
                    targets: '_all',
                    render: function(data, type, row) {
                        if (type === 'PDF') {
                            return data.split(' ').reverse().join(' ');
                        }
                        return data;
                    }
                }
            ],
            "language": {
                "url": "{{app()->getLocale()=='ar'?asset('datatable/ar.json'):asset('datatable/en.json')}}"
            }
        });

kthorngren

Is the RTL code working now?

Kevin

abdosaeed

No, it display statements words from left to right

abdosaeed

next is all my datatable code

var table=$('<?php echo $id; ?>').DataTable({
                dom: 'Bfrtip',
                "order": [[ 0, "desc" ]],
                "ordering": false,
                buttons: [
                    {
                        extend: 'pdfHtml5',
                        exportOptions: {
                            orthogonal: "PDF"
                        },
                        customize: function (doc) {
                            doc.defaultStyle.font = 'Roboto';
                    
                        }

                    },
                    'excelHtml5','csvHtml5','copyHtml5',
                ],
                columnDefs: [
                    {
                         targets: '_all',
                        render: function(data, type, row) {
                            if (type === 'PDF') {
                                return data.split(' ').reverse().join(' ');
                            }
                             return data;
                         }
                    }
                ],
                "language": {
                    "url": "{{app()->getLocale()=='ar'?asset('datatable/ar.json'):asset('datatable/en.json')}}"
                }
            });

colin

Please can you update my example (in Kevin's post) above to demonstrate this, it'll be easier for us to debug if we can see it,

Colin

abdosaeed

but arabic language not worked in your example, i already proccess that by changing the default font to other one in my work, i think your solution is correct may be not worked for me with the font that i used, i will try to solve it, thank you

abdosaeed

it now worked for me, i have mistak in return key word not implemented in my editor code as i did her, the all datatable reversed correctly except the header, is there any work around , thank you for help

colin

This example shows how to colour the header cells - that shows where you need to make the edit, then you would use the code as before to flip the words,

Colin

Emadeldeen

abdosaeed, Could you send the code that worked with you.

omar_helal

Emadeldeen , Code ?

mr2adam

could you please share the final PDFMake RTL code

xbox2007

hello
please can you share Arabic RTL code

thanks a lot

colin

This example from this thread demonstrates the reversing of the words,

Colin

xbox2007

thanks a lot for your replay .
but i looking for Arabic PDF Example

Arabic latter's not show in PDF

thanks again

colin

That'll be a font issue, you need to include all the necessary fonts - see this thread: https://datatables.net/forums/discussion/comment/138501#Comment_138501

Colin

mostafamedht

hi @colin
this a screenshot for same problem, of reverse word in Arabic
I did all steps explained here from you and Keivin

$(document).ready( function () {
            var table = $("#example1").DataTable({
                dom: "Bfrtip",
                "buttons": [{
                extend: "pdfHtml5",
                orientation: 'landscape',
                pageSize: 'A4',
                exportOptions: {
                    orthogonal: "myExport",
                    columns: [4, 3, 2, 1, 0],
                },
                customize: function (doc) {
                    doc.defaultStyle =
                    {
                        font: 'Cairo',
                    };
                        doc.styles.tableBodyEven.alignment = "center";
                        doc.styles.tableBodyOdd.alignment = "center";
                    },
                }, {
                        extend: 'excelHtml5',
                        exportOptions: {
                            columns: ':visible'
                        }
                    },],
                columnDefs: [
                {
                    // targets: '_all',
                    targets: "hiddenCols", visible: false,
                    render: function(data, type, row) {
                    if (type = 'myExport') {
                        return data.split(' ').reverse().join(' ');
                    }
                        return data;
                    }
                }
                ]
            });
        });

mostafamedht

Hi @colin
I did all the steps here, but it did not work for me

$(document).ready( function () {
            var table = $("#example1").DataTable({
                dom: "Bfrtip",
                "buttons": [{
                extend: "pdfHtml5",
                orientation: 'landscape',
                pageSize: 'A4',
                exportOptions: {
                    orthogonal: "myExport",
                    columns: [4, 3, 2, 1, 0],
                },
                customize: function (doc) {
                    doc.defaultStyle =
                    {
                        font: 'Cairo',
                    };
                        doc.styles.tableBodyEven.alignment = "center";
                        doc.styles.tableBodyOdd.alignment = "center";
                    },
                }, {
                        extend: 'excelHtml5',
                        exportOptions: {
                            columns: ':visible'
                        }
                    },],
                columnDefs: [
                {
                    // targets: '_all',
                    targets: "hiddenCols", visible: false,
                    render: function(data, type, row) {
                    if (type = 'myExport') {
                        return data.split(' ').reverse().join(' ');
                    }
                        return data;
                    }
                }
                ]
            });
        });

colin

We're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

Cheers,

Colin

hsm_sender

hi here is my code for persian ltr to rtl this is a function that's can use in datatable to export as pdf :

function buttonForDatatable(columns, margins, prtrait = "portrait",title='',message='') {
            return [
                 {
            extend: 'copy',
            text:"کپی",
            exportOptions: {

                columns: columns.reverse(),

            },

        },  {
            extend: 'csv',
            text:"سی اس وی",
            exportOptions: {

                columns: columns.reverse(),

            },

        },  {
            extend: 'print',
            text:"پرینت",
            exportOptions: {

                columns: columns.reverse(),

            },

        }, {
            extend: 'excel',
            text:"اکسل",
            exportOptions: {

                columns: columns,

            },

        }  ,{
                    extend: 'pdfHtml5',
                    orientation: prtrait,
                    footer: true,
                    alignment: "center",
                    title: title,
                    messageTop:message,
                    text: "PDF",
                    exportOptions: {
                        alignment: "center",
                        orthogonal: "PDF",
                        columns: columns,
                        modifier: {order: 'index', page: 'current'}

                    },
                    customize: function (doc) {
                        doc.styles.message.alignment = "right";
                        doc.styles.tableBodyEven.alignment = "center";
                        doc.styles.tableBodyOdd.alignment = "center";
                        doc.styles.tableFooter.alignment = "center";
                        doc.styles.tableHeader.alignment = "center";
                        doc.content[0]['text'] = doc.content[0]['text'].split(' ').reverse().join(' ');
                        doc.content[1].margin = margins;
                        doc.content[2].margin = margins;
                        for (var i = 0; i < doc.content[2].table.body.length; i++) {
                            // console.log(doc.content[1].table.body[i].length);
                            for (var j = 0; j < doc.content[2].table.body[i].length; j++) {
                                doc.content[2].table.body[i][j]['text'] = doc.content[2].table.body[i][j]['text'].split(' ').reverse().join(' ');
                            }
                        }
                    }
                }
            ];
        }

and after that you are can use same as here :

 table = $('#mydatatable').DataTable({
                language: language,
                "lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "all"]],
                dom: 'Blfrtip',
                buttons: buttonForDatatable([2, 3, 4], [0, 0, 0, 0]),
                processing: true,
                serverSide: true,
.....

colin

Nice, thanks for sharing,

Colin

abanobr

i have a proplem that when i export pdf in arabic it makes

but english works well

marcobarsoum

final solution:
1. encode your font (that font you need to use) using this page: https://www.giftofspeed.com/base64-encoder/
2. download vfs_fonts.js >> https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js
3. take encoded font text , and replace it with text of Roboto font , in each line in vfs_fonts.JS (4 times) , to change effect of font Roboto into your font characters..

good luck

allan

Nice one - thanks for posting back with your solution.

Allan

marcobarsoum

marcobarsoum

you can find full solution expalined in my last comment Here