Cell range indexes with ejSpreadsheet

[Anthony]

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]?

[Silambarasan I]

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. 

 

JSPlayground sample:
http://jsplayground.syncfusion.com/jaec4t5j 

 

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