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 communicat

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 simpl

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

2008-12-14 Thread Eike Rathke
Hi Oliver, On Sunday, 2008-12-14 09:07:49 +0100, Oliver Brinzing wrote: > I used Vista with oo 3.1 DEV300m37 Build 9371 and oo 3.0.1 DEV300m12 Build > 9368 > 'Feiertage' point to $Input.$D$6:$E$21 if i open F3 on sheet 'Input', but > points to > $Input.$D$6:Calendar.$E$21 if i open on sheet 'Ca

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 > av

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 atanh(x)=x(1+x²*(1/3+x²

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 develope

[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 http://fosdem.org/2

Re: [sc-dev] OpenFormula Implementation: numbervalue(Text X; Text DecimalPoint)

2009-01-12 Thread Eike Rathke
Hi, On Friday, 2009-01-09 15:31:38 +0800, ��?�??�?? wrote: > I am trying to implementate OpenFormula > NUMBERVALUE(Text X; Text DecimalPoint). Nice :) Lvyue already said there's someone who wanted to work on that. > 1) According to the OpenFormula specification, > formula NUMBERVALUE similar

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 koheida

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] OpenFormula Implementation: UNICODE(Text T) and UNICHAR(Number N)

2009-02-26 Thread Eike Rathke
Hi Chengbiao, On Thursday, 2009-02-26 17:21:45 +0800, Chengbiao Tan wrote: > These days I am trying to implementate two related OpenFormula > UNICODE(Text T) and UNICHAR(Number N). Nice to hear, welcome! > According to the OOo native String class is implementated in UNICODE, > so I can use th

Re: [sc-dev] OpenFormula Implementation: UNICODE(Text T) and UNICHAR(Number N)

2009-02-26 Thread Eike Rathke
Hi, On Thursday, 2009-02-26 12:39:47 +0100, Eike Rathke wrote: > For UNICHAR() a conversion from Unicode point to UTF-16 is needed, for > this use the OUString ctor > > OUString( const sal_Char * value, sal_Int32 length, rtl_TextEncoding > encoding, > sal_u

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 bas

[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] 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 exp

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 F

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 Wer

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

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 transp

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

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 X

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.

[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] TortoiseSVN and CrLf

2009-03-26 Thread Eike Rathke
Hi Regina, On Wednesday, 2009-03-25 21:58:46 +0100, Regina Henschel wrote: > I have looked around in the settings, but do not see such an option. It > seems to be possible to set a property to each single file, so that the > line end it forced to LF when committing the file. That would be on

Re: [sc-dev] signaling domain error in acosh

2009-04-06 Thread Eike Rathke
Hi Regina, On Monday, 2009-04-06 10:11:43 +0200, Regina Henschel wrote: > 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 Nice. > double SAL_CALL rtl_math_acosh(

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 i

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 func

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

Re: [sc-dev] Implementation details of POISSON

2009-04-19 Thread Eike Rathke
Hi Regina, On Wednesday, 2009-04-15 22:35:14 +0200, Regina Henschel wrote: > 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

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 stil

Re: [sc-dev] Schedule for CWS odff06

2009-04-28 Thread Eike Rathke
Hi Regina, On Sunday, 2009-04-26 23:44:03 +0200, Regina Henschel wrote: > 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? The page got jus

[sc-dev] CWS odff06, please svn update

2009-04-30 Thread Eike Rathke
Hi, I applied several pending patches to CWS odff06, please svn update for further development on interpreter functionality and patches to be created. Modules to be rebuilt and delivered are sal, formula, sc and scaddins. Thanks Eike -- OOo/SO Calc core developer. Number formatter stricken i

Re: [sc-dev] Hi, could some developer answer some questions?

2009-06-05 Thread Eike Rathke
Hi Isaac, On Sunday, 2009-05-10 04:15:44 -0400, Isaac M. Marcos wrote: > I need to solve some bugs in OOfice. > > I am willing to code if you could point me in the right direction. > > Let's assume I am a complete *newb*, Could you guide me to start? Niklas pointed you to how to build the code

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 http://sc.openoffice.org/servlets/ReadMsg?list=features

Re: [sc-dev] specifications

2009-06-05 Thread Eike Rathke
Hi Ain, On Friday, 2009-06-05 14:51:12 +0300, Ain Vagula wrote: > Seems to me that there is a lot to do to make feature changes more > collected and visible... It was collected in http://development.openoffice.org/releases/3.0.0.html (unfortunately with a completely messed up layout ignoring all

[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: http://blogs.s

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 los

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 format

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? Eik

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] 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] OOo2.4.2 takes of:=FDIST(a,b,c) as if it is ooc:=FDIST(a,b,c)

2009-07-06 Thread Eike Rathke
Hi Regina, On Saturday, 2009-07-04 14:53:45 +0200, Regina Henschel wrote: > 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 > upgr

Re: [sc-dev] Problems with BESSELJ

2009-07-08 Thread Eike Rathke
Hi Regina, On Saturday, 2009-07-04 23:44:36 +0200, Regina Henschel wrote: > I have attached a draft patch to issue 40309. You can use it to test the > performance. Unfortunately I currently have no time to test things. > On my PC a single calculation with x=500 lasts about 1 > second.

Re: [sc-dev] Problems with BESSELJ

2009-07-08 Thread Eike Rathke
Hi Regina, On Saturday, 2009-07-04 23:52:18 +0200, Regina Henschel wrote: >>> Or return an error, if neither asymptotic formula results at least 2 >>> digits (How tell the user, that the result is not accurate?) >> >> A few functions set errNoConvergence if a function can't determine >> a resu

[sc-dev] i85328 (was: [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 Leonard, On Saturday, 2009-07-04 19:53:56 +0200, Leonard Mada wrote: > this brings me to an older issue: > http://www.openoffice.org/issues/show_bug.cgi?id=85328 Which is completely unrelated to the problem we're talking about, you hijacked the thread. Input to a cell that is formatted as te

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: >> Argh, I forgot those are Add-In functions. Bah, other exceptions aren't >> allowed. Well, use IllegalArgumentException() then. The other >> possibility would be to move the code into the core, where >> SetError(errNoConver

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-09 Thread Eike Rathke
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 module. After having applied the p

Re: [sc-dev] Problems with BESSELJ

2009-07-10 Thread Eike Rathke
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 fail before tha

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 C

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

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

2009-08-17 Thread Eike Rathke
Hi Regina, On Friday, 2009-08-14 21:25:22 +0200, Regina Henschel wrote: The other problematic import case is Excels formula =CEILING(;value). In this case it becomes =CEILING(;value;1), which is an invalid formula in ODF1.2. Here too the result in Excel is 0, and an import

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 val

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 someth

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-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

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

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 sprea

Re: [sc-dev] Linker error on adding a new module to the sc project

2009-12-16 Thread Eike Rathke
Hi rashi, On Tuesday, 2009-12-15 22:49:42 +0300, rashi dhing wrote: > - Is it possible to build the installation set just for the spreadsheet rather > than the entire openoffice suite. No, but you can build only the sc module ( cd sc; build debug=true ) and copy the resulting libraries from sc/$

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,

[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

[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

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 x<1342177

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 ima

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 intereste

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

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] Questions about oox/source/xls/formulabase.cxx

2010-06-16 Thread Eike Rathke
Hi Regina, On Thursday, 2010-06-10 00:25:00 +0200, Regina Henschel wrote: > I have now looked at ScCompiler::IsOpCode. You have added a comment > (line 2520) > // If that isn't found we might continue with rName lookup as a > // last resort by just falling through to FindFunction(), but > // it

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 p

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

2010-06-21 Thread Eike Rathke
Hi Regina, On Thursday, 2010-06-17 01:11:40 +0200, Regina Henschel wrote: >> { "IMCOT", "IMCOT", false, "com.sun.star.sheet.addin.Analysis.getImcot", >> "IMCOT" } >> > The round trip ODF1.2 -> OOo2.4.3 -> ODF1.2 for sxc file format is OK > with that setting, but now sxc files fail both for reop

Re: [sc-dev] Patch for issue 49380

2010-06-21 Thread Eike Rathke
Hi Kirill, On Monday, 2010-06-21 11:32:08 +0400, Kirill S. Palagin wrote: > Dear developers, > the patch allows Find&Replace to search for empty cells. > This is useful operation, which otherwise requires learning regexes. Even a regex wouldn't help because only cells with content are considered

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 th

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 fun

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] 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] 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

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] Changing values in matrix which is parameter

2010-08-12 Thread Eike Rathke
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 calculate > pMatX->Get

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 >

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 na

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 t

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] 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] Changing values in matrix which is parameter

