Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
WEBINAR April 23, 2025: Iceberg Ahead: The Future of Open Lakehouses - REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
PabloLabbeImaps
Partner Ambassador
Partner Ambassador

Error when exporting Straight table object when total number of characters in a cell is larger than 32767

Found an issue when a cell of a Straight Table object is larger than 32.767 characters.

I identified two different behaviors in Qlik Cloud and On-Premise: 

- In Qlik Cloud the export dialog only show a message that something went wrong and ask to try again.

- In Qlik On-Premise the export file is generated but the cells with content larger than 32.767 are null.

Issue is the same for Native Straight Table and the New Straight Table extension.

 

If truncating the content to a length lower or equal to 32.767 , the export file is generated correctly.

As side note, the limit is imposed by Excel file format according this documentation

https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-2...

Maybe the export process can just truncate the content automatically.

Labels (2)
1 Solution

Accepted Solutions
Frank_S
Support
Support

Hello @PabloLabbeImaps 

Here are two suggested paths forward:

 

Support case creation:

Please create two separate support cases for

- In Qlik Cloud the export dialog only show a message that something went wrong and ask to try again.

and

- In Qlik On-Premise the export file is generated but the cells with content larger than 32.767 are null.

Better error reporting on these would be useful.

 

Feature requests:

Or you may prefer to make those points as feature requests to improve the error reporting here:

Ideas | Qlik Community

 

Kind regards..

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

2 Replies
Frank_S
Support
Support

Hello @PabloLabbeImaps 

Here are two suggested paths forward:

 

Support case creation:

Please create two separate support cases for

- In Qlik Cloud the export dialog only show a message that something went wrong and ask to try again.

and

- In Qlik On-Premise the export file is generated but the cells with content larger than 32.767 are null.

Better error reporting on these would be useful.

 

Feature requests:

Or you may prefer to make those points as feature requests to improve the error reporting here:

Ideas | Qlik Community

 

Kind regards..

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
PabloLabbeImaps
Partner Ambassador
Partner Ambassador
Author

Thank you for replying Frank ! I'll open a support ticket for each one.