Steven Borruso asked 6 years ago
Hi Abu,
I have a new grid with column header text rotated as seen here –
Is there a way to keep the column header text rotated when exporting to Excel and PDF formats ?
I also can’t seem to get the text to align with the bottom of the header cell (any help with this is also appreciated 😉
In my grid I’ve rotated the header text like so –
$virt_txt_style='<p class=”rotate”>’; // used for all vertical columns text
$col = array(); $col[“name”]=”clean_fridge_freezer”; $col[“title”]=”$virt_txt_style Clean Fridg Freezr</p>”; $col=build_rest_of_parms($col); $cols[]=$col;
function build_rest_of_parms($col)
{
$col[“width”] = “175”;
$col[“align”] = “left”;
$col[“editable”] = true;
$col[“search”] = false;
$col[“sortable”] = true;
//$col[“datefmt”] = “dd”;
return $col;
}
<style>
p.rotate {
writing-mode: vertical-rl;
transform: rotate(180deg);
text-align: left;
}
</style>
Thanks !
Steve
Abu Ghufran Staff answered 6 years ago
Currently wrapper that we are using to export pdf / excel will need core lib changes.
What you can do is to follow demos/export/export-custom.php which uses callback functions and data is passed to it. You can use TCPDF or PHPExcel library there and export with custom code.
Steven Borruso answered 6 years ago
Thanks Abu,
I had looked at demos/export/export-custom.php yesterday but there isn’t an example of exporting pdf format in there (only examples for xls and csv format)-
else if ($grid->options[“export”][“format”] == “pdf”)
{
// your custom pdf generation code goes here …
}
I started looking at TCPDF at tcpdf.org and am completely lost with getting started.
So … I copied off and started hacking up this demo file – demos/export/export-pdf-html.php
If I dump out the html at the end of my callback function to the browser, the header row (titles) are rotated and styled as I specified.
If I let the callback function return the HTML that I build, the resulting PDF in the browser shows that the header row is styled (text color, font-size, bkgrd color, etc.) but the text is not rotated.
Output example of both here – https://jmp.sh/xPdSuyN
I build the table cells for the first row (using 2 divs) in export-pdf-html.php like so –
$html .= “<td bgcolor=\”TEAL\” ><div class=\”vertical-text\”><div class=\”vertical-text__inner\”><strong>$d</strong></div></div></td>”;
The included CSS looks like this –
.vertical-text {
display: inline-block;
overflow: hidden;
width: 2.0em;
color: white;
font-size: 20pt;
}
.vertical-text__inner {
display: inline-block;
white-space: nowrap;
line-height: 2.0;
transform: translate(0,100%) rotate(-90deg);
transform-origin: 0 0;
}
/* This element stretches the parent to be square by using the mechanics of vertical margins */
.vertical-text__inner:after {
content: “”;
display: block;
margin: -2.0em 0 100%;
}
Not sure how best to proceed … just looking for a way for my client to be able to print and download grid output in somewhat of a usable fashion.
Thanks,
Steve
Steven Borruso answered 6 years ago
Found a TCPDF example to start with ( here ) so I guess I’ll hack that up and into my grid code to bypass the PHPGrid PDF processing altogether and see how I make out. Please let me know if you recommend any better examples to start with.
Thanks
