Full-column Preserve Formatting in Excel Output

[EW]

Using the Output tool to send data to a formatted spreadsheet apparently doesn't preserve formatting if the entire column is formatted.  I'd love this changed to keep the formatting when its applied to an entire column.  See this thread in Designer Discussions. 

[grathmell]

This functionality is very much needed. Formatting columns is much more efficient than formatting a range of cells. Formatting ranges blows up the Excel file size, where-as column formatting does not.