'caxlsx_rails autoselect the first element of a dropdown

I am making use of the caxlsx_rails gem, and I am adding this dropdown:

sheet.add_data_validation("F6:F2000", {
    :type => :list,
    :formula1 => "=IFERROR(VLOOKUP(E6,Lista_de_novedades_disponibles!A$2:B$#{@select_novedades['novelty'].count+1},2,0),#{'"n/a"'})",
    :showDropDown => false,
    :showErrorMessage => true,
    :errorTitle => '',
    :error => 'Please use the dropdown selector to choose the value',
    :errorStyle => :stop,
    :showInputMessage => true,
    :prompt => 'Choose the value from the dropdown'
})

but I need the first item to be automatically selected without the user having to select it. is this possible?

ruby-on-railsrubyruby-on-rails-4axlsx


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions