I'm hoping someone can help me. I have a report which is being exported to excel format through a Classic ASP web application. My report has 9 columns. Some values could potentially be blank. Whenever I have a blank field though, the data in the column after it will side into blank fields place. Is there any way to keep this from happening?
Here is a mockup of the problem I'm having. In this mockup, XXXXX, BBBBB, and CCCCC represent arbitrary data.
Figure 1:
Column1 Column2 Column3
XXXXX XXXXXX XXXXXX
XXXXX BBBBBB
CCCCC XXXXXX
Figure 1 is the formatting I would like to see in both preview display and when exporting to EXCEL from Classic ASP, however, in the figure below is actually what is happening.
Figure 2:
Column1 Column2 Column3
XXXXX XXXXXX XXXXXX
XXXXX <- BBBBBB
<-- CCCCC XXXXXX
If I have a blank field in a record such as in row 2 column 2 and in row 3 column 1, fields in those rows to the right will shift to the left to fill the empty fields. This only happens when exporting to Excel. Is there anything than can be done to fix this?
Thanks in advance for any tips or help with this!
Jim
Edited by JDM6763 - 28 Jul 2008 at 6:22am
IP Logged
