Page 1 of 1

strings longer than 32K in a cell

Posted: Wed Feb 14, 2024 7:56 pm
by jdorlon
Hello,

If I use XLSReadWriteII6 to put a string longer than 32K in length into a cell, then when I open the file in Excel, there is no data.

I can, however, paste the same data directly into Excel.

Is this a bug or is there some other reason for this behavior?

Thanks

John Dorlon

Re: strings longer than 32K in a cell

Posted: Mon Feb 19, 2024 11:06 am
by larsa
Hello

Max text length in a cell is 32767 characters. You can probably paste text in a cell because Excel truncates it.