https://issues.apache.org/bugzilla/show_bug.cgi?id=52972
Bug #: 52972
Summary: Enable RichText in SXSSF
Product: POI
Version: unspecified
Platform: PC
OS/Version: All
Status: NEW
Severity: enhancement
Priority: P2
Component: SXSSF
AssignedTo: dev@poi.apache.org
ReportedBy: jim-apache@spudsoft.co.uk
Classification: Unclassified
Currently RichText is lost (converted to normal text) in SXSSF.
Two ways to support this were suggested on the mailing list: either maintaining
the RichText instances in memory (like styles) or streaming them via a separate
file.
For my purposes I think in memory would be adequate, but a streaming solution
that worked like SXSSF and kept the last n entries in memory would be tunable
for different cases.
--
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
https://issues.apache.org/bugzilla/show_bug.cgi?id=52972
piczmar@wp.pl changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |piczmar@wp.pl
--
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
https://issues.apache.org/bugzilla/show_bug.cgi?id=52972
--- Comment #1 from piczmar@wp.pl ---
In addition to this issue RichText is also trimmed if there are leading or
trailing spaces.
This issue is similar to Bug 48070. Probably it should be treated as separate
issue.
I have localized the problem comes from:
org.apache.poi.xssf.streaming.SheetDataWriter
In metod 'writeCell' fragment:
case Cell.CELL_TYPE_STRING: {
_out.write(" t=\"inlineStr\">");
_out.write("<is><t>");
outputQuotedString(cell.getStringCellValue());
_out.write("</t></is>");
break;
}
a check should be done if value contains leading/trailing spaces and then
handled differently:
_out.write("<is><t xml:space=\"preserve\">");
instead of:
_out.write("<is><t>");
--
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
https://issues.apache.org/bugzilla/show_bug.cgi?id=52972
Oliver Frank <of...@directbox.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |ofrank@directbox.com
--
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
https://issues.apache.org/bugzilla/show_bug.cgi?id=52972
--- Comment #3 from Yegor Kozlov <ye...@dinom.ru> ---
A very good catch, thanks!
Fixed in r1397499, junit aded.
Yegor
(In reply to comment #1)
> In addition to this issue RichText is also trimmed if there are leading or
> trailing spaces.
> This issue is similar to Bug 48070. Probably it should be treated as
> separate issue.
>
> I have localized the problem comes from:
> org.apache.poi.xssf.streaming.SheetDataWriter
> In metod 'writeCell' fragment:
>
> case Cell.CELL_TYPE_STRING: {
> _out.write(" t=\"inlineStr\">");
> _out.write("<is><t>");
> outputQuotedString(cell.getStringCellValue());
> _out.write("</t></is>");
> break;
> }
> a check should be done if value contains leading/trailing spaces and then
> handled differently:
>
> _out.write("<is><t xml:space=\"preserve\">");
> instead of:
> _out.write("<is><t>");
--
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
https://issues.apache.org/bugzilla/show_bug.cgi?id=52972 --- Comment #2 from dirk.wilden@iav.de --- it is also the same issue with leading/trailing linebreaks (\n). They are trimmed as well. -- 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