### [sc-dev] stable algorithm for statistic functions issue 78250

Hello, I had a look at the source in interpr3.cxx and have made the proposed changes for the COVAR function. Although I'm a very beginner I think, that I'm able to change some of the other such functions too. The changes need to calculate the mean in a first loop and than calculating the

### Re: [sc-dev] stable algorithm for statistic functions issue 78250

Hello Eike, Eike Rathke schrieb: Hi Regina, On Thursday, 2007-07-05 10:34:37 +0200, Regina Henschel wrote: For COVAR it looks like this (based on OOF680_m18): Very nice, indeed. Could you do us a favor though and base your changes on a recent SRC680 milestone (latest available now is m219

### Re: [sc-dev] stable algorithm for statistic functions issue 78250

Hello Niklas, Niklas Nebel schrieb: Regina Henschel wrote: I had a look at the source in interpr3.cxx and have made the proposed changes for the COVAR function. Although I'm a very beginner I think, that I'm able to change some of the other such functions too. The changes need to calculate

### Re: [sc-dev] Is printing 0-values from formula's normal?

Hi Cor, Cor Nouws schrieb: Hi *, Cannot find an issue, so maybe by design? A speadsheat has formulas that (somtimes) result in zero. Settings ar to hide zero-values, so those cells are empty. However print preview and print do show them. 1.1.5 / 2.2 Bug or design? No bug, but feature.

### Re: [sc-dev] long formula with many conditions

Hi Ain, Ain Vagula schrieb: Hi, I have a spreadsheet from http://www.passiv.de/04_pub/Literatur/PHVP2002/PHVP02.ZIP In sheet U_Werte, cell K140 it contains formula:

### Re: [sc-dev] long formula with many conditions

Hi Ain, some additional remarks: Regina Henschel schrieb: Instead of COUNTIF(G140:G142;)=2 use COUNTBLANK(G140:G142)=2 This works only, of the cells are really empty. If a cell contains a formula with return an empty string, then I know no way to get the same result in Excel

### Re: [sc-dev] RATE function; issue 15090

Hi Eike, a remark on the ODFF-spec: The parameter 'PaymentType' has got type 'number'. In the description only the values 0 and 1 are mentioned. But there is no constraint to {0;1}. The description doesn't say what to do with other values. The parameter 'PaymentType' in the equation can be

### Re: [sc-dev] RATE function; issue 15090

Hi Eike, Eike Rathke schrieb: Hi Regina, On Sunday, 2008-02-03 01:27:55 +0100, Regina Henschel wrote: a remark on the ODFF-spec: The parameter 'PaymentType' has got type 'number'. In the description only the values 0 and 1 are mentioned. But there is no constraint to {0;1}. The description

### Re: [sc-dev] RATE function; issue 15090

Hi Eike, Eike Rathke schrieb: Hi Regina, On Monday, 2008-02-11 12:09:25 +0100, Regina Henschel wrote: for those, who read this. I've discussed it on [EMAIL PROTECTED] I've found a comment in http://wiki.services.openoffice.org/wiki/Windows#Extra_requirements with link for gperf http

### Re: [sc-dev] RATE function; issue 15090

problems exist. kind regards Regina Regina Henschel schrieb: Hi Eike, Eike Rathke schrieb: Hi Regina, I have not done it yet. Now I have installed WinCvs and have been able to check out the sc modul with the tag cws_src680_odff. Therefore I think, that it will be feasible for me in principle

### [sc-dev] precision of GAMMALN

Hello, the function GAMMALN is calculated with the Lanczos algorithm. The precision of the result depends on some coefficients. In the current version in OOo the coefficients give only a precision of up to 10 significant digits. I looked around for some better coefficient and found them in

### [sc-dev] constraints for ODF gamma function

Hi, in ODF 6.15.31 I find Syntax: GAMMA( Number N ) Constraints: N = 0 I think the constraint is wrong. GAMMA(0) is not defined. But there is no need for N0. The gamma function is defined for negative numbers too, besides the singularities for non-positive integers. Therefore the constraint

### Re: [sc-dev] Need help with error handling in interpr

Hi Eike, Eike Rathke schrieb: Hi Regina, On Sunday, 2008-04-13 13:25:25 +0200, Regina Henschel wrote: Can I use throw errNoConvergence; for example in this way? do ... while (!bFinished fCount1); if (fCount=1) { throw errNoConvergence

### Re: [sc-dev] [Issue 90759] ZTEST not same as Excel

Hi David, David King schrieb: Moving discussion of this issue here, at Regina's request. Hi Regina The function ZTEST should depend on NORMSDIST. Therefore NORMSDIST has to be controlled and improved first. I'm afraid I disagree pretty whole heartedly :) NORMSDIST may or may not be more

### Re: [sc-dev] [Issue 90759] ZTEST not same as Excel

Hi all, David King schrieb: [..] Whatever :). Yours is certainly clearer, mine a bit faster. I've attached a patch with your proposal to the issue. But both ways would have fSumSqr - fSum*fSum/rValCount which might give similar problems like in issue 78250. Yes - really should

### [sc-dev] wrong display for special function result near 1

Hello all, I'm working on BETADIST. For certain inputs my version of that function returns a value, which is near to 1. The formula in the cell is =BETADIST(B\$3;\$B\$1;\$A8) with B3=0,999 and B1=1e-9 and A8=1,5. The result should be shown as 1,00E+000 but it is shown as

### Re: [sc-dev] missing function log1p and expm1

Hi Eike, in addition: Regina Henschel schrieb: which I found as tip on http://www.plunk.org/~hatch/rightway.php. He gives also a version from which he says, it is from Kahan, but I have not tested the other. In the meantime I tested that version, and it works as well. I have submit http

### [sc-dev] development status of BETADIST

Hello all, this mail is about BETADIST(x,alpha,beta,lower bound, upper bound, cumulative) I have attached the actual stage of my work to issue 91547. The patch has already a status that it could be used, but there are still problems. I have attached it anyway, so that you can have a look at

### [sc-dev] How to use erfc() or getErfc() from scaddins in sc ?

Hello, I'm writing a function, which is local in interpr3.cxx. For this function I need erfc() or getErfc() from scaddins. How to get it? kind regards Regina - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

### Re: [sc-dev] How to use erfc() or getErfc() from scaddins in sc ?

Hi Daniel, hi Kohei, Daniel Rentz schrieb: Kohei Yoshida schrieb: Hi Regina, On Sun, 2008-08-03 at 18:53 +0200, Regina Henschel wrote: Hello, I'm writing a function, which is local in interpr3.cxx. For this function I need erfc() or getErfc() from scaddins. How to get it? Looks to me

### Re: [sc-dev] development status of BETADIST

+0200, Regina Henschel wrote: (2) Nearly all terms inside have parts like (1-x)^r. When the x argument is close to 1, approximately x 0., then the term (1-x)^r has large cancellation errors. I know no way to avoid it. Switching to power series 1+x^2+x^3+... is no solution, because

### Re: [sc-dev] How to use erfc() or getErfc() from scaddins in sc ?

Hi Daniel, Daniel Rentz schrieb: Hi Regina, Regina Henschel schrieb: [..] But the next part, which I want to modularize, is the algoritm known as BASYM (Didonato/Morris algoritm 708). It is a part of about 90 lines. Unfortunately it needs the private functions double ScInterpreter

### Re: [sc-dev] development status of BETADIST

abgeschickt ohne Begrüßung, tut mir leid. Bitte hinzufügen: Hi Eike, :) Bis dann Regina - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

### Re: [sc-dev] development status of BETADIST

