tracker issue : CF-4066259

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

[ANeff] Bug for: spreadsheetSetCellValue() not adding necessary rows

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/DesignLimitation

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

Created: 09/29/2015

Components: Document Management, Office Integration

Versions: 11.0

Failure Type:

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Normal / Some users will encounter

Locale/System: English / Win XP All

Vote Count: 1

spreadsheetSetCellValue() adds necessary columns (good) but does not add necessary rows (bad).

Steps to reproduce:

1) Run this:

<cfscript>
  mySpreadsheet = spreadsheetNew("mySheet", false);
  spreadsheetSetCellValue(mySpreadsheet, "row 3 column 6", 3, 6);
  spreadsheetWrite(mySpreadsheet, expandPath("./myspreadsheet.xls"), "", true);
  cfspreadsheet(action="read", src=expandPath("./myspreadsheet.xls"), query="q");
  writeOutput('Rows: ' & q.RecordCount & ' Columns: ' & listLen(q.ColumnList));
  cfspreadsheet(action="read", src=expandPath("./myspreadsheet.xls"), query="q");
  writeDump(var=q, format="text");
</cfscript>

Actual result:
- displays "Rows: 1 Columns: 6"
- dump shows "row 3 column 6" was placed in row 1 column 6

Expected result:
- displays "Rows: 3 Columns: 6"
- dump should show "row 3 column 6" placed in row 3 column 6

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

Watson Bug ID:	4066259

External Customer Info:
External Company:  
External Customer Name: Aaron Neff
External Customer Email:  
External Test Config: Verified in CF11 Update 5 (build 11,0,05,293506)

Attachments:

Comments:

Vote must be between 25 and 4000 characters
Vote by External U.
5695 | September 30, 2015 10:55:19 AM GMT
Hi , We did analyze this issue. POI returns the row which has got the data, in our example data starts from row 3. On POI we call getfirstRowNo. which returns the index of first non empty row, which is 3rd row. With the the row index we call sheet.getRow(rownum), even if we pass 0 as rownum POI returns null.This is a limitation of POI Library.
Comment by Mayur J.
5689 | October 29, 2015 04:37:49 AM GMT
Hi Mayur, Thank you for explaining its a bug in POI. I see this ticket is Open/To Test/ThirdParty, thanks. I will just watch this one. Thanks again!, -Aaron
Comment by External U.
5690 | October 29, 2015 08:51:54 PM GMT
Mayur, have we raised a bug with POI, and if so, do we have a bug number in their tracking system? May be we can attach that here for reference.
Comment by Vamseekrishna N.
5691 | November 02, 2015 08:08:48 AM GMT
+1 to Vamsee's question. Could the POI ticket# be attached here so it isn't lost track of? Thanks!, -Aaron
Comment by External U.
5692 | December 04, 2015 06:04:53 AM GMT
Hi Adobe, I see the status is currently "To Test/HaveNewInfo". Will the expected result be the same as described in the description? Thanks!, -Aaron
Comment by Aaron N.
5693 | July 27, 2017 06:24:43 PM GMT
withdrawing this. Apache says this is an efficient and intended behavior. https://bz.apache.org/bugzilla/show_bug.cgi?id=61343
Comment by Piyush K.
5694 | February 04, 2018 05:45:29 AM GMT