class Xlsxrb::Elements::Cell

# File lib/xlsxrb/elements/cell.rb, line 433
def self.calculate_column_index(letter)
  letter.bytes.reduce(0) { |acc, b| (acc * 26) + (b - 64) } - 1
end

# File lib/xlsxrb/elements/cell.rb, line 398
def self.calculate_column_letter(index)
  result = +""
  i = index
  loop do
    result.prepend(("A".ord + (i % 26)).chr)
    i = (i / 26) - 1
    break if i.negative?
  end
  result
end

# File lib/xlsxrb/elements/cell.rb, line 447
def self.column_index(letter)
  if letter.is_a?(Integer)
    raise ArgumentError, "Column index must be >= 0, got #{letter}" if letter.negative?

    return letter
  end

  str = letter.to_s
  if str.match?(/\A-?\d+\z/)
    val = str.to_i
    raise ArgumentError, "Column index must be >= 0, got #{val}" if val.negative?

    return val
  end

  raise ArgumentError, "Invalid column letter: #{letter.inspect}" unless str.match?(/\A[a-zA-Z]+\z/)

  calculate_column_index(str.upcase)
end

# File lib/xlsxrb/elements/cell.rb, line 422
def self.column_letter(index)
  raise ArgumentError, "Column index must be a non-negative Integer, got #{index.inspect}" unless index.is_a?(Integer) && index >= 0

  @column_letters[index] || calculate_column_letter(index)
end

# File lib/xlsxrb/elements/cell.rb, line 51
def self.fast_create(row_index, column_index, value, style_index = nil, formula = nil, raw_value = nil, format_code = nil, date1904 = false)
  inst = allocate
  inst.instance_variable_set(:@row_index, row_index)
  inst.instance_variable_set(:@column_index, column_index)
  inst.instance_variable_set(:@value, value)
  inst.instance_variable_set(:@formula, formula)
  inst.instance_variable_set(:@style_index, style_index)
  inst.instance_variable_set(:@unmapped_data, EMPTY_HASH)
  inst.instance_variable_set(:@errors, EMPTY_ERRORS)
  inst.instance_variable_set(:@hyperlink, nil)
  inst.instance_variable_set(:@comment, nil)
  inst.instance_variable_set(:@raw_value, raw_value)
  inst.instance_variable_set(:@format_code, format_code)
  inst.instance_variable_set(:@date1904, date1904 ? true : false)
  inst
end

# File lib/xlsxrb/elements/cell.rb, line 34
def initialize(row_index:, column_index:, value: nil, formula: nil, style_index: nil, unmapped_data: EMPTY_HASH, errors: nil, hyperlink: nil, comment: nil, raw_value: nil, format_code: nil, date1904: false)
  @row_index = row_index
  @column_index = column_index
  @value = value
  @formula = formula
  @style_index = style_index
  @unmapped_data = unmapped_data || EMPTY_HASH
  computed_errors = errors || self.class.validate(row_index, column_index, value)
  @errors = computed_errors.frozen? ? computed_errors : computed_errors.freeze
  @hyperlink = hyperlink
  @comment = comment
  @raw_value = raw_value
  @format_code = format_code
  @date1904 = date1904 ? true : false
end

# File lib/xlsxrb/elements/cell.rb, line 477
def self.parse_ref(ref)
  return nil unless ref

  bytes = ref.b
  len = bytes.bytesize
  col = 0
  i = 0
  while i < len
    b = bytes.getbyte(i)
    if b.between?(65, 90)
      col = (col * 26) + (b - 64)
      i += 1
    elsif b.between?(97, 122)
      col = (col * 26) + (b - 96)
      i += 1
    else
      break
    end
  end
  return nil if i.zero? || i == len

  row_part = bytes.byteslice(i, len - i)
  return nil unless row_part.match?(/\A[1-9]\d*\z/)

  row = row_part.to_i - 1
  [row, col - 1]
end

# File lib/xlsxrb/elements/cell.rb, line 511
def self.valid_coordinates?(row_index, column_index)
  row_index.instance_of?(Integer) && row_index >= 0 && row_index < 1_048_576 &&
    column_index.instance_of?(Integer) && column_index >= 0 && column_index < 16_384
