03-12-2015, 07:30 PM
There appears to be no way to Clear a Column (or Row) of data in a Spreadsheet by programming means.
So now I am required to write a Zero to each Cell in the Column, 1-10,000 Rows.
I have 6 columns.
Takes several minutes on the Prime.
You can do this directly in the Spreadsheet App.
It does it in an instant.
However, there really needs to be a way to do it programatically.
Needs to include a "Range" ability.
ex. Spreadsheet.Clear(A1:C10)
or better for programming and absolutely preferable
Spreadsheet.Clear(1,1,3,10)
not really needed but could have for convenience:
Clear a Column (say A)
Spreadsheet.Clear(0,1,0,0)
Clear a Row (say 2)
Spreadsheet.Clear(2,0,0,0)
Any thoughts or is this a new feature request?
So now I am required to write a Zero to each Cell in the Column, 1-10,000 Rows.
I have 6 columns.
Takes several minutes on the Prime.
You can do this directly in the Spreadsheet App.
It does it in an instant.
However, there really needs to be a way to do it programatically.
Needs to include a "Range" ability.
ex. Spreadsheet.Clear(A1:C10)
or better for programming and absolutely preferable
Spreadsheet.Clear(1,1,3,10)
not really needed but could have for convenience:
Clear a Column (say A)
Spreadsheet.Clear(0,1,0,0)
Clear a Row (say 2)
Spreadsheet.Clear(2,0,0,0)
Any thoughts or is this a new feature request?