| View previous topic :: View next topic |
| Author |
Message |
dfargo5133
Newbie
Joined: 14 Feb 2010
Posts: 4
|
 Posted: Tue May 17, 2011 7:29 am Post subject: Clearing data in data entery cells |
 |
|
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 |
|
 |
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8979
Location: Lexinton, Kentucky, USA
|
| Posted: Tue May 17, 2011 7:59 am Post subject: |
|
|
| Just entering new data in a cell deletes the old data. |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Tue May 17, 2011 8:12 am Post subject: |
|
|
Organize your input values in scenarios. Add one empty scenario with property "Copy Back" unchecked.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
dfargo5133
Newbie
Joined: 14 Feb 2010
Posts: 4
|
| Posted: Tue May 17, 2011 8:25 am Post subject: |
|
|
| 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 |
|
|
|
