tracker issue : CF-3226517

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

SpreadsheetFormatRow() and SpreadSheetFormatCell() function are not working on CF9.0 server

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/

Reporter/Name(from Bugbase): Bill Song / Bill Song (Bill Song)

Created: 06/28/2012

Components: Document Management, Office Integration

Versions: 9.0

Failure Type: Non Functioning

Found In Build/Fixed In Build: 9.0 /

Priority/Frequency: Major / Some users will encounter

Locale/System: English / Windows 7 SP1

Vote Count: 0

Problem Description:
alignment="vertical_top" does not bring any result when use SpreadsheetFormatRow() and SpreadSheetFormatCell() function
Steps to Reproduce:
<cfscript>

    // note: "verticalalignment" property was added in 9.0.1

    sheet = SpreadsheetNew();

    spreadsheetSetCellValue(sheet, "AAA", 1, 1);

    spreadsheetSetRowHeight(sheet, 1, 25);

    spreadsheetFormatCell(sheet,{verticalalignment="vertical_top"},1,1);

    spreadSheetWrite(sheet, "c:/test.xls", true);

</cfscript>
Actual Result:
Nothing happened
Expected Results
text in spreadsheet cell or rows vertical align to top
Any Workarounds:

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

Watson Bug ID:	3226517

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

Attachments:

Comments:

spreadsheetFormatCell(sheet,{verticalalignment="vertical_top"},1,1); should be: spreadsheetFormatCell(sheet,{alignment="vertical_top"},1,1);
Comment by External U.
18838 | June 28, 2012 02:50:54 PM GMT
This is tested on CF Server 9,0,0,251028 which is not working, test on CF10 is working fine, people with CF 9.0.1 said it works as well.
Comment by External U.
18839 | June 29, 2012 06:57:11 AM GMT