﻿<?xml version="1.0" encoding="utf-8"?><rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:media="http://search.yahoo.com/mrss/" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0"><channel><title>Intersoft Community - WebGrid Enterprise - Exporting HYPERLINK formula to Excel </title><link>http://www.intersoftsolutions.com/Community/WebGrid/Exporting-HYPERLINK-formula-to-Excel/</link><description /><generator>http://www.intersoftsolutions.com</generator><language>en</language><copyright>Copyright 2002 - 2015 Intersoft Solutions Corp. All rights reserved.</copyright><ttl>60</ttl><item><title>Exporting HYPERLINK formula to Excel </title><link>http://www.intersoftsolutions.com/Community/WebGrid/Exporting-HYPERLINK-formula-to-Excel/</link><pubDate>Tue, 08 Feb 2011 01:40:43 GMT</pubDate><dc:creator>yudi</dc:creator><description>&lt;p&gt;&lt;span style="font-family: 'segoe ui','sans-serif'; color: #1f497d; font-size: 9pt"&gt;Unfortunately there is no way to export excel formula using WebGrid Export functionality.&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-family: 'segoe ui','sans-serif'; color: #1f497d; font-size: 9pt"&gt;It is the default behavior of the export result of WebGrid.&lt;br /&gt;The export result will produce table with plain text.&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-family: 'segoe ui','sans-serif'; color: #1f497d; font-size: 9pt"&gt;Hope this helps.&lt;/span&gt;&lt;/p&gt;</description></item><item><title>Exporting HYPERLINK formula to Excel </title><link>http://www.intersoftsolutions.com/Community/WebGrid/Exporting-HYPERLINK-formula-to-Excel/</link><pubDate>Mon, 07 Feb 2011 16:06:14 GMT</pubDate><dc:creator>Intersoft817</dc:creator><description>&lt;p&gt;Hi,&lt;/p&gt;
&lt;p&gt; I want to export below webgrid cell value into excel as a &lt;span style="text-decoration:underline;"&gt;&lt;strong&gt;formula&lt;/strong&gt;&lt;/span&gt; using WebGrid Export functnality.&lt;/p&gt;
&lt;p&gt;e.g.  =HYPERLINK("&lt;a href="http://mysite/myscripts/ID=%22&amp;amp;30506"&gt;http://mysite/myscripts/ID="&amp;amp;30506&lt;/a&gt;,"  Maps ")&lt;/p&gt;
&lt;p&gt;when I export it into excel sheet, it appears as a &lt;span style="text-decoration:underline;"&gt;text&lt;/span&gt; instead of &lt;span style="text-decoration:underline;"&gt;formula&lt;/span&gt;. &lt;/p&gt;
&lt;p&gt;Please let me know How do I export excel formula using WebGrid Export functnality?  &lt;/p&gt;
&lt;p&gt; &lt;/p&gt;
&lt;p&gt;Thanks,&lt;/p&gt;
&lt;p&gt; &lt;/p&gt;</description></item></channel></rss>