[sc-dev] Re: Internship 2010: Statistical Data Analysis Tool

2011-03-28 Thread Regina Henschel
Hi Niklas, hi Pivithuruw, Niklas Nebel schrieb: On 28.03.2011 10:50, Niklas Nebel wrote: It's in the download section of sc.openoffice.org, the URL is now http://openoffice.org/projects/sc/downloads/directory/Data%20Analysis. But apparently, some of the files were truncated in the Kenai

[sc-dev] type logical in Excel

2011-02-28 Thread Regina Henschel
Hi, I just noticed, that Excel 2007 and Excel 2010 distinguish between type Logical and type Number. Is this new in Excel 2007/2010 or did Excel had a separate type Logical before? (I haven't got an older version of Excel and therefore cannot examine it by myself.) I came across it, when I

[sc-dev] Questions about LINEST implementation

2010-10-21 Thread Regina Henschel
Hi all, I have written issue http://www.openoffice.org/issues/show_bug.cgi?id=115189 for to attach the first draft of my implementation for LINEST. But there are still a lot of questions. So please have a look at that draft. (Checkmatrix has not essentially changed, but you need this version

Re: [sc-dev] Calc does not detect singularity

2010-10-19 Thread Regina Henschel
Hi Eike, Eike Rathke schrieb: Hi Regina, I'll try to give some long outstanding answers to questions you asked shortly before I went to OOoCon and then into vacation and then.. On Thursday, 2010-08-26 22:33:20 +0200, Regina Henschel wrote: next problem with matrices :( (All with German

Re: [sc-dev] TREND/GROWTH in ODF

2010-09-25 Thread Regina Henschel
Hi all, it seems the problem is solved in the way, that ODF will be changed. See http://lists.oasis-open.org/archives/office/201009/msg00356.html and http://tools.oasis-open.org/issues/browse/OFFICE-3437 Kind regards Regina Regina Henschel schrieb: Hi all, in the current implementation some

[sc-dev] TREND/GROWTH in ODF

2010-09-18 Thread Regina Henschel
Hi all, in the current implementation some functions are common to TREND/GROWTH and LINEST/LOGEST. So working on LINEST I had a look at TREND too. And I have found some problems. The definition of TREND in ODF1.2 (6.18.79) allows only NumberSequence as parameters and constrains the column,

Re: [sc-dev] Changing values in matrix which is parameter

2010-09-01 Thread Regina Henschel
Hi Eike, Eike Rathke schrieb: Hi Regina, On Monday, 2010-08-16 16:24:23 +0200, Eike Rathke wrote: The problem with constant parameters is already actual :( http://www.openoffice.org/issues/show_bug.cgi?id=113879 Thanks for catching. I'll see if I can easily introduce the mentioned

[sc-dev] Shortcomings in ScInterpreter::CheckMatrix

2010-08-29 Thread Regina Henschel
Hi all, CheckMatrix is used for LINEST/LOGEST and for TREND/GROWTH. It checks whether the input matrices have correct size and content, generates the default matrix for an empty MatX, changes Y to log(Y) in case LOGEST and GROWTH, determines the size of the input matrices for output parameter

[sc-dev] Calc does not detect singularity

2010-08-26 Thread Regina Henschel
Hi all, next problem with matrices :( (All with German local with comma as decimal delimiter) Fill A1:C3 with 1 2 3 3 6 9 9,1 18 27 Calculate =MINVERSE(A1:C3) I get 0,-1.#NANE+000 #VALUE! #VALUE! #NUM! #NUM! #VALUE! #NUM! #NUM! #VALUE! I

Re: [sc-dev] Changing values in matrix which is parameter

2010-08-13 Thread Regina Henschel
Hi Eike, Eike Rathke schrieb: Hi Regina, On Thursday, 2010-08-12 16:38:33 +0200, Regina Henschel wrote: The current implementation avoids to copy the matrices X or Y, although that would ease and shorten the code. I thought there must be a reason for that and tried to avoid it too. I

[sc-dev] Trouble with ScInterpreter::MFastMult

2010-08-12 Thread Regina Henschel
Hi all, in interpr5.cxx you find void ScInterpreter::MFastMult(ScMatrix* pA, ScMatrix* pB, ScMatrix* pR, SCSIZE n, SCSIZE m, SCSIZE l) // Multipliziert n x m Mat a mit m x l Mat b nach Mat r But actually it calculates R = B * A and A has size m x n and B

Re: [sc-dev] OpenOffice 3.2 Calc adding bitmap image to a cell

2010-08-12 Thread Regina Henschel
Hi Jari, this is the wrong list for your questions. Macros belong to the udk or the api project and images belong to the graphics project. Kind regards Regina Jari Kosonen schrieb: Can you advice how to change the pivot point in the calc -macro? oLinked.RotateAngle=rot

Re: [sc-dev] Changing values in matrix which is parameter

2010-08-12 Thread Regina Henschel
Hi Eike, Eike Rathke schrieb: Hi Regina, On Sunday, 2010-08-08 20:38:21 +0200, Regina Henschel wrote: in method LINEST I get pMatX from the stack. That is a reference to the matrix MatX. I calculate the means column wise getting a matrix MeanX with associated reference pMeanX. In next step I

Re: [sc-dev] OpenOffice 3.2 Calc adding bitmap image to a cell

2010-08-11 Thread Regina Henschel
Hi Jari, Jari Kosonen schrieb: Dear Developers Team, I'm no developer. Can you advice how to add bitmap image into openoffice calc cell by using calc-macro (and no uno-type)? You cannot put an image _into_ a Calc cell, Calc cells can only hold strings, values, and formulas. You can

Re: [sc-dev] DEV300m84 hangs when saving from Calc

2010-08-09 Thread Regina Henschel
Hi David, David Tardon schrieb: On Mon, Aug 09, 2010 at 10:20:11AM +0200, Daniel Rentz wrote: Hi Regina, Am 08.08.2010 19:12, schrieb Regina Henschel: I have build DEV300m84 on WinXP. That works so far, but saving a spreadsheet document from Calc gives always the Debug Output: Error: wrong

[sc-dev] DEV300m84 hangs when saving from Calc

2010-08-08 Thread Regina Henschel
Hi all, I have build DEV300m84 on WinXP. That works so far, but saving a spreadsheet document from Calc gives always the Debug Output: Error: wrong NameAccess From File C:/DEV300m84my/xmloff/source/core/SettingsExportHelper.cxx at Line 406 If I ignore it, the file is saved, but OOo does

[sc-dev] Changing values in matrix which is parameter

2010-08-08 Thread Regina Henschel
Hi all, in method LINEST I get pMatX from the stack. That is a reference to the matrix MatX. I calculate the means column wise getting a matrix MeanX with associated reference pMeanX. In next step I calculate pMatX-GetDouble(i,j) - pMeanX-GetDouble(i,0) Can I overwrite the values in

Re: [sc-dev] Missing parameter in LINEST

2010-08-05 Thread Regina Henschel
Hello Eike, Eike Rathke schrieb: Hi Regina, Sorry for not having answered your previous mail about whether someone was already working on LINEST. No one is. Thanks for taking that. On Tuesday, 2010-08-03 20:27:56 +0200, Regina Henschel wrote: the draft ODF1.2 spec defines the syntax LINEST

[sc-dev] Missing parameter in LINEST

2010-08-03 Thread Regina Henschel
Hi all, the draft ODF1.2 spec defines the syntax LINEST( Array knownY [ ; [ Array knownX ] [ ; Logical Const = TRUE() [ ; Logical Stats = FALSE() ] ] ] ) With this syntax the formula =LINEST(B2:B6;A2:A6;;TRUE()) is not allowed, but currently it gives no error (That is issue106118). And the

[sc-dev] Issues with LINEST

2010-07-21 Thread Regina Henschel
Hello all, I have started to work on LINEST. Is there anybody out there, who is looking at LINEST already? My current state is, that I have studied the concerning mathematics and the existing code, so that I know what to do in principle. The work is about issues Incorrect LINEST

Re: [sc-dev] Decision about Bessel-functions needed

2010-07-19 Thread Regina Henschel
Hi Eike, Eike Rathke schrieb: Hi Regina, On Thursday, 2010-05-20 21:40:02 +0200, Regina Henschel wrote: 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

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

2010-06-16 Thread Regina Henschel
Hi Eike, Eike Rathke schrieb: Hi Regina, That's odd. I'd have to take a deeper look at that. I expected that with { IMCOT, IMCOT, false, com.sun.star.sheet.addin.Analysis.getImcot, IMCOT }, the last IMCOT would had setup the map for FormulaGrammar::GRAM_PODF to be used in 'oooc:' namespace

[sc-dev] character set is not UTF-8 in analysis_deffuncnames.src

2010-06-16 Thread Regina Henschel
Hi all, I see ANSI character set and not UTF-8 in scaddins/source/analysis/analysis_deffuncnames.src. Is that an error or purpose? kind regards Regina - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For

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

2010-06-16 Thread Regina Henschel
Hi Eike, Regina Henschel schrieb: Hi Eike, Eike Rathke schrieb: Hi Regina, That's odd. I'd have to take a deeper look at that. I expected that with { IMCOT, IMCOT, false, com.sun.star.sheet.addin.Analysis.getImcot, IMCOT }, the last IMCOT would had setup the map for FormulaGrammar

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

2010-06-09 Thread Regina Henschel
Hi Eike, Eike Rathke schrieb: Hi Regina, On Thursday, 2010-06-03 16:56:56 +0200, Regina Henschel wrote: [..] Using in odffmap.cxx the entry { IMCOT, IMCOT, false, com.sun.star.sheet.addin.Analysis.getImcot, COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETIMCOT }, results

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

2010-06-04 Thread Regina Henschel
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

2010-06-04 Thread Regina Henschel
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

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

2010-06-03 Thread Regina Henschel
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

2010-06-03 Thread Regina Henschel
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

2010-06-01 Thread Regina Henschel
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

2010-05-31 Thread Regina Henschel
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

[sc-dev] Decision about Bessel-functions needed

2010-05-20 Thread Regina Henschel
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] EUROCONVERT() in the wrong category

2010-05-17 Thread Regina Henschel
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

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

2010-05-16 Thread Regina Henschel
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

2010-05-16 Thread Regina Henschel
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

2010-05-16 Thread Regina Henschel
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

2010-05-16 Thread Regina Henschel
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] constraint of x in sin(x) in scaddins

2010-05-15 Thread Regina Henschel
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

2010-05-15 Thread Regina Henschel
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

2010-05-15 Thread Regina Henschel
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] constraint of x in sin(x) in scaddins

