Hi Niklas,
Niklas Nebel schrieb:
In case anyone is still reading these lists:
Ja, ich habe sie noch abonniert.
I have left Oracle and started a new job, not related to
OpenOffice.org. Because of this, I won't have enough time for any
meaningful participation in the "new" OpenOffice.org at A
Hi Niklas, hi Pivithuruw,
Niklas Nebel schrieb:
On 28.03.2011 10:50, Niklas Nebel wrote:
It's in the download section of sc.openoffice.org, the URL is now
http://openoffice.org/projects/sc/downloads/directory/Data%20Analysis.
But apparently, some of the files were truncated in the Kenai
transit
Hi all,
There has been the project 'Internship 2010: Statistical Data Analysis
Tool'. On Wiki
http://wiki.services.openoffice.org/wiki/OpenOffice.org_Internship/Projects/2010/Statistical_Data_Analysis_Tool
I read in 'Project Status' the sentences "The implementation of the data
analysis tool
Hi,
I just noticed, that Excel 2007 and Excel 2010 distinguish between type
Logical and type Number. Is this new in Excel 2007/2010 or did Excel had
a separate type Logical before? (I haven't got an older version of Excel
and therefore cannot examine it by myself.)
I came across it, when I l
Hi all,
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 n (total number of independent trials) and x (number of
successful tri
Hi all,
I have written issue
http://www.openoffice.org/issues/show_bug.cgi?id=115189
for to attach the first draft of my implementation for LINEST. But there
are still a lot of questions. So please have a look at that draft.
(Checkmatrix has not essentially changed, but you need this version w
Hi Eike,
Eike Rathke schrieb:
Hi Regina,
I'll try to give some long outstanding answers to questions you asked
shortly before I went to OOoCon and then into vacation and then..
On Thursday, 2010-08-26 22:33:20 +0200, Regina Henschel wrote:
next problem with matrices :(
(All with G
n Thursday, 2010-08-26 22:33:20 +0200, Regina Henschel wrote:
next problem with matrices :(
(All with German local with comma as decimal delimiter)
Fill A1:C3 with
1 2 3
3 6 9
9,1 18 27
Calculate =MINVERSE(A1:C3)
I get
0,-1.#NANE+000 #VALUE! #VALUE!
#N
Hi all,
the draft spec for ODF1.2 allows empty and missing parameters. If I
interpret the syntax description correctly, this cases are possible:
For LINEST/LOGEST
1 Y ; X ; Const ; Stats
2 Y ; X ; Const
3 Y ; X
4 Y ; ; Const ; Stats
5 Y ; ; Const
6 Y
7
Hi all,
it seems the problem is solved in the way, that ODF will be changed. See
http://lists.oasis-open.org/archives/office/201009/msg00356.html
and
http://tools.oasis-open.org/issues/browse/OFFICE-3437
Kind regards
Regina
Regina Henschel schrieb:
Hi all,
in the current implementation some
Hi all,
in the current implementation some functions are common to TREND/GROWTH
and LINEST/LOGEST. So working on LINEST I had a look at TREND too. And I
have found some problems.
The definition of TREND in ODF1.2 (6.18.79) allows only "NumberSequence"
as parameters and constrains the column,
Hi Eike,
Eike Rathke schrieb:
Hi Regina,
On Monday, 2010-08-16 16:24:23 +0200, Eike Rathke wrote:
The problem with constant parameters is already actual :(
http://www.openoffice.org/issues/show_bug.cgi?id=113879
Thanks for catching. I'll see if I can easily introduce the mentioned
CloneIfCo
Hi all,
CheckMatrix is used for LINEST/LOGEST and for TREND/GROWTH. It checks
whether the input matrices have correct size and content, generates the
default matrix for an empty MatX, changes Y to log(Y) in case LOGEST and
GROWTH, determines the size of the input matrices for output parameter
Hi all,
next problem with matrices :(
(All with German local with comma as decimal delimiter)
Fill A1:C3 with
1 2 3
3 6 9
9,1 18 27
Calculate =MINVERSE(A1:C3)
I get
0,-1.#NANE+000 #VALUE! #VALUE!
#NUM! #NUM! #VALUE!
#NUM! #NUM! #VALUE!
I guess
Hi Eike,
Eike Rathke schrieb:
Hi Regina,
On Thursday, 2010-08-12 16:38:33 +0200, Regina Henschel wrote:
The current implementation avoids to copy the matrices X or Y,
although that would ease and shorten the code. I thought there must
be a reason for that and tried to avoid it too. I
Hi Eike,
Eike Rathke schrieb:
Hi Regina,
On Sunday, 2010-08-08 20:38:21 +0200, Regina Henschel wrote:
in method LINEST I get pMatX from the stack. That is a reference to
the matrix MatX. I calculate the means column wise getting a matrix
MeanX with associated reference pMeanX. In next step I
Hi Jari,
this is the wrong list for your questions. Macros belong to the udk or
the api project and images belong to the graphics project.
Kind regards
Regina
Jari Kosonen schrieb:
Can you advice how to change the "pivot point" in the calc -macro?
oLinked.RotateAngle=rot
oLinked.Position=aP
Hi all,
in interpr5.cxx you find
void ScInterpreter::MFastMult(ScMatrix* pA, ScMatrix* pB, ScMatrix* pR,
SCSIZE n, SCSIZE m, SCSIZE l)
// Multipliziert n x m Mat a mit m x l Mat b nach Mat r
But actually it calculates R = B * A and A has size m x n and B ha
Hi Jari,
Jari Kosonen schrieb:
Dear Developers Team,
I'm no developer.
Can you advice how to add bitmap image into openoffice calc cell by
using calc-macro (and no uno-type)?
You cannot put an image _into_ a Calc cell, Calc cells can only hold
strings, values, and formulas.
You can only
Hi Daniel,
Regina Henschel schrieb:
Hi Daniel,
Daniel Rentz schrieb:
Am 09.08.2010 11:26, schrieb Regina Henschel:
Hi David,
see http://qa.openoffice.org/issues/show_bug.cgi?id=113737 for the
assertion.
I have applied the patch. Now I get no longer a Debug Output, but OOo
still hangs
Hi Daniel,
Daniel Rentz schrieb:
Am 09.08.2010 11:26, schrieb Regina Henschel:
Hi David,
see http://qa.openoffice.org/issues/show_bug.cgi?id=113737 for the
assertion.
I have applied the patch. Now I get no longer a Debug Output, but OOo
still hangs after saving.
No problem in DEV300m86
Hi David,
David Tardon schrieb:
On Mon, Aug 09, 2010 at 10:20:11AM +0200, Daniel Rentz wrote:
Hi Regina,
Am 08.08.2010 19:12, schrieb Regina Henschel:
I have build DEV300m84 on WinXP. That works so far, but saving a
spreadsheet document from Calc gives always the Debug Output:
Error: wrong
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
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 not
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,
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 fo
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 calc
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 to
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 las
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 additional
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:' na
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
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 the
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 v
Hi Eike,
Eike Rathke schrieb:
[..]
That the round trip though OOo2.4.3 does not work for sxc file format
can be solved be forcing OOo3 to setting "ODF 1.0/1.1" when saving in
sxc, as already suggested in issue 95312. So the remaining problem would
be the round trip of an ods document produced
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
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
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 '=i
Hi Daniel,
Regina Henschel schrieb:
== B ==
But I have still questions concerning the new imaginary functions.
Those functions have no op-code. Need I to add them to
saFuncTable_Odf? If yes, how can I do it?
Yes, the filters in sc are used for import/export of the XLS format. On
export, the
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 (for
Hi all,
Daniel Rentz schrieb:
Regina Henschel schrieb:
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
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
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 Fun
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 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 to the
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 p
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,
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 functions
Hi,
next question with my imaginary functions task: I have found helpid
definitions for imaginary functions in sc/inc/sc.hrc. Shall I add
definitions for the new imaginary functions there? And then in
sc/source/core/tool/addinhelpid.cxx and sc/util/hidother.src too?
kind regards
Regina
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 E
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
ge
o 1.xxx * 10^32 would be fine in that case.
I believe that lambda should be not bigger than pi/4,
while epsilon is flexible in this case (e.g. 10^-6 is probably
sufficient).
Sincerely,
Leonard Mada
Original-Nachricht
Datum: Sat, 08 May 2010 21:02:45 +0200
Von: Regina Hensc
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+01
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 there
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 f
Leonard Mada schrieb:
Dear Calc Team,
I would like to easily copy the *Conditional Formatting* across
different sheets.
[see issue: http://www.openoffice.org/issues/show_bug.cgi?id=105659]
That is possible without problems.
1. Mark the cell in the source spreadsheet.
2. Copy to clipboard.
3
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")) ret
Hi,
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
=ISREF(A1~B1) returns TRUE
but
=ISREF(INDIRECT("A1~B1")) returns FALSE
And
Hi André,
André Schnabel schrieb:
Hi,
I'm about doing the review for our help translations and came across an
inconsistency for the WEIBULL function (the parameter C).
The new Help for this reads:
If C is 0, WEIBULL calculates the cumulative distribution function.
If C is 1, WEIBULL c
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 nu
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 woul
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 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,
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;Significa
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 CEILING(N;;
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.Mess
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.Mess
Hi Niklas,
Niklas Nebel schrieb:
Regina Henschel wrote:
c:\softwarearchiv2\odff06\scaddins\source\analysis\bessel.hxx(35) :
fatal error C1083: Cannot open include file:
'com/sun/star/sheet/NoConvergenceException.hpp': No such file or
directory
I see the file NoConvergenceExcept
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
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::s
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 th
Hi Eike,
Eike Rathke schrieb:
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.
Hi Eike,
Eike Rathke schrieb:
Hi Regina,
On Sunday, 2009-06-28 20:20:17 +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
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 x>1000
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 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
Hi all,
looking at issue http://www.openoffice.org/issues/show_bug.cgi?id=40309
I get some problems:
The algorithm, which is used for x<=30 is not good. The results become
invalid for larger order and for larger x. I guess that this was the
reason to switch to the asymptotic formula for x>3
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 d
Hi Niklas,
Niklas Nebel schrieb:
On 06/22/09 17:10, Regina Henschel wrote:
Right. A1+A2 is calculated as A1+A6, which is 2+700, or 702.
So OOo drops "=MULTIPLE.OPERATIONS(A3;A6;A4)"? OOo acts as if the
formula in A5 is "=A3".
All references to A6 in A3's for
Hi Niklas,
Niklas Nebel schrieb:
On 06/22/09 15:11, Regina Henschel wrote:
That makes it not clearer and I do not see by which rules OOo results
in 702. Would you be so kind to give a step by step calculation?
And besides the question what OOo does, there is the question whether
that
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 reference
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 all,
thinking about issue 102980 and 102981 I found, that it is not clear to
me, how to calculate MULTIPLE.OPERATIONS at all.
Take a spreadsheet and enter the following numbers and formulas into
column A, beginning in cell A1 with number 2.
2
3
=A1+A2
30
=MULTIPLE.OPERATIONS(A3;A2;A4)
70
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:
E
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 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 cel
Hi Maoyg,
maoyg schrieb:
> Hi, all
> I want to discuss this issue's the specification with your.
> If you think it is important, I hope you can vote it.
> As we know, the calc for the merged cell(selection etc) is different from the
> excel,
> I have some advice for the spec, I hope you can disc
Hi Eike,
you have set 2009-07-06 as date for 'ready for QA', but feature freeze
for 3.2 is already 2009-06-dd
http://wiki.services.openoffice.org/wiki/OOoRelease32
And issue 100119 is a feature, isn't it?
kind regards
Regina
---
Hi Eike,
Eike Rathke schrieb:
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
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,
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 x<0 it defines that the return value is 0. For x>=0 it
defines i
Hi Leonard,
Leonard Mada schrieb:
Hi Regina,
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
'left tail'. Therefore I like Jaron's proposal FDISTL more.
.
It adds the benefit
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 den
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 == 1.0
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 that
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,
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.
May I ask you to fix that issue, so that I can update my working copy?
My changes for NO
Hi Eike,
Eike Rathke schrieb:
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
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.
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 err
1 - 100 of 169 matches
Mail list logo