axlsx hacking comment position

comment-hack.rb

# Hacking comment position!
# Use at your own risk :)
# add_comment is the preferred way to add comments to your worksheet. However, if you really need to position a
# a specific comment, here is one way to do it.
require 'axlsx'
p = Axlsx::Package.new
wb = p.workbook
wb.add_worksheet(:name => 'comments') do |sheet|
  sheet.add_row ['Can we build it?', 'Yes we can!']
  sheet.add_comment(:ref => 'A1', :author => 'Bob', :text => 'Yes We Can!').tap do |comment|
    comment.vml_shape.top_row = 1
    comment.vml_shape.left_column = 1
    comment.vml_shape.bottom_row = 20
    comment.vml_shape.right_column = 5
  end
end
p.serialize 'comments.xlsx'