tracker issue : CF-4159299

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

[ANeff] Bug for: spreadsheet.formatCellRange() documented but not implemented

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Aaron Neff / Aaron Neff (Aaron Neff)

Created: 05/31/2016

Components: Document Management, Office Integration

Versions: 2016

Failure Type: Incorrect w/Workaround

Found In Build/Fixed In Build: CF2016_Final /

Priority/Frequency: Normal / Some users will encounter

Locale/System: English / Platforms All

Vote Count: 0

Listed in the version 2016.0.03.300466 Issues Fixed doc 
spreadsheet.formatCellRange() documented but not implemented

Steps to reproduce:

1) Run this:

<cfscript>
  q = queryNew("foo,bar,foobar", "", [[1,2,3],[4,5,6],[7,8,9],[10,11,12]]);
  ss = spreadsheetNew("mySheet");
  ss.addRows(q, 1, 1, true, [], true);
  spreadsheetFormatCellRange(ss, {color="grey_50_percent", strikeout=true}, 3, 1, 4, 3);//works (good)
  //ss.formatCellRange({color="grey_50_percent", strikeout=true}, 3, 1, 4, 3);//fails (bad)
  ss.write(expandPath("./myspreadsheet.xls"), true);
</cfscript>

Actual and expected result: spreadsheetFormatCellRange() works.

2) Run this:

<cfscript>
  q = queryNew("foo,bar,foobar", "", [[1,2,3],[4,5,6],[7,8,9],[10,11,12]]);
  ss = spreadsheetNew("mySheet");
  ss.addRows(q, 1, 1, true, [], true);
  //spreadsheetFormatCellRange(ss, {color="grey_50_percent", strikeout=true}, 3, 1, 4, 3);//works (good)
  ss.formatCellRange({color="grey_50_percent", strikeout=true}, 3, 1, 4, 3);//fails (bad)
  ss.write(expandPath("./myspreadsheet.xls"), true);
</cfscript>

Actual result: ss.formatCellRange() throws "The formatCellRange method was not found."

Expected result: ss.formatCellRange() should work like spreadsheetFormatCellRange().

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

Watson Bug ID:	4159299

External Customer Info:
External Company:  
External Customer Name: Aaron Neff
External Customer Email:

Attachments:

Comments: