Post Reply 
Clear data in a Spreadsheet by programming means
03-12-2015, 07:30 PM
Post: #1
Clear data in a Spreadsheet by programming means
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?
Find all posts by this user
Quote this message in a reply
03-12-2015, 09:31 PM (This post was last modified: 03-12-2015 09:35 PM by Thomas_Sch.)
Post: #2
RE: Clear data in a Spreadsheet by programming means
did you try this?
C1:F9999:="" or C1:F9999:={{}}
You can also execute this in the program of the spreadsheet app.

(found at http://www.hpmuseum.org/forum/thread-705...ml#pid5187
and http://www.hpmuseum.org/forum/thread-705...ml#pid5223)
Find all posts by this user
Quote this message in a reply
03-13-2015, 05:28 AM
Post: #3
RE: Clear data in a Spreadsheet by programming means
Honest to God, I thought I had searched the site and had actually tried what you have suggested.
Obviously, I had my head up my kazoo.

It works fine and you have my sincere gratitude.
Come here so I can give you a big hug.
Excellent.
Find all posts by this user
Quote this message in a reply
Post Reply 




User(s) browsing this thread: 1 Guest(s)