Skip to Content
Former Member
Oct 23, 2009 at 08:49 AM

Excel Export: Make column width same as largest cell value of that column



I´m using CR2008 SP2 to export reports with a dynamic number of fields to a number of formats, including excel. I have enabled CanGrow on all fields and this is working in the sence that when a value exceeds width of cell, it increases the size of the cell vertically and continues there. I would very much prefer the functionality of "dubbelclicking" a column border in excel to make it as wide as the largest value therein. That is, increasing cellsize horizontally instead of vertically. Is this possible to achieve?