[sc-dev] On the Numerical Accuracy of Spreadsheets

2011-01-04 Thread Eike Rathke
Hi, The Journal of Statistical Software, a publication by the American Statistical Association, last year published a paper On the Numerical Accuracy of Spreadsheets http://www.jstatsoft.org/v34/i04/ | This paper discusses the numerical precision of five spreadsheets (Calc, | Excel, Gnumeric,

Re: [sc-dev] Help with SC wiki template

2010-12-07 Thread Eike Rathke
Hi Alexandro, On Saturday, 2010-12-04 09:46:32 -0600, Alexandro Colorado wrote: http://wiki.services.openoffice.org/wiki/Template:Calc_Project Thanks, looks good in general, but some nitpicks: * For icons please use the OOo3 application icons instead of OOo2 from

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

2010-08-19 Thread Eike Rathke
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 CloneIfConst() approach or have

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

2010-08-16 Thread Eike Rathke
Hi Regina, On Saturday, 2010-08-14 00:18:38 +0200, Regina Henschel 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 CloneIfConst() approach or have to

Re: [sc-dev] Add a new Calc spreadsheet function

2010-08-13 Thread Eike Rathke
Hi Marina, On Thursday, 2010-08-12 15:13:24 +0200, Marina Plakalovic wrote: Working with ranges inside the functions is not the issue, but registering function is. I'm not sure I understand what you mean with registering. Are you referring to parclass.cxx? I followed steps described in

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

2010-08-13 Thread Eike Rathke
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 hesitate to copy X or Y, because they

Re: [sc-dev] Formation of Matrix formula

2010-08-13 Thread Eike Rathke
Hi rashi, On Friday, 2010-08-13 17:13:56 +0300, rashi dhing wrote: Hi !! Can you tell me where exactly is the matrix fomula formed (i.e) where are the curly brackets added to form the matrix formula. Is it done by the edit engine ?? The surrounding '{' and '}' are UI display features and

Re: [sc-dev] Add a new Calc spreadsheet function

2010-08-12 Thread Eike Rathke
Hi Marina, On Monday, 2010-08-09 15:21:39 +0200, Marina Plakalovic wrote: I have added new function by following the tutorial: http://wiki.services.openoffice.org/wiki/Calc/Implementation/Spreadsheet_Functions This works fine when the arguments of the function are scalar, but if I want to

Re: [sc-dev] Trouble with ScInterpreter::MFastMult

2010-08-12 Thread Eike Rathke
Hi Regina, On Thursday, 2010-08-12 09:24:59 +0200, Regina Henschel wrote: 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

Re: [sc-dev] Get individual cells inside a cell range

2010-08-06 Thread Eike Rathke
Hi Pivithuru, On Friday, 2010-08-06 14:01:31 +0530, Pivithuru Wijegunawardana wrote: I need to get the individual cells inside a cell range. But I need to do this without giving its x and y positions. Is there any method I could get a XCell list from a cell range? I am doing this in java.

Re: [sc-dev] Missing parameter in LINEST

2010-08-05 Thread Eike Rathke
Hi Regina, On Thursday, 2010-08-05 15:26:07 +0200, Regina Henschel wrote: The interpreter allows these cases because in Excel the missing parameter is allowed at most places and that's needed for imported documents. I think, that the interpreter should not allow invalid (in respect to

Re: [sc-dev] Missing parameter in LINEST

