Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

50th row in Excel always get truncated

Go to solution
Former Member

‎12-10-2011 4:46 AM

0 Kudos

50th row in Excel always get truncated in one cell instead of breaking to a new row while downloading the output in transaction KSB1.

1 ACCEPTED SOLUTION

Go to solution
former_member222709
Contributor

‎12-12-2011 1:13 PM

0 Kudos

Hi Deepa,

If you download the data in a text file then atleast we can understand the source of error. To open it and view in excel you will have to do the following:

1. Open excel and convert your existing worksheet into text mode (right click --> Format cells --> text mode)

2. Copy the data from the downloaded text file.

3. Save this in excel (text mode worksheet).

The problem is with excel as your data may have some identifiers that change the way data is handled in Excel. There special characters (, ), *, =, !, etc. are used as identifiers and do the job of truncation or merging.

Regards,

Pranav.

1 REPLY 1

Go to solution
former_member222709
Contributor

‎12-12-2011 1:13 PM

0 Kudos

Hi Deepa,

If you download the data in a text file then atleast we can understand the source of error. To open it and view in excel you will have to do the following:

1. Open excel and convert your existing worksheet into text mode (right click --> Format cells --> text mode)

2. Copy the data from the downloaded text file.

3. Save this in excel (text mode worksheet).

The problem is with excel as your data may have some identifiers that change the way data is handled in Excel. There special characters (, ), *, =, !, etc. are used as identifiers and do the job of truncation or merging.

Regards,

Pranav.