class Reports::OfflineExporter::Cell
Constants
- ALPHABET
- CELL_COLUMNS
Attributes
Public Class Methods
Source
# 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
Source
# 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
Source
# 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
Public Instance Methods
Source
# 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