poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 52484] Superscript font works for XSSFWorkbook but not SXSSFWorkbook
Date Fri, 20 Jan 2012 11:06:46 GMT

--- Comment #6 from Yegor Kozlov <yegor@dinom.ru> 2012-01-20 11:06:46 UTC ---
In theory we can stream SST too. In this case it wouldn't be a cache of strings
- we will simply write out strings and set the SST index in the cell. 

It is not trivial and will take some time to implement. The starting point is
SSTDataWriter which will convert rich text to xml and write into a temp file.
The implementation should be similar to SheetDataWriter which does this job for
cells and rows. SSTDataWriter  should keep track of the last written index and
total number of entries in the SST. 

Next we will tweak SXSSF to delegate string data to SSTDataWriter and update
the SST index in the cell.   

This is something to plan for POI-3.9. Until we release 3.8-final I would stay
on the safe side and keep SXSSF as it is. 


(In reply to comment #5)
> How does the SST differ from the Styles table, which is also maintained in
> memory and referenced by the streaming SXSSF?
> In other words, whilst SXSSF obviusly couldn't work if all cells were RichText
> (because the SST would have to be in memory and SXSSF wouldn't gain you
> anything) couldn't it still be beneficial if only a minority of the cells are
> RichText?
> We'd need to have an option to tell SXSSF which way to handle RichText, but for
> my circumstance it would work (I usually have either huge sheets or fancy
> sheets, but I don't know which until after I've started outputting them).

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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message