tracker issue : CF-3616845

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

SpreadSheetSetColumnWidth stops working after updating to ColdFusion 10 Update 11

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Claudio Cabete / Claudio Cabete (Claudio Cabete)

Created: 08/22/2013

Components: Document Management, Office Integration

Versions: 10.0

Failure Type: Incorrect w/Workaround

Found In Build/Fixed In Build: Final / CF10_Update14

Priority/Frequency: Major / All users will encounter

Locale/System: English / Mac 10 All,Win 2003 Server

Vote Count: 7

Problem Description:
SpreadSheetSetColumnWidth stops working after updating to ColdFusion 10 Update 11 
Steps to Reproduce:

<cfset 	SpreadSheetSetColumnWidth(theSheet, 1,10)>
<cfset 	SpreadSheetSetColumnWidth(theSheet, 2,15)>

Actual Result:

has to effect after updating CF to to update 11.

Expected Result:


Any Workarounds:

un-installed update 11 and started to work again.

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

Watson Bug ID:	3616845

Deployment Phase:	Release Candidate

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

Attachments:

Comments:

I can confirm this: With update 11 installed, SpreadsheetSetColumnWidth has no effect at all. After uninstalling update 11, SpreadsheetSetColumnWidth works as expected. I am running ColdFusion on Mac OS X 10.8.4.
Comment by External U.
14634 | September 10, 2013 05:03:58 AM GMT
I use SpreadsheetSetColumnWidth heavily in my applications (accounting stuff), and until this is fixed I really cannot apply update 11
Vote by External U.
14648 | September 10, 2013 05:04:49 AM GMT
I have been researching a workaround but no luck so far. It got the same result with poiSheet.setColumnWidth(). Until this is fixed I cannot apply update 11 either.
Comment by External U.
14635 | September 13, 2013 11:40:05 AM GMT
This is indeed reproducible On Cf 10 with update 11. I verified the same work-flow on a previous version - 9.0.2 and the spreadsheet created honors the parameters assigned in SpreadSheetSetColumnWidth() (Comment added from ex-user id:anjsriva)
Comment by Adobe D.
14636 | September 17, 2013 03:15:40 AM GMT
I'm seeing this as well. On workbooks with two sheets, SpreadsheetSetColumnWidth() seems to work as expected on the first sheet but not on the second.
Vote by External U.
14649 | September 30, 2013 08:24:30 PM GMT
I work with Nathan Mische (see previous vote).
Vote by External U.
14650 | October 01, 2013 07:11:52 AM GMT
This is still an issue up to update 13. I had to roll all the way back to update 10 as well to get this function to work again. I reinstalled 11, 12, and 13 one at a time to verify and each is broken. Security wise, I cannot run unpatched production servers on DOD hardware. Is there a hotfix available? Windows platform.
Comment by External U.
14637 | January 16, 2014 09:33:11 PM GMT
Reports don't match specs. This is an old bug that needs to be fixed.
Vote by External U.
14651 | January 16, 2014 09:34:26 PM GMT
This has been fixed and the fix will be available in the next update.
Comment by Rupesh K.
14638 | January 16, 2014 11:26:11 PM GMT
Installed update 13, and this is not fixed. I see Rupesh Kumar adds that it will be available in the next update (probably meaning the one after update 13?), while this page also states that it will be fixed in build 286553. Which makes no sense, since I have build 287689 after installing update 13…?
Comment by External U.
14639 | January 17, 2014 07:45:53 AM GMT
Hi, The update 13 is meant for users running ColdFusion 10 on Mac OSX As suggested on the Blog # http://blogs.coldfusion.com/post.cfm/coldfusion-10-update-13-released -- This update introduces support for OS X 10.9 Mavericks. It fixes the web server connector issue on OS X 10.9 reported as bug #CF-3653076. Users who are on OS X 10.9 or who plan to upgrade to 10.9 should apply this update. Users on other platforms need not apply this update. Please wait for the next update. Thanks, Anjaneai (Comment added from ex-user id:anjsriva)
Comment by Adobe D.
14640 | January 17, 2014 08:16:30 AM GMT
I am also encountering this issue. I have applied all available updates (currently update 13) with no resolution. Would appreciate more information about when to expect a fix
Vote by External U.
14652 | February 20, 2014 10:11:16 AM GMT
Please fix as soon as possible. It is impossible to generate useful excel documents without this feature.
Vote by External U.
14653 | March 05, 2014 04:22:27 AM GMT
fix verified with the cfmain build 288874. Win 7x64. closing this. test case checked in at: \depot\ColdFusion\qa\cf\regression\newmanual\coldfusion\functions\spreadsheet\SpreadSheetSetColumnWidth.cfm
Comment by Piyush K.
14641 | March 05, 2014 07:33:24 AM GMT
Client demands narrow columns in apps xls feature. Forced to downgrade to update 10. Concerned about security risks of this.
Vote by External U.
14654 | August 04, 2014 07:20:02 PM GMT
This bug is not fixed! spreashsheetSetColumnWidth works on (up-to, and including) CF10 update10. Broken on all updates from 11,12 and current 13. Using the POI library directly does not work either for setting column width. Tried updating POI to v3.6 (non-beta), 3.7, 3.10. None work! This feature is critical for my client as they have a super-wide xls that needs to print on one page. Leaving CF running on v10 is not an option as it leaves a large security hole un-patched (update 12)
Comment by External U.
14642 | August 04, 2014 08:30:32 PM GMT
Confirmed - this bug is NOT fixed. It is still an issue in 11, 12 and 13 as previously mentioned. Come on Adobe how long is this going to take? We can't keep giving excuses to our customers. Please at least offer a hotfix!
Comment by External U.
14643 | August 04, 2014 10:20:48 PM GMT
Ahh @rubytuby189 it looks like they are testing against a newer version than is available - I have 13 installed (latest - build 287689) and the build mentioned below appears to be 288874 - so we might be 1200 or so builds behind...@adobe can we assume that Update 14 will be available to the public soon?
Comment by External U.
14644 | August 04, 2014 10:27:30 PM GMT
yes, this will be included in the update 14.
Comment by Rupesh K.
14645 | August 05, 2014 05:24:01 AM GMT
Any idea when that will be Rupesh? I am desperate here! :)
Comment by External U.
14646 | August 05, 2014 04:07:47 PM GMT
The only solution now is to use coldfusion "wrap" method to achieve this. Apply the cell data with wrap method, you can see the cell width adjusted with the wrap length. This is a temp solution until there is a fix from adobe. Thank You
Comment by External U.
14647 | July 30, 2015 02:35:44 AM GMT