2010-08-04 Thread Eike Rathke
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( Array knownY [ ; [ Array knownX ]

Re: [sc-dev] Include file error

2010-07-21 Thread Eike Rathke
Hi rashi, On Tuesday, 2010-07-20 20:09:38 +0300, rashi dhing wrote: Right now static would be fine but at a later stage I will want them to dynamically update when other cells change. All change notifications of referenced cells to their dependents is done based on the RPN token array of the

Re: [sc-dev] Include file error

2010-07-07 Thread Eike Rathke
Hi Rashi, On Wednesday, 2010-07-07 11:09:00 +0200, Niklas Nebel wrote: On 07/07/10 10:50, rashi dhing wrote: Wanted to use a certain function of the ScInterpreter class ! Can I give the whole path sc/source/core/interpre.hxx and use it ? I wouldn't recommend that. If you have a function

Re: [sc-dev] Absurd behaviour while displaying values in a range of cells

2010-07-06 Thread Eike Rathke
Hi rashi, On Tuesday, 2010-07-06 12:40:35 +0300, rashi dhing wrote: So I did pore over the various functions of the ScInterpreter like GetNewMat and PushMatrix etc. Apart from being extremely complicated, I still really didn't understand where the result matrix was being set/put into the

Re: [sc-dev] Absurd behaviour while displaying values in a range of cells

2010-06-16 Thread Eike Rathke
Hi rashi, On Friday, 2010-06-04 14:10:31 +0300, rashi dhing wrote: Hi Eike, Could you tell me why modifying the spreadsheet while interpreting a function is not the right approach That could modify cells that are still to be interpreted, even for the same formula the modifying function is

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

2010-06-03 Thread Eike Rathke
Hi Regina, On Thursday, 2010-06-03 16:56:56 +0200, Regina Henschel wrote: 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 with

Re: [sc-dev] Absurd behaviour while displaying values in a range of cells

2010-06-03 Thread Eike Rathke
Hi rashi, On Thursday, 2010-06-03 17:52:10 +0300, rashi dhing wrote: I have defined a function in which I take as input, cell values from a range and after doing some calculation output them on the spreadsheet using the ScDocument::SetString and ScDocument::SetValue functions. Modifying

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

2010-06-01 Thread Eike Rathke
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 to integrate them, because

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

2010-06-01 Thread Eike Rathke
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 to issue 95312 the old

Re: [sc-dev] Calc/Chart Project

2010-06-01 Thread Eike Rathke
Hi Marina, On Monday, 2010-05-31 16:21:16 +0200, Marina Plakalovic wrote: I have heard about the summer student internship and decided to apply for Add new spreadsheet functions and parameters according to ODFF. Thank you for your interest in the OpenOffice.org internship! I am interested

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

2010-05-11 Thread Eike Rathke
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, or more specific x134217728. I

[sc-dev] ViSta (was: [sc-dev] Re: [dev] Debug the Calc Source Code)

2010-04-09 Thread Eike Rathke
Hi Ruben, On Thursday, 2010-04-08 10:34:13 -0300, Ruben Ledesma wrote: Would anyone be interested in connecting Calc with a data visualization system called ViSta The Visual Statistics System?. Could be interesting, I took a short glance at http://forrest.psych.unc.edu/research/index.html

[sc-dev] Show YOUR code on FOSDEM

2010-01-29 Thread Eike Rathke
Hi, If you have written some Calc code you'd like to discuss on FOSDEM in my Show me YOUR code workshop on Saturday, February 6 http://fosdem.org/2010/schedule/events/ooo_workshop please send mailto:er...@sun.com?subject=fosdem%20code Of course we can also discuss at other times on FOSDEM, meet

Re: [sc-dev] Issues with page formatting in XLS-import

2009-12-23 Thread Eike Rathke
Hi Cor, On Friday, 2009-12-18 11:45:39 +0100, Cor Nouws wrote: There are some open issues for page formatting in XLS-import. 70505, 75787, 72823 They are a bit different, but related in the sense that opening and printing an .xls is affected. Are all those three issues complicated, say a

Re: [sc-dev] Microsoft testing Excel for supercomputers

2009-11-24 Thread Eike Rathke
Hi Maho, On Friday, 2009-11-20 12:32:09 +0900, Maho NAKATA wrote: My idea is just a not a special and very simple. If we do vector-vector, vector-matrix, matrix-matrix multiplication etc, *just call BLAS and LAPACK* We don't do much of these operations, only in some context of

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

2009-09-21 Thread Eike Rathke
Hi Leonard, Just returned from vacation, hence the silence.. On Friday, 2009-09-11 00:43:09 +0200, Leonard Mada wrote: I might be too late, Yes, too late, UI string changes aren't allowed anymore. but the following small correction sounds slightly better: Calculates the probability of

Re: [sc-dev] Issue 5930 - split for better understanding and proceding?

2009-09-21 Thread Eike Rathke
Hi Cor, On Tuesday, 2009-09-15 14:47:50 +0200, Cor Nouws wrote: In this issue, someone did a proposal to split up things, for better understanding et cetera: http://www.openoffice.org/issues/show_bug.cgi?id=5930#desc56 AFAICS, it is a sound proposal. So if no one objects ... I 'll act

Re: [sc-dev] Issue 5658 solved

2009-09-09 Thread Eike Rathke
Hi Cor, Sorry for late answer, got drowned in 3.2 CWSs ... On Thursday, 2009-09-03 09:06:26 +0200, Cor Nouws wrote: Good to see you resolved the issue! * (I give my question here, in order not to disturb people in issuetracker while giving applause ;-) ) Well, thank you :) I more or

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

