Limitation in Text Object of 65,535 Chrs!?

[Jason_Michaelides]

Hi all,

I have just encountered something I have not seen before. See attached demo doc - it seems if you try and put more than 65,535 chrs into a text box it just shows blank.

Has anyone else encountered this?

Obviously, the need to do this is somewhat limited, but it's interesting...and I'd like to know if there's any way to turn off the limit - anyone have any ideas?

Thanks,

Jason

[rbecher]

Of course there must be a limit. Maybe you can display the text line-wise or in paragraphs within a table chart.

[Jason_Michaelides]

I don't really need to display it. I was testing something to pass a string out to another system and noticed the limitation. I agree there obviously has to be a limit although I think 65k chrs is maybe a little low given the size of some applications. No coincidence that it matches the exact Excel row limit that chart objects are still limited to for exporting either, I'd guess...

[rbecher]

Yea, maybe some old 16bit stuff. However you could always use a left()..

[rbecher · Accepted solution]

I have to remember this. One should use Concat on high amount of values with a left always:

=Left(Concat(DISTINCT Number,','), 65535)

..because it's also limited in a straight table chart.

[Jason_Michaelides]

Me too - thanks Ralf.