2010-08-17 Thread Eike Rathke
Hi Regina, On Monday, 2010-08-16 22:40:49 +0200, Regina Henschel wrote: > > Thanks for catching. I'll see if I can easily introduce the mentioned > > CloneIfConst() approach or have to simply fix this with an > > unconditional Clone(). > > Isn't the total length of a formula restricted to 255 ch

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 >

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

2010-10-18 Thread Eike Rathke
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 local with comma as decimal deli

Re: [sc-dev] Shortcomings in ScInterpreter::CheckMatrix

2010-10-18 Thread Eike Rathke
Hi Regina, On Sunday, 2010-08-29 18:33:38 +0200, Regina Henschel wrote: > [... CheckMatrix ...] > > In case of simple regression (nCase==1) the values M and N are not > set correctly, but the initial value 0 is returned. In case of an > emtpy MatX the values for nCX and nRX are only set in case

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 http://ui.openoffice.org/Vi

[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] Removing ULONG

2011-01-19 Thread Eike Rathke
Hi Regina, On Monday, 2011-01-17 23:12:16 +0100, Regina Henschel wrote: > I'm currently looking in ScBinomDist to remove the PushNoValue() > cases. I see a lot of ULONG there and as Carsten has announced, that > ULONG will be removed, my question now, how I should replace it. > > The parameters

