Excel Export Issue: Random blank/empty row

[jcampbell474]

Over the past year or so, some users and myself have exported data to Excel from Qlikview v11.206.0 SR13 and came across a random very large, blank row in the data.  The (empty) row is sometimes so big that the only way to re-size it is to highlight the entire row, right-click, row height, and enter 12.75 or something. 

I haven't been able to replicate it, just wondering if anyone else has experienced the same issue?  If so, how can it be replicated and/or fixed? 

[Anonymous]

Hi Jason

Very interesting. I've not come across this issue but haven't used sr13. Currently on sr12. Have you experienced the same issue on previous releases and have you checked to see if it is a bug fixed in sr14?

[jcampbell474]

I don't recall it happening before SR13.  Just checked the release notes for SR14 and SR15.  Didn't see any mention of the issue.  Very good questions - made me think.  Thank you!

[Anonymous]

You're welcome. I've also just checked the latest release notes and as you say no reference at all. It will be interesting to see if anyone else in the community has experienced the same issue. Did you get this issue when exporting from a particular client to excel or from any particular chart object i.e. from a pivot table but not from a straight table or something like that. Seems very strange. Final question for now did it happen with only one particular qlikview document or from different documents?

[jcampbell474]

It has only occurred when exporting a straight table from Qlikview Client to Excel 2010 thru 2016.  It 'might' happen with a Pivot table. 

It has happened from many different documents - two totally separate server environments / companies.

[duzford13]

Has anyone else experienced this? I have a handful of users who are seeing the same thing when they export, but I cannot replicate it. We are on version 12.1 SR8.