Hi Eike, Eike Rathke schrieb: Hi Regina, On Tuesday, 2008-08-05 22:17:56 +0200, Regina Henschel wrote: MuPad, the CAS I have got at home, overflows for large parameters. Of cause high end programs like Mathematica have no problems there (You can use it online for single function calls

### [sc-dev] What source for implementation of spreadsheet functions?

Hi, I want to bring GAMMA and CHISQDIST to UI. I've tried the guide in http://wiki.services.openoffice.org/wiki/Calc/Implementation/Spreadsheet_Functions for GAMMA and it works as described. But the build I used is rather old, a DEV300m20. Therefore I think I need a new build. Am I right?

### Re: [sc-dev] Some details of EUROCONVERT() specification.

Hi Lvyue, do you know the description from Microsoft? http://office.microsoft.com/en-us/excel/HP100624761033.aspx kind regards Regina lvyue schrieb: Hi, all I'm working on EUROCONVERT(), while implementing it, I found some details unmentioned in specifies. the format of the formula is

### [sc-dev] Which category for GAMMA and GAMMALN?

Hi, I want to bring the GAMMA function to UI, which works in general. But I have some questions for details. GAMMALN is currently in Category 'Statistical'. But in OpenFormula-v1.2-draft9.odt (which is the most current) it is in chapter '6.15 Mathematical Functions'. GAMMA is an expansion

### [sc-dev] Style of strings in sc/source/ui/src/scfuncs.src

Hello, I'll introduce new functions and I'm uncertain, how I should write the strings in the mentioned resource file. (1) Upper or lower case? If I give the type of the parameter, should I use lower or upper case, for example Number or number? Same if I give the name of the parameter, for

### Re: [sc-dev] Style of strings in sc/source/ui/src/scfuncs.src

Hi Niklas, thanks for your quick answer. I'll follow your remarks. kind regards Regina - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

### [sc-dev] How to handle ODFF constrain number must be integer?

Hello, and another questions, but I'm confident to finish this project next week ;) In the ODFF draft spec of CHISQDIST is a constraint for the parameter 'degrees of freedom' to be integer. Should I implement it: (1) break with an illegal argument error, if the value is not an integer or (2)

### Re: [sc-dev] How to handle ODFF constrain number must be integer?

Hi Niklas, Niklas Nebel schrieb: On 09/27/08 20:06, Regina Henschel wrote: In the ODFF draft spec of CHISQDIST is a constraint for the parameter 'degrees of freedom' to be integer. Shouldn't the argument type be integer instead? It seems to be an open ToDo, see remark at the end of part

### Re: [sc-dev] Which category for GAMMA and GAMMALN?

Hi Eike, thanks for your answer. Next step to finish :) kind regards Regina Eike Rathke schrieb: Hi Regina, replying after vacation gap.. On Sunday, 2008-09-21 19:26:04 +0200, Regina Henschel wrote: GAMMALN is currently in Category 'Statistical'. But in OpenFormula-v1.2-draft9.odt (which

### [sc-dev] Cannot use LEGACY.xxx style of functions in OOo3

Hi, reading the ODFF draft spec I have assumed, that it is possible to access the functions which have LEGACY.xxx names in exact this way. But it doesn't work. This might not be a problem with CHIDIST, because it is clear, that this is the old, right tailed form, because CHISQDIST is the new

### Re: [sc-dev] Congratulations, Regina! Gold Award winner of the Community Innovation Program.

regards Regina OpenOffice.org announced the winners of the Community Innovation Program, http://development.openoffice.org/awardees-2008.html I'm especially pleased that the Calc project is represented by Regina Henschel who is one of the Gold award winners for her work on improvements

### [sc-dev] Examine changes for ODFv1.2

Hi all, in discussion with Eike the idea has come up, to examine which changes are necessary to adapt the functions to ODF1.2, especially examine the distributions. First I thought to write a document, but now I have the idea to track it in the Wiki. My plan is a page like

### Re: [sc-dev] Examine changes for ODFv1.2

Hi all, Niklas Nebel schrieb: On 10/10/08 02:44 PM, Regina Henschel wrote: in discussion with Eike the idea has come up, to examine which changes are necessary to adapt the functions to ODF1.2, especially examine the distributions. First I thought to write a document, but now I have the idea

### Re: [sc-dev] Rebasing CWS odff05

Hi Eike, Eike Rathke schrieb: Hi, On Tuesday, 2008-11-18 17:31:03 +0100, Eike Rathke wrote: I started migrating CWS odff05 from CVS (currently resynced to m31 there) to SVN, and then will rebase it to m36 when available. I'll give you a heads up when the CWS will be ready for further

### [sc-dev] Implement expm1 and log1p

Hi, I've got a build of odff05 now and want to continue work. I need expm1 and log1p (issue 91602). I can put the following code into sal\inc\rtl\math.hxx, so I can use the functions with ::rtl::math::expm1 and ::rtl::math::log1p in interpr*.cxx Is it necessary to have a solution, which

### Re: [sc-dev] Implement expm1 and log1p

Hi Eike, I've attached it in patch form to issue 91602 kind regards Regina Eike Rathke schrieb: Hi Regina, On Monday, 2008-12-01 16:06:53 +0100, Regina Henschel wrote: I've got a build of odff05 now and want to continue work. I need expm1 and log1p (issue 91602). I can put the following

### Re: [sc-dev] How to continue after issue 94555 (CHISQDIST)

Hi Eike, Eike Rathke schrieb: Hi Regina, On Tuesday, 2008-12-02 18:34:25 +0100, Regina Henschel wrote: I have updated the patches in issue 94555. The work in that area is finished. Please have a look. Thanks a lot! I now want to go further on to BETADIST. Should I make the necessary

### Re: [sc-dev] The default parameter of formula LOG() and POISSON().

Hi Yue, I've added the issues numbers to http://wiki.services.openoffice.org/wiki/Calc/ODFF_Implementation/Examine_functions kind regards Regina lvyue schrieb: Hi Eike, I also finished the changes to the default parameter of formula LOG() and POISSON() in these two days. I know that

### Re: [sc-dev] How to continue after issue 94555 (CHISQDIST)

Hi Eike, Eike Rathke schrieb: Hi Regina, On Tuesday, 2008-12-02 18:34:25 +0100, Regina Henschel wrote: I have updated the patches in issue 94555. The work in that area is finished. Please have a look. Thanks a lot! I've hoped that the patch in 94555 (CHISQDIST) will get into odff05

### [sc-dev] Decision needed for FISHERINV and ATANH

Hi, I have examined FISHER and FISHERINV and thereby struggle about some problems. FISHERINV(x) is not accurate for x very near to zero. For example FISHERINV(1E-15)=1.1387379200E-015, but should result in 1E-15. That can be easily fixed by calling tanh() instead of the current

### Re: [sc-dev] Decision needed for FISHERINV and ATANH

Hi Eike, Merry Christmas and a happy New Year to you. Eike Rathke schrieb: Hi Regina, On Wednesday, 2008-12-17 16:22:09 +0100, Regina Henschel wrote: Mathematically FISHER(x)=atanh(x). But the OOo function ATANH() uses the same insufficient algorithm as FISHER. Therefore ATANH() has

### [sc-dev] How to export expanded LOGNORMDIST to Excel

Hi, I'm expanding LOGNORMDIST to the form it has in ODF spec. There it is LOGNORMDIST( Number x [ ; Number m = 0 [ ; Number s = 1 [ ; Logical Cumulative = TRUE() ] ] ] ) Inside OOo it is no problem. But how to export it to Excel? Excel has 3 Parameters, no one optional. For expanding

### Re: [sc-dev] How to export expanded LOGNORMDIST to Excel

Hi Daniel, Daniel Rentz schrieb: Regina Henschel schrieb: Hi, I'm expanding LOGNORMDIST to the form it has in ODF spec. There it is LOGNORMDIST( Number x [ ; Number m = 0 [ ; Number s = 1 [ ; Logical Cumulative = TRUE() ] ] ] ) Inside OOo it is no problem. But how to export it to Excel

### Re: [sc-dev] How to export expanded LOGNORMDIST to Excel

Hi Eike, hi Daniel, I delete the old mail-texts, because it becomes to long and confusing. There are still problems. First the Excel part: Exporting to xls is OK now. I get #NV for four parameters and for parameter count 3 the missing parameters are added. But export to Microsoft Excel

### Re: [sc-dev] How to export expanded LOGNORMDIST to Excel

Hi Eike, Eike Rathke schrieb: Hi Regina, On Tuesday, 2009-03-17 18:04:12 +0100, Regina Henschel wrote: But export to Microsoft Excel 2003 XML (.xml) is problematic. If OOo is set to save in odf1.2, the file opens with errors in Excel. All formulae are stripped. The error log says

### Re: [sc-dev] How to export expanded LOGNORMDIST to Excel

Hi Eike, hi Daniel, Regina Henschel schrieb: No more questions for now, I'll continue my tests. Thanks for your help. Now all works as it should and I'm going to create patches. And have got the next problem. For the file token.cxx in formula/source/core/api I get an odd patch. The patch

### Re: [sc-dev] Move ERF and ERFC from scaddins to sal

Hi Eike, Eike Rathke schrieb: Hi Regina, On Sunday, 2009-03-22 22:31:08 +0100, Regina Henschel wrote: May I ask you to fix that issue, so that I can update my working copy? My changes for NORMDIST and LOGNORMDIST include a fix for the NORMDIST part of http://www.openoffice.org/issues

### Re: [sc-dev] TortoiseSVN and CrLf

Hi Eike, Eike Rathke schrieb: Hi Regina, On Wednesday, 2009-03-25 14:22:17 +0100, Regina Henschel wrote: Thanks. I have updated my working copy using TortoiseSVN and hope that all is OK. You will tell me, if something is wrong with my next patches. :) Sure :) btw, which reminds me

### [sc-dev] signaling domain error in acosh

Hi all, I'm working to increase accuracy of ScArcCosHyp(). The function acosh is part of C99 but not provided by MSVC. Therefore I have written the ersatz in sal\rtl\source\math.cxx double SAL_CALL rtl_math_acosh( double fX ) SAL_THROW_EXTERN_C() { double fZ = fX - 1.0; if ( fX ==

### [sc-dev] Need UI name for new FDIST function

Hi all, (CC dev@sc.openoffice.org) with OpenFormula v1.2 we will get a new FDIST function. The current FDIST function calculates the _right_ tail cumulative distribution function of the F-distribution. The new function will calculate the _left_ tail cumulative distribution function and the

### [sc-dev] Implementation details for FDIST

Hi, besides the UI-name problem I come across two other questions. (1) If the numerator degrees of freedom (r1) is 1, then the density function has a pole at x=0. The draft spec does not define the return value in that case. For x0 it defines that the return value is 0. For x=0 it defines it

### [sc-dev] Implementation details of POISSON

Hi all, I have a look at the function POISSON for issue http://www.openoffice.org/issues/show_bug.cgi?id=69069 The bug is easy to fix, I have tested my solution already and it work so far, but I have some questions. (1) In draft spec of ODF the function POISSON has a constraint lambda 0.

### [sc-dev] Schedule for CWS odff06

Hi Eike, you have set 2009-07-06 as date for 'ready for QA', but feature freeze for 3.2 is already 2009-06-dd http://wiki.services.openoffice.org/wiki/OOoRelease32 And issue 100119 is a feature, isn't it? kind regards Regina

### Re: [sc-dev] About Issue 66028's correct behavior.

Hi Maoyg, maoyg schrieb: Hi, all I want to discuss this issue's the specification with your. If you think it is important, I hope you can vote it. As we know, the calc for the merged cell(selection etc) is different from the excel, I have some advice for the spec, I hope you can discuss

### Re: [sc-dev] About Issue 66028's correct behavior.

Hi Niklas, Niklas Nebel schrieb: On 05/25/09 05:33, maoyg wrote: I suggest the following behavior: For calculating the continuing interval, not-empty hidden cells are treated as if they were not hidden, and empty hidden cell are treated as if they do not exist. The hidden cell are only

### Re: [sc-dev] Re: [ux-discuss] About Issue 66028's correct behavior.

Hi maoyg, maoyg schrieb: Hi,all I have updated the specification for issue 66028, if you don't object it, according to the specification I will start to implement it. I have made same changes and annotations. The file is attached to the issue. Are you going to put your description into the

### Re: [sc-dev] Build problems (was: Rebasing CWS odff06 to m50)

Hi Eike, Eike Rathke schrieb: Hi dev, On Wednesday, 2009-06-17 11:24:36 +0200, Eike Rathke wrote: [... assertions in a Linux non-pro build ...] Applying the patch from http://qa.openoffice.org/issues/show_bug.cgi?id=102806 helped. Not committed to the CWS branch. I get the build errors:

### [sc-dev] How should MULTIPLE.OPERATIONS calculate?

Hi all, thinking about issue 102980 and 102981 I found, that it is not clear to me, how to calculate MULTIPLE.OPERATIONS at all. Take a spreadsheet and enter the following numbers and formulas into column A, beginning in cell A1 with number 2. 2 3 =A1+A2 30 =MULTIPLE.OPERATIONS(A3;A2;A4)

### Re: [sc-dev] How should MULTIPLE.OPERATIONS calculate?

Hi all, Regina Henschel schrieb: Hi all, thinking about issue 102980 and 102981 I found, that it is not clear to me, how to calculate MULTIPLE.OPERATIONS at all. Take a spreadsheet and enter the following numbers and formulas into column A, beginning in cell A1 with number 2. 2 3 =A1+A2

### Re: [sc-dev] How should MULTIPLE.OPERATIONS calculate?

Hi Niklas, Niklas Nebel schrieb: On 06/21/09 22:57, Regina Henschel wrote: In ODF1.2 draft spec I read, MULTIPLE.OPERATIONS executes the formula expression pointed to by FormulaCell and _all_ formula expressions it depends on while replacing _all_ references to RowCell with references

### Re: [sc-dev] How should MULTIPLE.OPERATIONS calculate?

Hi Niklas, Niklas Nebel schrieb: On 06/22/09 15:11, Regina Henschel wrote: That makes it not clearer and I do not see by which rules OOo results in 702. Would you be so kind to give a step by step calculation? And besides the question what OOo does, there is the question whether

### Re: [sc-dev] How should MULTIPLE.OPERATIONS calculate?

