https://issues.apache.org/bugzilla/show_bug.cgi?id=52484
--- Comment #4 from Yegor Kozlov <[email protected]> 2012-01-20 07:07:53 UTC --- It is a conceptual limitation. In a normal Excel file strings are stored in a special file called Shared String Table (SST) and it acts as a cache of strings. Cells don't store string values, instead they store a reference into the SST and two cells holding the same string will have the same reference into the SST. An alternative way to store strings is inside cell but in this case only plain text can be written. Rich text is supported only in SST. SXSSF is a streaming, forward-only API and it writes data immediately as it is passed to the API. This means that SXSSF does not cache strings. When a rich text string is passed it is converted into plain text and written as a plain text cell value. I don't see an easy way to improve it. If you want all Excel features then give more memory to Java and use XSSF. P.S. I'm going to reflect it in the documentation. The Spreadsheet API feature summary (http://poi.apache.org/spreadsheet/index.html) should explicitly say that rich text is not supported in SXSSF. Yegor (In reply to comment #2) > Thanks for the reply, Yegor. > > Will it ever be supported? > > Your suggestion wouldn't look like a footnote, as either the entire cell would > be superscripted, or the footnotes would float off away from the text in their > own superscript column, which defeats the logic behind a super-script. > > In HTML and Java Swing you can superscipt: > > My Row Header <sup>(1)</sup) > My Second Row Header > Third <sup>(2)></sup> -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
