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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Cell range indexes with ejSpreadsheet

Thread ID:

Created:

Updated:

Platform:

Replies:

141892 Jan 9,2019 04:09 PM UTC Jan 10,2019 07:03 AM UTC JavaScript 1
loading
Tags: ejSpreadSheet
Anthony
Asked On January 9, 2019 04:09 PM UTC

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 [Syncfusion]
Replied On 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 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;