RELATED IDEAS
Locked Column Width
Currently, reports will try to fit the content which is desirable in most cases, but I'd like to be able to "lock" a width for specified columns and keep it the size that is set in the template so that it does not resize when running the report.
Hi Peter,
Thanks for your input! Just to make sure I'm understanding, you're saying that you currently add something to the top of the report to make the columns all be the same size, but you want to know how to hide that row (or column), is that correct?
If so, you can use our Cosmos "Hide" function to do that. We have details here:
https://support.cosmosdatatech.com/hc/en-us/articles/26241280286349-How-to-Conditionally-Hide-Rows-Columns-or-Sheets
I hope this helps, let me know if I missed something or if you were referring to something else.
I found if I add a value (usually up to the max size that I would want the column to be) to the first cell of the column and then add the same value to the corresponding first cell of the row and then adjust the sizing, when I run the report, it'll preserve the column width and height unless the column has a value that exceeds the value I included.
I would also hide the top row and first column to hide these placement values.
This worked for a report that needed to have an expanding column.