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? |
|||
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) |
|||
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. |
|||
« Next Oldest | Next Newest »
|
User(s) browsing this thread: