[sc-dev] Problem with GAMMADIST

2008-04-01 Thread Regina Henschel
Hi all, In Calc up to OOo 2.4 and in Excel [1] the function GAMMADIST works in this way: GAMMADIST(x;a;b;0) = 1 / (b**a * Γ(a) ) * x**(a-1) * e**(-x/b) [I write power as **] Therefore GAMMADIST(2;3;5;0) returns ≈0.010725. In ODF chapter 6.17.28 I now see, that there will be a function GAMM

Re: [sc-dev] Preparation of localizable separators in CWSkoheiformula01

2008-04-01 Thread Kohei Yoshida
Hi Daniel, On Tue, 2008-04-01 at 10:48 +0200, Daniel Rentz wrote: > Hello Kohei, Eike, all, > > > for public interest, I post my knowledge about formula separators in MS > Excel into the mailing list... > > After some testing with different Excel versions with different UI > languages (3.0 Ge

Re: [sc-dev] Something about the last patch of issue 35579

2008-04-01 Thread Thomas Benisch
Hi Gao, I cannot reproduce this crash. Can you provide me with some more details, e.g. a stack trace. After I added the code the export of the new filter conditions works fine. But I noticed, that the import of the new conditions fails, I think you should debug this, too. In addition I recommen

Re: [sc-dev] Preparation of localizable separators in CWS koheiformula01

2008-04-01 Thread Daniel Rentz
Hello Kohei, Eike, all, for public interest, I post my knowledge about formula separators in MS Excel into the mailing list... After some testing with different Excel versions with different UI languages (3.0 German, 4.0 German, 5.0 German, 2003 English and German, 2007 English) in combina

Re: Re: [sc-dev] Something about the last patch of issue 35579

2008-04-01 Thread gaozm
Hello Thomas: Thank you for your useful help. The code that you gave me is helpful, when "uno::Sequence< sheet::TableFilterField2 > aTableFilterFields2( xSheetFilterDescriptor2->getFilterFields2() )" is executed in function ScXMLExportDatabaseRanges::WriteFilterDescriptor(constuno::Refe