Title:
SpreadsheetAddFreezePane does not occur when a spreadsheet object is added to an existing file
| View in TrackerStatus/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Robert Mann / Robert Mann (Robert Mann)
Created: 04/25/2013
Components: Document Management, Office Integration
Versions: 10.0
Failure Type: Incorrect w/Workaround
Found In Build/Fixed In Build: 285562 / 288992
Priority/Frequency: Major / Some users will encounter
Locale/System: English / Win 2008 Server R2 64 bit
Vote Count: 0
Problem Description:
SpreadsheetAddFreezePane does not occur when a spreadsheet object is added to an existing file using action = update.
It only gets applied when the action = write.
Steps to Reproduce:
Create two speadsheet objects via SpreadsheetNew ()
- objSheetSummary
- objSheetDetails
Populate each speadsheet object with queries.
SpreadsheetAddFreezePane(objSheetSummary, 0, 1) ;
SpreadsheetAddFreezePane(objSheetDetails, 0, 1) ;
Use tag, cfspreadsheet, action = write to create the file and the first sheet (objSheetSummary).
Use following tag, cfspreadsheet, action = update to add the sheet (objSheetDetails) to file previously "written" with objSheetSummary.
Actual Result:
The sheet for summary has a freeze pane so the first row is locked.
The sheet for details has no freeze pane.
Expected Result:
The sheet for summary has a freeze pane so the first row is locked.
The sheet for details has a freeze pane so the first row is locked.
Any Workarounds:
None. I tested by switching the order of the sheets; whereby, I assume the action = update is at the fault since it would only work when action = write.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3549922
External Customer Info:
External Company:
External Customer Name: heisrmann
External Customer Email:
External Test Config: My Hardware and Environment details:
Windows Server 2008 R2
ColdFusion 10,283649
OpenOffice 3.4.1Attachments:
Comments: