Can't edit datatable

[Marcus_Donnelly]

Hi,

I can’t seem to make a simple datatable editable. Code as follows:

from bokeh.models.widgets.tables import DataTable, TableColumn, IntEditor
from bokeh.models.layouts import WidgetBox
from bokeh.models import ColumnDataSource
from collections import OrderedDict
from bokeh.io import show

od = OrderedDict()
n = 5
od[‘A’] = range(n)
od[‘B’] = range(0,n2,2)
od[‘C’] = range(0,n3,3)
ds = ColumnDataSource(od)

cols =
for v in iter(od):
cols.append(TableColumn(title = v,field = v,editor = IntEditor(step=1)))

t = DataTable(source = ds,columns = cols,selectable = True,sortable = False,editable = True,
height=300,width=500,fit_columns=True)

show(WidgetBox(t))

The table appears OK but the cells can’t be edited. Double clicking on a cell will clear it but a value still can’t be entered.

Any help appreciated!

Thanks,
Marcus.

[avelo]

There is a reported bug about that in 0.12 :

Cannot edit cells in DataTable

awaiting updates…

···

El domingo, 10 de julio de 2016, 19:04:43 (UTC+2), Marcus Donnelly escribió:

Hi,

I can’t seem to make a simple datatable editable. Code as follows:

from bokeh.models.widgets.tables import DataTable, TableColumn, IntEditor
from bokeh.models.layouts import WidgetBox
from bokeh.models import ColumnDataSource
from collections import OrderedDict
from bokeh.io import show

od = OrderedDict()
n = 5
od[‘A’] = range(n)
od[‘B’] = range(0,n2,2)
od[‘C’] = range(0,n3,3)
ds = ColumnDataSource(od)

cols =
for v in iter(od):
cols.append(TableColumn(title = v,field = v,editor = IntEditor(step=1)))

t = DataTable(source = ds,columns = cols,selectable = True,sortable = False,editable = True,
height=300,width=500,fit_columns=True)

show(WidgetBox(t))

The table appears OK but the cells can’t be edited. Double clicking on a cell will clear it but a value still can’t be entered.

Any help appreciated!

Thanks,
Marcus.

[Marcus_Donnelly]

Thanks, that explains it!

···

On Tuesday, July 12, 2016 at 11:59:27 AM UTC+1, avelo wrote:

There is a reported bug about that in 0.12 :
https://github.com/bokeh/bokeh/issues/4616

awaiting updates…

El domingo, 10 de julio de 2016, 19:04:43 (UTC+2), Marcus Donnelly escribió:

Hi,

I can’t seem to make a simple datatable editable. Code as follows:

from bokeh.models.widgets.tables import DataTable, TableColumn, IntEditor
from bokeh.models.layouts import WidgetBox
from bokeh.models import ColumnDataSource
from collections import OrderedDict
from bokeh.io import show

od = OrderedDict()
n = 5
od[‘A’] = range(n)
od[‘B’] = range(0,n2,2)
od[‘C’] = range(0,n3,3)
ds = ColumnDataSource(od)

cols =
for v in iter(od):
cols.append(TableColumn(title = v,field = v,editor = IntEditor(step=1)))

t = DataTable(source = ds,columns = cols,selectable = True,sortable = False,editable = True,
height=300,width=500,fit_columns=True)

show(WidgetBox(t))

The table appears OK but the cells can’t be edited. Double clicking on a cell will clear it but a value still can’t be entered.

Any help appreciated!

Thanks,
Marcus.

[Marcus_Donnelly]

Hi,

This bug (see below) seems to have reappeared in 0.12.13. Should I file an issue or has someone already got it?

Thanks,
Marcus.

···

On Sunday, July 10, 2016 at 6:04:43 PM UTC+1, Marcus Donnelly wrote:

Hi,

I can’t seem to make a simple datatable editable. Code as follows:

from bokeh.models.widgets.tables import DataTable, TableColumn, IntEditor
from bokeh.models.layouts import WidgetBox
from bokeh.models import ColumnDataSource
from collections import OrderedDict
from bokeh.io import show

od = OrderedDict()
n = 5
od[‘A’] = range(n)
od[‘B’] = range(0,n2,2)
od[‘C’] = range(0,n3,3)
ds = ColumnDataSource(od)

cols =
for v in iter(od):
cols.append(TableColumn(title = v,field = v,editor = IntEditor(step=1)))

