Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Avoiding error on Input Box - if no value is entered | Excel Discussion (Misc queries) | |||
Avoiding Value error message due to space in cell w/ formula | Excel Discussion (Misc queries) | |||
Avoiding the triangle (formula error checker) | Excel Programming | |||
Avoiding the dreaded #div/0 error | Excel Worksheet Functions | |||
Avoiding 400 Error code | Excel Programming |