code block answer does not paste correctly

[lucaseatp]

Self Checks

• [X] This is only for bug report, if you would like to ask a question, please head to Discussions.
• [X] I have searched for existing issues search for existing issues, including closed ones.
• [X] I confirm that I am using English to submit this report (我已阅读并同意 Language Policy).
• [X] [FOR CHINESE USERS] 请务必使用英文提交 Issue，否则会被关闭。谢谢！:）
• [X] Please do not modify this template :) and fill in all the required fields.

Dify version

0.9.1

Cloud or Self Hosted

Self Hosted (Docker)

Steps to reproduce

ask the AI to answer in a code block for excel, it will answer you, but the copy-paste doesn't work. the format is wrong somehow. I think the issue is with the code block.

✔️ Expected Behavior

I can copy the AI answer and paste on excel/g.sheets to ease my work

sample: VICTOR HUGO M. DA LUZ 04/04/2024 NOTURNO VICTOR HUGO M. DA LUZ 11/04/2024 NOTURNO VICTOR HUGO M. DA LUZ 18/04/2024 NOTURNO VICTOR HUGO M. DA LUZ 21/04/2024 NOTURNO VICTOR HUGO M. DA LUZ 28/04/2024 NOTURNO

❌ Actual Behavior

doesn't paste on excel correcly. it pastes on the same cell the whole content, instead of breaking columns and lines. same prompt works on chatgpt.

[dosubot[bot]]

The issue you're experiencing with copying and pasting code blocks into Excel might be related to the delimiter used in the generated content. Excel typically expects data to be separated by specific delimiters like tabs or commas to correctly parse it into separate cells.

To resolve this, you can try the following workaround:

1. Check Delimiters: Ensure that the AI-generated response uses a delimiter that Excel recognizes, such as a tab (\t) or a comma (,). You might need to adjust the prompt to specify the desired delimiter.

2. Manual Adjustment: If the AI response is not using the correct delimiter, you can manually replace spaces with tabs or commas before pasting into Excel.

3. Excel Import Options: Use Excel's "Text to Columns" feature to manually specify the delimiter after pasting the content into a single cell. This can help split the data into separate columns.

Unfortunately, I couldn't find specific information on how Dify handles delimiters for Excel compatibility, so these general suggestions might help in the meantime.

To continue talking to Dosu, mention @dosu.