t = DataTable(source = ds,columns = cols,selectable = True,sortable = False,editable = True,
height=300,width=500,fit_columns=True)

show(WidgetBox(t))

The table appears OK but the cells can’t be edited. Double clicking on a cell will clear it but a value still can’t be entered.

Any help appreciated!

Thanks,
Marcus.

[Bryan]

There is already an issue on the next milestone:

  DataTable editing regression · Issue #7304 · bokeh/bokeh · GitHub

Thanks,

Bryan

···

On Dec 20, 2017, at 02:59, Marcus Donnelly <[email protected]> wrote:

Hi,

This bug (see below) seems to have reappeared in 0.12.13. Should I file an issue or has someone already got it?

Thanks,
Marcus.

On Sunday, July 10, 2016 at 6:04:43 PM UTC+1, Marcus Donnelly wrote:
Hi,

I can't seem to make a simple datatable editable. Code as follows:

from bokeh.models.widgets.tables import DataTable, TableColumn, IntEditor
from bokeh.models.layouts import WidgetBox
from bokeh.models import ColumnDataSource
from collections import OrderedDict
from bokeh.io import show

od = OrderedDict()
n = 5
od['A'] = range(n)
od['B'] = range(0,n*2,2)
od['C'] = range(0,n*3,3)
ds = ColumnDataSource(od)

cols =
for v in iter(od):
    cols.append(TableColumn(title = v,field = v,editor = IntEditor(step=1)))

t = DataTable(source = ds,columns = cols,selectable = True,sortable = False,editable = True,
              height=300,width=500,fit_columns=True)

show(WidgetBox(t))

The table appears OK but the cells can't be edited. Double clicking on a cell will clear it but a value still can't be entered.

Any help appreciated!

Thanks,
Marcus.

--
You received this message because you are subscribed to the Google Groups "Bokeh Discussion - Public" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit https://groups.google.com/a/continuum.io/d/msgid/bokeh/471c9d21-b724-42fe-81e5-b02d46229a77%40continuum.io\.
For more options, visit https://groups.google.com/a/continuum.io/d/optout\.

[Marcus_Donnelly]

Thanks Bryan.

···

On 20 Dec 2017 3:49 pm, “Bryan Van de ven” [email protected] wrote:

There is already an issue on the next milestone:

    [https://github.com/bokeh/bokeh/issues/7304](https://github.com/bokeh/bokeh/issues/7304)

Thanks,

Bryan

On Dec 20, 2017, at 02:59, Marcus Donnelly [email protected] wrote:

Hi,

This bug (see below) seems to have reappeared in 0.12.13. Should I file an issue or has someone already got it?

Thanks,

Marcus.

On Sunday, July 10, 2016 at 6:04:43 PM UTC+1, Marcus Donnelly wrote:

Hi,

I can’t seem to make a simple datatable editable. Code as follows:

from bokeh.models.widgets.tables import DataTable, TableColumn, IntEditor

from bokeh.models.layouts import WidgetBox

from bokeh.models import ColumnDataSource

from collections import OrderedDict

from bokeh.io import show

od = OrderedDict()

n = 5

od[‘A’] = range(n)

od[‘B’] = range(0,n*2,2)

od[‘C’] = range(0,n*3,3)

ds = ColumnDataSource(od)

cols =

for v in iter(od):

cols.append(TableColumn(title = v,field = v,editor = IntEditor(step=1)))

t = DataTable(source = ds,columns = cols,selectable = True,sortable = False,editable = True,

          height=300,width=500,fit_columns=True)

show(WidgetBox(t))

The table appears OK but the cells can’t be edited. Double clicking on a cell will clear it but a value still can’t be entered.

Any help appreciated!

Thanks,

Marcus.

–

You received this message because you are subscribed to the Google Groups “Bokeh Discussion - Public” group.

To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].

To post to this group, send email to [email protected].

To view this discussion on the web visit https://groups.google.com/a/continuum.io/d/msgid/bokeh/471c9d21-b724-42fe-81e5-b02d46229a77%40continuum.io.

For more options, visit https://groups.google.com/a/continuum.io/d/optout.

–

You received this message because you are subscribed to the Google Groups “Bokeh Discussion - Public” group.

To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].

To post to this group, send email to [email protected].

To view this discussion on the web visit https://groups.google.com/a/continuum.io/d/msgid/bokeh/B4ACB3E8-12DB-486D-8DF7-1284AD0CDBA1%40anaconda.com.

