[Bug 57008] Wrting _x0427_ to a string cell changes the string to some strange UTF-8 character

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[Bug 57008] Wrting _x0427_ to a string cell changes the string to some strange UTF-8 character

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=57008

--- Comment #12 from Mark Murphy <[hidden email]> ---
I was intrigued by this issue so I went into Excel and typed LUS_BO_WP_x24B8_AI
into a cell. Excel retained the text as typed. So I looked in the XML and found
that _x24B8_ had been changed to _x005F_x24B8_. It seems to me that when a user
sets a value, that value should be escaped if it isn't already so that what
they set the value to is what they get. I also recognize that some may need to
use the special strings to encode Unicode characters, and would want them to
appear as such. It seems to me that the default behavior should be to insert
the escaped value into the cell, and have a special setRawValue() method for
the cases where you want those special values to remain unescaped. Though I
could be convinced that we should leave setValue alone and create a
setEscapedText() method where a user might want to use these _x####_ values.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]