Hello,
I had a look at the source in interpr3.cxx and have made the proposed
changes for the COVAR function. Although I'm a very beginner I think,
that I'm able to change some of the other such functions too.
The changes need to calculate the mean in a first loop and than
calculating the
Hello Eike,
Eike Rathke schrieb:
Hi Regina,
On Thursday, 2007-07-05 10:34:37 +0200, Regina Henschel wrote:
For COVAR it looks like this (based on OOF680_m18):
Very nice, indeed. Could you do us a favor though and base your changes
on a recent SRC680 milestone (latest available now is m219
Hello Niklas,
Niklas Nebel schrieb:
Regina Henschel wrote:
I had a look at the source in interpr3.cxx and have made the proposed
changes for the COVAR function. Although I'm a very beginner I think,
that I'm able to change some of the other such functions too.
The changes need to calculate
Hi Cor,
Cor Nouws schrieb:
Hi *,
Cannot find an issue, so maybe by design?
A speadsheat has formulas that (somtimes) result in zero.
Settings ar to hide zero-values, so those cells are empty.
However print preview and print do show them.
1.1.5 / 2.2
Bug or design?
No bug, but feature.
Hi Ain,
Ain Vagula schrieb:
Hi, I have a spreadsheet from
http://www.passiv.de/04_pub/Literatur/PHVP2002/PHVP02.ZIP
In sheet U_Werte, cell K140 it contains formula:
Hi Ain,
some additional remarks:
Regina Henschel schrieb:
Instead of
COUNTIF(G140:G142;)=2
use
COUNTBLANK(G140:G142)=2
This works only, of the cells are really empty. If a cell contains a
formula with return an empty string, then I know no way to get the same
result in Excel
Hi Eike,
a remark on the ODFF-spec:
The parameter 'PaymentType' has got type 'number'. In the description
only the values 0 and 1 are mentioned. But there is no constraint to
{0;1}. The description doesn't say what to do with other values. The
parameter 'PaymentType' in the equation can be
Hi Eike,
Eike Rathke schrieb:
Hi Regina,
On Sunday, 2008-02-03 01:27:55 +0100, Regina Henschel wrote:
a remark on the ODFF-spec:
The parameter 'PaymentType' has got type 'number'. In the description only
the values 0 and 1 are mentioned. But there is no constraint to {0;1}. The
description
Hi Eike,
Eike Rathke schrieb:
Hi Regina,
On Monday, 2008-02-11 12:09:25 +0100, Regina Henschel wrote:
for those, who read this.
I've discussed it on [EMAIL PROTECTED] I've found a comment in
http://wiki.services.openoffice.org/wiki/Windows#Extra_requirements with
link for gperf http
problems exist.
kind regards
Regina
Regina Henschel schrieb:
Hi Eike,
Eike Rathke schrieb:
Hi Regina,
I have not done it yet. Now I have installed WinCvs and have been
able to check out the sc modul with the tag cws_src680_odff.
Therefore I think, that it will be feasible for me in principle
Hello,
the function GAMMALN is calculated with the Lanczos algorithm. The
precision of the result depends on some coefficients. In the current
version in OOo the coefficients give only a precision of up to 10
significant digits. I looked around for some better coefficient and
found them in
Hi Eike,
Eike Rathke schrieb:
Hi Regina,
On Sunday, 2008-04-13 13:25:25 +0200, Regina Henschel wrote:
Can I use
throw errNoConvergence;
for example in this way?
do
...
while (!bFinished fCount1);
if (fCount=1)
{
throw errNoConvergence
Hi David,
David King schrieb:
Moving discussion of this issue here, at Regina's request.
Hi Regina
The function ZTEST should depend on NORMSDIST.
Therefore NORMSDIST has to be controlled and improved first.
I'm afraid I disagree pretty whole heartedly :)
NORMSDIST may or may not be more
Hi all,
David King schrieb:
[..]
Whatever :). Yours is certainly clearer, mine a bit faster.
I've attached a patch with your proposal to the issue.
But both ways would have
fSumSqr - fSum*fSum/rValCount
which might give similar problems like in issue 78250.
Yes - really should
Hello all,
I'm working on BETADIST. For certain inputs my version of that function
returns a value, which is near to 1. The formula in the cell is
=BETADIST(B$3;$B$1;$A8) with B3=0,999 and B1=1e-9 and A8=1,5. The result
should be shown as 1,00E+000 but it is shown as
Hi Eike,
in addition:
Regina Henschel schrieb:
which I found as tip on http://www.plunk.org/~hatch/rightway.php. He
gives also a version from which he says, it is from Kahan, but I have
not tested the other.
In the meantime I tested that version, and it works as well.
I have submit http
Hello all,
this mail is about
BETADIST(x,alpha,beta,lower bound, upper bound, cumulative)
I have attached the actual stage of my work to issue 91547. The patch
has already a status that it could be used, but there are still
problems. I have attached it anyway, so that you can have a look at
+0200, Regina Henschel wrote:
(2)
Nearly all terms inside have parts like (1-x)^r. When the x argument is
close to 1, approximately x 0., then the term (1-x)^r has large
cancellation errors. I know no way to avoid it. Switching to power
series 1+x^2+x^3+... is no solution, because
Hi Daniel,
Daniel Rentz schrieb:
Hi Regina,
Regina Henschel schrieb:
[..]
But the next part, which I want to modularize, is the algoritm known
as BASYM (Didonato/Morris algoritm 708). It is a part of about 90
lines. Unfortunately it needs the private functions
double ScInterpreter
abgeschickt ohne Begrüßung, tut mir leid. Bitte hinzufügen:
Hi Eike,
:)
Bis dann
Regina
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Hi Eike,
Eike Rathke schrieb:
Hi Regina,
On Tuesday, 2008-08-05 22:17:56 +0200, Regina Henschel wrote:
MuPad, the CAS I have got at
home, overflows for large parameters. Of cause high end programs like
Mathematica have no problems there (You can use it online for single
function calls
Hi,
I want to bring GAMMA and CHISQDIST to UI. I've tried the guide in
http://wiki.services.openoffice.org/wiki/Calc/Implementation/Spreadsheet_Functions
for GAMMA and it works as described. But the build I used is rather old,
a DEV300m20. Therefore I think I need a new build. Am I right?
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
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
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
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]
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 ==
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
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
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.
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
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
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:
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
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
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
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
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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,
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1 - 100 of 114 matches
Mail list logo
