Too Much Data In a Cell Promotes Data Truncation

[BryanHec]

I do have some workbooks that contains thousands of very large cells. These cells are not merged but they contain thousands of lines of text each. I am not allow to merge cells. If I add Line controls on them I may see all the text but If I do not rezise the horizontal borders of the cell when I print I get data truncation. How could I programatically go around this issue. I want to be able to print all the content of these workbooks.

Thank you

 

[SkipVought]

Hi,

From Excel HELP
[tt]
Excel specifications and limits
Show All
Hide All
Worksheet and workbook specifications

Feature Maximum limit

Column width 255 characters
Row height 409 points
Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.

[/tt]

Skip,
[sub]
[red][/red]
[/sub]

 

[BryanHec]

Thank you,

But I know about this limitations. I am looking for a programatically way to go around them.

 

[SkipVought]

Programatically parse the data in mutiple cells in order to be able to view/print.

Skip,
[sub]
[red][/red]
[/sub]

 

[BryanHec]

Thank you for the reply. The problem is that because of forensics rools we can change the format a little bit but we can not move data from the cells.

 

[SkipVought]

Well looks like yer trying to put 5 lbs in a 4 lb bag, chum. Doesn't work, does it?

Excel has rools, toooo. ;-)

Skip,
[sub]
[red][/red]
[/sub]

 

[bpeirson]

Copy and paste all the relevant cells to a Word document (I tried this with 5066 characters). Word has superior capabilities for printing information whereas Excel has superior capabilities for processing information.

The idea behind processing information is to condense it into readily digested amounts, ie if excel is doing its job you should only need to print short amounts or data.