column_static_dropdown not producing dropdowns in selectable column

[charleyferrari]

column_static_dropdown not producing dropdowns in selectable column

[Marc-Andre-Rivet]

@charleyferrari You need to set type='dropdown' on the column, default is 'text', the column_static_dropdown will not override the type behavior

[cldougl]

@charleyferrari can you edit your example and see if that resolves the issue you're seeing?

[charleyferrari]

@Marc-Andre-Rivet @cldougl hmm... still not working for me.

Here's what I have:

import dash
from dash.dependencies import Input, Output, State

import dash_html_components as html
import dash_table

import pandas as pd

collist = ['one', 'two', 'three', 'category']
categories = ['Great', 'Good', 'Fair', 'Poor']

df = pd.DataFrame({i: [1, 2, 3, 4] if i != 'category'
                   else ['Great', 'Good', 'Poor', 'Fair']
                   for idx, i in enumerate(collist)})
df = df[collist]
df = df.values


app = dash.Dash()
app.css.config.serve_locally = True
app.scripts.config.serve_locally = True

app.layout = html.Div([
    dash_table.Table(
        id='table',
        dataframe=df,
        columns=[{'id': idx, 'name': i} if i != 'category'
                 else {'id': idx, 'name': i, 'type': 'dropdown'}
                 for idx, i in enumerate(collist)],
        editable=True,
        row_deletable=True,
        sorting=True,
        # Toggling this
        n_fixed_rows=1,
        column_static_dropdown=[{
            'id': 'bbb',
            'dropdown': [{'label': i, 'value': i} for i in categories]
        }],
        row_selectable='single'
    )
])


@app.callback(
    Output('table', 'dataframe'),
    [Input('table', 'dataframe_timestamp')],
    [State('table', 'dataframe')]
)
def table_it(df_ts, df):
    print('called it')
    return df


if __name__ == '__main__':
    app.run_server(debug=True)

The only change being columns = [..., where I added the dropdown key for category.

I'll continue troubleshooting to make sure I'm not missing something.

[Marc-Andre-Rivet]

@charleyferrari As discussed outside this thread, column_static_dropdown 'id' needs to match the column ids above.

[charleyferrari]

@Marc-Andre-Rivet Thanks, it's working for me, so this can be closed out.