Blank column on XLS export

[emberqParticipant]

I have a grid with about 500 rows. One of the columns is email address. When I export to XLS all the columsn come in OK except the email addresses are blank. The column is there and the column header is there. On other data sets within that same grid the email addresses do appear. Please understand this is not a show/hide issue and it is not and Excel issue. The email addresses are sometimes missing in the data returned from your server. There are 10 other columns of data and they always OK even when the email address column goes blank in a particular data set. The same problem happens for PDF transform and HTML in the exact same way – for some particular data set the email addresses are blank.

When they do go blank a small set of what seems like random rows have todays date in that email column instead of the email address.

It leads me to believe that there is something occasionally in the data coming out of my grid that s causing the XLS transformation on your server to give up on that email column or take the data from some other column. Are you aware of any special characters or really any conditions in which your XLS transformation would give up on a column like that?

[HristoParticipant]

Hello emberq,

It is a normal behavior if you use the cellsrenderer to create this ‘links’.
‘Exporting result of “cellsrenderer” callback function is not possible because “cellsrenderer” returns HTML, not Text.’
Please, take a look at this forum topic post:
https://www.jqwidgets.com/community/topic/export-data-with-cellsrenderer-value/#post-56505

I would like to suggest you as a workaround to create an additional column (that could be hidden). After that set into it these links as a plain text and another column (parent column). You could transform that way that it does not be exported exportable: false.

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[emberqParticipant]

Hi Hristo,

Thanks for your follow-up. This is important to me because it’s a key feature of my app that enables my clients to create e-mail lists of their own clients.

Anyway, I’m not using cellsrenderer for that column or any other column that is participating in this grid and this export. So I appreciate the hidden column idea and I do use hidden columns in other grids, but this is not that problem.

Is there some way you can check your logs on that export server to assist with this? For example, I’d like to know if the email addresses from that column are indeed being sent to your server. I know for a fact they’re not coming back.

[HristoParticipant]

Hello emberq,

Our server is only for demonstrations purposes and we do not collect data.

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[cmoParticipant]

Hi Emberq,

just my 2c here, but the actual excel document is built on the client side and posted to backend just to allow the posibility to download the file ( there’s no way to create files in javascript in the browser ) . So you can check the payload that the page sends to the server to see the exact XLS buffer.

Cip

[Author]

Posts