Currently, because the appointment entity supports rich text, the default behavior is to include HTML tags in the summary field when exporting to Excel.
It would be more convenient if users could choose to export to Excel in plain text without including HTML tags.
Comments
@Xiaowu Chen, can you provide us with the link to the plug in? Even if it is third party, would be nice if we can give it a try.
Category: General
Hi Kenji,Hope you are doing good!We have two workarounds about the exporting data to excel to avoid HTML tags.1 - In excel, select the whole column contains HTML tags, push Ctrl + H to pop up replace&find window, in Find what, we input , and let replace with to empty, and click Replace All, it will remove all HTML tags at once.2 - Using custom Plugins, we need to create an extra multiline text field in the table to store the plain text value for rich text. We just need to display the plain text column in the view, and put the rich text field in the form. So when we click save on the form, we use custom plugin logic to parse the rich text values to plain text and store the plain text values to the plain field in table.For the HTML tags, this issue has been there since Rich Text column is introduced, we also hope it will be fixed one day in the product. thanks!
Category: General