Announcement (2017-05-07): www.ruby-forum.com is now read-only since I
unfortunately do not have the time to support and maintain the forum any
more. Please see rubyonrails.org/community and ruby-lang.org/en/community
for other Rails- und Ruby-related community platforms.

hi
can any one help me out to fix this
hyper_link = "=HYPERLINK("test.xls#Sheet2!A1", "Sheet2")"
worksheet.write_url( 4+ j , 4 , hyper_link, format_bold)
above one is the code to give hyperlink for the text in Sheet1
once I clicked the Sheet2 link it should goes to Sheet2
I have tried and I got the text HYPERLINK("test.xls#Sheet2!A1",
"Sheet2") in the generated excel but I want this as link