X - why Offset of a rectange range is a cell?

[The GridLock]

Hi,

I think it should be a rectangles not a cell, please clarify this!

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Khanh Dang, 

Greetings from Syncfusion. 

We are sorry that we are unable to understand your query and request you to help us by explaining it in detail. 

Regards, 

Keerthi. 

[The GridLock]

Hi Keerthi,

I mean: why Gworksheet.Range("E3:E15).Offset(0, 1).Address -> return: F3.  

did i miss something?

More question: Is there a way for me to check if a string is valid address for Irange , eg "a1::a2" will return an error (must "a1:a2") without trycast?

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Khanh Dang, 

Thanks for sharing the details about query. 

Please find the response below. 

Query	Response
why Gworksheet.Range("E3:E15).Offset(0, 1).Address -> return: F3.	The Offset method returns the cell which is shifted by the specified number of rows and columns.  Example:   string address1 = worksheet.Range["E3:E15"].Offset(0, -1).Address; //returns D3  string address2 = worksheet.Range["E3:E15"].Offset(0, 0).Address;  //returns E3  string address3 = worksheet.Range["E3:E15"].Offset(0, 1).Address;  //returns F3  Please look into following link to know more about Offset method.  https://help.syncfusion.com/cr/file-formats/Syncfusion.XlsIO.IRange.html#Syncfusion_XlsIO_IRange_Offset_System_Int32_System_Int32_
Is there a way for me to check if a string is valid address for Irange , eg "a1::a2" will return an error (must "a1:a2") without trycast?	When an invalid address is given in IRange, Syncfusion XlsIO throws Argument Exception.

Regards, 

Keerthi. 

[The GridLock]

Hi Keerthi ,

I think it should be rectangles range would be more reasonable, if so this word should be changed "range" to "cell"

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Khanh Dang, 

Thanks for the update. 

Syncfusion XlsIO considers even a single cell as range and it is returned as IRange. We will modify the description of the method as “Returns an IRange object that represents a range or cell that is offset from the specified range or cell”. 

Kindly let us know if you need any further assistance. 

Regards, 

Keerthi. 

[Mohit Joshi]

This is affecting us as well. When Offset is used on a square range (e.g. a Range with address A1:A5), the function returns a single cell and not a range of the same size of the original range. So if I use sheet.Range["A1:A5"].Offset(0,1) it returns B1 instead of B1:B5.

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Mohit, 

The Offset method returns an IRange object that represents a range or cell that is offset from the specified range or cell. This is the behavior of the Offset method. As promised earlier, we have modified the description of this Offset method in our release version 18.3.0.35. 

Kindly let us know if you need any further assistance. 

Regards, 

Ramya.