class RubyXL::Cell

# File lib/rubyXL/objects/sheet_data.rb, line 61
def column
  r && r.first_col
end

# File lib/rubyXL/objects/sheet_data.rb, line 65
def column=(v)
  self.r = RubyXL::Reference.new(row || 0, v)
end

# File lib/rubyXL/objects/sheet_data.rb, line 86
def get_cell_border
  workbook.stylesheet.borders[get_cell_xf.border_id]
end

# File lib/rubyXL/objects/sheet_data.rb, line 82
def get_cell_font
  workbook.stylesheet.fonts[get_cell_xf.font_id]
end

# File lib/rubyXL/objects/sheet_data.rb, line 78
def get_cell_xf
  workbook.stylesheet.cell_xfs[self.style_index || 0]
end

# File lib/rubyXL/objects/sheet_data.rb, line 49
def index_in_collection
  r.col_range.begin
end

# File lib/rubyXL/objects/sheet_data.rb, line 126
def inspect
  str = "#<#{self.class}(#{row},#{column}): #{raw_value.inspect}"
  str << " =#{self.formula.expression}" if self.formula
  str << ", datatype=#{self.datatype.inspect}, style_index=#{self.style_index.inspect}>"
  return str
end

# File lib/rubyXL/objects/sheet_data.rb, line 94
def is_date?
  return false unless # Only fully numeric values can be dates
    case raw_value
    when Numeric then true
    when String  then raw_value =~ NUMBER_REGEXP
    else false
    end

  num_fmt = self.number_format
  num_fmt && num_fmt.is_date_format?
end

# File lib/rubyXL/objects/sheet_data.rb, line 90
def number_format
  workbook.stylesheet.get_number_format_by_id(get_cell_xf.num_fmt_id)
end

# File lib/rubyXL/objects/sheet_data.rb, line 69
def raw_value
  value_container && value_container.value
end

# File lib/rubyXL/objects/sheet_data.rb, line 73
def raw_value=(v)
  self.value_container ||= RubyXL::CellValue.new
  value_container.value = v
end

# File lib/rubyXL/objects/sheet_data.rb, line 53
def row
  r && r.first_row
end

# File lib/rubyXL/objects/sheet_data.rb, line 57
def row=(v)
  self.r = RubyXL::Reference.new(v, column || 0)
end

# File lib/rubyXL/objects/sheet_data.rb, line 108
def value(args = {})
  r = self.raw_value

  case datatype
  when RubyXL::DataType::SHARED_STRING then workbook.shared_strings_container[r.to_i].to_s
  when RubyXL::DataType::INLINE_STRING then is.to_s
  when RubyXL::DataType::RAW_STRING    then raw_value
  else
    if is_date? then workbook.num_to_date(r.to_f)
    elsif r.is_a?(String) && (r =~ NUMBER_REGEXP) then # Numeric
      if $1 != '' then r.to_f
      else r.to_i
      end
    else r
    end
  end
end