Can't adjust column width on table/layout/render tool combination
- 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
I have a workflow that creates one spreadsheet with four separate Excel tabs by using four separate instances of the table and layout tools which are combined with the union tool and outputted using one render tool.
On the render tool I have report style set to a custom size of 20 x 11 in order to compensate for one of the tabs that has 19 columns - otherwise it truncates the columns.
I have another tab with only 3 columns, but the columns are expanded out much further than needed - I'm guessing because of the render tool settings of 20 x 11.
Is there a way to change the column widths for just the tab with 3 columns? I've tried changing the Table tool Table width, as well as the Layout tool Layout configuration to different settings such as changing to fixed and percentage. But the columns are always expanded out too far. In fact the column widths don't change at all no matter how I change the configurations on the Table and Layout tools.
Solved! Go to Solution.
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You're correct that once the render size is set, it's used for all sheets. What you can do to render your data in a more concise manner is add empty fields to that sheet so they can take up some of that space.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How can this be done without extra empty columns being visible?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@sfyodor wrote:How can this be done without extra empty columns being visible?
That mostly depends on your table style settings. Setting table and column/row outlines to disabled is the first step that comes to mind.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Charlie, Where do I find how to do that? Is it in 'Default Table Settings'? The Style Editor?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The 'Default Table Setting' button is at the bottom of the Table tool configuration window. What I was suggesting by "not visible" was to remove the cell outline and fill with a white color so those fields are less obvious.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks. It works, but it makes the column really small since I cant control the width. Unless I put something in there which then will get picked up if you are in the actual cell or apply filter which then grabs that "blank" column since the text is there but not visible.
Any other ideas on how to widen this column out?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
I have the same problem , may you provide screens of where I can disable the column/rows outlines
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Its in your table tool -> default table settings.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
i changed the settings but its still stretched out for sheets that have for example only 3 columns
how were you able to fix this?