2009-08-26 Thread Eike Rathke
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 null hypothesis, of observing a value as

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

2009-08-26 Thread Eike Rathke
Hi Regina, On Wednesday, 2009-08-26 18:02:44 +0200, Regina Henschel wrote: calculates the probability of observing a value as large or larger for the z-statistic There is a comparison observing a value larger but it does not contain, to what it is compared. There must be something like

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

2009-08-12 Thread Eike Rathke
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 filter the third parameter 1 is added to

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

2009-08-05 Thread Eike Rathke
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 some changes to allow

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

2009-07-08 Thread Eike Rathke
Hi Regina, On Monday, 2009-07-06 11:43:23 +0200, Regina Henschel wrote: I agree, not to implement FDISTL with OOo3.2. I can send you the code which contains the algorithms, so that you can keep it and the algorithms get not lost. Do you want a patch or the complete interpr3.cxx file?

Re: [sc-dev] Problems with BESSELJ

2009-07-08 Thread Eike Rathke
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 the core would make it necessary to

Re: [sc-dev] Problems with BESSELJ

2009-07-03 Thread Eike Rathke
Hi Regina, On Tuesday, 2009-06-30 23:34:27 +0200, Regina Henschel wrote: Excel rounds down to integer. The comment in ODF spec 16.15.11 says that Gnumeric allow fractional N, but my Gnumeric 1.6.3 rounds down too. In the comment Kspread is said to allow fractional N, but I haven't got

Re: [sc-dev] Problems with BESSELJ

2009-06-30 Thread Eike Rathke
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 order+x*1.1+30 iterations.

Re: [sc-dev] Build problems

2009-06-23 Thread Eike Rathke
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 with dmake depend=t help? Eike

Re: [sc-dev] Rebasing CWS odff06 to m50

2009-06-18 Thread Eike Rathke
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. Eike -- OOo/SO Calc core developer. Number formatter

Re: [sc-dev] Rebasing CWS odff06 to m50

2009-06-17 Thread Eike Rathke
Hi dev, On Thursday, 2009-06-11 15:33:02 +0200, Eike Rathke wrote: I'm currently rebasing CWS odff06 to DEV300_m50, I'll give a note when done. Rebasing is done, also applied the patch from http://qa.openoffice.org/issues/show_bug.cgi?id=102701 to prevent accidental data loss. When using

[sc-dev] Rebasing CWS odff06 to m50

2009-06-11 Thread Eike Rathke
Hi, I'm currently rebasing CWS odff06 to DEV300_m50, I'll give a note when done. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun:

Re: [sc-dev] specifications

2009-06-05 Thread Eike Rathke
Hi Ain, On Friday, 2009-06-05 13:52:50 +0300, Ain Vagula wrote: I'm more interested about changes handling empty cells in various calc functions, made before 3.0. Ok, I can digg in allfeatures list archives ;) Seems you're looking for

Re: [sc-dev] Implementation details of POISSON

