Class: Axlsx::Comment

Inherits:
Object
  • Object
show all
Includes:
Accessors, OptionsParser
Defined in:
lib/axlsx/workbook/worksheet/comment.rb

Overview

A comment is the text data for a comment

Instance Attribute Summary collapse

Instance Method Summary collapse

Methods included from OptionsParser

#parse_options

Constructor Details

#initialize(comments, options = {}) {|_self| ... } ⇒ Comment

Creates a new comment object

Parameters:

  • comments (Comments) —

    The comment collection this comment belongs to

  • options (Hash) (defaults to: {})
  • [String] (Hash) —

    a customizable set of options

  • [Boolean] (Hash) —

    a customizable set of options

Yields:

  • (_self)

Yield Parameters:

Raises:

  • (ArgumentError) 


16
17
18
19
20
21
22
 
# File 'lib/axlsx/workbook/worksheet/comment.rb', line 16

def initialize(comments, options={})
  raise ArgumentError, "A comment needs a parent comments object" unless comments.is_a?(Comments)
  @visible = true
  @comments = comments
  parse_options options
  yield self if block_given?
end

Instance Attribute Details

#comments ⇒ Comments (readonly)

The owning Comments object

Returns:



29
30
31
 
# File 'lib/axlsx/workbook/worksheet/comment.rb', line 29

def comments
  @comments
end

#ref ⇒ String|Cell

The string based cell position reference (e.g. 'A1') that determines the positioning of this comment

Returns:



33
34
35
 
# File 'lib/axlsx/workbook/worksheet/comment.rb', line 33

def ref
  @ref
end

Instance Method Details

#author_index ⇒ Integer

The index of this author in a unique sorted list of all authors in the comment.

Returns:

  • (Integer) 


49
50
51
 
# File 'lib/axlsx/workbook/worksheet/comment.rb', line 49

def author_index
  @comments.authors.index(author)
end

#to_xml_string(str = "") ⇒ String

serialize the object

Parameters:

  • str (String) (defaults to: "")

Returns:



63
64
65
66
67
68
69
70
71
72
73
74
75
 
# File 'lib/axlsx/workbook/worksheet/comment.rb', line 63

def to_xml_string(str = "")
  author = @comments.authors[author_index]
  str << ('<comment ref="' << ref << '" authorId="' << author_index.to_s << '">')
  str << '<text>'
  unless author.to_s == ""
    str << '<r><rPr><b/><color indexed="81"/></rPr>'
    str << ("<t>" << ::CGI.escapeHTML(author.to_s) << ":\n</t></r>")
  end
  str << '<r>'
  str << '<rPr><color indexed="81"/></rPr>'
  str << ('<t>' << ::CGI.escapeHTML(text) << '</t></r></text>')
  str << '</comment>'
end

#vml_shape ⇒ VmlShape

The vml shape that will render this comment

Returns:



42
43
44
 
# File 'lib/axlsx/workbook/worksheet/comment.rb', line 42

def vml_shape
  @vml_shape ||= initialize_vml_shape
end