Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 71
Default Spreadsheet displays differently in Excel 2003 SP2 & SP3

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?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
DOES ANYONE KNOW IF EXCEL READS ITEMS IN A LIST DIFFERENTLY ? johnnyz197034 Excel Discussion (Misc queries) 12 April 3rd 07 11:40 PM
Pivot table displays data differently, Excel 2003 Perkyleo Excel Worksheet Functions 1 December 16th 05 04:36 PM
Number format exactly the same, displays differently in some cells eider Excel Discussion (Misc queries) 1 July 29th 05 12:26 AM
When I send a spreadsheet via e-mail they see it differently? LeslieV Excel Discussion (Misc queries) 3 July 28th 05 05:14 PM
Formula window displays correct answer while cell displays incorre MMV Excel Worksheet Functions 3 November 10th 04 09:28 PM


All times are GMT +1. The time now is 03:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"