flipandboef
Posts: 107
|
Posted: 02/18/2009, 8:12 AM |
|
Ok, a little weird issue...
I export my grid to Excel as done via the example-pack. Had to add some code to remove some line-breaks and seems to work great, however.....
When I now export to Excel, there's an extra row (empty!) under each row with data, that is merged in Excel on each cell
This does not show up in the grid itself via the browser.
(There's no extra line showing in the browser)
Example:
|-----------------|
|Row1 -- DATA |
|Row2 -- empty|
|-----------------|
|Row3 -- DATA |
|Row4 -- empty|
|-----------------|
etc...
Anyone any idea how this get's there and how to get rid of it?
Note:
The code used to get rid of my line breaks is:
Dim RegEx
Set RegEx = New RegExp
RegEx.Pattern = "(\r|\n|<BR>)*"
RegEx.Global = True
X.Y.Value = RegEx.Replace(X.Y.Value, "")
But I do not see that that adds this line....
CCS 3.2
DB Access
ASP with templates
|