Class: RubyXL::Cell

Inherits:
OOXMLObject show all
Includes:
LegacyCell
Defined in:
lib/rubyXL/objects/sheet_data.rb

Overview

www.schemacentral.com/sc/ooxml/e-ssml_c-2.html

Constant Summary

Constants included from LegacyCell

LegacyCell::ERROR, LegacyCell::RAW_STRING, LegacyCell::SHARED_STRING

Instance Attribute Summary

Attributes included from LegacyCell

#formula, #worksheet

Instance Method Summary collapse

Methods included from LegacyCell

#border_bottom, #border_diagonal, #border_left, #border_right, #border_top, #change_border_bottom, #change_border_diagonal, #change_border_left, #change_border_right, #change_border_top, #change_contents, #change_fill, #change_font_bold, #change_font_color, #change_font_italics, #change_font_name, #change_font_size, #change_font_strikethrough, #change_font_underline, #change_horizontal_alignment, #change_text_wrap, #change_vertical_alignment, #fill_color, #font_color, #font_name, #font_size, #horizontal_alignment, #inspect, #is_bolded, #is_date?, #is_italicized, #is_struckthrough, #is_underlined, #text_wrap, #vertical_alignment, #workbook

Methods included from OOXMLObjectClassMethods

#define_attribute, #define_child_node, #define_element_name, #obtain_class_variable, #parse, #set_countable

Methods included from OOXMLObjectInstanceMethods

#before_write_xml, #dup, #initialize, #write_xml

Instance Method Details

#column ⇒ Object 



39
40
41
 
# File 'lib/rubyXL/objects/sheet_data.rb', line 39

def column
  r && r.first_col
end

#column=(v) ⇒ Object 



43
44
45
 
# File 'lib/rubyXL/objects/sheet_data.rb', line 43

def column=(v)
  self.r = RubyXL::Reference.new(row || 0, v)
end

#index_in_collection ⇒ Object 



27
28
29
 
# File 'lib/rubyXL/objects/sheet_data.rb', line 27

def index_in_collection
  r.col_range.begin
end

#raw_value ⇒ Object 



47
48
49
 
# File 'lib/rubyXL/objects/sheet_data.rb', line 47

def raw_value
  value_container && value_container.value
end

#raw_value=(v) ⇒ Object 



51
52
53
54
 
# File 'lib/rubyXL/objects/sheet_data.rb', line 51

def raw_value=(v)
  self.value_container ||= RubyXL::CellValue.new
  value_container.value = v
end

#row ⇒ Object 



31
32
33
 
# File 'lib/rubyXL/objects/sheet_data.rb', line 31

def row
  r && r.first_row
end

#row=(v) ⇒ Object 



35
36
37
 
# File 'lib/rubyXL/objects/sheet_data.rb', line 35

def row=(v)
  self.r = RubyXL::Reference.new(v, column || 0)
end

#value(args = {}) ⇒ Object 



56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
 
# File 'lib/rubyXL/objects/sheet_data.rb', line 56

def value(args = {})
  return raw_value if args[:raw]
  case datatype
  when RubyXL::Cell::SHARED_STRING then
    workbook.shared_strings_container[raw_value.to_i]
  else 
    if is_date? then workbook.num_to_date(raw_value.to_i)
    elsif raw_value.is_a?(String) && (raw_value =~ /^-?\d+(\.\d+(?:e[+-]\d+)?)?$/i) # Numeric
      if $1 then raw_value.to_f
      else raw_value.to_i
      end
    else raw_value
    end
  end
end