# Update a cell in a PowerTable without using "system.dataset.setValue()"

**URL:** <https://forum.inductiveautomation.com/t/update-a-cell-in-a-powertable-without-using-system-dataset-setvalue/38128>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [August 27, 2020, 1:41pm UTC](https://forum.inductiveautomation.com/t/update-a-cell-in-a-powertable-without-using-system-dataset-setvalue/38128 "2020-08-27T13:41:38Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![informatica](https://avatars.discourse-cdn.com/v4/letter/i/3ab097/32.png) [@informatica](https://forum.inductiveautomation.com/u/informatica)\
**Post date:** [August 27, 2020, 1:41pm UTC](https://forum.inductiveautomation.com/t/update-a-cell-in-a-powertable-without-using-system-dataset-setvalue/38128/1 "2020-08-27T13:41:38Z")

</div>

Good afternoon.

In Ignition **8.0.14** I need to update a cell by script in a _ **Power Table** _ without using “_**system.dataset.setValue()**_”.

I need this because I hide some rows in this way:  
…  
_JTable = PowerTable.getTable()_  
_JTable.setRowHeight(i, 0)_  
…

Then, if I after use “_system.dataset.setValue()_” to update a cell, the _Power Table_ is **reloaded** and the row height is reset to the “Row Height” property of the Power Table.  
So, I want to edit the value of a cell by script without losing the custom height of some rows.

Best Regards.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [August 27, 2020, 1:56pm UTC](https://forum.inductiveautomation.com/t/update-a-cell-in-a-powertable-without-using-system-dataset-setvalue/38128/2 "2020-08-27T13:56:20Z")

</div>

You can’t. The Power Table’s backing data model _is_ the dataset, and Ignition datasets are (generally) immutable, which is why you have to go through so many hoops to edit them.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [August 27, 2020, 2:32pm UTC](https://forum.inductiveautomation.com/t/update-a-cell-in-a-powertable-without-using-system-dataset-setvalue/38128/3 "2020-08-27T14:32:12Z")

</div>

What Paul said.

Consider setting a row filter in a propertyChange event for the table’s data.

---

<div class="post-metadata">

**Author:** ![informatica](https://avatars.discourse-cdn.com/v4/letter/i/3ab097/32.png) [@informatica](https://forum.inductiveautomation.com/u/informatica)\
**Post date:** [August 27, 2020, 3:31pm UTC](https://forum.inductiveautomation.com/t/update-a-cell-in-a-powertable-without-using-system-dataset-setvalue/38128/4 "2020-08-27T15:31:15Z")

</div>

Can you write a little example, please?

Thank you.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [August 27, 2020, 3:43pm UTC](https://forum.inductiveautomation.com/t/update-a-cell-in-a-powertable-without-using-system-dataset-setvalue/38128/5 "2020-08-27T15:43:32Z")

</div>

Start here:

> [@Script filtering on Power Table](http://forum.inductiveautomation.com/t/script-filtering-on-power-table/23673):
>
> Am I able to script the filtering functionality on a power table? I have a datasource (Sepasoft) that can’t be manipulated, and I would like to remove rows on condition. I can do this manually in runtime, but I’d like to be able to have the table load with this filter in place. Thanks

---

<div class="post-metadata">

**Author:** ![informatica](https://avatars.discourse-cdn.com/v4/letter/i/3ab097/32.png) [@informatica](https://forum.inductiveautomation.com/u/informatica)\
**Post date:** [August 27, 2020, 3:45pm UTC](https://forum.inductiveautomation.com/t/update-a-cell-in-a-powertable-without-using-system-dataset-setvalue/38128/6 "2020-08-27T15:45:46Z")

</div>

Thank you.