PC Review


Reply
Thread Tools Rate Thread

Avoiding hyperlink error

 
 
=?Utf-8?B?QUJhbHVzdQ==?=
Guest
Posts: n/a
 
      18th Oct 2007
I'm using XML-formatted Excel 2003 (11.8146.8132) SP2 files as template to
populate data from an ASP.Net web app. I'd like to avoid the "Hyperlink
creation for cell data starts with 'FTP ' followed by numbers, then
double-clicked on this cell and moved to other cell" error, and I tried
setting the Ticked attribute as follows:

<Cell><Data ss:Type="String" x:Ticked="1">FTP 123</Data></Cell>

However, this appears to have single quote in front of the data ('FTP 123).
In case, when user double-clicks the cell for copying the data, this single
quote is also appeared in-front of the data. Is it possible to prevent this
single quote? Or Is it possible to prevent the hyperlink creation if the data
starts with 'FTP ' followed by numbers?

Please advice. Thanks in advance
abalusu
 
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
Avoiding a #n/a error brian.baker13@googlemail.com Microsoft Excel Discussion 3 4th Mar 2008 10:56 AM
Avoiding an error Francis Hookham Microsoft Excel Programming 2 10th Apr 2007 10:32 PM
Hyperlink - avoiding system question topola Microsoft Excel Discussion 2 27th Jun 2006 02:31 PM
Avoiding the dreaded #div/0 error Marie1uk Microsoft Excel Worksheet Functions 10 21st Jul 2005 10:49 PM
Avoiding 400 Error code =?Utf-8?B?bm9zcGFtaW5saWNo?= Microsoft Excel Programming 2 2nd Feb 2005 07:55 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:08 PM.