2010-05-10 Thread Regina Henschel
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

2010-05-09 Thread Regina Henschel
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

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

2010-05-08 Thread Regina Henschel
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] Functions in Excel 2010

2010-04-06 Thread Regina Henschel
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] Functions in Excel 2010

2010-04-02 Thread Regina Henschel
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] What are valid arguments for INDIRECT

2009-09-21 Thread Regina Henschel
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

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

2009-08-26 Thread Regina Henschel
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] Re: [Issue 90759] ZTEST not same as Excel

2009-08-25 Thread Regina Henschel
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] Missing second parameter in CEILING

2009-08-14 Thread Regina Henschel
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] Missing second parameter in CEILING

2009-08-07 Thread Regina Henschel
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

[sc-dev] Missing second parameter in CEILING

2009-08-05 Thread Regina Henschel
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

2009-08-05 Thread Regina Henschel
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] Problems with BESSELJ

2009-07-10 Thread Regina Henschel
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

Re: [sc-dev] Problems with BESSELJ

2009-07-09 Thread Regina Henschel
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

2009-07-09 Thread Regina Henschel
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

2009-07-09 Thread Regina Henschel
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

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

2009-07-04 Thread Regina Henschel
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

2009-07-04 Thread Regina Henschel
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

2009-06-30 Thread Regina Henschel
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