end

# File lib/xlsxrb/elements/cell.rb, line 521
def self.valid_value?(value)
  case value
  when nil, String, Numeric, true, false, Date, Time, Formula, RichText, CellError
    true
  when Hash
    value.key?(:formula)
  else
    false
  end
end

# File lib/xlsxrb/elements/cell.rb, line 539
def self.validate(row_index, column_index, value)
  valid_val = valid_value?(value)
  return EMPTY_ERRORS if valid_coordinates?(row_index, column_index) && valid_val

  errs = []
  errs << "row_index must be a non-negative Integer (got #{row_index.inspect})" if !row_index.is_a?(Integer) || row_index.negative?
  errs << "column_index must be a non-negative Integer (got #{column_index.inspect})" if !column_index.is_a?(Integer) || column_index.negative?
  errs << "row_index must be < 1048576 (got #{row_index}, max row is 1048575)" if row_index.is_a?(Integer) && row_index >= 1_048_576
  errs << "column_index must be < 16384 (got #{column_index}, max column is XFD=16383)" if column_index.is_a?(Integer) && column_index >= 16_384
  errs << "unsupported value type: #{value.class} (#{value.inspect}) — supported types: String, Numeric, true/false, Date, Time, Formula, RichText, CellError, or nil" unless valid_val
  errs
end

# File lib/xlsxrb/elements/cell.rb, line 69
def ==(other)
  other.is_a?(Cell) &&
    row_index == other.row_index &&
    column_index == other.column_index &&
    value == other.value &&
    formula == other.formula &&
    style_index == other.style_index &&
    unmapped_data == other.unmapped_data &&
    errors == other.errors &&
    hyperlink == other.hyperlink &&
    comment == other.comment &&
    raw_value == other.raw_value &&
    format_code == other.format_code
end

# File lib/xlsxrb/elements/cell.rb, line 251
def [](key)
  case key
  when :value then value
  when :formula
    formula.is_a?(Formula) ? formula.expression : formula
  when :style_index then style_index
  when :ref then ref
  when :column_index then column_index
  when :row_index then row_index
  when :hyperlink then hyperlink
  when :url then url
  when :tooltip then tooltip
  when :comment then comment
  when :raw_value then raw_value
  when :format_code then format_code
  when :formatted_value then formatted_value
  when :format_type then format_type
  when :date_format then date_format?
  when :time_format then time_format?
  when :date1904 then date1904?
  when :type
    case value
    when String then "s"
    when true, false then "b"
    end
  end
end

# File lib/xlsxrb/elements/cell.rb, line 210
def comment?
  case comment
  when nil then false
  when Hash, String then !comment.empty?
  else true
  end
end

# File lib/xlsxrb/elements/cell.rb, line 223
def comment_text
  case comment
  when Hash
    txt = comment[:text]
    txt&.to_s
  when String
    comment.empty? ? nil : comment
  end
end

# File lib/xlsxrb/elements/cell.rb, line 320
def content
  value
end

# File lib/xlsxrb/elements/cell.rb, line 311
def date1904?
  @date1904 ? true : false
end

# File lib/xlsxrb/elements/cell.rb, line 293
def date_format?
  format_code ? NumberFormatter.date_format?(format_code) : false
end

# File lib/xlsxrb/elements/cell.rb, line 89
def deconstruct
  [row_index, column_index, value, formula, style_index, unmapped_data, errors, hyperlink, comment, raw_value, format_code]
end

# File lib/xlsxrb/elements/cell.rb, line 93
def deconstruct_keys(keys)
  h = { row_index: row_index, column_index: column_index, value: value, formula: formula,
        style_index: style_index, unmapped_data: unmapped_data, errors: errors, hyperlink: hyperlink,
        comment: comment, raw_value: raw_value, format_code: format_code }
  keys ? h.slice(*keys) : h
end

# File lib/xlsxrb/elements/cell.rb, line 284
def format_type
  format_code ? NumberFormatter.format_type(format_code) : nil
