Class: Axlsx::WorksheetComments

Inherits:
Object
  • Object
show all
Defined in:
lib/axlsx/workbook/worksheet/worksheet_comments.rb

Overview

A wraper class for comments that defines its on worksheet serailization

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(worksheet) ⇒ WorksheetComments

Creates a new WorksheetComments object param [Worksheet] worksheet The worksheet comments in thes object belong to

Raises:

  • (ArugumentError)

9
10
11
12
# File 'lib/axlsx/workbook/worksheet/worksheet_comments.rb', line 9

def initialize(worksheet)
  raise ArugumentError, 'You must provide a worksheet' unless worksheet.is_a?(Worksheet)
  @worksheet = worksheet
end

Instance Attribute Details

#worksheetObject (readonly)

Returns the value of attribute worksheet


14
15
16
# File 'lib/axlsx/workbook/worksheet/worksheet_comments.rb', line 14

def worksheet
  @worksheet
end

Instance Method Details

#add_comment(options = {}) ⇒ Object

Adds a comment

Parameters:

  • options (Hash) (defaults to: {})

See Also:


25
26
27
# File 'lib/axlsx/workbook/worksheet/worksheet_comments.rb', line 25

def add_comment(options={})
  comments.add_comment(options)
end

#commentsComments

The comments for this worksheet.

Returns:


18
19
20
# File 'lib/axlsx/workbook/worksheet/worksheet_comments.rb', line 18

def comments
  @comments ||= Comments.new(worksheet)
end

#drawing_rIdString

The relationship id of the VML drawing that will render the comments.

Returns:

  • (String)

See Also:


46
47
48
# File 'lib/axlsx/workbook/worksheet/worksheet_comments.rb', line 46

def drawing_rId
  comments.relationships.find{ |r| r.Type == VML_DRAWING_R }.Id
end

#has_comments?Boolean

Helper method to tell us if there are comments in the comments collection

Returns:

  • (Boolean)

39
40
41
# File 'lib/axlsx/workbook/worksheet/worksheet_comments.rb', line 39

def has_comments?
  !comments.empty?
end

#relationshipsRelationships

The relationships defined by this objects comments collection

Returns:


31
32
33
34
# File 'lib/axlsx/workbook/worksheet/worksheet_comments.rb', line 31

def relationships
  return [] unless has_comments?
  comments.relationships
end

#to_xml_string(str = '') ⇒ String

Seraalize the object

Parameters:

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

Returns:

  • (String)

53
54
55
56
# File 'lib/axlsx/workbook/worksheet/worksheet_comments.rb', line 53

def to_xml_string(str = '')
  return unless has_comments?
  str << "<legacyDrawing r:id='#{drawing_rId}' />"
end