Hi Niklas, Niklas Nebel schrieb: On 06/22/09 17:10, Regina Henschel wrote: Right. A1+A2 is calculated as A1+A6, which is 2+700, or 702. So OOo drops =MULTIPLE.OPERATIONS(A3;A6;A4)? OOo acts as if the formula in A5 is =A3. All references to A6 in A3's formula are replaced with A4

### Re: [sc-dev] Build problems

Hi Eike, Eike Rathke schrieb: Hi Regina, On Saturday, 2009-06-20 13:26:08 +0200, Regina Henschel wrote: dmake: Error: -- `../inc/store/object.hxx' not found, and can't be made /cygdrive/c/SoftwareArchiv2/odff06/store/source Did Frank's hint in d...@ooo to regenerate the dependency files

### Re: [sc-dev] Problems with BESSELJ

Hi Eike, Eike Rathke schrieb: Hi Regina, On Sunday, 2009-06-28 20:20:17 +0200, Regina Henschel wrote: Searching around I come across an iterative solution from Peter Deuflhard [1] (German). My tests as Basic macro results in an accuracy of at least 12 digits. But it needs approximately

### [sc-dev] OOo2.4.2 takes of:=FDIST(a,b,c) as if it is ooc:=FDIST(a,b,c)

Hello all, during my implementation of FDISTL I saw the following problems. (1) I generate a file with a formula =FDISTL(a,b,c) and store it in version ODF1.2. Unzipping the file I find of:=FDIST(a,b,c), which is correct. Now I open the file in OOo2.4.2. I get the version warning to upgrade.

### Re: [sc-dev] Problems with BESSELJ

Hi Eike, Eike Rathke schrieb: Hi Regina, On Tuesday, 2009-06-30 23:34:27 +0200, Regina Henschel wrote: What is large and what is long lasting? I would have to implement it in C++ to see how long it really lasts. The Basic macro lasts several seconds for x1. The effort is linear in x

### Re: [sc-dev] Problems with BESSELJ

Hi Eike, Eike Rathke schrieb: Hi Daniel, On Wednesday, 2009-07-08 18:37:59 +0200, Daniel Rentz wrote: Anyway, I would volunteer to do these changes. :) Roll back! ;-) That would complicate things even further because the addin.Analysis name is used in API calls, moving implementation to

### Re: [sc-dev] Problems with BESSELJ

Hi Eike, hi Niklas, Eike Rathke schrieb: Hi Regina, On Thursday, 2009-07-09 12:17:43 +0200, Regina Henschel wrote: (1) How do I introduce a new exception? The attached (hopefully not stripped by the mailing list software)patch I've received it. adds the ::com::sun::star::sheet

### Re: [sc-dev] Problems with BESSELJ

Hi Eike, Eike Rathke schrieb: Hi Regina, On Thursday, 2009-07-09 12:17:43 +0200, Regina Henschel wrote: (1) How do I introduce a new exception? The attached (hopefully not stripped by the mailing list software) patch adds the ::com::sun::star::sheet::NoConvergenceException to the offapi

### Re: [sc-dev] Problems with BESSELJ

Hi Eike, Eike Rathke schrieb: Hi Regina, On Thursday, 2009-07-09 15:47:06 +0200, Regina Henschel wrote: (3) I have tried to use the Message of the exception. But there I fail already in the syntax. The original exception's Message should be available as rWrapped.TargetException.Message I

### [sc-dev] Missing second parameter in CEILING

Hi, I'am currently looking at issue 102957 ODFF: FLOOR and CEILING should work with a single argument. Now OOo allows CEILING(N;Significance;Mode) and CEILING(N;Significance). I have made some changes to allow CEILING(N) too. Thereby I noticed the following problem: OOo allows

### Re: [sc-dev] Missing second parameter in CEILING

Hi Eike, Eike Rathke schrieb: Hi Regina, On Wednesday, 2009-08-05 16:06:45 +0200, Regina Henschel wrote: I'am currently looking at issue 102957 ODFF: FLOOR and CEILING should work with a single argument. Now OOo allows CEILING(N;Significance;Mode) and CEILING(N;Significance). I have made

### Re: [sc-dev] Missing second parameter in CEILING

Hi Daniel, I do not answer directly, because it seems that I described my concern not good enough. Next try: == Import == Importing an Excel-file with =CEILING(-3.4;) for example gives the cellcontent =CEILING(-3.4;;1), because in the current import filter the third parameter 1 is added to

### Re: [sc-dev] Missing second parameter in CEILING

Hi Eike, hi Daniel, Eike Rathke schrieb: Hi Daniel, Regina, On Wednesday, 2009-08-12 10:15:43 +0200, Daniel Rentz wrote: Regina Henschel schrieb: == Import == Importing an Excel-file with =CEILING(-3.4;) for example gives the cellcontent =CEILING(-3.4;;1), because in the current import

### Re: [sc-dev] Re: [Issue 90759] ZTEST not same as Excel

Hi Leonard, Leonard Mada schrieb: Dear Calc team, the following wording is ambiguous and it may be wrong altogether: function description: calculates the probability of a *sample* mean greater than the mean of the given *sample*. [EMPHASIS ADDED] A long phrase for the application help

### Re: [sc-dev] Re: [Issue 90759] ZTEST not same as Excel

Hi Eike, hi Leonard, Eike Rathke schrieb: Hi Leonard, On Tuesday, 2009-08-25 15:45:42 +0200, Leonard Mada wrote: I would therefore stick with the one sample definition, and adapt only the text to correspond to what actually the function computes. The p-value is the probability, under the

### Re: [sc-dev] What are valid arguments for INDIRECT

Hi Niklas, Niklas Nebel schrieb: On 09/19/09 22:15, Regina Henschel wrote: the submitter of issue 105182 closed the issue, because he find a way to solve his problem. But for me the situation is not clear. =ISREF(D1:D3!C2:E2) returns TRUE but =ISREF(INDIRECT(D1:D3!C2:E2)) returns FALSE

### [sc-dev] Functions in Excel 2010

Hi all, Excel 2010 has some significant changes for statistical functions, see [1][2]. Are there any plans to adapt the import filter and to implement further functions? Has work on this already started? kind regards Regina [1] http://blogs.msdn.com/excel/attachment/9905140.ashx or search

### Re: [sc-dev] Functions in Excel 2010

Hi Niklas, Niklas Nebel schrieb: On 04/02/10 21:49, Regina Henschel wrote: Excel 2010 has some significant changes for statistical functions, see [1][2]. Are there any plans to adapt the import filter and to implement further functions? Has work on this already started? At the moment

### [sc-dev] constraint of x in sin(x) in scaddins

Hi all, I have notice a constraint SinOverflow (which is x=134217728) in analysishelper.cxx in scaddins. What is the special reason for it? In other places with sin() the version ::rt::math::sin() is used to get a guard for overflow. That would result in constraint x=9,22337203685478E+018,

### Re: [sc-dev] constraint of x in sin(x) in scaddins

Hi Leonard, it seems, that I have not been clear enough. sin() is a function in the math library of C and C++ compilers and is nowadays accurate in double precision up to x2^64. To prevent larger arguments the special implementation ::rtl::math::sin() is used in OOo. But inside the

### Re: [sc-dev] constraint of x in sin(x) in scaddins

Hi Niklas, Niklas Nebel schrieb: On 05/08/10 21:02, Regina Henschel wrote: I have notice a constraint SinOverflow (which is x=134217728) in analysishelper.cxx in scaddins. What is the special reason for it? In other places with sin() the version ::rt::math::sin() is used to get a guard

### Re: [sc-dev] constraint of x in sin(x) in scaddins

Hi Eike, Eike Rathke schrieb: Hi Regina, On Saturday, 2010-05-08 21:02:45 +0200, Regina Henschel wrote: I have notice a constraint SinOverflow (which is x=134217728) in analysishelper.cxx in scaddins. What is the special reason for it? Having tried I confirm that Excel has that constraint

### [sc-dev] HelpID for imaginary trigonometric functions

Hi, next question with my imaginary functions task: I have found helpid definitions for imaginary functions in sc/inc/sc.hrc. Shall I add definitions for the new imaginary functions there? And then in sc/source/core/tool/addinhelpid.cxx and sc/util/hidother.src too? kind regards Regina

### [sc-dev] Questions about oox/source/xls/formulabase.cxx

Hi, the file oox/source/xls/formulabase.cxx has a section /** Functions defined by OpenFormula, but not supported by Calc or by Excel. */ Does this refer to the draft ODF 1.2 formula spec? Which functions are listed there? For example, why are the imaginary functions and the secant

### Re: [sc-dev] Questions about oox/source/xls/formulabase.cxx

Hi Daniel, Daniel Rentz schrieb: Hi regina, Regina Henschel schrieb: the file oox/source/xls/formulabase.cxx has a section /** Functions defined by OpenFormula, but not supported by Calc or by Excel. */ Does this refer to the draft ODF 1.2 formula spec? No. I just scanned the function op

### Re: [sc-dev] Questions about oox/source/xls/formulabase.cxx

Hi Daniel, Daniel Rentz schrieb: scadddins/analysis should contain only these functions that Excel offers in its Analysis add-in. New functions should go into the Calc core IMHO. (Anyway, starting from Excel 2007, all Analysis functions are built-in in Excel.) I'm not sure if the filters are

### Re: [sc-dev] Questions about oox/source/xls/formulabase.cxx

Hi Daniel, Daniel Rentz schrieb: Regina Henschel schrieb: Hi Daniel, Daniel Rentz schrieb: Hi regina, Regina Henschel schrieb: the file oox/source/xls/formulabase.cxx has a section /** Functions defined by OpenFormula, but not supported by Calc or by Excel. */ Does this refer

### Re: [sc-dev] Questions about oox/source/xls/formulabase.cxx

Hi Daniel, Daniel Rentz schrieb: Same for the equivalent table saFuncTable_Odf in sc/source/filter/excel/xlformula.cxx. It seems, that I have to wait till m78, because m76 does not contain saFuncTable_Odf and m77 does not build for me. kind regards Regina

### Re: [sc-dev] EUROCONVERT() in the wrong category

Hi Alexandro, Alexandro Colorado schrieb: Hi today I found this formula as part of Math as opposed to Financial or something else. I think this is a bug, want confirmation that this is replicated. in ODF Open Formula draft spec, section 5.16.29 EUROCONVERT is in the section 'Mathematical

### [sc-dev] Decision about Bessel-functions needed

Hi all, the Bessel-functions have some accuracy problems, see issues 31656, 40309, and 43040. I have written patches to fix these bugs. They have lain about for nearly 10 month now. I suggest to integrate them, because any other solution using the boost library is not in sight. kind regards

### Re: [sc-dev] Questions about oox/source/xls/formulabase.cxx

Hallo Daniel, Daniel Rentz schrieb: Hello, Regina Henschel schrieb: == A == I have added SEC, CSC, SECH, and CSCH, to saFuncTable_Odf. All four new functions have op-codes. Tests look good: Reloading directly is correct for ods, xls, sdc, and sxc. Loading and resaving with StarOffice8

### Re: [sc-dev] Questions about oox/source/xls/formulabase.cxx

Hi Eike, Eike Rathke schrieb: Hi Regina, On Sunday, 2010-05-30 22:44:06 +0200, Regina Henschel wrote: In the cases 'ODF 1.0' with ods and 'ODF 1.2 extended' with sxc and ods, the new functions are reloaded with #NAME?, but the cells contain the formulas like '=imsech(z)'. In contrast

### Re: [sc-dev] Questions about oox/source/xls/formulabase.cxx

HI Eike, Regina Henschel schrieb: Hi Eike, Eike Rathke schrieb: Hi Regina, On Sunday, 2010-05-30 22:44:06 +0200, Regina Henschel wrote: In the cases 'ODF 1.0' with ods and 'ODF 1.2 extended' with sxc and ods, the new functions are reloaded with #NAME?, but the cells contain the formulas

### Re: [sc-dev] Questions about oox/source/xls/formulabase.cxx

Hi Eike, Regina Henschel schrieb: HI Eike, Regina Henschel schrieb: I have now changed the entries to the form, for example { IMCOT, IMCOT, false, IMCOT, IMCOT }, Now I can use setting ODF 1.2 or ODF 1.0/1.1, file format ods, sxc, or sdc, reopen directly or round trip through SO8

### Re: [sc-dev] Questions about oox/source/xls/formulabase.cxx

Hi Eike, same additional information: I use the odffmap entry { IMCOT, IMCOT, false, com.sun.star.sheet.addin.Analysis.getImcot, COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETIMCOT } (1) Save document in setting ODF 1.2. (2) Open it in OOo2.4.3 and save there. That results in document version

### Re: [sc-dev] Questions about oox/source/xls/formulabase.cxx

Hi Daniel, Daniel Rentz schrieb: Hi Regina, Regina Henschel schrieb: If I use ocExternal the prefix is set, but the functions are not distinct, only one name is written and on import the whole function name is stripped, so only =(z) remains from =_xlfnodf.IMSECH(z). I see no way to add