tracker issue : CF-3039531

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

Bug 79243:When you supply the headerRow attribute to the cfspreadsheet tag, the header values are correctly read, but the row containing the headers remains in the data

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/

Reporter/Name(from Bugbase): Adam Tuttle / Adam Tuttle (Adam Tuttle)

Created: 08/03/2009

Components: Language, Tags

Versions: 9.0

Failure Type: Unspecified

Found In Build/Fixed In Build: 9,0,0,241018 /

Priority/Frequency: Trivial / Unknown

Locale/System: English / Win All

Vote Count: 4

Duplicate ID:	CF-3035868

Problem:

When you supply the headerRow attribute to the cfspreadsheet tag, the header values are correctly read, but the row containing the headers remains in the data. It should be omitted from the returned data set.
Method:

<cfspreadsheet action="read" src="#f#" query="data" headerrow="1" /><cfdump var="#data#">
Result:

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

Watson Bug ID:	3039531

External Customer Info:
External Company:  
External Customer Name: Adam Tuttle
External Customer Email: 71DA001D4586B5B5992015D5
External Test Config: 08/03/2009

Attachments:

Comments:

+1 for this. Ran into this giving a demo tonight.
Vote by External U.
23179 | November 10, 2011 06:57:50 PM GMT
This bug has been voted..
Vote by External U.
23180 | November 10, 2011 06:57:52 PM GMT
Header row data sould not be included in the results.
Vote by External U.
23181 | November 10, 2011 06:57:54 PM GMT
This bug has been voted..
Vote by External U.
23182 | November 10, 2011 06:57:55 PM GMT
This is supposedly a duplicate, but the bug number provided does not exist: https://bugbase.adobe.com/index.cfm?event=bug&id=CF-3035868 Regardless, I think this needs to be revisited. There will be the issue of backwards compatibility that many will cry about, so let's add a new attribute that defaults to the old behavior. How about "includeHeaderRow" which would default to true? Then, if I set it to false, my header row would not be included in the data.
Comment by External U.
23177 | September 15, 2014 07:09:56 PM GMT
@Adam, this tag has an attribute called excludeHeaderRow which does exactly the same. https://wikidocs.adobe.com/wiki/display/coldfusionen/cfspreadsheet
Comment by Rupesh K.
23178 | September 16, 2014 12:16:22 AM GMT