OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Clearing data in data entery cells

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
dfargo5133
Newbie
Newbie


Joined: 14 Feb 2010
Posts: 4

PostPosted: Tue May 17, 2011 7:29 am    Post subject: Clearing data in data entery cells Reply with quote

Is there a way to place a button on a sheet to clear data entry in some cells?
I have a spreed sheet to calculate cable TV signal levels in the home with amps and splitters and coax. I would like to be able to reset some of the data fields between calculations (example feet of cable).

In other words enter the data get the results reset and enter a new set of data and get the results.

Thanks

Dan
Back to top
View user's profile Send private message
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Tue May 17, 2011 7:59 am    Post subject: Reply with quote

Just entering new data in a cell deletes the old data.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Tue May 17, 2011 8:12 am    Post subject: Reply with quote

Organize your input values in scenarios. Add one empty scenario with property "Copy Back" unchecked.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
dfargo5133
Newbie
Newbie


Joined: 14 Feb 2010
Posts: 4

PostPosted: Tue May 17, 2011 8:25 am    Post subject: Reply with quote

JohnV wrote:
Just entering new data in a cell deletes the old data.


I have done that but forgot to change other cells which caused an error in my results.

Thanks anyway.

Dan
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group