Cameron Roberts wrote:
I am writing to express interest in participating in the Google Summer
of Code Project. In particular I am interested in contributing to one
of the following projects listed on the OpenOffice web page:
* OpenOffice.org Calc: Creating a solver component
* OpenOff
John Manslow wrote:
There are two tricks that are normally used to overcome the problem that
OpenOffice has with its implementation of the Poisson distribution. The
first is to perform all interim computations on the natural logs of the
quantities involved. This prevents large and small quantit
[EMAIL PROTECTED] wrote:
OpenOffice V1.1.4 Stable.
OS Windows 2000
MS Excel 2000 (9.0.2720)
Create a worksheet in Excel.
Protect the sheet
Save
Open the worksheet in CALC
You will get the following error.
Error loading file :///path/file_name
Read-Error.
This file is password-protected.
OOo
Kohei Yoshida wrote:
Niklas, the last time we talked about this natural sort feature, you
said we couldn't make it into 2.0 because we needed to wait for the
appropriate dev team to update the UNO API and the file format to
reflect this feature addition. Is this still the case?
File format is
Laurent Godard wrote:
1- ShowDetail needs the whole range as argument but hideDetail, not,
only one row of the group
is it a bug/feature ?
The hideDetail/showDetail methods do the same as the "Hide Details" and
"Show Details" menu entries, where this is intended behavior.
2- more important
Laurent Godard wrote:
I think this information is missing as the showDetail becomes useless
without the adress
Sure, the information should be available. Maybe in a later version.
Niklas
-
To unsubscribe, e-mail: [EMAIL PROTE
Kohei Yoshida wrote:
I guess I wansn't too clear. We can't use GPL for this project, since
the main OO.o code base is SISSL/LGPL dual licensed (but not GPL).
Could you change that GPL license line on that page to LGPL (but keep
the SISSL license clause)? After the change, the Solver code will
Kohei Yoshida wrote:
All went well, but now I need to make some arguments in some functions
optional, by providing a default value for them. How do I do that?
Do I do it in the IDL definition, or in one of those overloaded member
functions of com.sun.star.sheet.XAddIn ?
In the IDL. Among an
Lakin Wecker wrote:
I assume these discrepancies are the result of caching formula results.
The assumption is that Excel stores the previously calculated results of
the formulae in the spreadsheet and uses these values at load time,
while OO.o ignores these and fully recalculates the formulae on
M. Fioretti wrote:
a couple of months ago I asked about this:
http://www.mail-archive.com/dev@sc.openoffice.org/msg00139.html
I just wanted to ask is there has been any news about this (especially
openformula adoption) and where I could read it. Any comment is
obviously appreciated.
I haven't
Lakin Wecker wrote:
No charts. The spreadsheet that I talked about, (specifically,
spreadsheet #1) is about 3 worksheets of 4000 rows, and 125 columns, and
1 worksheet with maybe 25 cells filled in.
For our own format, that number of cells seems to explain most of your
1:40 loading time (comp
Daniel Miller wrote:
As I close out the last week of the summer of code, I have finished the
test cases, deployed them in the code and rendered results. I am
finishing up the final documentation to hand in to my mentor Niklas by
Tuesday. If you have any comments or questions on this project ple
Jahn, Ray (R.) wrote:
I have searched both the application help and mail archives (sc-users,
sc-dev) for how to search a cell range of dates, with no success yet.
Please accept my apology if this is a trivial question.
* interactive search
What menu command sequence?
Web page or document of exam
Hi everybody,
I have put a file "possible performance improvements.sxw" into the
"Performance" folder under
http://sc.openoffice.org/servlets/ProjectDocumentList.
It lists a few improvement ideas for loading and saving files in Excel
XLS as well as our own format. This was collected last yea
Kohei Yoshida wrote:
Now, if someone is interested in investigating into this matter (not
necessarily saying that I am one ;-) ), are all relevant files located
under sc/source/filter/excel and sc/source/filter/xml, or is there any
other locations he/she should look into?
These directories are
Eike Rathke wrote:
Not sure if this is related to this formula standardization issue, but
would such a standardization address the argument separator
inconsistency i.e. ',' vs ';' ?
Note that OpenFormula is about the file format, no the representation in
the UI.
The draft does have a section
Jody Goldberg wrote:
What is the goal of an open-formula specification ? I'd assume it is
to improve interoperability between versions and implementors of the
standard. If that is the case then there is already a standard, MS
Excel. Given the complexity and prevalence of it's evaluation
engine
Jody Goldberg wrote:
The time varying nature of MS Excel does have the potential for
problems in the future. However, Microsoft is even more strongly
bound by the chains of backwards compatibility than we are. I
suspect that the differences will be small, and well documented.
When they are disc
Jody Goldberg wrote:
There's an important distinction to be made between errors of
omission and commission. While it's true that we are unlikely to
make any standard 100% accurate, even for a particular version of
MS Excel. It seems reasonable that any errors would be omissions,
corner cases th
Kohei Yoshida wrote:
At the moment, I have two issues in mind that I think need a cursory
attention from a core developer.
http://qa.openoffice.org/issues/show_bug.cgi?id=19991
http://qa.openoffice.org/issues/show_bug.cgi?id=26836
Both are related to cell function defects, and a patch is attach
Askanthea wrote:
I dont know if you can help but i got your email from the -to do page.
dev@sc.openoffice.org is a mailing list, see
http://sc.openoffice.org/servlets/ProjectMailingListList for details.
If I have a long column of variables for example numbers 1-100 in cells
a1-a100 when i t
Askanthea wrote:
http://www.novell.com/connectionmagazine/2005/09/fine_print.html
this pages says check the auto linebreak box -
im using version 2.0 RC - sould i be using a differnt download to access
this feature??
In OOo 2.0, the setting is called "Wrap text automatically", because
users
David A. Wheeler wrote:
OpenDocument is a good specification, but I believe its spreadsheet
formula specification needs more detail. I have crafted a very
early draft of those details, and I hope to create an effort to further
improve them into something useful. I've named this work "OpenFormula
Kohei Yoshida wrote:
Also, refer to Niklas's comment on this list a while ago:
http://sc.openoffice.org/servlets/ReadMsg?list=dev&msgNo=1598
So I might as well give a little update on some items from that list:
- Access to simple (non-formatted) cell content has been changed to
direct calls,
Oliver Brinzing wrote:
the following basic script will insert a form control into a spreadsheet.
but it is not possible to print the form control (have a look at the print
preview)
printing of the form control will only work after a save & relaod ...
any hints whats wrong ?
no problems so far
Kohei Yoshida wrote:
Just for curiosity's sake, what are you guys using if it's not either
SAX nor DOM?
Currently it is SAX. The idea for the future is to move around
identifiers for known element and attribute names instead of strings.
Niklas
---
Kohei Yoshida wrote:
What's the latest word on natural sort? Will this feature ever stand
a chance for integration?
http://qa.openoffice.org/issues/show_bug.cgi?id=26565
With UI changes and file format extension, that seems to be something
for the next major version (3.0, or whatever it will
Kohei Yoshida wrote:
FYI, the patch attached to Issue 55735
http://qa.openoffice.org/issues/show_bug.cgi?id=55735
is ready for review and possibly integration. Please let me know if
there is anything I could do to speed up the process.
Slow down earth's rotation, so there are more hours in a
Kohei Yoshida wrote:
Thanks for letting me know. Would, myself creating a CWS and having
someone QA it help take some load off your shoulder, or not really?
Just a hypothetical scenario, as I don't know if I could find an
appropriate QA personnel... But just a thought.
Last 2.0.1 CWS integr
Norm Byers wrote:
Dear Sirs,
Long ago, in a galaxy far away... I was the developer of the Saturn-Calc
Spreadsheet application for the PDP-11 (RT-11,TSX,RSX,RSTS O/S), VAX (VMS),
and PC (DOS only). Though a couple of $million worth were sold it met its
demise with the demise of DEC and the rise of
Pablo Rodríguez Rey wrote:
We hope if your team have any time you can make a WQ1/WB3 Quattro Pro
file format importer from Corel WordPerfect Suite v6,7,8. We have a
lot of documents in this format and we are trying to upgrade to
OpenOffice 2.0, but this characteristic is basic for us.
A Quattro
Sebastião Alves wrote:
I'm a professor in the University of the State of Rio Grande do Norte,
Brazil. I'm an entusiast of OpenOffice.org and i work in the operation
research and combinatorial optimization area. I would like to know if
you need some help to do the solver componnent. Is there som
Hello everybody,
There has been some disagreement on how to handle changes that would
improve formula compatibility with other applications, but break
documents created with existing versions of OOo. Compatibility with
others and with older versions are two requirements that both have to be
t
Jody Goldberg wrote:
You've identified
1) Compatibility with other spreadsheets
2) Compatibility with older versions of OOo/SO
3) Avoiding conflicts with future OpenFormula spec
There are several things we can do, but they will require us to nail
down more detail on (2). Loading an
JC Helary wrote:
I noticed a considerable difference in size between the "links updated"
and "links not updated" version of an imported Excel spreadsheet.
After checking the content.xml file I noticed that in one case the
whole linked tables were not displayed but present in the xml, while
Oliver Brinzing wrote:
it seems, the has been removed, T1 was:
is it a change or is it my fault, mybe i used a different cell formatting ?
A text style is used only if you applied some formatting (here: language
attribute) to the te
JC Helary wrote:
Neither in Excel nor in Calc are the linked files/sheets originally
displayed. I am only translating the displayed information in the
files, I am not the creator so I don't know what was the purpose of
linking the tables in the first place.
It's a hidden sheet. You can sho
JC Helary wrote:
I found the following structure in a text box attached to a cell:
A sentence is split in two by a line break and the corresponding code
looks like:
beginning of
string
end of
string.
Why is it necessary to implement 2 when the styles are
identical in both segments ?
JC Helary wrote:
You mean that OOo considers a line break to be a paragraph in any
context ?
|You mean that |
|OOo considers |
|a line break to |
|be a paragraph |
|in any context ?|
Here my whole box uses the same style for each of the line break
se
JC Helary wrote:
|You mean that |
|OOo considers |
|a line break to |
|be a paragraph |
|in any context ?|
I was wondering why OOo considers the necessity to convert a line break
to a series of paragraphs in the context of a shape (is that what "text
JC Helary wrote:
I am sorry I have to insist. I am not talking about text fitting into a
box but about the contents of content.xml.
Imported Excel text boxes line breaks are interpreted as paragraphs,
but OOo line breaks in the same context are not. Why the difference ? I
think that is a
Oliver Brinzing wrote:
i found that, the oSheet.copyRange(oDstCell, oSrcRange) does not work,
if cells in the destination area are merged ...
If the source and destination area both contain merged cells, to be
exact. It's the same limitation as with Drag&Drop. The check is there to
prevent in
Kohei Yoshida wrote:
My question is, how do you guys think this integration should be done?
Especially the way it is done as described above is not good for
localization. The menu label needs to be empty, and the label needs
to be define elsewhere, properly localized I assume (I'm not really
fa
Terry North wrote:
I'm not a programmer but I've been using spreadsheets
for a long time, including Lotus, which went through a
number of changes. I hope that reading this does not
take too long, if my suggestion has no merit.
Sorry for the late reply. It's good to see some suggestions, instea
Laurent Godard wrote:
reading some press article, it is claimed that the next xls monster will
handle 1 000 000 of lines and thousands of columns
i think it is ridiculous but for a end-user point of view it will be a
difference. And communication by microsoft seems to oriented in this
direct
Laurent Godard wrote:
i could not wait
i just built sc with a 2 000 000 rows (multiple of 128)
it works :) wonderfull
So Now, I can say "OOo has the biggest one" ;)
lets try if we can do with more than 16 000 columns :)
MAXCOLCOUNT_DEFINE, but I'm not sure if all code that deals with column
n
Laurent Godard wrote:
MAXCOLCOUNT_DEFINE, but I'm not sure if all code that deals with
column names can handle more than two letters.
yes i found it (was not so hard ;-) )
i'll try and see for the letter support
a pointer on the source where to do handle it ? (well, optional)
The code in addr
Kohei Yoshida wrote:
On 3/6/06, KamiHír <[EMAIL PROTECTED]> wrote:
As you probably know I am not a programmer, but I would like to add one
small functionality to SC.
If you click twice on first field ofWriter's statusbar the Navigator
shows up. You can not start the navigator same way in Calc. I
jim wrote:
(e) What is the solution?
This is a matter of opinion. My view is that an improvement for one type of
case is a step forward, and it does not matter if other cases remain as they
are now.
We know about the case when drag or copy is done from a single row, onto a
range of filtered r
Alexandro Colorado wrote:
I have been playing around with IRows something interestesting that I
have been asking for Calculation for a while is retrieve live data and
live spreadsheets. IRows did something similar with models such as
Portafolio ticket where typing =stockprice("MSFT") will give
Alexandro Colorado wrote:
Is it possible to make a live spreadsheet, meaning that the content of
the cells are provided by a live XML feed from an APi. The idea is to
have stock charts/currency exchange/ and/or pricing of products directly
inserted into a Calc spreadsheet and users can add cal
eric ehlers wrote:
how do i troubleshoot problems with OOo calc loading a custom addin
(DLL) from the program directory?
on my old windows machine i have an addin which successfully compiles
under VC6 and loads into calc version 1.1.
on my new windows machine i take the same source code and com
Oliver Brinzing wrote:
I have a problem using cut & paste on non protected cells (input area) on
password protected sheets:
Example:
A user insert values into non protected cells to do some calculations.
The sheet is password protected, the user can not change the formulas.
Now the user uses
Niklas Nebel wrote:
less than an hour after the suggestions were published
Er, forget about that part (times listed in too many different time
zones)...
Niklas
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
Geoffrey Hyde wrote:
Hi, I am an end-user of OpenOffice Org 1.1.2 and I was wondering if
there are any plans to add more types of units of measurement into
OpenOffice Org's next version?
What I am after is basically simple unit conversion, addition, and
subtraction of weights, eg 4lb 6 oz to/
Oliver Brinzing wrote:
maybe i am blind, but i am looking for a simple way to stop the cell editing,
if a user presses a control element (for example an ok button)
background:
the users has to insert values into some spreadsheet cells.
after that he has to press a button to do some calculation
Aby wrote:
I am studying in second year for M.SC(Software Systems) in Tamil Nadu, India
I am capable of doing C++ programs and is interested in the Calc program
in Summer of Code
I would like to now more about this project and would really appreciate
if i could do this project for you
Both su
Vagmi Mudumbai wrote:
I have recently moved my laptop into the all unix world with Ubuntu. I
am now participating in a Management course. Lot of the quantitative
techniques demostrated use the solver addin for Excel. I was surprised
that I could not find a relevant component in Calc. Alhough Go
Oliver Brinzing wrote:
yes, i can do so, but i think it's just a workaround ...
what about an interface with the following methods
isCellEditable()
isEditing()
startCellEditing()
stopCellEditing()
cancelEditing()
Is there any deeper meaning to the inclusion of "Cell" into only some of
the met
Oliver Brinzing wrote:
No, i had a look at some java classes (javax.swing.AbstractCellEditor,
javax.swing.plaf.TreeUI,...) and found a mixture of names indeed
i would prefer the method names without "Cell" ...
Which might lead to the expectation that editing of text in shapes is
included,
Oliver Brinzing wrote:
I just tried out the latest oo dev-build m165 and have problems with the
display update in calc now.
Now after the change via listbox *sometimes* the display is not correct,
i have some white rectangles on screen.
Is this with the file from issue 33728, or something mor
Kohei Yoshida wrote:
I've uploaded a new snapshot of Calc Solver to my website. The
difference from the previous snapshot is mainly to combine the two
separate UNO packages into one, by statically linking to lp_solve, and
removing some preprocessing of models which prevented lp_solve from
solvin
Kohei Yoshida wrote:
The static linking is done only for the standalone UNO package that is
to be distributed outside OO.o (i.e. via my personal website). I
would think this should pose no problem since my UNO package is
distributed separately from the main OO.o build.
As far as integration goe
Kohei Yoshida wrote:
My question is, is it possible to disable repainting of cells while
their data are being modified? Something like:
disableCellUpdates();
enableCellUpdates();
would be the most desirable, but I'm not sure if such API exists.
You can use lockControllers / unlockControll
Gerrow, Darryl wrote:
I am looking to contribute to the projects of:
*- OpenOffice.org Calc: Validation of spreadsheet functions*
*- OpenOffice.org Platform Technology: Layout Manager Widget*
Please let me know how I can join and help in these projects. Thanks.
"Validation of spreadsheet fun
Oliver Brinzing wrote:
IMHO this should be treated as a bug, cause the linebreak char is
changed into a space (code 32) ...
The first cell doesn't contain a line break character. It contains two
paragraphs.
Niklas
-
To unsu
Oliver Brinzing wrote:
this is true, if one acesses the cell via basic getString() method ...
' result: 10 -> ok
but if one uses a formula
=CODE(TEIL(A1;6;1))
the result is 32 ... :-(
Sure, different interfaces for different uses. This by itself is not a
problem and was done on purpos
Leandro Silveira Monteiro da Silva wrote:
My name's Leandro Silveira and I'm a Brazilian computer programmer just
trying to find something nice to do.
While visiting OpenOffice.org website, I got interested in doing some
contributing work.
That's great.
Actually, the task below interested me
Kohei Yoshida wrote:
I'm in the process of creating a CWS for the solver feature I've been
working on for quite some time. I have spoken to Martin Hollmichel
and Michael Meeks about this, and the only bits that we need to be
sure about is whether or not you guys are okay with the naming of
modul
Sven Verleyen wrote:
1. I have a little table with 2 collumns and 8 rows, in that table is
the legend of something in my spreadsheet. So I want to so that legend
when I scroll down the page.
So the idea is: the ability to block a few cells.
You mean something like Window/Freeze, but not for w
Caolan McNamara wrote:
I have a large csv file
(http://people.redhat.com/caolanm/speed/rh198788.csv.bz2) with 39,000
rows and 36 columns, it imports fairly ok, but on save to .ods it takes
an astounding amount of time before the export progress bar appears.
Some minimal poking shows that the t
Loiseleur Michel wrote:
I have opened an issue on a regression betwen OOo 1.x and OOo 2.x.
http://www.openoffice.org/issues/show_bug.cgi?id=69081
What do you mean by "HTML table"? Any HTML file that contains a table?
Without specifying a filter, those were always loaded into Writer/Web.
Loiseleur Michel wrote:
A file which begins with "", eventually "" and
close respectively with "" or "".
Those kind of files are already well parsed and displayed in Calc.
The problem is just on the file detection.
If it's recognized as HTML, it's loaded into Writer/Web by default. This
Guido Ostkamp wrote:
I am a member of the German OOo-QA. Andre Schnabel suggested that I
discuss certain bugs and usability issues directly with the developers of
the spreadsheet application.
I hope I have found the correct list to do so.
You know about Issue Tracker, don't you?
26. Select
Guido Ostkamp wrote:
I suppose the reason for the two problems is that the target check which
prevents the content copy is somehow executed ignoring the 'format=off'
selection, it behaves as if the melting-property is to be copied and
checks for clashes, even though it is explicitely unselected
Niklas Nebel wrote:
30. Select Sheet 2
Looks related to issue 65964, I'll take a look at this. Thanks for
pointing it out.
The problems on the second sheet are fixed together with issue 68690 on
the child workspace "dr50", which will go into OOo 2.1. "Fixed&quo
Kohei Yoshida wrote:
Now, where do you think the scsolver should go? I was thinking along
the line of sc/scsolver just like the existing sc/addin sub-module.
But It'd be nice to get your opinion on this.
sc/addin is more or less obsolete, so it's not the best example. If this
is going to be a
Tanya wrote:
Could you pse send more info?
Some very good work on "Validation of spreadsheet functions" has been
done by Daniel Miller in last year's Google Summer of Code. The results
can be found under "Function Validation" at
http://sc.openoffice.org/servlets/ProjectDocumentList. You shou
Morgan Stefik wrote:
I am writing to request an OO.org Calc feature. There is no ability
to plot multiple data sets in an XY plot. In order to do this
currently one would have to merge the X lists and space the Y values
in the appropriate columns. There should be an ability to select
multiple
Oliver Brinzing wrote:
(1) File | Export to PDF...
(2) Give file name and destination
(3) Klick "Save"
(4) Choose Range|Selection
uups, i forgot to mention, that i was looking for a starbasic script ...
PDF export supports FilterData in the MediaDescriptor. It's a sequence
of PropertyValue,
Michael Meeks wrote:
I was just reading the sc code (on an errand) and I notice that
'GetEnglishFormula' appears to exist in 2 (cut/pasted) forms, each ~55
lines of code.
It seems the code for:
void ScFormulaCell::GetEnglishFormula( String& rFormula, BOOL bCompileXML) const
void
Michael Meeks wrote:
I attach the 'obvious' patch saving only ~40 lines, small of course but
perhaps worthwhile, I assume that the hot path here is to hit
CreateStringFromTokenArray - which does the same trick in it's own
implementation. [ edited in emacs, and possibly broken as a patch ]
Peter Eberlein wrote:
is the method sort on a xRange restricted to max 3 columns (as in the GUI)?
If I specify 6 TableSortFields and run the method, it seems, that
MaxFieldCount is always 3 and a readOnly property.
Yes, it's the same limitation.
Niklas
---
Peter Eberlein wrote:
is there an issue about that? At least a note in the DevGuide would be
useful.
For more sort fields, there's issue 10933.
The IDL description for "MaxFieldCount" in the sort descriptor says
"contains the maximum number of sort fields the descriptor can hold".
By contr
Oliver Brinzing wrote:
is it possible to access the cipher api for en-/decrypting calc password
protected sheets/documents ?
No, not directly (you could create a hidden document, protect a sheet,
save the file and extract the hash, or something like that).
Niklas
---
Leonard Mada wrote:
I was wondering what coding algorithm does Calc use when implementing
the various statistical functions?
REASON
===
Although different formulas are mathematically identical, they give
different *error estimates* when coded on a computer.
EXAMPLE
The variance
Hi,
Some people complain that a large number of Calc patches is piling up at
ooo-build and we at Sun are ignoring or delaying them. To counter this
impression, we (the core Calc team at Sun) went through the Calc section
of the list at http://go-oo.org/ooo-build/patches/src680/apply, and
sort
Leonard Mada wrote:
I noticed that Calc calculates the SUM in the same order as that of the
data cells. However I was reading somewhere (though do not remember
anymore where) that it is best to calculate the sum by:
1. ordering the numbers from smallest to largest (as absolute numbers,
i.e. wit
Alan Yaniger wrote:
Thanks for your suggestion. I added a function in output2.cxx to extend
the default alignment handling, call it when necessary, and it works
great. There's still a problem, though. When I edit a field by pressing
F2 or clicking on the string in the input window, the alignmen
Alan Yaniger wrote:
Is this the way to get the text direction value if I want to change it ?
To change the value, I've been trying to use the function, for example:
pItem.PutValue( FRMDIR_ENVIRONMENT, ATTR_WRITINGDIR );
but I'm getting the compiler error:
"cannot convert 'this' point
Kohei Yoshida wrote:
Issue 35579 - sc-standard-filter-options.diff
Issue 26565 - sc-natural-sort.diff
I'm fully aware that the reason why the file format needs to be
extended in order for these patches to be included is because the
state of their corresponding UI control (i.e. checkbox, combo
Leonard Mada wrote:
What I really want is an easy way to run gawk scripts in calc, i.e.:
- Calc should open a bidirectional pipeline to gawk (gawk supports this)
as described in issue 66816
- (advanced: Calc should recognize the shebang line (e.g. #!gawk
-parameters...), and use the correct pro
Leonard Mada wrote:
Exactly this is the problem. It returns an *ERROR*, so searching for
"string 1" OR "string 2" will fail grandiosely. Actually, it is
impossible to perform this search in calc. This is a *BUG*. (the full
comments can be found for issue 66590)
It's possible using ISERROR. On
Leonard Mada wrote:
2.2 IF FIND() is not 100% equivalent to Exel, it is NO problem. We could
still develop the .xls writing module to write the file to be fully (or
almost) fully compatible with Exel. (see COUNTIF())
2.3 When opening Exel files, you can have a compatibility mode.
Far too much
Leonard Mada wrote:
USED the NumAcc4 TESTSUITE: (see
http://www.itl.nist.gov/div898/strd/univ/certvalues/numacc4.html )
OK, I have tried the most difficult test case, AND Calc fails (for
CORREL major failure):
- for the mean at the 7th decimal digit
- for SD: at the 10th decimal digit
- I bel
Leonard Mada wrote:
I entered in column B(1): "=A1 + 1", that is I added the value "1" for
every element in column A. That said, data values in columns A and B
should be totally correlated. The NIST accepts a value of -0.999, but:
They don't "accept" a value of -0.999 instead of 1, they just c
Leonard Mada wrote:
Mind if I ask, in which file is the CORREL function defined?
Tests are still useful to see where the algorithm fails (and
purportedly, the new algorithm should be correct). Extensive test cases
are always welcome.
sc/source/core/tool/interpr3.cxx, method ScInterpreter::ScC
Leonard Mada wrote:
I wish to mention the following 3 issues:
1. compiling and testing the new algorithm
2. "void ScInterpreter::ScCorrel()" AND "void
ScInterpreter::ScPearson()" seem to be identical
-- I have found NO difference in the documentation for CORREL() and
PEARSON(), but I may have
Leonard Mada wrote:
I wish to discuss the following points:
1.) NEED HELP to compile
Have you seen http://wiki.services.openoffice.org/wiki/Windows? If you
have questions about that, try the tools-dev list.
2.) ANOVA
I'd suggest to concentrate on the existing functions for the moment,
ra
Leonard Mada wrote:
One LAST COMMENT:
The code outputs the *F statistic*, NOT the *p Value*.
To obtain the p-value, a call to FDIST('F statistic value', dfB, dfE)
must be made, BUT:
- I did NOT figure out yet where this function is and how it's named
- all statistic software outputs both the F
201 - 300 of 435 matches
Mail list logo