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.
Syncfusion Feedback

HasString Method Problem

Thread ID:

Created:

Updated:

Platform:

Replies:

103241 Apr 16,2012 12:35 PM UTC Apr 24,2012 01:31 PM UTC WPF 1
loading
Tags: SpreadsheetControl(Classic)
Salih
Asked On April 16, 2012 12:35 PM UTC

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 01:31 PM UTC

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.

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

;