2009-04-22 Thread Eike Rathke
Hi Regina, On Tuesday, 2009-04-21 22:39:06 +0200, Regina Henschel wrote: I have attached a patch to the issue. When I have generated the patch with TortoiseSVN, it includes all the other parts, on which I am working in interpr3.cxx. I have deleted them and hope, that the patch will still

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

2009-04-19 Thread Eike Rathke
Hi Regina, chiming in late on this.. On Wednesday, 2009-04-08 16:02:31 +0200, Regina Henschel wrote: Leonard Mada schrieb: I would suggest DISTF(). It would be short and reflects the change in tail. But I worry, that people will not remember which one is 'right tail' and which one is

Re: [sc-dev] Implementation details for FDIST

2009-04-19 Thread Eike Rathke
Hi Regina, On Monday, 2009-04-13 22:42:07 +0200, Regina Henschel wrote: besides the UI-name problem I come across two other questions. For clarification: we're talking about ODF FDIST here, as opposed to LEGACY.FDIST (1) If the numerator degrees of freedom (r1) is 1, then the density

Re: [sc-dev] Implementation details for FDIST

2009-04-19 Thread Eike Rathke
Hi, On Sunday, 2009-04-19 20:35:09 +0200, Eike Rathke wrote: I can set the result to 0 or set illegal argument or perhaps set infinity. Please decide. I think letting the calculation just run into an error the same as occurs for the expression =0^-1 in ScInterpreter::ScExp() is fine

[sc-dev] TortoiseSVN and CrLf (was: Move ERF and ERFC from scaddins to sal)

2009-03-25 Thread Eike Rathke
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 that I saw TortoiseSVN added a ^M

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

2009-03-24 Thread Eike Rathke
Hi Regina, On Sunday, 2009-03-22 22:31:08 +0100, Regina Henschel wrote: I have now build CWS odff06. I have regenerated patches to move ERF and ERFC from scaddins to sal, now based on odff06. http://www.openoffice.org/issues/show_bug.cgi?id=97091 Please have a look. Much appreciated.

Re: [sc-dev] Excel 2003 XML export

2009-03-19 Thread Eike Rathke
Hi Niklas, On Wednesday, 2009-03-18 14:05:45 +0100, Niklas Nebel wrote: That's http://qa.openoffice.org/issues/show_bug.cgi?id=96018 We should consider to drop that filter completely... +1 Objections, anyone? We'd still have the same kind of issues with any user-defined XSLT filters.

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

2009-03-18 Thread Eike Rathke
Hi Regina, On Tuesday, 2009-03-17 22:15:48 +0100, Regina Henschel wrote: While 3.2 will be able to read without arguments for the optional parameters, it will write something that can be read by any 3.x release. OK, a kind of 'political' decision. I'll implement it that way. More a kind of

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

2009-03-18 Thread Eike Rathke
Hi Regina, On Wednesday, 2009-03-18 12:25:32 +0100, Regina Henschel wrote: For the file token.cxx in formula/source/core/api I get an odd patch. The patch includes the function FormulaMissingContext::AddMissingExternal( FormulaTokenArray *pNewArr ) although there is nothing changed.

[sc-dev] Excel 2003 XML export (was: [sc-dev] How to export expanded LOGNORMDIST to Excel)

2009-03-18 Thread Eike Rathke
Hi Daniel, On Wednesday, 2009-03-18 09:39:51 +0100, Daniel Rentz wrote: That's http://qa.openoffice.org/issues/show_bug.cgi?id=96018 We should consider to drop that filter completely... +1 Objections, anyone? Eike -- OOo/SO Calc core developer. Number formatter stricken i18n

Re: [sc-dev] Issue #5930 - Engineering notation

2009-03-18 Thread Eike Rathke
Hi Frédéric, On Tuesday, 2009-03-17 20:07:46 -0400, Frédéric Courchesne wrote: I am looking for engineering notation in Calc for about 5 years!!! Issue 5930 has been opened in 2002 and is not closed yet: http://www.openoffice.org/issues/show_bug.cgi?id=5930 I would like to participate and

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

