This content has been marked as final. Show 4 replies
Yes there is a limit, but it wasn't intentional.
This has been fixed for a future release. Will let you know when it's available.
Thanks, Jeff. I'll be waiting with bated breath!!! Keep those enhancements coming.
Glad I wasn't going crazy. Strangely enough we had some archaic "LONG" datatypes in our system which have finally been converted by our vendor to CLOB. In testing, the LONG has other SQL limitations - but it could pull every character stored; whereas the CLOB was long overdue - but then I was seeing the truncation.
Well Yes, there is a limit of an xlsx cell of 4000 characters.
If possible, you can have your data written in excel file in 2 cells. That will resolve the issue, else you can write that CLOB to a physical file and store the path in excel cell if you want any further processing of that data.
Thanks, Parth. Great suggestions! ... Now why didn't I think of that :)