Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Avoiding hyperlink error

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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Avoiding error on Input Box - if no value is entered dhstein Excel Discussion (Misc queries) 5 April 25th 09 12:43 PM
Avoiding Value error message due to space in cell w/ formula A.R. Hunt Excel Discussion (Misc queries) 3 January 26th 07 09:52 PM
Avoiding the triangle (formula error checker) OmegaMan Excel Programming 1 October 20th 06 10:45 PM
Avoiding the dreaded #div/0 error Marie1uk Excel Worksheet Functions 10 July 21st 05 10:49 PM
Avoiding 400 Error code nospaminlich Excel Programming 2 February 2nd 05 07:55 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"