[Request] restart a spreadsheet

[Jsather]

(06-17-2014 05:30 AM)cyrille de brébisson Wrote:  The best that I can think of to do this would be A1:ZZ9999(-1):={}

The syntax "A1:ZZ9999(-1):={}" and variations referencing other cell ranges usually generate a "bad argument type" error in my attempts. As far as I'm concerned, fabila's very valid question remains unanswered: How can you clear cells of a spreadsheet from a program or Home screen command line?

Clearing would be the equivalent of selecting cells and pressing backspace. Cleared cells should take up no memory space and should return -1 when queried by Cell(R,C,-1). My own efforts to achieve this have been fruitless.