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,
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
Hi Regina,
On Monday, 2010-08-16 16:24:23 +0200, Eike Rathke wrote:
The problem with constant parameters is already actual :(
http://www.openoffice.org/issues/show_bug.cgi?id=113879
Thanks for catching. I'll see if I can easily introduce the mentioned
CloneIfConst() approach or have
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
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
Hi Regina,
On Thursday, 2010-08-12 16:38:33 +0200, Regina Henschel wrote:
The current implementation avoids to copy the matrices X or Y,
although that would ease and shorten the code. I thought there must
be a reason for that and tried to avoid it too. I hesitate to copy X
or Y, because they
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
Hi Marina,
On Monday, 2010-08-09 15:21:39 +0200, Marina Plakalovic wrote:
I have added new function by following the tutorial:
http://wiki.services.openoffice.org/wiki/Calc/Implementation/Spreadsheet_Functions
This works fine when the arguments of the function are scalar, but if I want
to
Hi Regina,
On Thursday, 2010-08-12 09:24:59 +0200, Regina Henschel wrote:
in interpr5.cxx you find
void ScInterpreter::MFastMult(ScMatrix* pA, ScMatrix* pB, ScMatrix* pR,
SCSIZE n, SCSIZE m, SCSIZE l)
// Multipliziert n x m Mat a mit m x l Mat b nach
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.
Hi Regina,
On Thursday, 2010-08-05 15:26:07 +0200, Regina Henschel wrote:
The interpreter allows these cases because in Excel the missing
parameter is allowed at most places and that's needed for imported
documents.
I think, that the interpreter should not allow invalid (in respect
to
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 ]
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
Hi Rashi,
On Wednesday, 2010-07-07 11:09:00 +0200, Niklas Nebel wrote:
On 07/07/10 10:50, rashi dhing wrote:
Wanted to use a certain function of the ScInterpreter class ! Can I give the
whole path sc/source/core/interpre.hxx and use it ?
I wouldn't recommend that. If you have a function
Hi rashi,
On Tuesday, 2010-07-06 12:40:35 +0300, rashi dhing wrote:
So I did pore over the various functions of the ScInterpreter like GetNewMat
and PushMatrix etc.
Apart from being extremely complicated, I still really didn't understand
where the result matrix
was being set/put into the
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
Hi Regina,
On Thursday, 2010-06-03 16:56:56 +0200, Regina Henschel wrote:
I have now changed the entries to the form, for example
{ IMCOT, IMCOT, false, IMCOT, IMCOT },
Now I can use setting ODF 1.2 or ODF 1.0/1.1, file format ods, sxc,
or sdc, reopen directly or round trip through SO8 with
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
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
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
Hi Marina,
On Monday, 2010-05-31 16:21:16 +0200, Marina Plakalovic wrote:
I have heard about the summer student internship and decided to apply for Add
new spreadsheet functions and parameters according to ODFF.
Thank you for your interest in the OpenOffice.org internship!
I am interested
Hi Regina,
On Saturday, 2010-05-08 21:02:45 +0200, Regina Henschel wrote:
I have notice a constraint SinOverflow (which is x=134217728) in
analysishelper.cxx in scaddins. What is the special reason for it?
Having tried I confirm that Excel has that constraint, or more specific
x134217728. I
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
Hi Cor,
On Friday, 2009-12-18 11:45:39 +0100, Cor Nouws wrote:
There are some open issues for page formatting in XLS-import.
70505, 75787, 72823
They are a bit different, but related in the sense that opening and
printing an .xls is affected.
Are all those three issues complicated, say a
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
Hi Cor,
On Tuesday, 2009-09-15 14:47:50 +0200, Cor Nouws wrote:
In this issue, someone did a proposal to split up things, for better
understanding et cetera:
http://www.openoffice.org/issues/show_bug.cgi?id=5930#desc56
AFAICS, it is a sound proposal.
So if no one objects ... I 'll act
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
Hi Leonard,
On Tuesday, 2009-08-25 15:45:42 +0200, Leonard Mada wrote:
I would therefore stick with the one sample definition,
and adapt only the text to correspond to what actually
the function computes.
The p-value is the probability, under the null hypothesis,
of observing a value as
Hi Regina,
On Wednesday, 2009-08-26 18:02:44 +0200, Regina Henschel wrote:
calculates the probability of observing a value as large
or larger for the z-statistic
There is a comparison observing a value larger but it does not
contain, to what it is compared. There must be something like
Hi Daniel, Regina,
On Wednesday, 2009-08-12 10:15:43 +0200, Daniel Rentz wrote:
Regina Henschel schrieb:
== Import ==
Importing an Excel-file with =CEILING(-3.4;) for example gives the
cellcontent =CEILING(-3.4;;1), because in the current import filter the
third parameter 1 is added to
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
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?
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
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
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.
Hi Regina,
On Saturday, 2009-06-20 13:26:08 +0200, Regina Henschel wrote:
dmake: Error: -- `../inc/store/object.hxx' not found, and can't be made
/cygdrive/c/SoftwareArchiv2/odff06/store/source
Did Frank's hint in d...@ooo to regenerate the dependency files with
dmake depend=t help?
Eike
Hi dev,
On Wednesday, 2009-06-17 11:24:36 +0200, Eike Rathke wrote:
[... assertions in a Linux non-pro build ...]
Applying the patch from
http://qa.openoffice.org/issues/show_bug.cgi?id=102806
helped. Not committed to the CWS branch.
Eike
--
OOo/SO Calc core developer. Number formatter
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:
Hi Regina,
On Tuesday, 2009-04-21 22:39:06 +0200, Regina Henschel wrote:
I have attached a patch to the issue. When I have generated the patch
with TortoiseSVN, it includes all the other parts, on which I am working
in interpr3.cxx. I have deleted them and hope, that the patch will still
Hi Regina,
chiming in late on this..
On Wednesday, 2009-04-08 16:02:31 +0200, Regina Henschel wrote:
Leonard Mada schrieb:
I would suggest DISTF().
It would be short and reflects the change in tail. But I worry, that
people will not remember which one is 'right tail' and which one is
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
Hi,
On Sunday, 2009-04-19 20:35:09 +0200, Eike Rathke wrote:
I can set the result to 0 or set illegal argument or perhaps set
infinity. Please decide.
I think letting the calculation just run into an error the same as
occurs for the expression =0^-1 in ScInterpreter::ScExp() is fine
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
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.
Hi Niklas,
On Wednesday, 2009-03-18 14:05:45 +0100, Niklas Nebel wrote:
That's http://qa.openoffice.org/issues/show_bug.cgi?id=96018
We should consider to drop that filter completely...
+1
Objections, anyone?
We'd still have the same kind of issues with any user-defined XSLT
filters.
Hi Regina,
On Tuesday, 2009-03-17 22:15:48 +0100, Regina Henschel wrote:
While 3.2 will be able to read without arguments
for the optional parameters, it will write something that can be read by
any 3.x release.
OK, a kind of 'political' decision. I'll implement it that way.
More a kind of
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.
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
Hi Frédéric,
On Tuesday, 2009-03-17 20:07:46 -0400, Frédéric Courchesne wrote:
I am looking for engineering notation in Calc for about 5 years!!!
Issue 5930 has been opened in 2002 and is not closed yet:
http://www.openoffice.org/issues/show_bug.cgi?id=5930
I would like to participate and
Hi Regina,
On Tuesday, 2009-03-17 18:04:12 +0100, Regina Henschel wrote:
But export to Microsoft Excel 2003 XML (.xml) is problematic.
If OOo is set to save in odf1.2, the file opens with errors in Excel.
All formulae are stripped. The error log says for example
GRUND: Ungültiger Wert
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
Hi maoyg,
On Sunday, 2009-03-15 02:30:48 +0800, maoyg wrote:
build debug=t
[... multiple definitions of symbol ...]
See Oliver's answer on the d...@ooo list.
Eike
--
OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer.
SunSign 0x87F8D412 : 2F58 5236 DB02 F335
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
Hi William,
On Thursday, 2009-03-05 23:47:49 +, William S Fulton wrote:
Well, I finally found some time to get back to this
Good news! :)
Is now the right time to set up a CWS as mentioned above or are there
any more suggestions for improvement?
I just created CWS calcmultiline based
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
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
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
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
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
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
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
Hi Regina,
On Tuesday, 2008-12-09 20:07:53 +0100, Eike Rathke wrote:
I've hoped that the patch in 94555 (CHISQDIST) will get into odff05 and
that the feature will be in OOo3.1. Will that happen or is something
wrong with that patch?
No, I simply was busy with getting a few CWSs rfQA
Hi Regina,
On Tuesday, 2008-12-09 16:33:01 +0100, Regina Henschel wrote:
I've hoped that the patch in 94555 (CHISQDIST) will get into odff05 and
that the feature will be in OOo3.1. Will that happen or is something
wrong with that patch?
No, I simply was busy with getting a few CWSs rfQA,
Hi Kohei,
On Tuesday, 2008-12-09 13:20:48 -0500, Kohei Yoshida wrote:
Again, modularization. We want to separate the Excel filter from the
sc module, and opcode mapping is part of it.
But VBA is not part of the filter, and we need that for VBA. The filter
is merely re-using it.
Hi Regina,
On Monday, 2008-12-01 16:06:53 +0100, Regina Henschel wrote:
I've got a build of odff05 now and want to continue work. I need expm1
and log1p (issue 91602). I can put the following code into
sal\inc\rtl\math.hxx, so I can use the functions with ::rtl::math::expm1
and
Hi Regina,
On Tuesday, 2008-12-02 18:34:25 +0100, Regina Henschel wrote:
I have updated the patches in issue 94555. The work in that area is
finished. Please have a look.
Thanks a lot!
I now want to go further on to BETADIST. Should I make the necessary
changes based on the original
Hi Leonard,
On Friday, 2008-11-28 01:25:25 +0200, Leonard Mada wrote:
I can't give a timeline for further work on ODFF implementation.
I myself will focus on performance.
Does this mean that issue 89976 gets addressed?
http://www.openoffice.org/issues/show_bug.cgi?id=89976
Yes.
I noticed
Hi Cor,
On Wednesday, 2008-11-26 22:05:25 +0100, Cor Nouws wrote:
I thought (ignorance ;-) ) that odff implementation was finished in 3.0
Not at all.
Can you pls tell what you expect about features / time line / impact for
users?
Regina prepared a nice wiki page
Hi Leonard,
On Wednesday, 2008-11-26 23:37:00 +0200, Leonard Mada wrote:
I just noticed the following formula in one of the issues:
=IF(AND((ISERROR(SEARCH(Pass,$F8))),
(ISERROR(SEARCH(Warn,$F8))),
(ISERROR(SEARCH(Closed,$F8,0,1)
IIRC we already mentioned the to be
Hi Daniel,
On Thursday, 2008-11-27 08:44:51 +0100, Daniel Rentz wrote:
odff05 is rebased to m36. Compiled fine on Linux/x86 and Solaris/SPARC,
Daniel is currently building Windows.
Hm. Currently I just build sc and oox on my local machine to continue
some fixes for the oox filter.
I also
Hi,
On Tuesday, 2008-11-18 17:31:03 +0100, Eike Rathke wrote:
I started migrating CWS odff05 from CVS (currently resynced to m31
there) to SVN, and then will rebase it to m36 when available. I'll give
you a heads up when the CWS will be ready for further development.
m36 took longer than I
Hi Cor,
On Wednesday, 2008-11-19 07:46:42 +0100, Cor Nouws wrote:
I'm looking for a comprehensive description of what users should take
care of, because of the implementation of ODFF in 3.0.
I know http://blogs.sun.com/GullFOSS/tags/odff
and have prepared
Hi,
I started migrating CWS odff05 from CVS (currently resynced to m31
there) to SVN, and then will rebase it to m36 when available. I'll give
you a heads up when the CWS will be ready for further development.
Eike
--
OOo/SO Calc core developer. Number formatter stricken i18n
Hi William,
On Saturday, 2008-11-08 23:48:43 +, William S Fulton wrote:
I've had a good look at many of these and have posted a new patch fixing
various multiline problems.
This is great! I think that patch does it, other opinions?
It includes some
subtle changes which I hope are
Hi William,
On Monday, 2008-11-10 23:03:49 +, William S Fulton wrote:
we need to decide how to support multiline text over DDE. We
could implement a number of different protocols over DDE or even OLE,
this is a useful document describing the protocols Excel uses -
Hi Leonard,
On Thursday, 2008-10-30 02:10:33 +0200, Leonard Mada wrote:
I will present a more global solution addressing the FILL on the OASIS
list.
Please note that the OASIS ODF TC works on the file format and the
formula subcommittee on specifying spreadsheet functions and operators
and
Hi Niklas,
On Thursday, 2008-10-30 09:42:30 +0100, Niklas Nebel wrote:
If I select 2 or more equal dates, and try to fill, the date still gets
incremented. This is not the case with ordinary numbers.
Two numbers lead to linear fill, no special handling for the equal
case there.
For
Hi Daniel,
On Tuesday, 2008-10-21 09:41:05 +0200, Daniel Rentz wrote:
+BOOL lclConvertMoney( const String aSearchUnit, double rfRate, int
rnDec )
Btw, aSearchUnit should be a const reference instead of a copy, so
const String aSearchUnit
^^^
+{
+#define COUNT 16
+#define
Hi Leonard,
On Sunday, 2008-10-12 19:11:36 +0200, Leonard Mada wrote:
Shouldn't ODF implement the following functions:
1.) ISHIDDEN(cell, IGNORE_EMPTY = TRUE)
2.) ISFILTERED(cell, IGNORE_EMPTY = TRUE)
3.) ISVISIBLE(cell, IGNORE_EMPTY = TRUE)
While ISHIDDEN() and ISFILTERED() might be
Hi Oliver,
On Saturday, 2008-10-11 18:35:24 +0200, Oliver Brinzing wrote:
=CELL(Width;A1) reports the cell width, for example 12
now a user changes column width - but the formula still reports: 12
pressing (F9) does not help ... only a save reload cycle will display
the new column witdh
Hi Leonard,
On Friday, 2008-10-10 22:19:04 +0200, Leonard Mada wrote:
I made some changes to the following page, basically changing the
background-color for alternating rows:
http://wiki.services.openoffice.org/wiki/Calc/ODFF_Implementation/Schedule
It surely looks better and easier
Hi Regina,
On Thursday, 2008-10-02 23:24:18 +0200, Regina Henschel wrote:
reading the ODFF draft spec I have assumed, that it is possible to
access the functions which have LEGACY.xxx names in exact this way. But
it doesn't work.
ODFF is about file format storage, UI names may and
Congratulations, Regina!
OpenOffice.org announced the winners of the Community Innovation
Program, http://development.openoffice.org/awardees-2008.html
I'm especially pleased that the Calc project is represented by Regina
Henschel who is one of the Gold award winners for her work on
improvements
Hi Regina,
replying after vacation gap..
On Sunday, 2008-09-21 19:26:04 +0200, Regina Henschel wrote:
GAMMALN is currently in Category 'Statistical'. But in
OpenFormula-v1.2-draft9.odt (which is the most current) it is in chapter
'6.15 Mathematical Functions'. GAMMA is an expansion of
Hi Yue,
On Friday, 2008-09-19 17:14:11 +0800, lvyue wrote:
I found some details unmentioned in specifies.
the format of the formula is EUROCONVERT( Number; TextFrom; TextTo;
[FullPrecision [; TriangulationPrecision]] ).
Comparing with Excel, I find following things:
1. if TextFrom equals
Hi Regina,
On Saturday, 2008-09-13 18:18:33 +0200, Regina Henschel wrote:
I want to bring GAMMA and CHISQDIST to UI. I've tried the guide in
http://wiki.services.openoffice.org/wiki/Calc/Implementation/Spreadsheet_Functions
for GAMMA and it works as described.
Good to hear :-)
But the
Hi,
Some time ago we agreed upon an IRC chat hour in a time slot that
allowed both, Chinese and European colleagues, to participate during
their working hours. It was never explicitly announced in public but
just worked. However, I think it would be a good idea to introduce
that as a more
Hi Leonard,
On Thursday, 2008-08-07 21:12:29 +0300, Leonard Mada wrote:
A1: '-3
A2: 4
=ABS(A1)= 3
=SUM(A1:A2) = 4
=SUM(A1,A2) = 4
=A1+A2 = 1
The 2 sensible options are:
- raise an error
Which is what I favor ans want to implement.
BUT then implement a mechanism to detect
Hi Leonard,
On Thursday, 2008-08-07 21:17:34 +0300, Leonard Mada wrote:
The reason why interpreting strings as numeric values on the fly is
harmful and we do not want to implement it.
BUT you do it. You interpret it *always* as 0. This is the worst
possible scenario.
It is at least
Hi Leonard,
On Friday, 2008-08-08 01:44:46 +0300, Leonard Mada wrote:
I recently stumbled upon 2 potentially interesting articles:
On the accuracy of statistical procedures in Microsoft Excel 2007
http://www.sciencedirect.com/science/article/B6V8V-4S1S6FC-5/1/153b556411c3508840f66b38f74c6186
Hi Cor,
On Thursday, 2008-08-07 13:00:46 +0200, Cor Nouws wrote:
Clear that an operator treats text numbers different than a function.
Actually that's not a difference between operators and functions, but
a difference between operators or functions expecting a scalar value as
argument, such as
Hi Ain,
On Wednesday, 2008-07-30 21:00:03 +0300, Ain Vagula wrote:
filed issue http://www.openoffice.org/issues/show_bug.cgi?id=92292
See my comment there.
Eike
--
OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer.
SunSign 0x87F8D412 : 2F58 5236 DB02 F335
Hi William,
On Wednesday, 2008-07-30 17:22:43 +0100, William S Fulton wrote:
I have been working on adding multiline formulae support and have
attached a patch to bug #35913. It also fixes bug #83666. A quick
summary of what it adds is the display of new lines when the result of a
Hi Regina,
On Tuesday, 2008-08-05 22:36:56 +0200, Regina Henschel wrote:
Non of the functions that do mathematical calculation is static and they
call one another across the files. But as you might have noticed I'm a
very beginner and cannot decide yet. I'll come back, when I have learned
Hi Regina,
On Tuesday, 2008-08-05 22:17:56 +0200, Regina Henschel wrote:
It seems to be one of the most difficult functions. To get an idea of
that function, have a look at the file toms708.c of the R-project.
Wow, impressive. The original coder(s) must have spent a lot of time for
numeric
Hi Regina,
On Tuesday, 2008-08-05 22:40:47 +0200, Regina Henschel wrote:
abgeschickt ohne Begrüßung, tut mir leid. Bitte hinzufügen:
Hi Eike,
:)
Getan ;-)
Eike
--
PGP/OpenPGP/GnuPG encrypted mail preferred in all private communication.
Key ID: 0x293C05FD - 997A 4C60 CE41 0149 0DB3
Hi Leonard,
On Wednesday, 2008-08-06 00:47:00 +0300, Leonard Mada wrote:
It seems to be one of the most difficult functions. To get an idea of
that function, have a look at the file toms708.c of the R-project.
There is some hidden beauty in that file. ;)
Without being of much help, I
Hi Cor,
On Tuesday, 2008-07-22 22:29:09 +0200, Cor Nouws wrote:
Example:
A1 = '1.5
B1 = A1-1
Result Excel #VALUE!
Result OOo -1
In Excel that's when loaded in a locale where the decimal separator is
not the '.' dot. If it was, you'd get 0.5
The reason why interpreting strings as numeric
Hi Regina,
I postponed this reply far too many times.. sorry.
Too many questions at once ;-)
On Saturday, 2008-07-19 00:35:29 +0200, Regina Henschel wrote:
BETADIST(x,alpha,beta,lower bound, upper bound, cumulative)
I have attached the actual stage of my work to issue 91547.
Thank you, I
Hi Cor,
On Monday, 2008-07-21 22:30:49 +0200, Cor Nouws wrote:
In some cases, if in Excel a formula has a non-numeric argument,
#VALUE! is returned.
In Calc this is simply neglected.
(Apologies if I over simplify).
Erm.. care to elaborate? On which occasions non-numeric arguments are
1 - 100 of 202 matches
Mail list logo