tracker issue : CF-3950771

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

spreadsheetAddRow support array

| View in Tracker

Status/Resolution/Reason: To Fix//

Reporter/Name(from Bugbase): Raymond Camden / Raymond Camden (Raymond Camden)

Created: 03/10/2015

Components: Document Management, Office Integration

Versions: 11.0

Failure Type: Enhancement Request

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Minor / Unknown

Locale/System: English / Platforms All

Vote Count: 1

spreadsheetAddRow is pretty much unsafe to use with *any* dynamic data unless you first sanitize the data to not include commas. To correct this, allow this function to take an array as the first arg. You can keep this backwards compat too - just allow either a string or an array.

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

Watson Bug ID:	3950771

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

Attachments:

Comments:

Please make Platforms All the default for Platforms.
Comment by External U.
8111 | March 10, 2015 09:02:05 AM GMT
Please accept my vote which is between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters Vote must be between 25 and 4000 characters
Vote by External U.
8115 | March 10, 2015 09:05:14 AM GMT
We will pass the feedback to the team that manages the bugbase application with regards to making "Platforms All" as the default. Thanks!
Comment by Vamseekrishna N.
8112 | March 19, 2015 03:01:52 AM GMT
Raymond, for the sake of discussion, can you pls. dwell on the expected behavior of the spreadsheetAddRow method with the use of this hypothetical array parameter. Assuming that the array should be one dimensional, passing the array (say arr = ["A1" , "B1", "C1" ]) should add the elements to respective cells in a single row, in an excel file. Now if this array is to be ["A1" , "B1, B1.1", "C1" ], the method should populate the excel cell 'B1' with "B1,B1.1". This may stand at odds with the current behavior of SpreadsheetAddRows when using such an array.
Comment by Piyush K.
8113 | March 19, 2015 07:27:52 AM GMT
Can you explain how spreadsheetaddrows works with an array? I've only used it with a query. The docs say it is supported, but do not explain how it works, and your example below isn't clear. Given an array, if item N is a list, it does something special?
Comment by External U.
8114 | March 19, 2015 07:42:28 AM GMT