Your product is great! But when exporting to Excel or PDF with smart rendering enabled using full_color, the rows that have not been displayed in the viewport have a black background. Tried looping through all rows with render_row() but that didn’t solve the problem. Using enterprise version with PHP. Any suggestions will be greatly appreciated!
Hi,
could you provide link to your page with grid or complete demo? There is no way to repeat problem at local machine.
Hi Radyno - thanks for your quick reply! We’re dealing with sensitive data so I set up a demo site that shows the problem. If you export as PDF or Excel and scroll down, I think you’ll see the problem. Thanking you in advance for any help you can give.
… Just want to add that the problem occurs on rows that have not been viewed in the grid, so to see the problem it’s important you do not scroll the page before exporting.
Hi,
please, update file dhtmlxgrid_export.js from attachment.
But unfortunately there is no way to get real colors of not-rendered rows, so the best way would be to use color mode instead of fullcolor.
dhtmlxgrid_export.zip (2.55 KB)
Hi again Radyno. I replaced the .js file - thanks for that.
I don’t know what the difference is between “color” mode and the default. If you could direct me to some documentation that would be great. My experiments show that cell formatting is lost (font and bg colors) using “mygrid.toExcel(‘dhtmlxGrid/codebase/grid-excel-php/generate.php’,‘color’)” - same with PDF. Is that correct? This is not a total show stopper since smaller data sets don’t require smart rendering, but it would be nice if larger data sets could be properly exported to PDF and Excel while retaining cell formatting changes. As always, thanks for your help.
Yes, you right about differencies between color and fullcolor.
Unfortunately there is no way to get properly formatting of not-rendered cells.
Another question please, this time related to exporting as CSV. It appears that serializeToCSV() includes data from hidden columns. Is there a function or setting that will cause the grid to serialize only the columns and rows that are currently showing and non-filtered?
I also notice that full_color toExcel loses cell alignment settings (center and right). Unless there’s a fix for that, perhaps it can go on a list of future improvements, along with the row rendering issue.
It appears that serializeToCSV() includes data from hidden columns
Fixed in dev. servion
Will be included in next build ( if you need the fix ASAP - please open ticket in the support system )
I was able to deal with it on my end. I hope some of the issues with full_color export to Excel and PDF will be considered for future fixes as well. In any case this is a great product and your support is greatly appreciated.