tracker issue : CF-3963656

select a category, or use search below
(searches all categories and all time range)

spreadsheetWrite autosize Only On Active Sheet

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Christopher Tierney / Christopher Tierney (Christopher Tierney)

Created: 04/01/2015

Components: Document Management, Office Integration

Versions: 11.0

Failure Type:

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Normal / Unknown

Locale/System: English / Win 2008 Server R2 64 bit

Vote Count: 2

Listed in the version 2016.0.03.300466 Issues Fixed doc
Problem Description:
When saving a spreadsheet only the active sheet auto-sizes each column. All other sheet columns are not auto-sized.

Steps to Reproduce:
var sObj = spreadsheetNew( 'Live Shows', true );
spreadsheetAddRow( sObj, 'First Name, Last Name, Email, Phone, Signup');
spreadsheetCreateSheet( sObj, "Recorded Shows");
spreadsheetSetActiveSheet( sObj, "Recorded Shows");
spreadsheetAddRow( sObj, 'First Name, Last Name, Email, Phone, Signup');
spreadSheetWrite( sObj, expandPath('./visitorReport.xlsx'), true );

Actual Result:
'Recorded Shows' sheet columns are auto-sized, 'Live Shows' sheet is not.

Expected Result:
Both sheets should have auto-sized columns

Any Workarounds:

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3963656

External Customer Info:
External Company:  
External Customer Name: Christopher
External Customer Email:  
External Test Config: My Hardware and Environment details:

CF 11,0,04,293328

Java 1.8.0_25



+1 ......................
Vote by External U.
7943 | October 09, 2015 09:40:30 PM GMT
Thanks for the fix. When you know, please note the release that this will be sent out in.
Comment by External U.
7937 | October 13, 2015 09:55:54 AM GMT
Affects ColdFusion 10 Update 18 as well, please apply the fix to ColdFusion 10 too.
Comment by External U.
7938 | April 10, 2016 08:04:42 AM GMT
Legorol San, The autosize attribute was introduced with CF11, and hence is not applicable for CF10. Christopher, This fix is currently available with the current version of CF (2016 release).
Comment by Piyush K.
7939 | June 21, 2016 02:09:27 AM GMT
Piyush, Thanks for your comment, but it doesn't make sense. The autosize attribute was introduced in CF11 in order to give the option to *disable* autosizing. Up to CF10, autosizing *always* happens, but *only* on the first sheet. This bug affects CF10, and causes the first sheet and only the first sheet to autosize. This inconsistency is very hard to work around. Please consider back-porting the fix to CF10 as well.
Comment by External U.
7940 | June 21, 2016 05:49:30 AM GMT
@Piyush, ColdFusion 11 is still under support by Adobe. This fix also needs to be applied to ColdFusion 11 as well. I also agree with @Legorol that 10 needs to be taken care of.
Comment by External U.
7941 | June 21, 2016 05:16:14 PM GMT
Thanks Christopher / Legorol for pointing that out. I am marking this fix to be taken up in a future CF11 and CF10 update. We'll see how this works out for CF10.
Comment by Piyush K.
7942 | June 21, 2016 09:25:18 PM GMT