Using Numbers V 3.6.1 and trying to clear content of cells, and keep the formula from a previous spreadsheet.
Running 10.11.3 on my mac and tried selecting a row of cells and from file menu hit delete. All cells I selected
cleared. I tested the row with data and none of the cells that had formulas worked.
iMac, OS X Mavericks (10.9.2)
only clear the cells that are inputs to the formula.
Hard to provide more specific guidance without specific details. Posting screenshots is always helpful
ragu1086 wrote:
trying to clear content of cells, and keep the formula
A short script can clear all the content in a selected range of cells except formulas, which are left intact.
It's always best to make a copy of your work before performing an operation like this, just in case you do the wrong thing or change your mind.
SG
tell application "Numbers"
tell front document to tell active sheet
tell (first table whose selection range's class is range)
set selRng to selection range
repeat with aCell in selRng's cells
tell aCell to if its formula is missing value then ¬
set its value to ""
end repeat
end tell
end tell
end tell
Hi ragu1086,
Keep your Input table separate from your Result table.
Then you can delete values in the Input table without deleting the formulas in the Result table.
Another safeguard, lock the Result table (Menu > Arrange > Lock) to prevent accidental deletion of formulas.
Save as Template for future use.
Regards,
Ian.
clear content in cell without loosing formula
