<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>module RubyXL::LegacyCell - rubyXL 3.3.8</title>
<script type="text/javascript">
var rdoc_rel_prefix = "../";
</script>
<script src="../js/jquery.js"></script>
<script src="../js/darkfish.js"></script>
<link href="../css/fonts.css" rel="stylesheet">
<link href="../css/rdoc.css" rel="stylesheet">
<body id="top" role="document" class="module">
<nav role="navigation">
<div id="project-navigation">
<div id="home-section" role="region" title="Quick navigation" class="nav-section">
<h2>
<a href="../index.html" rel="home">Home</a>
</h2>
<div id="table-of-contents-navigation">
<a href="../table_of_contents.html#pages">Pages</a>
<a href="../table_of_contents.html#classes">Classes</a>
<a href="../table_of_contents.html#methods">Methods</a>
</div>
</div>
<div id="search-section" role="search" class="project-section initially-hidden">
<form action="#" method="get" accept-charset="utf-8">
<div id="search-field-wrapper">
<input id="search-field" role="combobox" aria-label="Search"
aria-autocomplete="list" aria-controls="search-results"
type="text" name="search" placeholder="Search" spellcheck="false"
title="Type to search, Up and Down to navigate, Enter to load">
</div>
<ul id="search-results" aria-label="Search Results"
aria-busy="false" aria-expanded="false"
aria-atomic="false" class="initially-hidden"></ul>
</form>
</div>
</div>
<div id="class-metadata">
<!-- Method Quickref -->
<div id="method-list-section" class="nav-section">
<h3>Methods</h3>
<ul class="link-list" role="directory">
<li ><a href="#method-i-change_contents">#change_contents</a>
<li ><a href="#method-i-change_fill">#change_fill</a>
<li ><a href="#method-i-change_font_bold">#change_font_bold</a>
<li ><a href="#method-i-change_font_color">#change_font_color</a>
<li ><a href="#method-i-change_font_italics">#change_font_italics</a>
<li ><a href="#method-i-change_font_name">#change_font_name</a>
<li ><a href="#method-i-change_font_size">#change_font_size</a>
<li ><a href="#method-i-change_font_strikethrough">#change_font_strikethrough</a>
<li ><a href="#method-i-change_font_underline">#change_font_underline</a>
<li ><a href="#method-i-font_switch">#font_switch</a>
<li ><a href="#method-i-inspect">#inspect</a>
<li ><a href="#method-i-workbook">#workbook</a>
</ul>
</div>
</div>
</nav>
<main role="main" aria-labelledby="module-RubyXL::LegacyCell">
<h1 id="module-RubyXL::LegacyCell" class="module">
module RubyXL::LegacyCell
</h1>
<section class="description">
</section>
<section id="5Buntitled-5D" class="documentation-section">
<section class="attribute-method-details" class="method-section">
<header>
<h3>Attributes</h3>
</header>
<div id="attribute-i-formula" class="method-detail">
<div class="method-heading attribute-method-heading">
<span class="method-name">formula</span><span
class="attribute-access-type">[RW]</span>
</div>
<div class="method-description">
</div>
</div>
<div id="attribute-i-worksheet" class="method-detail">
<div class="method-heading attribute-method-heading">
<span class="method-name">worksheet</span><span
class="attribute-access-type">[RW]</span>
</div>
<div class="method-description">
</div>
</div>
</section>
<section id="public-instance-5Buntitled-5D-method-details" class="method-section">
<header>
<h3>Public Instance Methods</h3>
</header>
<div id="method-i-change_contents" class="method-detail ">
<div class="method-heading">
<span class="method-name">change_contents</span><span
class="method-args">(data, formula_expression = nil)</span>
<span class="method-click-advice">click to toggle source</span>
</div>
<div class="method-description">
<div class="method-source-code" id="change_contents-source">
<pre><span class="ruby-comment"># File lib/rubyXL/cell.rb, line 99</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier">change_contents</span>(<span class="ruby-identifier">data</span>, <span class="ruby-identifier">formula_expression</span> = <span class="ruby-keyword">nil</span>)
<span class="ruby-identifier">validate_worksheet</span>
<span class="ruby-keyword">if</span> <span class="ruby-identifier">formula_expression</span> <span class="ruby-keyword">then</span>
<span class="ruby-keyword">self</span>.<span class="ruby-identifier">datatype</span> = <span class="ruby-keyword">nil</span>
<span class="ruby-keyword">self</span>.<span class="ruby-identifier">formula</span> = <span class="ruby-constant">RubyXL</span><span class="ruby-operator">::</span><span class="ruby-constant">Formula</span>.<span class="ruby-identifier">new</span>(<span class="ruby-value">:expression</span> =<span class="ruby-operator">></span> <span class="ruby-identifier">formula_expression</span>)
<span class="ruby-keyword">else</span>
<span class="ruby-keyword">self</span>.<span class="ruby-identifier">datatype</span> = <span class="ruby-keyword">case</span> <span class="ruby-identifier">data</span>
<span class="ruby-keyword">when</span> <span class="ruby-constant">Date</span>, <span class="ruby-constant">Numeric</span> <span class="ruby-keyword">then</span> <span class="ruby-keyword">nil</span>
<span class="ruby-keyword">else</span> <span class="ruby-constant">RubyXL</span><span class="ruby-operator">::</span><span class="ruby-constant">DataType</span><span class="ruby-operator">::</span><span class="ruby-constant">RAW_STRING</span>
<span class="ruby-keyword">end</span>
<span class="ruby-keyword">end</span>
<span class="ruby-identifier">data</span> = <span class="ruby-identifier">workbook</span>.<span class="ruby-identifier">date_to_num</span>(<span class="ruby-identifier">data</span>) <span class="ruby-keyword">if</span> <span class="ruby-identifier">data</span>.<span class="ruby-identifier">is_a?</span>(<span class="ruby-constant">Date</span>)
<span class="ruby-keyword">self</span>.<span class="ruby-identifier">raw_value</span> = <span class="ruby-identifier">data</span>
<span class="ruby-keyword">end</span></pre>
</div>
</div>
</div>
<div id="method-i-change_fill" class="method-detail ">
<div class="method-heading">
<span class="method-name">change_fill</span><span
class="method-args">(rgb = 'ffffff')</span>
<span class="method-click-advice">click to toggle source</span>
</div>
<div class="method-description">
<p>changes fill color of cell</p>
<div class="method-source-code" id="change_fill-source">
<pre><span class="ruby-comment"># File lib/rubyXL/cell.rb, line 22</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier">change_fill</span>(<span class="ruby-identifier">rgb</span> = <span class="ruby-string">'ffffff'</span>)
<span class="ruby-identifier">validate_worksheet</span>
<span class="ruby-constant">Color</span>.<span class="ruby-identifier">validate_color</span>(<span class="ruby-identifier">rgb</span>)
<span class="ruby-keyword">self</span>.<span class="ruby-identifier">style_index</span> = <span class="ruby-identifier">workbook</span>.<span class="ruby-identifier">modify_fill</span>(<span class="ruby-keyword">self</span>.<span class="ruby-identifier">style_index</span>, <span class="ruby-identifier">rgb</span>)
<span class="ruby-keyword">end</span></pre>
</div>
</div>
</div>
<div id="method-i-change_font_bold" class="method-detail ">
<div class="method-heading">
<span class="method-name">change_font_bold</span><span
class="method-args">(bolded = false)</span>
<span class="method-click-advice">click to toggle source</span>
</div>
<div class="method-description">
<p>Changes font bold settings of cell</p>
<div class="method-source-code" id="change_font_bold-source">
<pre><span class="ruby-comment"># File lib/rubyXL/cell.rb, line 67</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier">change_font_bold</span>(<span class="ruby-identifier">bolded</span> = <span class="ruby-keyword">false</span>)
<span class="ruby-identifier">validate_worksheet</span>
<span class="ruby-identifier">font</span> = <span class="ruby-identifier">get_cell_font</span>.<span class="ruby-identifier">dup</span>
<span class="ruby-identifier">font</span>.<span class="ruby-identifier">set_bold</span>(<span class="ruby-identifier">bolded</span>)
<span class="ruby-identifier">update_font_references</span>(<span class="ruby-identifier">font</span>)
<span class="ruby-keyword">end</span></pre>
</div>
</div>
</div>
<div id="method-i-change_font_color" class="method-detail ">
<div class="method-heading">
<span class="method-name">change_font_color</span><span
class="method-args">(font_color = '000000')</span>
<span class="method-click-advice">click to toggle source</span>
</div>
<div class="method-description">
<p>Changes font color of cell</p>
<div class="method-source-code" id="change_font_color-source">
<pre><span class="ruby-comment"># File lib/rubyXL/cell.rb, line 48</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier">change_font_color</span>(<span class="ruby-identifier">font_color</span> = <span class="ruby-string">'000000'</span>)
<span class="ruby-identifier">validate_worksheet</span>
<span class="ruby-constant">Color</span>.<span class="ruby-identifier">validate_color</span>(<span class="ruby-identifier">font_color</span>)
<span class="ruby-identifier">font</span> = <span class="ruby-identifier">get_cell_font</span>.<span class="ruby-identifier">dup</span>
<span class="ruby-identifier">font</span>.<span class="ruby-identifier">set_rgb_color</span>(<span class="ruby-identifier">font_color</span>)
<span class="ruby-identifier">update_font_references</span>(<span class="ruby-identifier">font</span>)
<span class="ruby-keyword">end</span></pre>
</div>
</div>
</div>
<div id="method-i-change_font_italics" class="method-detail ">
<div class="method-heading">
<span class="method-name">change_font_italics</span><span
class="method-args">(italicized = false)</span>
<span class="method-click-advice">click to toggle source</span>
</div>
<div class="method-description">
<p>Changes font italics settings of cell</p>
<div class="method-source-code" id="change_font_italics-source">
<pre><span class="ruby-comment"># File lib/rubyXL/cell.rb, line 58</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier">change_font_italics</span>(<span class="ruby-identifier">italicized</span> = <span class="ruby-keyword">false</span>)
<span class="ruby-identifier">validate_worksheet</span>
<span class="ruby-identifier">font</span> = <span class="ruby-identifier">get_cell_font</span>.<span class="ruby-identifier">dup</span>
<span class="ruby-identifier">font</span>.<span class="ruby-identifier">set_italic</span>(<span class="ruby-identifier">italicized</span>)
<span class="ruby-identifier">update_font_references</span>(<span class="ruby-identifier">font</span>)
<span class="ruby-keyword">end</span></pre>
</div>
</div>
</div>
<div id="method-i-change_font_name" class="method-detail ">
<div class="method-heading">
<span class="method-name">change_font_name</span><span
class="method-args">(new_font_name = 'Verdana')</span>
<span class="method-click-advice">click to toggle source</span>
</div>
<div class="method-description">
<p>Changes font name of cell</p>
<div class="method-source-code" id="change_font_name-source">
<pre><span class="ruby-comment"># File lib/rubyXL/cell.rb, line 29</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier">change_font_name</span>(<span class="ruby-identifier">new_font_name</span> = <span class="ruby-string">'Verdana'</span>)
<span class="ruby-identifier">validate_worksheet</span>
<span class="ruby-identifier">font</span> = <span class="ruby-identifier">get_cell_font</span>.<span class="ruby-identifier">dup</span>
<span class="ruby-identifier">font</span>.<span class="ruby-identifier">set_name</span>(<span class="ruby-identifier">new_font_name</span>)
<span class="ruby-identifier">update_font_references</span>(<span class="ruby-identifier">font</span>)
<span class="ruby-keyword">end</span></pre>
</div>
</div>
</div>
<div id="method-i-change_font_size" class="method-detail ">
<div class="method-heading">
<span class="method-name">change_font_size</span><span
class="method-args">(font_size = 10)</span>
<span class="method-click-advice">click to toggle source</span>
</div>
<div class="method-description">
<p>Changes font size of cell</p>
<div class="method-source-code" id="change_font_size-source">
<pre><span class="ruby-comment"># File lib/rubyXL/cell.rb, line 38</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier">change_font_size</span>(<span class="ruby-identifier">font_size</span> = <span class="ruby-value">10</span>)
<span class="ruby-identifier">validate_worksheet</span>
<span class="ruby-identifier">raise</span> <span class="ruby-string">'Argument must be a number'</span> <span class="ruby-keyword">unless</span> <span class="ruby-identifier">font_size</span>.<span class="ruby-identifier">is_a?</span>(<span class="ruby-constant">Integer</span>) <span class="ruby-operator">||</span> <span class="ruby-identifier">font_size</span>.<span class="ruby-identifier">is_a?</span>(<span class="ruby-constant">Float</span>)
<span class="ruby-identifier">font</span> = <span class="ruby-identifier">get_cell_font</span>.<span class="ruby-identifier">dup</span>
<span class="ruby-identifier">font</span>.<span class="ruby-identifier">set_size</span>(<span class="ruby-identifier">font_size</span>)
<span class="ruby-identifier">update_font_references</span>(<span class="ruby-identifier">font</span>)
<span class="ruby-keyword">end</span></pre>
</div>
</div>
</div>
<div id="method-i-change_font_strikethrough" class="method-detail ">
<div class="method-heading">
<span class="method-name">change_font_strikethrough</span><span
class="method-args">(struckthrough = false)</span>
<span class="method-click-advice">click to toggle source</span>
</div>
<div class="method-description">
<div class="method-source-code" id="change_font_strikethrough-source">
<pre><span class="ruby-comment"># File lib/rubyXL/cell.rb, line 84</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier">change_font_strikethrough</span>(<span class="ruby-identifier">struckthrough</span> = <span class="ruby-keyword">false</span>)
<span class="ruby-identifier">validate_worksheet</span>
<span class="ruby-identifier">font</span> = <span class="ruby-identifier">get_cell_font</span>.<span class="ruby-identifier">dup</span>
<span class="ruby-identifier">font</span>.<span class="ruby-identifier">set_strikethrough</span>(<span class="ruby-identifier">struckthrough</span>)
<span class="ruby-identifier">update_font_references</span>(<span class="ruby-identifier">font</span>)
<span class="ruby-keyword">end</span></pre>
</div>
</div>
</div>
<div id="method-i-change_font_underline" class="method-detail ">
<div class="method-heading">
<span class="method-name">change_font_underline</span><span
class="method-args">(underlined = false)</span>
<span class="method-click-advice">click to toggle source</span>
</div>
<div class="method-description">
<p>Changes font underline settings of cell</p>
<div class="method-source-code" id="change_font_underline-source">
<pre><span class="ruby-comment"># File lib/rubyXL/cell.rb, line 76</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier">change_font_underline</span>(<span class="ruby-identifier">underlined</span> = <span class="ruby-keyword">false</span>)
<span class="ruby-identifier">validate_worksheet</span>
<span class="ruby-identifier">font</span> = <span class="ruby-identifier">get_cell_font</span>.<span class="ruby-identifier">dup</span>
<span class="ruby-identifier">font</span>.<span class="ruby-identifier">set_underline</span>(<span class="ruby-identifier">underlined</span>)
<span class="ruby-identifier">update_font_references</span>(<span class="ruby-identifier">font</span>)
<span class="ruby-keyword">end</span></pre>
</div>
</div>
</div>
<div id="method-i-font_switch" class="method-detail ">
<div class="method-heading">
<span class="method-name">font_switch</span><span
class="method-args">(change_type, arg)</span>
<span class="method-click-advice">click to toggle source</span>
</div>
<div class="method-description">
<p>Performs correct modification based on what type of change_type is
specified</p>
<div class="method-source-code" id="font_switch-source">
<pre><span class="ruby-comment"># File lib/rubyXL/cell.rb, line 125</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier">font_switch</span>(<span class="ruby-identifier">change_type</span>, <span class="ruby-identifier">arg</span>)
<span class="ruby-keyword">case</span> <span class="ruby-identifier">change_type</span>
<span class="ruby-keyword">when</span> <span class="ruby-constant">Worksheet</span><span class="ruby-operator">::</span><span class="ruby-constant">NAME</span> <span class="ruby-keyword">then</span> <span class="ruby-identifier">change_font_name</span>(<span class="ruby-identifier">arg</span>)
<span class="ruby-keyword">when</span> <span class="ruby-constant">Worksheet</span><span class="ruby-operator">::</span><span class="ruby-constant">SIZE</span> <span class="ruby-keyword">then</span> <span class="ruby-identifier">change_font_size</span>(<span class="ruby-identifier">arg</span>)
<span class="ruby-keyword">when</span> <span class="ruby-constant">Worksheet</span><span class="ruby-operator">::</span><span class="ruby-constant">COLOR</span> <span class="ruby-keyword">then</span> <span class="ruby-identifier">change_font_color</span>(<span class="ruby-identifier">arg</span>)
<span class="ruby-keyword">when</span> <span class="ruby-constant">Worksheet</span><span class="ruby-operator">::</span><span class="ruby-constant">ITALICS</span> <span class="ruby-keyword">then</span> <span class="ruby-identifier">change_font_italics</span>(<span class="ruby-identifier">arg</span>)
<span class="ruby-keyword">when</span> <span class="ruby-constant">Worksheet</span><span class="ruby-operator">::</span><span class="ruby-constant">BOLD</span> <span class="ruby-keyword">then</span> <span class="ruby-identifier">change_font_bold</span>(<span class="ruby-identifier">arg</span>)
<span class="ruby-keyword">when</span> <span class="ruby-constant">Worksheet</span><span class="ruby-operator">::</span><span class="ruby-constant">UNDERLINE</span> <span class="ruby-keyword">then</span> <span class="ruby-identifier">change_font_underline</span>(<span class="ruby-identifier">arg</span>)
<span class="ruby-keyword">when</span> <span class="ruby-constant">Worksheet</span><span class="ruby-operator">::</span><span class="ruby-constant">STRIKETHROUGH</span> <span class="ruby-keyword">then</span> <span class="ruby-identifier">change_font_strikethrough</span>(<span class="ruby-identifier">arg</span>)
<span class="ruby-keyword">else</span> <span class="ruby-identifier">raise</span> <span class="ruby-string">'Invalid change_type'</span>
<span class="ruby-keyword">end</span>
<span class="ruby-keyword">end</span></pre>
</div>
</div>
</div>
<div id="method-i-inspect" class="method-detail ">
<div class="method-heading">
<span class="method-name">inspect</span><span
class="method-args">()</span>
<span class="method-click-advice">click to toggle source</span>
</div>
<div class="method-description">
<div class="method-source-code" id="inspect-source">
<pre><span class="ruby-comment"># File lib/rubyXL/cell.rb, line 117</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier">inspect</span>
<span class="ruby-identifier">str</span> = <span class="ruby-node">"#<#{self.class}(#{row},#{column}): #{raw_value.inspect}"</span>
<span class="ruby-identifier">str</span> <span class="ruby-operator">+=</span> <span class="ruby-node">" =#{self.formula.expression}"</span> <span class="ruby-keyword">if</span> <span class="ruby-keyword">self</span>.<span class="ruby-identifier">formula</span>
<span class="ruby-identifier">str</span> <span class="ruby-operator">+=</span> <span class="ruby-node">", datatype = #{self.datatype}, style_index = #{self.style_index}>"</span>
<span class="ruby-keyword">return</span> <span class="ruby-identifier">str</span>
<span class="ruby-keyword">end</span></pre>
</div>
</div>
</div>
<div id="method-i-workbook" class="method-detail ">
<div class="method-heading">
<span class="method-name">workbook</span><span
class="method-args">()</span>
<span class="method-click-advice">click to toggle source</span>
</div>
<div class="method-description">
<div class="method-source-code" id="workbook-source">
<pre><span class="ruby-comment"># File lib/rubyXL/cell.rb, line 17</span>
<span class="ruby-keyword">def</span> <span class="ruby-identifier">workbook</span>
<span class="ruby-ivar">@worksheet</span>.<span class="ruby-identifier">workbook</span>
<span class="ruby-keyword">end</span></pre>
</div>
</div>
</div>
</section>
</section>
</main>
<footer id="validator-badges" role="contentinfo">
<p><a href="http://validator.w3.org/check/referer">Validate</a>
<p>Generated by <a href="http://docs.seattlerb.org/rdoc/">RDoc</a> 4.2.0.
<p>Based on <a href="http://deveiate.org/projects/Darkfish-RDoc/">Darkfish</a> by <a href="http://deveiate.org">Michael Granger</a>.
</footer>