We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Cell range indexes with ejSpreadsheet

Sorry if I missed it somewhere, but when using the hyperlink functionality, is there a way to use cell range indexes as opposed to the traditional cell names? For example

Instead of this: $("#Spreadsheet").ejSpreadsheet("setHyperlink", "C5", { "webAddr": "www.google.com"}, 1);

Can I reference C5 using something like [3,5]?

1 Reply

SI Silambarasan I Syncfusion Team January 10, 2019 07:03 AM UTC

Hi Anthony, 
 
Thank you for contacting Syncfusion support. 
 
Yes, we can pass the cell reference as array value to set the hyperlink in Spreadsheet. But, it should be in the format of [StartRowIndex, StartColumnIndex, EndRowIndex, EndColumnIndex] i.e. in your case, you should pass C5 as [2, 4, 2, 4] (note: it is zero based index). Please refer the below sample and code example. 
 
 
CODE EXAMPLE: 
 
//… 
 
$("#Spreadsheet").ejSpreadsheet("setHyperlink", [4, 2, 4, 2], { "webAddr": "https://www.google.com" }, 1); 
 
 
Please get back to us if you require any further assistance. 
 
Regards, 
Silambarasan 


Loader.
Live Chat Icon For mobile
Up arrow icon