When I set the cell's Style to URL, I'm losing the decimal format. It is trimming trailing zeroes. And it seems to ignore the cell's Format property. How do you change a decimal cell or column to display as a link while keeping the current formatting intact?
Hi,
Using a URL Style for the column means that the column's data will be interpreted as a string, and there's no way to format a string - or at least no automatic or easy way.
One thing you could do is hide the real column of decimal data. Keep the Format on it, but set Hidden to True on that column. Then you could add an unbound string column to the grid in it's place and set the Style of this column to URL. Then you use the InitializeRow event to copy the Text of the real, hidden, decimal cell into the URL cell.
That seems to work fine; however, it's removing the comma in the final URL string. Is there a way to prevent this?