tracker issue : CF-3158250

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

CFSPREADSHEET.spreadSheetFormatRow not re-setting bold and italic to no/false

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): / ext-user (Viny Nigam)

Created: 04/05/2012

Components: Document Management, Office Integration

Versions: 10.0

Failure Type:

Found In Build/Fixed In Build: 282234 / CF11 Update5,CF10 Update16

Priority/Frequency: Major / Some users will encounter

Locale/System: English / Mac 10 All,Win XP All

Vote Count: 0

Listed in the version 11.0.05.293506 Issues Fixed doc 
Problem:
spreadSheetFormatRow not re-setting bold and italic to no/false

Method:
See notes

SingleSheet.xls attached

<cfspreadsheet action="read" src="#dirname#SingleSheet.xls" name="excelVar" >

<cfset format= StructNew()>
<cfset format.font="courier">
<cfset format.size="20">
<cfset format.color="BLUE">
<cfset format.bold="true">
<cfset format.italic="true">
<cfset format.underline="true">
<cfset format.strikeout ="true">
<cfset spreadsheetFormatRow(excelVar,format,"1")> 
<cfset spreadsheetFormatRow(excelVar,format,"3")> 
<cfset spreadsheetFormatColumn(excelVar,format,1)>
<cfset spreadsheetFormatCell(excelVar,format,2,2)> 
<!----- Added these steps as a part of fix of bug 72499------>
<cfset format.bold="false">
<cfset format.italic="no">
<cfset format.underline="no">
<cfset format.strikeout ="false">
<cfset spreadsheetFormatRow(excelVar,format,"3")> 

<cfspreadsheet action="write" filename="#dirname#SingleSheet1.xls"  name="excelVar" overwrite="true" >


Result:

Sheet=1, row=3 is bold and underlined

Expected:

Verify that at Sheet=1, row=3 is having following formatting:
font ="courier"
color=Blue 
Bold="false" 
Italic="false"
underlined="false" 
Strikethrough="false"

Workaround:

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

Watson Bug ID:	3158250

External Customer Info:
External Company:  
External Customer Name:  
External Customer Email:

Attachments:

Comments:

Can you check if it still exist?
Comment by Uday O.
19782 | July 01, 2014 01:00:31 AM GMT
bug verified with CF11 HF3 build 11,0,03,291742 issue with the methods: spreadsheetFormatRow, spreadsheetFormatColumn, spreadsheetFormatCell. Bold and underline attributes are not reset to false with a second call to these methods. Other format attributes like italic, strikeout, font name color and size are reset. test code: <cfspreadsheet action="read" src="#expandpath("./")#SingleSheet.xlsx" name="excelVar" > <cfset format= StructNew()> <cfset format.font="courier"> <cfset format.size="20"> <cfset format.color="BLUE"> <cfset format.bold="true"> <cfset format.italic="true"> <cfset format.underline="true"> <cfset format.strikeout ="true"> <cfset spreadsheetFormatRow(excelVar,format,"1")> <cfset spreadsheetFormatRow(excelVar,format,"3")> <cfset spreadsheetFormatColumn(excelVar,format,1)> <cfset spreadsheetFormatCell(excelVar,format,2,2)> <cfset format.font="arial"> <cfset format.size="10"> <cfset format.color="red"> <cfset format.bold="false"> <cfset format.italic="no"> <cfset format.underline="no"> <cfset format.strikeout ="false"> <cfdump var=#format#> <cfset spreadsheetFormatRow(excelVar,format, 3)> <cfset spreadsheetFormatColumn(excelVar,format, 1)> <cfset spreadsheetFormatCell(excelVar,format, 2, 2 )> <cfspreadsheet action="write" filename="#expandpath("./")#SingleSheet1.xlsx" name="excelVar" overwrite="true" >
Comment by Piyush K.
19783 | October 21, 2014 04:07:06 AM GMT
The fix for this bug is available in the pre-release build of ColdFusion 11 Update 5 and ColdFusion 10 Update 16
Comment by CFwatson U.
19784 | February 20, 2015 09:24:22 AM GMT
I updated to CF10u16 and am encountering a crash when using spreadsheetFormatRow() using JVM1.7u80. (This function should work with all versions of 1.7 right?) This bug should be re-opened and is connected to the one I just reported. https://bugbase.adobe.com/index.cfm?event=bug&id=CF-3981800
Comment by External U.
19785 | May 05, 2015 10:25:17 AM GMT
Verified this is fixed in CF11 Update 5 (build 11,0,05,293506). Thanks!, -Aaron
Comment by External U.
19786 | September 04, 2015 10:42:31 PM GMT