PC Review


Reply
Thread Tools Rate Thread

C# Excel cell content partially strikeout

 
 
=?Utf-8?B?TW9ua2V5TW9ua2V5?=
Guest
Posts: n/a
 
      17th Oct 2007
Hi All,

Does anyone have any idea in detecting the data of a particular cells in
Excel is partially strikeout?

I have tried :

cell.IsStrikeThrough = System.Convert.ToBoolean(rowFound.Font.Strikethrough);

the cell is simply an struct object, and the rowFound is Excel.Range object.

This line of code works fine if the content in the rowFound is fully
strikeout or not strikeout. But when it comes to a cell's data which is
partially strikeout, it will return an System.DBNull.

Appreciate if anyone can provide an idea or example to check if the content
in a cell is partially strikeout, and how to determine the characters of the
cell where it starts to strikeout.

Thank you very much!

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Userform combobox: best match on partially typed content? ker_01 Microsoft Excel Programming 4 27th Mar 2009 02:56 PM
Excel 2002: How to add content to a cell ? =?Utf-8?B?TXIuIExvdw==?= Microsoft Excel Misc 4 19th Apr 2007 05:50 PM
Merging into an Excel Cell the content of the Bookmarked table Cell from msword chamdan0150@netscape.net Microsoft Excel Discussion 1 6th Dec 2006 06:32 PM
Excel - create button to replace cell content with cell value =?Utf-8?B?YmxhY2ttb3Q=?= Microsoft Excel Worksheet Functions 3 7th Dec 2005 05:10 PM
Flashing cell content in Excel D.M.Beiso Microsoft Excel Discussion 2 12th Dec 2003 03:13 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:36 AM.