tracker issue : CF-4205357

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

SpreadSheetRead() Does Not Read Past First Page

| View in Tracker

Status/Resolution/Reason: Open//

Reporter/Name(from Bugbase): Ray G. / ()

Created: 10/02/2019

Components: Language, Functions

Versions: 2018

Failure Type: Incorrectly functioning

Found In Build/Fixed In Build: 2018,0,01,314546 /

Priority/Frequency: Normal / All users will encounter

Locale/System: English / Win 2016

Vote Count: 0

Problem Description:
Function spreadSheetRead() and tag CFSpreadsheet with "read" action attribute

Steps to Reproduce:
local.returnObject = spreadSheetRead(test.cfm, "2");

Actual Result:
coldfusion.excel.Excel$ExcelInvalidSheetNameException: Specified sheet 2 is not valid. at coldfusion.excel.Excel.getExcelInfo( at coldfusion.excel.Excel.getExcelInfo( at coldfusion.runtime.CFPage.SpreadsheetRead( 

Expected Result:
Spreadsheet Object

Any Workarounds:
Use only value 1 for attribute sheetNumber and modify logic as necessary