To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=70213
------- Additional comments from [EMAIL PROTECTED] Thu Jun 7 11:00:41 +0000
2007 -------
Hi Takashi,
Thank you very much for clarification.
> First of all, I hope the test case document covers all related
> characters, but it's not uncertain because I can't find any
> specification of Excel's JIS and ASC function.
I doubt there is any official full specification. Also the ECMA/MOOXML
spec only repeats what the Excel online help already tells.
> I will ask other
> Japanese contributors to find other characters that should be
> supported by the functions.
Would be fine if we could get an answer very soon, if there are
additional conversions needed. We'll also have to nail this down in the
OASIS ODF formula (ODFF aka OpenFormula) specification.
> Second, the implementation of Excel's JIS and ASC function is so
> unclear that you may have some irrational problems. As to the
> convertion of 0x0022 QUOTATION MARK, you should make your
> implementation's result same as one of Excel.
As this obscure function only exists for Excel interoperability I'll
simply mimick that behavior.
> Third, I looked over your modification and I found an error. While you
> commented out some lines related to "katakana vu" in
> lcl_convertIntoFullWidth, the corresponding lines in
> lcl_convertIntoHalfWidth are not commented out. Originally this is my
> fault :-p I'm sorry.
Ah, thanks for pointing that out, I overlooked it. I simply tweaked the
code until it gave the same results as Excel, and that code portion was
never reached because the 0x30a2 character in question is already
handled correctly with the first if statement
if( pSrc[i] >= 0x30a1 && pSrc[i] <= 0x30aa && (pSrc[i] % 2) == 0 )
> However, according to the explanation of ASC function in Excel's help
> document, it should convert full width "katakana vu" into half
> characters literally, but it doesn't do so in fact. This problem is
> stated here (sorry I couldn't find the equivalent page written in
> English):
> http://support.microsoft.com/kb/402493/ja
Well, thanks for the pointer, whatever may be written there ;-)
I just can decifer the table that lists (apparently for Excel 5.0) some
full-width characters that seem to be converted to half-width using ASC.
And two other columns with characters with no conversion. However, only
a few numbers given in the second column there actually match the
hexagesimal Unicode value of the characters shown, so I'm more puzzled
than delighted by that table..
Eike
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
