tracker issue : CF-3819363

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

cfspreadsheet generated issues with "Format Cells..."

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/CannotReproduce

Reporter/Name(from Bugbase): Miguel Arvelo / Miguel Arvelo (Miguel Arvelo)

Created: 09/05/2014

Components: Document Management, Office Integration

Versions: 10.0

Failure Type:

Found In Build/Fixed In Build: Final /

Priority/Frequency: Normal / All users will encounter

Locale/System: English / Linux All

Vote Count: 0

Problem Description:Spreadsheets generated using the CF10 spreadsheet functions will not let the user to make changes in the format of the cell by using the "Format Cells..." option in MS Excel.  The option works on cells not generated by the CF functions (cells with no data except cells adjacent to the ones with data).

Steps to Reproduce:Generate a spreadsheet using the CF functions and then try to change the data type or border style of any populated cell, the UI  just won't come up

Actual Result:The Format Cells UI won't come up

Expected Result:CF generated cells work as any other cell in Excel

Any Workarounds:

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

Watson Bug ID:	3819363

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


  1. September 05, 2014 00:00:00: 1_excel_format_cells_1.png


Miguel, I am unable to reproduce the issue with CF10 update 12 (on a Win 7x64). I am able to change the cell format after creating a spreadsheet. Here's the code I used. Can you pls. share the code with which you can reproduce the issue, in case you are using a different set of functions/tags. <cfset xl_qry = QueryNew("Name, Time, Advanced, day", "VarChar, Time, Bit, Date")> <cfset QueryAddRow(xl_qry, 2)> <cfset QuerySetCell(xl_qry, "Name", "The Wonderful World of CMFL", 1)> <cfset QuerySetCell(xl_qry, "Time", "9:15 AM", 1)> <cfset QuerySetCell(xl_qry, "Advanced", False, 1)> <cfset QuerySetCell(xl_qry, "day", dateFormat(now()), 1)> <cfset QuerySetCell(xl_qry, "Name", "CFCs for Enterprise Applications", 2)> <cfset QuerySetCell(xl_qry, "Time", "12:15 PM", 2)> <cfset QuerySetCell(xl_qry, "Advanced", True, 2)> <cfset QuerySetCell(xl_qry, "day", dateFormat(now()), 2)> <cfset xls_sheet = spreadsheetNew(false)> <cfset SpreadSheetAddRows(xls_sheet, xl_qry)> <cfset SpreadSheetWrite(xls_sheet, "#expandpath("./")#" & "output.xls", true)> <cfset xlsx_sheet = spreadsheetNew(true)> <cfset SpreadSheetAddRows(xlsx_sheet, xl_qry)> <cfset SpreadSheetWrite(xlsx_sheet, "#expandpath("./")#" & "output.xlsx", true)>
Comment by Piyush K.
11015 | September 09, 2014 01:30:05 AM GMT
Hi Piyush, I'm also unable to reproduce this (tried on CF10 Update 8 and CF11 Update 3). I am able to change the cell format using your example code. Thanks!, -Aaron
Comment by External U.
11016 | November 24, 2014 02:59:50 AM GMT
Thanks Aaron. Miguel, Closing this since the issue is not reproducible with the test case i my previous note. If you continue to face the issue please feel free to revert with a test case or with further details.
Comment by Piyush K.
11017 | December 03, 2014 03:43:46 AM GMT