Contents

require 'soroban/parser'

module Soroban

  # Return true if the supplied data represents a formula.
  def self.formula?(data)
    data.to_s.slice(0..0) == '='
  end

  # Return true if the supplied data is a number.
  def self.number?(data)
    Float(data.to_s) && true rescue false
  end

  # Return true if the supplied data is a boolean.
  def self.boolean?(data)
    /^(true|false)$/i.match(data.to_s) && true || false
  end

  # Return true if the supplied data is a string.
  def self.string?(data)
    /^["](\"|[^"])*["]$/.match(data.to_s) && true || /^['][^']*[']$/.match(data.to_s) && true || false
  end

  # Return true if the supplied data is a range.
  def self.range?(data)
    /^([a-zA-Z]+)([\d]+):([a-zA-Z]+)([\d]+)$/.match(data.to_s) && true || false
  end

  # Return true if the supplied data is of no recognised format.
  def self.unknown?(data)
    !self.formula?(data) && !self.number?(data) && !self.boolean?(data) && !self.string?(data)
  end

  # Return the components of a range.
  def self.getRange(range)
    /^([a-zA-Z]+)([\d]+):([a-zA-Z]+)([\d]+)$/.match(range.to_s).to_a[1..-1]
  end

  # Return the row and column index of the given label.
  def self.getPos(label)
    # TODO: fix for labels such as "BC42"
    match = /^([a-zA-Z]+)([\d]+)$/.match(label.to_s)
    return match[2].to_i - 1, match[1].upcase[0].ord-"A"[0].ord
  end

  # Return an array of values for the supplied arguments (which may be numbers, labels and ranges).
  def self.getValues(context, *args)
    args.map { |arg| Soroban::range?(arg) ? ValueWalker.new(arg, context).to_a : arg }.to_a.flatten
  end

end

Version data entries

6 entries across 6 versions & 1 rubygems

Version	Path
soroban-0.7.3	lib/soroban/helpers.rb
soroban-0.7.2	lib/soroban/helpers.rb
soroban-0.5.4	lib/soroban/helpers.rb
soroban-0.4.0	lib/soroban/helpers.rb
soroban-0.3.1	lib/soroban/helpers.rb
soroban-0.3.0	lib/soroban/helpers.rb