zdavatz / spreadsheet

The Ruby Spreadsheet by ywesee GmbH
http://spreadsheet.ch
GNU General Public License v3.0
1.13k stars 240 forks source link

How to attach note/comment to a particular cell in Ruby Spreadsheet? #224

Closed rajanmodi closed 6 years ago

rajanmodi commented 6 years ago

Spreadsheet.client_encoding = 'UTF-8' book = Spreadsheet::Workbook.new sheet = book.create_worksheet(:name => "Test") sheet.row(0)[0] = "Rajan" # putting value in 0th row and 0th column comment = Spreadsheet::Note.new #Creating Note object comment.objID = 0 . #Initialising instance variables of Note class comment.row = 0 comment.col =0 comment.text = "Some Comment"

ToDo - How to attach this note to a particular cell(0th row and 0th column)?

zdavatz commented 6 years ago

Good question. I do not know if this is implemented. I do not think so. Please let me know if you succeed.