C
Cody
I have a spreadsheet with data that has been exported from a database that is
displaying some odd behavior in Excel 2003 SP3.
The problem seems to be that the final column in the database allows html to
be entered, so when we export it to Excel, all of the tags show up with the
data. In SP3, some of this data from the final column is being broken up and
displayed in multiple cells. So, for example, in a cell that has multiple
lines of text with tags in between, the first line appears where it should,
the second line displays on the next row, but in the first column instead of
the last, the next line in the row below that, etc. In SP2, it displays
normally: we still see the tags mixed in with the data, but nothing spills
over.
Has anyone else experienced a problem like this, or have any idea what
changed between SP2 and SP3 that could be the cause of the issue?
displaying some odd behavior in Excel 2003 SP3.
The problem seems to be that the final column in the database allows html to
be entered, so when we export it to Excel, all of the tags show up with the
data. In SP3, some of this data from the final column is being broken up and
displayed in multiple cells. So, for example, in a cell that has multiple
lines of text with tags in between, the first line appears where it should,
the second line displays on the next row, but in the first column instead of
the last, the next line in the row below that, etc. In SP2, it displays
normally: we still see the tags mixed in with the data, but nothing spills
over.
Has anyone else experienced a problem like this, or have any idea what
changed between SP2 and SP3 that could be the cause of the issue?