2009-03-17 Thread Eike Rathke
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 for example GRUND: Ungültiger Wert

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

2009-03-16 Thread Eike Rathke
Hi Regina, On Friday, 2009-03-13 22:20:35 +0100, Regina Henschel wrote: It is a concession that the missing parameters are added, although the user who will export to Excel-format should know, that Excel expects three parameters. Not necessarily. They might use OOo and just have to

Re: [sc-dev] About compile's error.

2009-03-16 Thread Eike Rathke
Hi maoyg, On Sunday, 2009-03-15 02:30:48 +0800, maoyg wrote: build debug=t [... multiple definitions of symbol ...] See Oliver's answer on the d...@ooo list. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335

[sc-dev] CWS odff06 for ODFF related work

2009-03-12 Thread Eike Rathke
Hi, I created CWS odff06 based on DEV300_m43 for work related to the ODF formula specification, targeted to OOo3.2, see http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fodff06 Please develop new patches for the spreadheet functions' interpreter area in an up-to-date tree of that

Re: [sc-dev] Multiline formulae support

2009-03-06 Thread Eike Rathke
Hi William, On Thursday, 2009-03-05 23:47:49 +, William S Fulton wrote: Well, I finally found some time to get back to this Good news! :) Is now the right time to set up a CWS as mentioned above or are there any more suggestions for improvement? I just created CWS calcmultiline based

Re: [sc-dev] Open Office

2009-02-01 Thread Eike Rathke
Hi Romke, On Saturday, 2009-01-31 10:29:15 +, Romke jan Prins wrote: I've just downloaded open office from your website. Last week i did the same. The installation program asked for an installation-code. I've send a text message to the right number. I got a few text messages back, but

Re: [sc-dev] [almost] Crasher is alive for 3 years - issue 55266

2009-01-28 Thread Eike Rathke
Hi Kirill, On Tuesday, 2009-01-27 22:13:50 +0300, Kirill Palagin wrote: Please see http://www.openoffice.org/issues/show_bug.cgi?id=55266 - Calc allocates 1.1GB of RAM for 81kb file with DataPilot.. That may be fixed with http://qa.openoffice.org/issues/show_bug.cgi?id=93998 in CWS

[sc-dev] Would you like to be a FOSDEM 2009 speaker for Calc?

2009-01-08 Thread Eike Rathke
Hi, Yes, this is on short notice. In case you haven't seen it already on d...@ooo or other mailing lists: OOo has a DevRoom and stand on FOSDEM 2009, the Free and Open Source Software Developers' European Meeting, February 7+8, which is approaching sooner than it appears.. see

Re: [sc-dev] accuracy of ASINH and ACOSH

2009-01-06 Thread Eike Rathke
Hi Regina, Happy New Year! On Saturday, 2008-12-27 23:11:26 +0100, Regina Henschel wrote: please see issue 97605 and decide, where you want to have the changes. Same as for atanh() and those, a C99 replacement function in rtl::math would do fine. Thanks Eike -- OOo/SO Calc core

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

2008-12-21 Thread Eike Rathke
Hi Regina, On Monday, 2008-12-22 00:09:02 +0100, Regina Henschel wrote: Merry Christmas and a happy New Year to you. Well, yes, same to you! (1) atanh(x)=0.5*log1p(2*x/(1-x)) (2) Use the first five summands of the power series for |x|0.01, which would be

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

2008-12-17 Thread Eike Rathke
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 to be changed too. The best solution, using a build-in function, is not

Re: [sc-dev] strange formula Err:504 with oo 3.x

2008-12-13 Thread Eike Rathke
Hi Oliver, On Saturday, 2008-12-13 11:38:07 +0100, Oliver Brinzing wrote: i created an issue with attachment http://www.openoffice.org/issues/show_bug.cgi?id=97225 Didn't encounter any problem here, see issue. Eike -- PGP/OpenPGP/GnuPG encrypted mail preferred in all private

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

