tracker issue : CF-3673214

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

cfspreadsheet issue on java 1.7

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/CannotReproduce

Reporter/Name(from Bugbase): Craig Capodilupo / Craig Capodilupo (ccapodilupo)

Created: 11/21/2013

Components: Document Management, Office Integration

Versions: 10.0

Failure Type: Cosmetic Issue

Found In Build/Fixed In Build: Final /

Priority/Frequency: Normal / All users will encounter

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

Vote Count: 1

Problem Description: Column widths on 2nd tab of spreadhseet all same narrow width

Steps to Reproduce: Create a spreadsheet with a 2nd tab on CF using jvm 1.7

Actual Result: The column widths are all the same narrow width and you can't see most of the text in the cells

Expected Result: The columns width are set to fit the text nicely.

Any Workarounds: Run CF on jvm 1.6

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

Watson Bug ID:	3673214

External Customer Info:
External Company:  
External Customer Name: ccapodilupo
External Customer Email:  
External Test Config: My Hardware and Environment details: windows 2008 R2, CF 10 Update 12 Enterprise, 3 CF instances in a cluster

Attachments:

Comments:

unable to reproduce the issue with CF10 update 12 with Java 1.7.0_25 on Windows 7 x64. column width is the same in both the tabs. @ ccapodilupo, please suggest if you are following a different workflow, then what is in the script below: <cfset colList = "col1,col2,col3"> <cfset qryObj = QueryNew("#colList#")> <cfset rowCount = 5> <cfset QueryAddRow(qryObj, #rowCount#)> <cfloop from="1" to="#rowCount#" index="r"> <cfset QuerySetCell(qryObj, "col1", "col 1: A spreadsheet cell containing random text value.", r)> <cfset QuerySetCell(qryObj, "col2", "2012-10-17 10:21:15.720", r)> <cfset QuerySetCell(qryObj, "col3", "col 3: A spreadsheet cell containing random text value.", r)> </cfloop> <cfset basefile = "#ExpandPath(".")#\exl_file.xlsx" > <cfset basefile_qry = "#ExpandPath(".")#\exl_file_qry.xlsx" > <cfset ssobj = SpreadsheetNew("sheet1", true)> <cfset SpreadsheetAddRows(ssobj, qryObj)> <cfspreadsheet action="write" filename="#basefile#" name="ssobj" overwrite="true"> <cfspreadsheet action="update" filename="#basefile#" name="ssobj" sheetname="sheet2"> <cfspreadsheet action="write" filename="#basefile_qry#" query="qryObj" overwrite="true"> <cfspreadsheet action="update" filename="#basefile_qry#" query="qryObj" sheetname="sheet2">
Comment by Piyush K.
13916 | December 18, 2013 10:19:26 AM GMT
Have similar issue with CF 10 HF 12 with the cfspreadsheet action="read/write" messing up column formatting of original Excel format since HF 12. This should be looked at....please.
Vote by External U.
13918 | April 28, 2014 10:49:08 AM GMT
closing this. ccapodilupo, please revert with a test case if the issue exists.
Comment by Piyush K.
13917 | December 03, 2014 03:52:58 AM GMT