Re: [sc-dev] Build problems

2009-06-23 Thread Regina Henschel
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] How should MULTIPLE.OPERATIONS calculate?

2009-06-22 Thread Regina Henschel
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?

2009-06-22 Thread Regina Henschel
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?

2009-06-22 Thread Regina Henschel
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

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

2009-06-21 Thread Regina Henschel
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?

2009-06-21 Thread Regina Henschel
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] Build problems (was: Rebasing CWS odff06 to m50)

2009-06-20 Thread Regina Henschel
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:

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

2009-06-01 Thread Regina Henschel
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] About Issue 66028's correct behavior.

2009-05-26 Thread Regina Henschel
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] About Issue 66028's correct behavior.

2009-05-22 Thread Regina Henschel
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

[sc-dev] Schedule for CWS odff06

2009-04-26 Thread Regina Henschel
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

[sc-dev] Implementation details of POISSON

2009-04-15 Thread Regina Henschel
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] Implementation details for FDIST

2009-04-13 Thread Regina Henschel
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] Need UI name for new FDIST function

2009-04-07 Thread Regina Henschel
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] signaling domain error in acosh

2009-04-06 Thread Regina Henschel
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 ==

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

2009-03-25 Thread Regina Henschel
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

2009-03-25 Thread Regina Henschel
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

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

2009-03-18 Thread Regina Henschel
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] How to export expanded LOGNORMDIST to Excel

2009-03-17 Thread Regina Henschel
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

2009-03-17 Thread Regina Henschel
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

2009-03-13 Thread Regina Henschel
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

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

2009-03-11 Thread Regina Henschel
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] Decision needed for FISHERINV and ATANH

2008-12-21 Thread Regina Henschel
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] Decision needed for FISHERINV and ATANH

2008-12-17 Thread Regina Henschel
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] How to continue after issue 94555 (CHISQDIST)

2008-12-09 Thread Regina Henschel
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

Re: [sc-dev] Implement expm1 and log1p

2008-12-03 Thread Regina Henschel
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)

2008-12-03 Thread Regina Henschel
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().

2008-12-03 Thread Regina Henschel
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

[sc-dev] Implement expm1 and log1p

2008-12-01 Thread Regina Henschel
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] Rebasing CWS odff05

2008-11-29 Thread Regina Henschel
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] Examine changes for ODFv1.2

2008-10-10 Thread Regina Henschel
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

2008-10-10 Thread Regina Henschel
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] Congratulations, Regina! Gold Award winner of the Community Innovation Program.

2008-10-07 Thread Regina Henschel
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] Cannot use LEGACY.xxx style of functions in OOo3

2008-10-02 Thread Regina Henschel
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] How to handle ODFF constrain number must be integer?

2008-10-01 Thread Regina Henschel
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?

2008-10-01 Thread Regina Henschel
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

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

2008-09-27 Thread Regina Henschel
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?

2008-09-27 Thread Regina Henschel
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)

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

2008-09-26 Thread Regina Henschel
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

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

2008-09-21 Thread Regina Henschel
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

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

2008-09-19 Thread Regina Henschel
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

  1   2   >