Added index_of to drawing for finding the position of a chart, image or hyperlink

2 files changed, 8 insertions, 1 deletions

diff --git a/lib/axlsx/drawing/drawing.rb b/lib/axlsx/drawing/drawing.rb
index 48b9320f..769d67c5 100644
--- a/lib/axlsx/drawing/drawing.rb
+++ b/lib/axlsx/drawing/drawing.rb
@@ -137,6 +137,12 @@ module Axlsx
       "#{DRAWING_RELS_PN % (index+1)}"
     end
 
+    # The index of a chart, image or hyperlink object this drawing contains
+    def index_of(object)
+      objects = charts + images + hyperlinks
+      objects.index(object)
+    end
+
     # The drawing's relationships.
     # @return [Relationships]
     def relationships
diff --git a/lib/axlsx/drawing/hyperlink.rb b/lib/axlsx/drawing/hyperlink.rb
index 3f4a2e80..aa763e1f 100644
--- a/lib/axlsx/drawing/hyperlink.rb
+++ b/lib/axlsx/drawing/hyperlink.rb
@@ -93,10 +93,11 @@ module Axlsx
     end
 
     private
+
     # The relational ID for this hyperlink
     # @return [Integer]
     def id
-      @parent.anchor.drawing.charts.size + @parent.anchor.drawing.images.size + @parent.anchor.drawing.hyperlinks.index(self) + 1
+      @parent.anchor.drawing.index_of(self)+1
     end
 
   end