# Power Table oldValue and newValue

**URL:** <https://forum.inductiveautomation.com/t/power-table-oldvalue-and-newvalue/14158>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [April 28, 2017, 1:58am UTC](https://forum.inductiveautomation.com/t/power-table-oldvalue-and-newvalue/14158 "2017-04-28T01:58:47Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![TimE](https://avatars.discourse-cdn.com/v4/letter/t/ee59a6/32.png) [@TimE](https://forum.inductiveautomation.com/u/TimE)\
**Post date:** [April 28, 2017, 1:58am UTC](https://forum.inductiveautomation.com/t/power-table-oldvalue-and-newvalue/14158/1 "2017-04-28T01:58:47Z")

</div>

I am using the onCellEdited extension function in a column with all none values.

```auto
	print "oldValue = ",oldValue
	print "newValue = ",newValue	

```

If I click on a cell but do not change anything it still changes the value to 0.0.

The oldValue is None and the newValue is 0.0.

How can I prevent 0.0 from being entered. I only want 0 if they enter it.

Thanks

---

<div class="post-metadata">

**Author:** ![richardNZ15](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/richardnz15/32/33373_2.png) [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\
**Post date:** [April 28, 2017, 8:05am UTC](https://forum.inductiveautomation.com/t/power-table-oldvalue-and-newvalue/14158/2 "2017-04-28T08:05:46Z")

</div>

Something like this should do the trick:

```auto
	if newValue == 0:
		newValue = None
	self.data = system.dataset.setValue(self.data, rowIndex, colIndex, newValue)

```

**Edit** : Sorry didn't read this part.

> I only want 0 if they enter it.