Class: Axlsx::Cell

144
145
146
147
148
149
150
151
152
153
154

# File 'lib/axlsx/workbook/worksheet/cell.rb', line 144

def cell_type_from_value(v)      
  if v.is_a? Time
    :time
  elsif v.to_s.match(/\A[+-]?\d+?\Z/) #numeric
    :integer
  elsif v.to_s.match(/\A[+-]?\d+\.\d+?\Z/) #float
    :float
  else
    :string
  end
end

127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183

# File 'lib/axlsx/workbook/worksheet/cell.rb', line 127

def col_ref
    chars = []
    index = self.index
    while index >= 26 do
      chars << ((index % 26) + 65).chr
      index /= 26
    end
    chars << ((chars.empty? ? index : index-1) + 65).chr
    chars.reverse.join
  end

  # Determines the cell type based on the cell value. 
  # @note This is only used when a cell is created but no :type option is specified, the following rules apply:
  #   1. If the value is an instance of Time, the type is set to :time
  #   2. :float and :integer types are determined by regular expression matching.
  #   3. Anything that does not meet either of the above is determined to be :string.
  # @return [Symbol] The determined type
  def cell_type_from_value(v)      
    if v.is_a? Time
      :time
    elsif v.to_s.match(/\A[+-]?\d+?\Z/) #numeric
      :integer
    elsif v.to_s.match(/\A[+-]?\d+\.\d+?\Z/) #float
      :float
    else
      :string
    end
  end

  # Cast the value into this cells data type. 
  # @note 
  #   About Time - Time in OOXML is *different* from what you might expect. The history as to why is interesting,  but you can safely assume that if you are generating docs on a mac, you will want to specify Workbook.1904 as true when using time typed values.
  # @see Axlsx#date1904
  def cast_value(v)
    if @type == :time && v.is_a?(Time)
      #todo consider a time parsing method to convert strings to time
      epoc = Workbook.date1904 ? Time.local(1904,1,1,0,0,0,0,v.zone) : Time.local(1900,1,1,0,0,0,0,v.zone)
      ((v - epoc) /60.0/60.0/24.0).to_f
    elsif @type == :float
      v.to_f
    elsif @type == :integer
      v.to_i
    else
      @type = :string
      v.to_s
      # curious as to why this would be the cells responsibility
      # convert your values before passing them in wankers! CGI.unescapeHTML(v.to_s).to_xs
      # to revert, load this once when the gem is loaded.
      # unless String.method_defined? :to_xs
      #   require 'fast_xs' #dep
      #   class String
      #     alias_method :to_xs, :fast_xs
      #   end
      # end
    end
  end    
end

67
68
69

# File 'lib/axlsx/workbook/worksheet/cell.rb', line 67

def index
  @row.cells.index(self)
end

74
75
76

# File 'lib/axlsx/workbook/worksheet/cell.rb', line 74

def r
  "#{col_ref}#{@row.index+1}"      
end

81
82
83

# File 'lib/axlsx/workbook/worksheet/cell.rb', line 81

def r_abs
  "$#{r.split('').join('$')}"
end

110
111
112
113
114
115
116
117

# File 'lib/axlsx/workbook/worksheet/cell.rb', line 110

def to_xml(xml)
  if @type == :string
    #NOTE not sure why, but xml.t @v renders the text as html entities of unicode data
    xml.c(:r => r, :t=>:inlineStr, :s=>style) { xml.is { xml << "<t>#{value}</t>" } }
  else
    xml.c(:r => r, :s => style) { xml.v value }
  end
end