For more options, visit https://groups.google.com/a/continuum.io/d/optout.

[Jan_Burgy]

Still using 12.9 here so not experiencing this issue. I am, however, trying to achieve something very related: I’d like only a subset of my table’s columns to be editable. Setting editor to None or SelectEditor with no options doesn’t work. Any suggestions?

Thanks,

Jan

[Bryan]

Hi,

It looks like if you don't specify any editor, which is currently equivalent to setting None in this situation, then a StringEditor is used by default. It might be reasonable to add a column-specific "editable" flag to TableColumn to override the global one on DataTable. Or to make it so None has that effect. But that would be new development, so a GitHub feature request issue would be the appropriate next step. In the mean time, I think the only option would be to make a custom extension that subclasses CellEditor to make it a "not editor". If you are interested in pursuing that idea I can point to additional resources.

Thanks,

Bryan

···

On Dec 22, 2017, at 10:06, Jan Burgy <[email protected]> wrote:

Still using 12.9 here so not experiencing this issue. I am, however, trying to achieve something very related: I'd like only a subset of my table's columns to be editable. Setting editor to None or SelectEditor with no options doesn't work. Any suggestions?

Thanks,

Jan

--
You received this message because you are subscribed to the Google Groups "Bokeh Discussion - Public" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit https://groups.google.com/a/continuum.io/d/msgid/bokeh/46e8107d-6f53-4c45-a7e2-0824a4fa743a%40continuum.io\.
For more options, visit https://groups.google.com/a/continuum.io/d/optout\.

[Marcus_Donnelly]

Hi Bryan,

I think this bug may have reappeared in 0.12.15 in a different form. The same code as previously used in this thread (replicated below) results in cells which can be edited by double-clicking but the value isn’t stored when pressing enter. Also having clicked on one cell I can’t change to another. The browser console JS log shows the error: ‘TypeError: n is undefined’. I’m using Bokeh 0.12.15 with Python 3.5.2 and Firefox 59.0.2 (64-bit) on Ubuntu Mate 16.04.4 LTS.

Thanks,
Marcus.

from bokeh.models.widgets.tables import DataTable, TableColumn, IntEditor
from bokeh.models.layouts import WidgetBox
from bokeh.models import ColumnDataSource
from collections import OrderedDict
from bokeh.io import show

od = OrderedDict()
n = 5
od[‘A’] = range(n)
od[‘B’] = range(0, n2, 2)
od[‘C’] = range(0, n3, 3)
ds = ColumnDataSource(od)

cols =
for v in iter(od):
cols.append(TableColumn(title=v, field=v, editor=IntEditor(step=1)))

t = DataTable(source=ds, columns=cols, selectable=True, sortable=False,
editable=True, height=300, width=500, fit_columns=True)

show(WidgetBox(t))

``

[Bryan]

Hi,

This bug happened during the typescript port. It was fixed in

https://github.com/bokeh/bokeh/pull/7737

And merged to master a few days ago. I’m on a plane now but going to get a Dev Build out tonight.

Thanks,

Bryan

···

On Apr 5, 2018, at 08:27, Marcus Donnelly [email protected] wrote:

Hi Bryan,

I think this bug may have reappeared in 0.12.15 in a different form. The same code as previously used in this thread (replicated below) results in cells which can be edited by double-clicking but the value isn’t stored when pressing enter. Also having clicked on one cell I can’t change to another. The browser console JS log shows the error: ‘TypeError: n is undefined’. I’m using Bokeh 0.12.15 with Python 3.5.2 and Firefox 59.0.2 (64-bit) on Ubuntu Mate 16.04.4 LTS.

Thanks,
Marcus.

from bokeh.models.widgets.tables import DataTable, TableColumn, IntEditor
from bokeh.models.layouts import WidgetBox
from bokeh.models import ColumnDataSource
from collections import OrderedDict
from bokeh.io import show

od = OrderedDict()
n = 5
od[‘A’] = range(n)
od[‘B’] = range(0, n2, 2)
od[‘C’] = range(0, n3, 3)
ds = ColumnDataSource(od)

cols =
for v in iter(od):
cols.append(TableColumn(title=v, field=v, editor=IntEditor(step=1)))

t = DataTable(source=ds, columns=cols, selectable=True, sortable=False,
editable=True, height=300, width=500, fit_columns=True)

