1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
|
# frozen_string_literal: true
module Axlsx
# This class details a single cell anchor for drawings.
# @note The recommended way to manage drawings, images and charts is Worksheet#add_chart or Worksheet#add_image.
# @see Worksheet#add_chart
# @see Worksheet#add_image
class OneCellAnchor
include Axlsx::OptionsParser
# Creates a new OneCellAnchor object and an Pic associated with it.
# @param [Drawing] drawing
# @option options [Array] start_at the col, row to start at
# @option options [Integer] width
# @option options [Integer] height
# @option options [String] image_src the file location of the image you will render
# @option options [String] name the name attribute for the rendered image
# @option options [String] descr the description of the image rendered
def initialize(drawing, options = {})
@drawing = drawing
@width = 0
@height = 0
drawing.anchors << self
@from = Marker.new
parse_options options
start_at(*options[:start_at]) if options[:start_at]
@object = Pic.new(self, options)
end
# A marker that defines the from cell anchor. The default from column and row are 0 and 0 respectively
# @return [Marker]
attr_reader :from
# The object this anchor hosts
# @return [Pic]
attr_reader :object
# The drawing that holds this anchor
# @return [Drawing]
attr_reader :drawing
# the width of the graphic object in pixels.
# this is converted to EMU at a 92 ppi resolution
# @return [Integer]
attr_reader :width
# the height of the graphic object in pixels
# this is converted to EMU at a 92 ppi resolution
# @return [Integer]
attr_reader :height
# sets the starting position for the anchor.
# You can provide a String like "A1", an array like [0,0] or a cell object for the x parameter.
# We just 'figure it out' for you.
# @param [Array, String, Cell, Integer] x Accepts many inputs for defining the starting position of the cell.
# @param [Integer] y When x is an integer, this value is used for the row index at which the anchor starts.
def start_at(x, y = 0)
from.coord x, y
end
#
# @see height
def height=(v) Axlsx.validate_unsigned_int(v); @height = v; end
# @see width
def width=(v) Axlsx.validate_unsigned_int(v); @width = v; end
# The index of this anchor in the drawing
# @return [Integer]
def index
@drawing.anchors.index(self)
end
# Serializes the object
# @param [String] str
# @return [String]
def to_xml_string(str = +'')
str << '<xdr:oneCellAnchor>'
str << '<xdr:from>'
from.to_xml_string(str)
str << '</xdr:from>'
str << '<xdr:ext cx="' << ext[:cx].to_s << '" cy="' << ext[:cy].to_s << '"/>'
@object.to_xml_string(str)
str << '<xdr:clientData/>'
str << '</xdr:oneCellAnchor>'
end
private
# converts the pixel width and height to EMU units and returns a hash of
# !{:cx=>[Integer], :cy=>[Integer]
# @return [Hash]
def ext
cy = @height * 914400 / 96
cx = @width * 914400 / 96
{ cy: cy, cx: cx }
end
end
end
|
