Could you please specify the XML format for each cell,as mine is not working
<?xml version="1.0" encoding="UTF-8"?><worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main";><sheetData> <row r="1"> <c r="A1" t="inlineStr" s="5"><is><t>Title</t></is></c><c r="B1" t="inlineStr" s="5"><is><t>% Change</t></is></c><c r="C1" t="inlineStr" s="5"><is><t>Ratio</t></is></c><c r="D1" t="inlineStr" s="5"><is><t>Expenses</t></is></c><c r="E1" t="inlineStr" s="5"><is><t>Date</t></is></c></row> <row r="2"> <c r="B2"><si><r><rPr><sz val="11"/><color theme="4"/><rFont val="Calibri"/><family val="2"/><scheme val="minor"/></rPr><t>Blue</t></r><r><rPr><sz val="11"/><color theme="1"/><rFont val="Calibri"/><family val="2"/><scheme val="minor"/></rPr><t xml:space="preserve"> </t></r><r><rPr><u/><sz val="11"/> <color theme="9"/> <rFont val="Calibri"/> <family val="2"/> <scheme val="minor"/> </rPr> <t>Widget</t> </r></si> </c><c r="C2" t="inlineStr"><is><t>V</t></is></c><c r="D2" t="inlineStr"><is><t>K</t></is></c></row> </sheetData></worksheet> My requirement is like in one cell "Blue Widget" with murltiple tesxt style,remaining three cells with V and K I formatted XML like this,multiple style is not working.Please give me as ample XML format for multiple styling in one cell and no styling in another cell for a sinlge workssheet in SPreadsheet xml format Please help me as iam strucked. Thanks in advance -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Rich-text-string-implementation-in-Biggriddemo-tp5724964.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