show(WidgetBox(t))

``

–

You received this message because you are subscribed to the Google Groups “Bokeh Discussion - Public” group.

To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].

To post to this group, send email to [email protected].

To view this discussion on the web visit https://groups.google.com/a/continuum.io/d/msgid/bokeh/5b561139-09d9-4722-a02e-de366cba68d0%40continuum.io.

For more options, visit https://groups.google.com/a/continuum.io/d/optout.

[Marcus_Donnelly]

Thanks for the speedy (and high altitude) response!

Marcus.

[joannajiang]

Hey all! I’m also running into this DataTable edit issue in 12.15 where I can type into one cell only but not execute a change in the source or click into another cell. Wondering if there’s any update on this thread / if it’s still a bug?

···

On Thursday, 5 April 2018 17:35:15 UTC+2, Bryan Van de ven wrote:

Hi,

This bug happened during the typescript port. It was fixed in

https://github.com/bokeh/bokeh/pull/7737

And merged to master a few days ago. I’m on a plane now but going to get a Dev Build out tonight.

Thanks,

Bryan

On Apr 5, 2018, at 08:27, Marcus Donnelly [email protected] wrote:

Hi Bryan,

I think this bug may have reappeared in 0.12.15 in a different form. The same code as previously used in this thread (replicated below) results in cells which can be edited by double-clicking but the value isn’t stored when pressing enter. Also having clicked on one cell I can’t change to another. The browser console JS log shows the error: ‘TypeError: n is undefined’. I’m using Bokeh 0.12.15 with Python 3.5.2 and Firefox 59.0.2 (64-bit) on Ubuntu Mate 16.04.4 LTS.

Thanks,
Marcus.

from bokeh.models.widgets.tables import DataTable, TableColumn, IntEditor
from bokeh.models.layouts import WidgetBox
from bokeh.models import ColumnDataSource
from collections import OrderedDict
from bokeh.io import show

od = OrderedDict()
n = 5
od[‘A’] = range(n)
od[‘B’] = range(0, n2, 2)
od[‘C’] = range(0, n3, 3)
ds = ColumnDataSource(od)

cols =
for v in iter(od):
cols.append(TableColumn(title=v, field=v, editor=IntEditor(step=1)))

t = DataTable(source=ds, columns=cols, selectable=True, sortable=False,
editable=True, height=300, width=500, fit_columns=True)

show(WidgetBox(t))

``

–

You received this message because you are subscribed to the Google Groups “Bokeh Discussion - Public” group.

To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].

To post to this group, send email to [email protected].

To view this discussion on the web visit https://groups.google.com/a/continuum.io/d/msgid/bokeh/5b561139-09d9-4722-a02e-de366cba68d0%40continuum.io.

For more options, visit https://groups.google.com/a/continuum.io/d/optout.

[Bryan]

Several DataTable bugs have recently been fixed in master, so my first suggestion is for you to try out the latest dev build and see if things are fixed there for your case or not:

  Installation — Bokeh 0.12.3 documentation

Thanks,

Bryan

···

On Apr 23, 2018, at 09:25, joannajiang via Bokeh Discussion - Public <[email protected]> wrote:

Hey all! I'm also running into this DataTable edit issue in 12.15 where I can type into one cell only but not execute a change in the source or click into another cell. Wondering if there's any update on this thread / if it's still a bug?

On Thursday, 5 April 2018 17:35:15 UTC+2, Bryan Van de ven wrote:
Hi,

This bug happened during the typescript port. It was fixed in

    add missing return to cell editor view validate() by bryevdv · Pull Request #7737 · bokeh/bokeh · GitHub

And merged to master a few days ago. I'm on a plane now but going to get a Dev Build out tonight.

Thanks,

Bryan

On Apr 5, 2018, at 08:27, Marcus Donnelly <[email protected]> wrote:

Hi Bryan,

I think this bug may have reappeared in 0.12.15 in a different form. The same code as previously used in this thread (replicated below) results in cells which can be edited by double-clicking but the value isn't stored when pressing enter. Also having clicked on one cell I can't change to another. The browser console JS log shows the error: 'TypeError: n is undefined'. I'm using Bokeh 0.12.15 with Python 3.5.2 and Firefox 59.0.2 (64-bit) on Ubuntu Mate 16.04.4 LTS.

Thanks,
Marcus.

