rtf - Oracle BI Publisher auto width of excel columns -

when creating bi publisher rdf template in microsoft word, intended output microsoft excel; there way specify table should use auto width columns in excel output.

by default, when use bi publisher desktop addin microsoft word; table wizard creates table in word not result in output excel columns in excel sized fit data. users of report have manually size excel columns every time run report.

i did try "autofit contents" in microsoft word, didn't work.

here go workaround: check part of rtf generates largest number of columns, let's header address , order info uses 4 columns, order items list uses 10. build whole document table 10 columns , many rows needed, including row every text line. fill in text, formulas, , fields cells never merge columns, let is, text exceed cell width excel recognizes there's no input in adjacent cells , displays text/sentences if single merged cell, although keeping interesting part tables in needed cells order. right click on table, properties, select fixed column width ( math: 22 page width, minus borders padding right , left, divided number of columns, here have target column width.. once done, excel fill should fine.

solution 2: build template in excel 1997-2003 xls, know it's hell of work adding cell cell, , output limited xls only, can fix printable area fit 1 page , fix columns width in same way explained. output @ least not change fit content , let tables messy. hope helps.