Table header texts are not wrapped automatically when using the straight table from the custom objects. This is a known limitation.
Resolution
Usage pagination to work around the limitation.
- Switch to Edit sheet mode
- Select the Straight table
- Enable Properties
- Expand Presentation and scroll to Styling
- Toggle on Usage pagination by ticking the checkbox

Fix Version:
The limitation is on the roadmap for review. No date is currently set.
Internal Investigation ID(s):
QB-21283
Environment
Qlik Cloud