2008-12-13 Thread Eike Rathke
Hi Regina, On Tuesday, 2008-12-09 20:07:53 +0100, Eike Rathke wrote: I've hoped that the patch in 94555 (CHISQDIST) will get into odff05 and that the feature will be in OOo3.1. Will that happen or is something wrong with that patch? No, I simply was busy with getting a few CWSs rfQA

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

2008-12-09 Thread Eike Rathke
Hi Regina, On Tuesday, 2008-12-09 16:33:01 +0100, Regina Henschel wrote: I've hoped that the patch in 94555 (CHISQDIST) will get into odff05 and that the feature will be in OOo3.1. Will that happen or is something wrong with that patch? No, I simply was busy with getting a few CWSs rfQA,

Re: [sc-dev] Re: [allsvn] r265030 - cws/ooxml02/offapi/com/sun/star/sheet

2008-12-09 Thread Eike Rathke
Hi Kohei, On Tuesday, 2008-12-09 13:20:48 -0500, Kohei Yoshida wrote: Again, modularization. We want to separate the Excel filter from the sc module, and opcode mapping is part of it. But VBA is not part of the filter, and we need that for VBA. The filter is merely re-using it.

Re: [sc-dev] Implement expm1 and log1p

2008-12-03 Thread Eike Rathke
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 code into sal\inc\rtl\math.hxx, so I can use the functions with ::rtl::math::expm1 and

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

2008-12-03 Thread Eike Rathke
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 changes based on the original

[sc-dev] Performance (was: [sc-dev] Informing users about ODFF)

2008-11-28 Thread Eike Rathke
Hi Leonard, On Friday, 2008-11-28 01:25:25 +0200, Leonard Mada wrote: I can't give a timeline for further work on ODFF implementation. I myself will focus on performance. Does this mean that issue 89976 gets addressed? http://www.openoffice.org/issues/show_bug.cgi?id=89976 Yes. I noticed

Re: [sc-dev] Informing users about ODFF was [sc-dev] Rebasing CWS odff05

2008-11-27 Thread Eike Rathke
Hi Cor, On Wednesday, 2008-11-26 22:05:25 +0100, Cor Nouws wrote: I thought (ignorance ;-) ) that odff implementation was finished in 3.0 Not at all. Can you pls tell what you expect about features / time line / impact for users? Regina prepared a nice wiki page

Re: [sc-dev] Return 0 on Search Instead of Zero

