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.
Unfortunately, activation email could not send to your email. Please try again.

HasString Method Problem

Thread ID:

Created:

Updated:

Platform:

Replies:

103241 Apr 16,2012 08:35 AM Apr 24,2012 09:31 AM WPF 1
loading
Tags: SpreadsheetControl(Classic)
Salih
Asked On April 16, 2012 08:35 AM

Hi,

I am using SpreadSheet WPF and i have this "if" block:

if(SpreadSheetStatic.ExcelProperties.WorkBook.Worksheets[activesheetname].Columns[d].HasNumber)

This is working correctly. But, when i use "HasString" method instead of "HasNumber" method, it is not working - although Cells have String values.

Where is my mistake in this problem?

Regards.


Ponraja A [Syncfusion]
Replied On April 24, 2012 09:31 AM

Hi Salih,

You can achieve your requirement by directly access the HasString property in worksheet range by using the row and column index as shown in the following code snippet.

[Sample Code][C#]
IWorksheet worksheet = spreadSheetControl.ExcelProperties.WorkBook.Worksheets[spreadSheetControl.GridProperties.CurrentSheetName];
IRange range = worksheet.Range[RowIndex, ColumnIndex];
bool Result = range.HasString;

For more information please refer the attached sample and video.

Please let us know if you have any queries.

Regards,
Ponraja




Spreadsheet_2a8d6308.zip

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.

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.

;