Rich Text Format mapped to excel cell- with formatting intact

Aspose.Cells Product Family
1

Hi Support,

I have a user control which is a rich text editor, when I save the control it saves the “content” in the rich text format. When I generate a report, using an excel template, I read the “content”, however, it just splurts out the rich text format (including tags) into the cell, without any formatting.

I had a look through the forums and the last post regarding this is from 2011, I was wondering if RTF is supported with Aspose Cells, if not what work arounds are available?

Thanks again,

Dan

2

Hi,


I am not entirely certain about scenario/ issue. Well, I think you may try to use Cell.HtmlString which will give you HTML tags for a given formatted cell value. If your control is a text box in MS Excel (form control), then you may use TextBox.HtmlText property for your requirements.

Moreover, you may see the documents on how to do (set/get) the formattings ( back/fore color, font/text color and other attributes, configurations, borders for cells etc.):

Thank you.

3

Thanks for that.

Essentially I want this…


{\rtf1\ansi\ansicpg1252\uc1\htmautsp\deff2{\fonttbl{\f0\fcharset0 Times New Roman;}{\f2\fcharset0 Segoe UI;}}{\colortbl\red0\green0\blue0;\red255\green255\blue255;}
{*\listtable
{\list\listtemplateid1\listhybrid
{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid5’02’00.;}{\levelnumbers’01;}\fi-360\li720\lin720\jclisttab\tx720}
{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid6’02’01.;}{\levelnumbers’01;}\fi-360\li1440\lin1440\jclisttab\tx1440}
{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid7’02’02.;}{\levelnumbers’01;}\fi-360\li2160\lin2160\jclisttab\tx2160}
{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid8’02’03.;}{\levelnumbers’01;}\fi-360\li2880\lin2880\jclisttab\tx2880}
{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid9’02’04.;}{\levelnumbers’01;}\fi-360\li3600\lin3600\jclisttab\tx3600}
{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid10’02’05.;}{\levelnumbers’01;}\fi-360\li4320\lin4320\jclisttab\tx4320}
{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid11’02’06.;}{\levelnumbers’01;}\fi-360\li5040\lin5040\jclisttab\tx5040}
{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid12’02’07.;}{\levelnumbers’01;}\fi-360\li5760\lin5760\jclisttab\tx5760}
{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid13’02’08.;}{\levelnumbers’01;}\fi-360\li6480\lin6480\jclisttab\tx6480}
{\listname ;}\listid1}}
{*\listoverridetable
{\listoverride\listid1\listoverridecount0\ls1}
}
\loch\hich\dbch\pard\plain\ltrpar\itap0{\lang1033\fs20\f2\cf0 \cf0\ql{\fs24\f2 {\ltrch TITLE}\li0\ri0\sa0\sb0\fi0\ql\par}
{\fs24\f2 \li0\ri0\sa0\sb0\fi0\ql\par}
{\fs24 {\pntext 1.\tab}{*\pn\pnlvlbody\pndec\pnstart1{\pntxta .}}{\b\ltrch TEXT.}\li720\ri0\sa0\sb0\jclisttab\tx720\fi-360\ql\par}
}
}


Mapped to a cell, via Aspose, in the same format that it was originally.

Dan


4

Hi,


Well, I am afraid, you got to do the formattings using Aspose.Cells APIs, see the documents in the section “Working with Data Formatting” which I referred in my previous reply. Aspose.Cells only supports simple HTML tags in HtmlString property.

Thank you.