2008-11-27 Thread Eike Rathke
Hi Leonard, On Wednesday, 2008-11-26 23:37:00 +0200, Leonard Mada wrote: I just noticed the following formula in one of the issues: =IF(AND((ISERROR(SEARCH(Pass,$F8))), (ISERROR(SEARCH(Warn,$F8))), (ISERROR(SEARCH(Closed,$F8,0,1) IIRC we already mentioned the to be

Re: [sc-dev] Rebasing CWS odff05

2008-11-27 Thread Eike Rathke
Hi Daniel, On Thursday, 2008-11-27 08:44:51 +0100, Daniel Rentz wrote: odff05 is rebased to m36. Compiled fine on Linux/x86 and Solaris/SPARC, Daniel is currently building Windows. Hm. Currently I just build sc and oox on my local machine to continue some fixes for the oox filter. I also

Re: [sc-dev] *.xls import: formula =Cell(Zeile) is broken

2008-11-26 Thread Eike Rathke
Hi Oliver, On Wednesday, 2008-11-26 11:25:58 +0100, Oliver Brinzing wrote: just recieved an excel file with a formula like this: =DATUM($G$1;MONAT(A$3);((ZELLE(ZEILE;A4))-3)) OO displays Err:502, cause the argument Zeile should be row ... Sigh.. the brain-dead localization of string

Re: [sc-dev] Rebasing CWS odff05

2008-11-26 Thread Eike Rathke
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 development. m36 took longer than I

Re: [sc-dev] Changes in 3.0 for ODFF

2008-11-19 Thread Eike Rathke
Hi Cor, On Wednesday, 2008-11-19 07:46:42 +0100, Cor Nouws wrote: I'm looking for a comprehensive description of what users should take care of, because of the implementation of ODFF in 3.0. I know http://blogs.sun.com/GullFOSS/tags/odff and have prepared

[sc-dev] Rebasing CWS odff05

2008-11-18 Thread Eike Rathke
Hi, 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 development. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n

Re: [sc-dev] Multiline formulae support

2008-11-11 Thread Eike Rathke
Hi William, On Saturday, 2008-11-08 23:48:43 +, William S Fulton wrote: I've had a good look at many of these and have posted a new patch fixing various multiline problems. This is great! I think that patch does it, other opinions? It includes some subtle changes which I hope are

Re: [sc-dev] Multiline formulae support

2008-11-11 Thread Eike Rathke
Hi William, On Monday, 2008-11-10 23:03:49 +, William S Fulton wrote: we need to decide how to support multiline text over DDE. We could implement a number of different protocols over DDE or even OLE, this is a useful document describing the protocols Excel uses -

Re: [sc-dev] Filling dates in Calc

2008-10-30 Thread Eike Rathke
Hi Leonard, On Thursday, 2008-10-30 02:10:33 +0200, Leonard Mada wrote: I will present a more global solution addressing the FILL on the OASIS list. Please note that the OASIS ODF TC works on the file format and the formula subcommittee on specifying spreadsheet functions and operators and

Re: [sc-dev] Filling dates in Calc

2008-10-30 Thread Eike Rathke
Hi Niklas, On Thursday, 2008-10-30 09:42:30 +0100, Niklas Nebel wrote: If I select 2 or more equal dates, and try to fill, the date still gets incremented. This is not the case with ordinary numbers. Two numbers lead to linear fill, no special handling for the equal case there. For

Re: [sc-dev] The Excel import/export part of EUROCONVERT().

2008-10-22 Thread Eike Rathke
Hi Daniel, On Tuesday, 2008-10-21 09:41:05 +0200, Daniel Rentz wrote: +BOOL lclConvertMoney( const String aSearchUnit, double rfRate, int rnDec ) Btw, aSearchUnit should be a const reference instead of a copy, so const String aSearchUnit ^^^ +{ +#define COUNT 16 +#define

Re: [sc-dev] =CELL(Width;A1) does not recognize changes of column width ?

2008-10-14 Thread Eike Rathke
Hi Leonard, On Sunday, 2008-10-12 19:11:36 +0200, Leonard Mada wrote: Shouldn't ODF implement the following functions: 1.) ISHIDDEN(cell, IGNORE_EMPTY = TRUE) 2.) ISFILTERED(cell, IGNORE_EMPTY = TRUE) 3.) ISVISIBLE(cell, IGNORE_EMPTY = TRUE) While ISHIDDEN() and ISFILTERED() might be

Re: [sc-dev] =CELL(Width;A1) does not recognize changes of column width ?

2008-10-12 Thread Eike Rathke
Hi Oliver, On Saturday, 2008-10-11 18:35:24 +0200, Oliver Brinzing wrote: =CELL(Width;A1) reports the cell width, for example 12 now a user changes column width - but the formula still reports: 12 pressing (F9) does not help ... only a save reload cycle will display the new column witdh

Re: [sc-dev] ODFF_Implementation/Schedule Table Style

2008-10-12 Thread Eike Rathke
Hi Leonard, On Friday, 2008-10-10 22:19:04 +0200, Leonard Mada wrote: I made some changes to the following page, basically changing the background-color for alternating rows: http://wiki.services.openoffice.org/wiki/Calc/ODFF_Implementation/Schedule It surely looks better and easier

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

2008-10-07 Thread Eike Rathke
Hi Regina, On Thursday, 2008-10-02 23:24:18 +0200, Regina Henschel wrote: 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. ODFF is about file format storage, UI names may and

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

2008-10-07 Thread Eike Rathke
Congratulations, 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

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

2008-10-01 Thread Eike Rathke
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 is the most current) it is in chapter '6.15 Mathematical Functions'. GAMMA is an expansion of

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

2008-09-19 Thread Eike Rathke
Hi Yue, On Friday, 2008-09-19 17:14:11 +0800, lvyue wrote: I found some details unmentioned in specifies. the format of the formula is EUROCONVERT( Number; TextFrom; TextTo; [FullPrecision [; TriangulationPrecision]] ). Comparing with Excel, I find following things: 1. if TextFrom equals

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

2008-09-14 Thread Eike Rathke
Hi Regina, On Saturday, 2008-09-13 18:18:33 +0200, Regina Henschel wrote: 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. Good to hear :-) But the

[sc-dev] Dedicated chat hour Wednesday 08:00 UTC (10:00 CEST)

2008-08-12 Thread Eike Rathke
Hi, Some time ago we agreed upon an IRC chat hour in a time slot that allowed both, Chinese and European colleagues, to participate during their working hours. It was never explicitly announced in public but just worked. However, I think it would be a good idea to introduce that as a more

Re: [sc-dev] Issue for #VALUE! on Excel import ?

2008-08-08 Thread Eike Rathke
Hi Leonard, On Thursday, 2008-08-07 21:12:29 +0300, Leonard Mada wrote: A1: '-3 A2: 4 =ABS(A1)= 3 =SUM(A1:A2) = 4 =SUM(A1,A2) = 4 =A1+A2 = 1 The 2 sensible options are: - raise an error Which is what I favor ans want to implement. BUT then implement a mechanism to detect

Re: [sc-dev] Issue for #VALUE! on Excel import ?

2008-08-08 Thread Eike Rathke
Hi Leonard, On Thursday, 2008-08-07 21:17:34 +0300, Leonard Mada wrote: The reason why interpreting strings as numeric values on the fly is harmful and we do not want to implement it. BUT you do it. You interpret it *always* as 0. This is the worst possible scenario. It is at least

Re: [sc-dev] Statistical Articles

2008-08-08 Thread Eike Rathke
Hi Leonard, On Friday, 2008-08-08 01:44:46 +0300, Leonard Mada wrote: I recently stumbled upon 2 potentially interesting articles: On the accuracy of statistical procedures in Microsoft Excel 2007 http://www.sciencedirect.com/science/article/B6V8V-4S1S6FC-5/1/153b556411c3508840f66b38f74c6186

Re: [sc-dev] Issue for #VALUE! on Excel import ?

2008-08-07 Thread Eike Rathke
Hi Cor, On Thursday, 2008-08-07 13:00:46 +0200, Cor Nouws wrote: Clear that an operator treats text numbers different than a function. Actually that's not a difference between operators and functions, but a difference between operators or functions expecting a scalar value as argument, such as

Re: [sc-dev] automatic fill

2008-08-07 Thread Eike Rathke
Hi Ain, On Wednesday, 2008-07-30 21:00:03 +0300, Ain Vagula wrote: filed issue http://www.openoffice.org/issues/show_bug.cgi?id=92292 See my comment there. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335

Re: [sc-dev] Multiline formulae support

2008-08-07 Thread Eike Rathke
Hi William, On Wednesday, 2008-07-30 17:22:43 +0100, William S Fulton wrote: I have been working on adding multiline formulae support and have attached a patch to bug #35913. It also fixes bug #83666. A quick summary of what it adds is the display of new lines when the result of a

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

2008-08-07 Thread Eike Rathke
Hi Regina, On Tuesday, 2008-08-05 22:36:56 +0200, Regina Henschel wrote: Non of the functions that do mathematical calculation is static and they call one another across the files. But as you might have noticed I'm a very beginner and cannot decide yet. I'll come back, when I have learned

Re: [sc-dev] development status of BETADIST

2008-08-06 Thread Eike Rathke
Hi Regina, On Tuesday, 2008-08-05 22:17:56 +0200, Regina Henschel wrote: It seems to be one of the most difficult functions. To get an idea of that function, have a look at the file toms708.c of the R-project. Wow, impressive. The original coder(s) must have spent a lot of time for numeric

  1   2   3   >