from bokeh.models.widgets.tables import DataTable, TableColumn, IntEditor
from bokeh.models.layouts import WidgetBox
from bokeh.models import ColumnDataSource
from collections import OrderedDict
from bokeh.io import show

od = OrderedDict()
n = 5
od['A'] = range(n)
od['B'] = range(0, n*2, 2)
od['C'] = range(0, n*3, 3)
ds = ColumnDataSource(od)

cols =
for v in iter(od):
    cols.append(TableColumn(title=v, field=v, editor=IntEditor(step=1)))

t = DataTable(source=ds, columns=cols, selectable=True, sortable=False,
              editable=True, height=300, width=500, fit_columns=True)

show(WidgetBox(t))

--
You received this message because you are subscribed to the Google Groups "Bokeh Discussion - Public" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bokeh+un...@continuum.io.
To post to this group, send email to bo...@continuum.io.
To view this discussion on the web visit https://groups.google.com/a/continuum.io/d/msgid/bokeh/5b561139-09d9-4722-a02e-de366cba68d0%40continuum.io\.
For more options, visit https://groups.google.com/a/continuum.io/d/optout\.

--
You received this message because you are subscribed to the Google Groups "Bokeh Discussion - Public" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit https://groups.google.com/a/continuum.io/d/msgid/bokeh/0b3bfbb6-5a87-4225-93cd-9a73f280946a%40continuum.io\.
For more options, visit https://groups.google.com/a/continuum.io/d/optout\.

[Bryan]

Or, to if you are sure it is the same issue you linked, then as stated yes it has been fixed, there has just not been a new full release with the fix yet.

Thanks,

Bryan

···

On Apr 23, 2018, at 09:25, joannajiang via Bokeh Discussion - Public <[email protected]> wrote:

Hey all! I'm also running into this DataTable edit issue in 12.15 where I can type into one cell only but not execute a change in the source or click into another cell. Wondering if there's any update on this thread / if it's still a bug?

On Thursday, 5 April 2018 17:35:15 UTC+2, Bryan Van de ven wrote:
Hi,

This bug happened during the typescript port. It was fixed in

    add missing return to cell editor view validate() by bryevdv · Pull Request #7737 · bokeh/bokeh · GitHub

And merged to master a few days ago. I'm on a plane now but going to get a Dev Build out tonight.

Thanks,

Bryan

On Apr 5, 2018, at 08:27, Marcus Donnelly <[email protected]> wrote:

Hi Bryan,

I think this bug may have reappeared in 0.12.15 in a different form. The same code as previously used in this thread (replicated below) results in cells which can be edited by double-clicking but the value isn't stored when pressing enter. Also having clicked on one cell I can't change to another. The browser console JS log shows the error: 'TypeError: n is undefined'. I'm using Bokeh 0.12.15 with Python 3.5.2 and Firefox 59.0.2 (64-bit) on Ubuntu Mate 16.04.4 LTS.

Thanks,
Marcus.

from bokeh.models.widgets.tables import DataTable, TableColumn, IntEditor
from bokeh.models.layouts import WidgetBox
from bokeh.models import ColumnDataSource
from collections import OrderedDict
from bokeh.io import show

od = OrderedDict()
n = 5
od['A'] = range(n)
od['B'] = range(0, n*2, 2)
od['C'] = range(0, n*3, 3)
ds = ColumnDataSource(od)

cols =
for v in iter(od):
    cols.append(TableColumn(title=v, field=v, editor=IntEditor(step=1)))

t = DataTable(source=ds, columns=cols, selectable=True, sortable=False,
              editable=True, height=300, width=500, fit_columns=True)

show(WidgetBox(t))

--
You received this message because you are subscribed to the Google Groups "Bokeh Discussion - Public" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bokeh+un...@continuum.io.
To post to this group, send email to bo...@continuum.io.
To view this discussion on the web visit https://groups.google.com/a/continuum.io/d/msgid/bokeh/5b561139-09d9-4722-a02e-de366cba68d0%40continuum.io\.
For more options, visit https://groups.google.com/a/continuum.io/d/optout\.

--
You received this message because you are subscribed to the Google Groups "Bokeh Discussion - Public" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit https://groups.google.com/a/continuum.io/d/msgid/bokeh/0b3bfbb6-5a87-4225-93cd-9a73f280946a%40continuum.io\.
For more options, visit https://groups.google.com/a/continuum.io/d/optout\.