[RESOLVED] VB6 - Spreadsheet "MergeCells" formating not working.

[anhn]

Excel 2007 has higher limits:

? Len(Sheet1.Range("E900").Value)
 9000 
? Len(Sheet1.Range("E900").Text)
 8221 
? Mid(Sheet1.Range("E900").Text, 8215,30)
008220 
? Mid(Sheet1.Range("E900").Value, 8215,30)
008220 000008230 000008240 000

Cell.value can hold up to 32767 chars,
max column width = 255
max row height = 409.5

With this width and height limits, depend on font style and size, you may see more or less up to 32767 chars.
with font Arial size 8, on 1280 resolution screen, you can see less than 8000 chars.

The problem of non-wrap text was fixed in Excel-2007.