end

# File lib/xlsxrb/elements/cell.rb, line 239
def formatted_value(custom_format_code = nil)
  return nil if value.nil?

  NumberFormatter.format(value, custom_format_code || format_code)
end

# File lib/xlsxrb/elements/cell.rb, line 139
def formula?
  if formula.is_a?(Formula)
    !formula.expression.nil? && !formula.expression.empty?
  else
    !formula.nil? && !formula.to_s.empty?
  end
end

# File lib/xlsxrb/elements/cell.rb, line 152
def formula_expression
  expr = formula.is_a?(Formula) ? formula.expression : formula
  return nil if expr.nil?

  str = expr.to_s
  str.empty? ? nil : str
end

# File lib/xlsxrb/elements/cell.rb, line 85
def hash
  [row_index, column_index, value, formula, style_index, unmapped_data, errors, hyperlink, comment, raw_value, format_code].hash
end

# File lib/xlsxrb/elements/cell.rb, line 165
def link?
  case hyperlink
  when nil then false
  when Hash, String then !hyperlink.empty?
  else true
  end
end

# File lib/xlsxrb/elements/cell.rb, line 130
def ref
  "#{self.class.column_letter(column_index)}#{row_index + 1}"
end

# File lib/xlsxrb/elements/cell.rb, line 302
def time_format?
  format_code ? NumberFormatter.time_format?(format_code) : false
end

# File lib/xlsxrb/elements/cell.rb, line 357
def to_date(date1904: nil)
  return value if value.is_a?(Date)

  d1904 = date1904.nil? ? date1904? : date1904
  if value.is_a?(Numeric)
    Ooxml::Utils.serial_to_date(value, date1904: d1904)
  else
    begin
      Date.parse(value.to_s)
    rescue StandardError
      nil
    end
  end
end

# File lib/xlsxrb/elements/cell.rb, line 347
def to_f
  value.to_f
end

# File lib/xlsxrb/elements/cell.rb, line 338
def to_i
  value.to_i
end

# File lib/xlsxrb/elements/cell.rb, line 329
def to_s
  value.to_s
end

# File lib/xlsxrb/elements/cell.rb, line 378
def to_time(date1904: nil)
  return value if value.is_a?(Time)

  d1904 = date1904.nil? ? date1904? : date1904
  if value.is_a?(Numeric)
    Ooxml::Utils.serial_to_datetime(value, date1904: d1904)
  else
    begin
      Time.parse(value.to_s)
    rescue StandardError
      nil
    end
  end
end

# File lib/xlsxrb/elements/cell.rb, line 196
def tooltip
  case hyperlink
  when Hash
    hyperlink[:tooltip]&.to_s
  when Elements::Hyperlink
    hyperlink.tooltip&.to_s
  end
end

# File lib/xlsxrb/elements/cell.rb, line 179
def url
  case hyperlink
  when Hash
    u = hyperlink[:url] || hyperlink[:location]
    u&.to_s
  when String
    hyperlink.empty? ? nil : hyperlink
  when Elements::Hyperlink
    (hyperlink.url || hyperlink.location)&.to_s
  end
end

# File lib/xlsxrb/elements/cell.rb, line 121
def valid?
  errors.empty?
end

# File lib/xlsxrb/elements/cell.rb, line 100
def with(**changes)
  self.class.new(
    row_index: changes.fetch(:row_index, row_index),
    column_index: changes.fetch(:column_index, column_index),
    value: changes.fetch(:value, value),
    formula: changes.fetch(:formula, formula),
    style_index: changes.fetch(:style_index, style_index),
    unmapped_data: changes.fetch(:unmapped_data, unmapped_data),
    errors: changes.fetch(:errors, errors),
    hyperlink: changes.fetch(:hyperlink, hyperlink),
    comment: changes.fetch(:comment, comment),
    raw_value: changes.fetch(:raw_value, raw_value),
    format_code: changes.fetch(:format_code, format_code),
    date1904: changes.fetch(:date1904, @date1904 || false)
  )
end