Excel Output : Formatting Issue
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi There,
I have an excel called format in.xlsx and need to make some formatting updates....but when i put this excel through Table, Layout and Render tools I get header names trimmed...see orange below...e.g. Segment becomes Segmen and Region become Regio and data cells with no wrap text??
...I want all header names to keep their original name and then space out all columns so full header names and rows are easier to see....like format wanted.xlsx...any help would be great :)
Solved! Go to Solution.
- Labels:
- Data Investigation
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@DelData change the render tool paper size to custom and increase the size
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi binuacs...
I cannot get the report style to save these custom size settings...each time i save/run/close then open the report styles go back to default.....any ideas how i save and keep the custom settings?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@DelData what is your alteryx version?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Version: 2022.1.1.42673 Patch: 8
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
i can see when i browse the layout tool i get view with header names not trimmed....its when it goes through render i lose part of header name :(
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@DelData an you turn off the AMP Engine and try again?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
AMP Engine is switched off in Workflow Configuration and in User Settings....still render tool not saving changes...keeps its default settings?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Ah!!....ok....Render Report Style keeps settings when i publish to server....so now fixed and have better layout that i need...thank you :)
I was saving/testing Render Report Styles locally and this did not save Render Report Styles..
is there a way to wrap text so each row is on single line?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
no have rows on single line :)....just increased custom style size.....thanks for help 😀 Got all i need now 💪
