Re: [dev] Re: Implementation details of spreadsheet function TEXT

2008-03-08 Thread Eike Rathke 
Hi Andreas,

On Friday, 2008-03-07 17:58:55 +0100, Andreas Saeger wrote:

 Sorry, I found an inconsistancy with this feature:
 =TEXT(A1;-MM-DD) works just fine
 =TEXT(A1;-MM-DD HH:MM:SS) returns -03-DD 08:17:40
 
 It needs to be
 =TEXT(A1;-MM-TT HH:MM:SS)
 with German locale.

Sigh.. I wish localized format codes were never introduced.

 May I file an issue?

I added details to
http://www.openoffice.org/issues/show_bug.cgi?id=72235

Thanks
  Eike

-- 
 PGP/OpenPGP/GnuPG encrypted mail preferred in all private communication.
 Key ID: 0x293C05FD - 997A 4C60 CE41 0149 0DB3  9E96 2F1A D073 293C 05FD


pgppNdEB6ugt6.pgp
Description: PGP signature

Re: [dev] Re: Implementation details of spreadsheet function TEXT

2008-03-08 Thread Eike Rathke 
Hi Andreas,

On Friday, 2008-03-07 18:23:21 +0100, Andreas Saeger wrote:

 Not shure if this is related to the TEXT function issue, but there seems
 to be something wrong with a similar API function.
 
 msgbox oNumberFormatter.convertNumberToPreviewString (-MM-DD
 HH:MM:SS, d, oLocale, TRUE)

Yes, internally that uses the same mechanism as the TEXT() spreadsheet
function. Also added to i72235

Thanks
  Eike

-- 
 PGP/OpenPGP/GnuPG encrypted mail preferred in all private communication.
 Key ID: 0x293C05FD - 997A 4C60 CE41 0149 0DB3  9E96 2F1A D073 293C 05FD


pgpBI01cPGGEl.pgp
Description: PGP signature