Method: NtqExcelsior::Exporter#list_data_validation_for_column

Defined in:

lib/ntq_excelsior/exporter.rb

#list_data_validation_for_column(list_config) ⇒ Object

# File 'lib/ntq_excelsior/exporter.rb', line 199

def list_data_validation_for_column(list_config)
  if list_config.is_a?(Array)
    return {
      type: :list,
      formula1: "\"#{list_config.join(', ')}\""
    }
  end

  config = {
    type: :list,
    formula1: "\"#{list_config[:options].join(', ')}\"",
    showErrorMessage: list_config[:show_error_message] || false,
    showInputMessage: list_config[:show_input_message] || false,
  }

  if list_config[:show_error_message]
    config[:error] = list_config[:error] || ''
    config[:errorStyle] = list_config[:error_style] || :stop
    config[:errorTitle] = list_config[:error_title] || ''
  end

  if list_config[:show_input_message]
    config[:promptTitle] = list_config[:prompt_title] || ''
    config[:prompt] = list_config[:prompt] || ''
  end

  config
end