Oracle BI Publisher auto width of excel columns
When creating a BI Publisher rdf template in Microsoft Word, with intended output to Microsoft Excel; is there a way to specify that a table should use auto width for the columns in the Excel output.
By default, when you use the BI Publisher Desktop addin for Microsoft Word; the table wizard creates a table in Word that does not result in output to Excel where the columns in Excel is sized to fit the data. Users of the report then have to manually size the excel columns every time they run the report.
I did try "Autofit to Contents" in Microsoft Word, but it didn't work.
Answer
I have the same issue....But not all reports do it...The Columns have to be manually widened in this output, and the other output to excel allowed for a quick highlight "all columns" with the corner box click and then click once on the column lines and the auto-size, but this one will not. To matters worse it doesn't have this issue in the desktop viewer, it publishes perfectly when I use that Desktop Viewer tool (I do a lot of development offline)