Re: GAH!!!!!! Excel is so STUPID!

["Mark Allen" <scprideandms@xxxxxxxxx>]

i think I remember this being fixed in Excel 2007???  I'll have to check
tomorrow, not that I have to deal with Japanese much.....

On Wed, Aug 13, 2008 at 5:21 PM, Bill <brobins3d@xxxxxxxxx> wrote:

> David Gibbs wrote:
> > Folks:
>
> > LENB is (supposed to be) aware of double byte & single byte character
> > sets ... unfortunately, it's only aware of double byte characters when
> > Japanese is the default language on your PC.
> >
> > So, if Japanese IS the default language on your PC, and a character is
> > double byte ... it will return 2 as the length of the character.
> > However, if Japanese is *NOT* the default language on your PC ... it
> > will return 1 as the length of a character.
> >
> > There's no warning about this potential discrepancy when you load the
> > spread sheet ... the only way I was able to find this out was to dig
> > through the documentation.
>
>
> But isn't that the purpose of documentation, to tell us of things like
> that?  The help text for Excel 2003 is pretty straightforward:
>
> LENB counts each double-byte character as 2 when you have enabled the
> editing of a language that supports DBCS and then set it as the default
> language. Otherwise, LENB counts each character as 1.
> The languages that support DBCS include Japanese, Chinese (Simplified),
> Chinese (Traditional), and Korean.
>
> Bill
> --
> This is the PC Technical Discussion for iSeries Users (PcTech) mailing list
> To post a message email: PcTech@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/pctech
> or email: PcTech-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/pctech.