[Feature] Add support for new line characters within table widget cells

[nidhi-nair]

A user on Discord wanted to be able to format their table data with new line characters but the table only supports a single line of data.

Front conversations

[nidhi-nair]

Another way to solve this would be to create a new ColumnType for HTML as the user on Discord suggests. We might want to consider other formatting mechanisms as well.

An alternative to adding support for newline characters specifically would be to add a column type "HTML" (instead of using "Plain text") which would render the contents as HTML, similar to the "Text" widget.

[somangshu]

note:

• Add HTML as a new column type
• Input will receive HTML code
• Output needs to be rendered as HTML

Question: @vicky-primathon @riodeuno

• Can HTML be rendered in the table column?
• Will this be solved using Textarea column type
• @SatishGandham bought this point up; A new line could increase the row height of the table and it could break the layout.

[dilippitchika]

Discussed with @sbalaji1192 can be done with word wrap logic, we can wrap if we encounter a new line character or the limit is reached. Dependent on #5693

[areyabhishek]

Got another request for this feature today on Discord. https://discord.com/channels/725602949748752515/1053001054482092233

[dilippitchika]

@sbalaji1192 can you look at this once and document the changes we need to make

[dilippitchika]

This issue needs validation on how many users it will help if we release this feature. Because not a lot of users will have data with line break characters.

A quick check might be to understand how many users have an rte or textarea widget and are trying to use it with a table, though this data might be hard to grasp

[ame-appsmith]

Another Enterprise user needs this feature.