[sc-dev] Re: Farewell

2011-09-05 Thread Eike Rathke
Hi Niklas, On Sunday, 2011-09-04 18:56:17 +0200, Niklas Nebel wrote: > In case anyone is still reading these lists: Occasionally.. > Thanks everybody for a great time! It was a pleasure working with you. All the best! Eike -- PGP/OpenPGP/GnuPG encrypted mail preferred in all private com

Re: [sc-dev] Single reference vs double reference

2005-02-23 Thread Eike Rathke
Hi Kohei, On Tue, Feb 22, 2005 at 21:24:53 -0500, Kohei Yoshida wrote: > I've been looking through the part around > ScToken/ScTokenArray/SingleDoubleRefProvider/..., and have come across > this enum called StackVarEnum which holds the members svSingleRef and > svDoubleRef. Also, there are two c

Re: [sc-dev] ScToken & ScTokenArray

2005-02-23 Thread Eike Rathke
Hi Kohei, On Tue, Feb 22, 2005 at 23:00:11 -0500, Kohei Yoshida wrote: > I'm trying to understand the mechanism of cell referencing, and > somehow the two classes ScToken and ScTokeArray seem to be playing a > major role in this. Absolutely, yes. > I have only read a fraction of the relevant co

[sc-dev] building sources (was: Single reference vs double reference)

2005-02-24 Thread Eike Rathke
Hi Safee, I don't see how your question is related to the thread it appeared in, but anyway ... On Thu, Feb 24, 2005 at 11:22:31 +0500, Safee wrote: > can we build calc source in visual studio? Literally spoken: no, you'd also need the compiler ;-) For current development .NET 2003 is required

Re: [sc-dev] ScToken & ScTokenArray

2005-02-24 Thread Eike Rathke
Hi Kohei, On Wed, Feb 23, 2005 at 10:42:14 -0500, Kohei Yoshida wrote: > You're right on! This helps tremendously. :-) This mechanism is > still a bit complicated, but I will try to understand it slowly but > surely. I'd do it differently in a new implementation, but I don't think it would be

Re: [sc-dev] building sources

2005-02-24 Thread Eike Rathke
Hi Safee, On Thu, Feb 24, 2005 at 16:11:02 +0500, Safee wrote: > btw why cant we build a stand alone calc? There is no stand-alone Calc application, Calc is a shared library that is called by the OOo application's executable. What you can do is build the entire suite and then install only the co

<    1   2   3   4   >