XSSFCell character encoding

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

XSSFCell character encoding

Matthias Gerth
Hi,

XSSFCell seems to encode certain character sequences as unicode characters. How can I prevent this? Do I need to apply some kind of character escaping?

e.g.
cell.setCellValue("LUS_BO_WP_x24B8_AI"); // The cell value now is „LUS_BO_WPⒸAI"

In Unicode Ⓒ is U+24B8

Regards
Matthias Gerth

Reply | Threaded
Open this post in threaded view
|

Re: XSSFCell character encoding

Dominik Stadler
This is the way how Excel encodes unicode characters here and thus POI
performs the same conversion as well, see
https://bz.apache.org/bugzilla/show_bug.cgi?id=57008#c8 for the related
issue and a longer explanation.

Dominik

On Jan 12, 2018 09:03, "Matthias Gerth" <[hidden email]> wrote:

Hi,

XSSFCell seems to encode certain character sequences as unicode characters.
How can I prevent this? Do I need to apply some kind of character escaping?

e.g.
cell.setCellValue("LUS_BO_WP_x24B8_AI"); // The cell value now is
„LUS_BO_WPⒸAI"

In Unicode Ⓒ is U+24B8

Regards
Matthias Gerth
Reply | Threaded
Open this post in threaded view
|

Re: XSSFCell character encoding

Matthias Gerth
This character conversion is done in XSSFRichTextString.utfDecode()
I have now written a function that basicaly does the same thing in reverse.

private static final Pattern utfPtrn = Pattern.compile("_(x[0-9A-F]{4}_)");

private static final String UNICODE_CHARACTER_LOW_LINE = "_x005F_";

public static String escape(final String value) {
    if(value == null) return null;

    StringBuffer buf = new StringBuffer();
    Matcher m = utfPtrn.matcher(value);
    int idx = 0;
    while(m.find()) {
        int pos = m.start();
        if( pos > idx) {
            buf.append(value.substring(idx, pos));
        }

        buf.append(UNICODE_CHARACTER_LOW_LINE + m.group(1));

        idx = m.end();
    }
    buf.append(value.substring(idx));
    return buf.toString();
}
Thank you
Matthias

> On 12 Jan 2018, at 13:34, Dominik Stadler <[hidden email]> wrote:
>
> This is the way how Excel encodes unicode characters here and thus POI
> performs the same conversion as well, see
> https://bz.apache.org/bugzilla/show_bug.cgi?id=57008#c8 for the related
> issue and a longer explanation.
>
> Dominik
>
> On Jan 12, 2018 09:03, "Matthias Gerth" <[hidden email]> wrote:
>
> Hi,
>
> XSSFCell seems to encode certain character sequences as unicode characters.
> How can I prevent this? Do I need to apply some kind of character escaping?
>
> e.g.
> cell.setCellValue("LUS_BO_WP_x24B8_AI"); // The cell value now is
> „LUS_BO_WPⒸAI"
>
> In Unicode Ⓒ is U+24B8
>
> Regards
> Matthias Gerth