Class: Writexlsx::Worksheet::InternalHyperlink

Inherits:
Hyperlink
  • Object
show all
Defined in:
lib/write_xlsx/worksheet/hyperlink.rb

Constant Summary

Constants inherited from Hyperlink

Hyperlink::MAXIMUM_URLS_SIZE

Constants included from Utility

Utility::COL_MAX, Utility::ROW_MAX, Utility::SHEETNAME_MAX, Utility::STR_MAX

Instance Attribute Summary

Attributes inherited from Hyperlink

#str, #tip

Instance Method Summary collapse

Methods inherited from Hyperlink

#display_on, #external_hyper_link, factory

Methods included from Utility

#absolute_char, #check_dimensions, #check_dimensions_and_update_max_min_values, #check_parameter, #convert_date_time, #dash_types, delete_files, #fill_properties, #float_to_str, #layout_properties, #line_fill_properties, #line_properties, #palette_color, #pixels_to_points, #process_workbook_options, #ptrue?, #put_deprecate_message, #quote_sheetname, #r_id_attributes, #row_col_notation, #shape_style_base, #store_col_max_min_values, #store_row_max_min_values, #substitute_cellref, #underline_attributes, #v_shape_attributes_base, #v_shape_style_base, #value_or_raise, #write_anchor, #write_auto_fill, #write_color, #write_comment_path, #write_div, #write_fill, #write_font, #write_stroke, #write_xml_declaration, #xl_cell_to_rowcol, #xl_col_to_name, #xl_range, #xl_range_formula, #xl_rowcol_to_cell, #xml_str

Constructor Details

#initialize(url, str, tip) ⇒ InternalHyperlink


88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
# File 'lib/write_xlsx/worksheet/hyperlink.rb', line 88

def initialize(url, str, tip)
  @url = url
  # The displayed string defaults to the url string.
  str ||= @url.dup

  # Strip the mailto header.
  @str = str.sub(/^mailto:/, '')

  # Copy string for use in hyperlink elements.
  @url_str = @str.dup

  # Excel limits escaped URL to 255 characters.
  if @url.bytesize > MAXIMUM_URLS_SIZE
    raise "URL '#{@url}' > #{MAXIMUM_URLS_SIZE} characters, it exceeds Excel's limit for URLS."
  end

  @tip = tip
end

Instance Method Details

#attributes(row, col, dummy = nil) ⇒ Object


107
108
109
110
111
112
113
114
115
# File 'lib/write_xlsx/worksheet/hyperlink.rb', line 107

def attributes(row, col, dummy = nil)
  attr = [
          ['ref', xl_rowcol_to_cell(row, col)],
          ['location', @url]
         ]

  attr << ['tooltip', @tip] if @tip
  attr << ['display', @str]
end