class RubyXL::Reference

# File lib/rubyXL/objects/reference.rb, line 111
def self.ind2ref(row = 0, col = 0, row_abs = false, col_abs = false)
  col_ref = ''

  loop do
    x = col % 26
    col_ref = ('A'.ord + x).chr + col_ref
    col = (col / 26).floor - 1
    break if col < 0
  end

  "#{col_abs ? '$' : ''}#{col_ref}#{row_abs ? '$' : ''}#{row + 1}"
end

# File lib/rubyXL/objects/reference.rb, line 13
def initialize(*params)
  row_from = row_to = col_from = col_to = nil
  @row_from_absolute = @row_to_absolute = @col_from_absolute = @col_to_absolute = false

  case params.size
  when 4 then row_from, row_to, col_from, col_to = params
  when 2 then row_from, col_from = params
  when 1 then
    case params.first
    when Hash then
      row_from, row_to, col_from, col_to = params.first.fetch_values(:row_from, :row_to, :col_from, :col_to)
    when String then
      str = params.first
      match_data = str.match(/^('(?<sheet_name1>[^']+)'|(?<sheet_name2>[^']+))!/)
      if match_data then
        @sheet_name = match_data['sheet_name1'] || match_data['sheet_name2']
        str = str[match_data[0].size..-1]
      end

      from, to = str.split(':')
      row_from, col_from, @row_from_absolute, @col_from_absolute = self.class.ref2ind(from)
      row_to, col_to, @row_to_absolute, @col_to_absolute = self.class.ref2ind(to) unless to.nil?
    else
      raise ArgumentError.new("invalid value for #{self.class}: #{params[0].inspect}") unless params[0].is_a?(String)
    end
  end

  @row_range = Range.new(row_from || 0, row_to || row_from || ROW_MAX)
  @col_range = Range.new(col_from || 0, col_to || col_from || COL_MAX)
end

# File lib/rubyXL/objects/reference.rb, line 125
def self.ref2ind(str)
  matchdata = str.match(/\A(?<cabs>\$?)(?<col>[A-Z]+)(?<rabs>\$?)(?<row>\d+)\Z/)
  return [ -1, -1 ] unless matchdata
  [  matchdata['row'].to_i - 1,
     matchdata['col'].each_byte.inject(0) { |col, chr| (col * 26) + (chr - 64) } - 1,
     !matchdata['rabs'].empty?,
     !matchdata['cabs'].empty? ]
end

# File lib/rubyXL/objects/reference.rb, line 68
def ==(other)
  !other.nil? && (@sheet_name == other.sheet_name) &&
    (@row_range == other.row_range) && (@col_range == other.col_range)
end

# File lib/rubyXL/objects/reference.rb, line 73
def cover?(other)
  !other.nil? && (@row_range.cover?(other.row_range.begin) &&
                  @row_range.cover?(other.row_range.end) &&
                  @col_range.cover?(other.col_range.begin) &&
                  @col_range.cover?(other.col_range.end))
end

# File lib/rubyXL/objects/reference.rb, line 60
def first_col
  @col_range.begin
end

# File lib/rubyXL/objects/reference.rb, line 52
def first_row
  @row_range.begin
end

# File lib/rubyXL/objects/reference.rb, line 101
def inspect
  if single_cell? then
    "#<#{self.class} @sheet_name=#{@sheet_name} @row=#{@row_range.begin} @col=#{@col_range.begin}>"
  else
    "#<#{self.class} @sheet_name=#{@sheet_name} @row_range=#{@row_range} @col_range=#{@col_range}>"
  end
end

# File lib/rubyXL/objects/reference.rb, line 64
def last_col
  @col_range.end
end

# File lib/rubyXL/objects/reference.rb, line 56
def last_row
  @row_range.end
end

# File lib/rubyXL/objects/reference.rb, line 44
def single_cell?
  (@row_range.begin == @row_range.end) && (@col_range.begin == @col_range.end)
end

# File lib/rubyXL/objects/reference.rb, line 80
def to_s
  result = +''

  if @sheet_name then
    if @sheet_name.index(' ') then
      result << "'#{@sheet_name}'"
    else
      result << @sheet_name
    end
    result << '!'
  end

  if single_cell? then
    result << self.class.ind2ref(@row_range.begin, @col_range.begin, @row_from_absolute, @col_from_absolute)
  else
    result << self.class.ind2ref(@row_range.begin, @col_range.begin, @row_from_absolute, @col_from_absolute)
    result << ':'
    result << self.class.ind2ref(@row_range.end, @col_range.end, @row_to_absolute, @col_to_absolute)
  end
end

# File lib/rubyXL/objects/reference.rb, line 48
def valid?
  !(row_range.begin.negative? || col_range.begin.negative?)
end