On Wed, 14 Aug 2013, lilliank wrote:
The only difference in the files appears to be that in the SXSSFWorkbook the string contents are inline as inlineStr cells, while in XSSFWorkbook they’re in sharedStrings.xml and apparently the native mac .xlsx viewer can’t handle inline strings.
You might want to report a bug to apple about this, but that won't be a short term fix...
*My question is this*: can SXSSFWorkbook be altered to use sharedStrings.xml instead of inlineStr cells? (On the assumption that that's what's breaking preview on the mac.)
It would require quite a lot more memory to do it that way. Inline strings can get flushed out immediately, so don't need buffering. They also don't have dependencies between sheets, forwards and backwards in rows etc.
The Shared Strings have to be in memory the whole time you're working on the file, and will apply across sheets, so can be pretty large. Using them would negate at least some of the memory advantages of SXSSF over XSSF
That said, it probably wouldn't be that much work to try out, and we'd be glad of a patch if you could make it toggle-able. You should be fine to load the existing shared strings table yourself, or create a new one if needed, then add things into it
Nick
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
