class Reports::OfflineExporter::Cell

# File app/lib/reports/offline_exporter.rb, line 628
def self.default_style_for(type)
  if type == :date
    { format_code: "dd/mm/yyyy" }
  else
    {}
  end
end

# File app/lib/reports/offline_exporter.rb, line 617
def self.default_type_for(value)
  case value
  when Date
    :date
  when Integer
    :integer
  else
    :string
  end
end

# File app/lib/reports/offline_exporter.rb, line 575
def initialize(
  value = "",
  type: nil,
  style: {},
  allowed_values: [],
  allowed_formula: nil
)
  @value = value
  @type = type || Cell.default_type_for(value)
  @style = Cell.default_style_for(@type).merge(style)
  @allowed_values = allowed_values
  @allowed_formula = allowed_formula
end

# File app/lib/reports/offline_exporter.rb, line 592
def add_data_validation_to(sheet:, column_index:, row_index:)
  return if allowed_values.blank? && allowed_formula.blank?

  cell = "#{CELL_COLUMNS[column_index]}#{row_index + 1}"
  formula1 =
    if allowed_values.present?
      "\"#{allowed_values.join(", ")}\""
    elsif allowed_formula.present?
      "=#{allowed_formula}"
    end

  sheet.add_data_validation(
    cell,
    type: :list,
    formula1:,
    hideDropDown: 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"
  )
end