Re: [sc-dev] Validator for Calc

2010-06-04 Thread Leonard Mada
My biggest wish would be for type checking. E.g. if a cell seems to hold a currency value, and one a date, than currency + date is an error. So, the idea is to verify that types are used in proper calculations. Some options may specify the stringency of the validation, e.g.: - allow or disallow

Re: [sc-dev] constraint of x in sin(x) in scaddins

2010-05-09 Thread Leonard Mada
changing in a single direction, sinus is not a monotone function). Sincerely, Leonard Mada Original-Nachricht Datum: Sun, 09 May 2010 18:07:22 +0200 Von: Regina Henschel rb.hensc...@t-online.de An: dev@sc.openoffice.org Betreff: Re: [sc-dev] constraint of x in sin(x

Re: [sc-dev] constraint of x in sin(x) in scaddins

2010-05-09 Thread Leonard Mada
to compute the sinus of it. I hope this explains why there must be an upper limit (unlike monotone functions, where the value is continuously changing in a single direction, sinus is not a monotone function). Sincerely, Leonard Mada Original-Nachricht Datum: Sun

Re: [sc-dev] constraint of x in sin(x) in scaddins

2010-05-09 Thread Leonard Mada
hope this explanation is better than my previous one. I get the feeling otherwise that my posts resemble more and more the dead parrot sketch. Sincerely, Leonard Mada Betreff: Re: [sc-dev] constraint of x in sin(x) in scaddins Dear Regina, It is completely irrelevant how accurate

Re: [sc-dev] constraint of x in sin(x) in scaddins

2010-05-08 Thread Leonard Mada
, Leonard Mada Original-Nachricht Datum: Sat, 08 May 2010 21:02:45 +0200 Von: Regina Henschel rb.hensc...@t-online.de An: Calc dev dev@sc.openoffice.org Betreff: [sc-dev] constraint of x in sin(x) in scaddins Hi all, I have notice a constraint SinOverflow (which is x=134217728

[sc-dev] Copying Conditional Formatting across spreadsheets

2009-10-06 Thread Leonard Mada
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] A.) THE PROBLEM Lets suppose we want to do some useful, but more complex Conditional Formatting: [These examples are

Re: [sc-dev] Copying Conditional Formatting across spreadsheets

2009-10-06 Thread Leonard Mada
Henschel rb.hensc...@t-online.de An: dev@sc.openoffice.org Betreff: Re: [sc-dev] Copying Conditional Formatting across spreadsheets Leonard Mada schrieb: Dear Calc Team, I would like to easily copy the *Conditional Formatting* across different sheets. [see issue: http://www.openoffice.org

[sc-dev] Re: [Issue 90759] ZTEST not same as Excel

2009-09-10 Thread Leonard Mada
Hello Eike, I might be too late, but the following small correction sounds slightly better: Calculates the probability of observing a z-statistic greater than the one computed based on *the* sample. Original-Nachricht Datum: 3 Sep 2009 12:34:44 - Von: e...@openoffice.org

Re: [sc-dev] Issue 5658 solved

2009-09-09 Thread Leonard Mada
, you need to (manually) change all strings to numbers, which again makes the extension very handy. Sincerely, Leonard Mada -- Jetzt kostenlos herunterladen: Internet Explorer 8 und Mozilla Firefox 3 - sicherer, schneller und einfacher! http://portal.gmx.net/de/go/atbrowser

Re: [sc-dev] Re: [Issue 90759] ZTEST not same as Excel

2009-08-26 Thread Leonard Mada
welcomed some input from anyone speaking natively English. Sincerely, Leonard Mada A last note: I understand what was meant in the previous definition with a second sample, but I found that explanation very confusing, because we never take a 2nd sample. Also, the 2 samples are never compared

[sc-dev] Re: [Issue 90759] ZTEST not same as Excel

2009-08-25 Thread Leonard Mada
is used, but I would rather specify it explicitly. There are a lot of different statistics out there. Sincerely, Leonard Mada Original-Nachricht Datum: 25 Aug 2009 07:20:41 - Von: drk...@openoffice.org An: disco...@openoffice.org Betreff: [Issue 90759] ZTEST not same

Re: [sc-dev] OOo2.4.2 takes of:=FDIST(a,b,c) as if it is ooc:=FDIST(a,b,c)

2009-07-04 Thread Leonard Mada
as: '= I believe this is a more deeper problem within Calc that needs to be addressed. Sincerely, Leonard Mada -- Neu: GMX Doppel-FLAT mit Internet-Flatrate + Telefon-Flatrate für nur 19,99 Euro/mtl.!* http://portal.gmx.net/de/go/dsl02

Re: [sc-dev] Need UI name for new FDIST function

2009-04-08 Thread Leonard Mada
Hi Regina, I would suggest DISTF(). It adds the benefit that all distribution functions could be grouped at some point under a DIST...() name. DISTGAMMA() DISTPOISSON() DISTGAUSS() (reluctantly DISTNORM) There could be a shorthand form: DISTF DISTG DISTP DISTN (it is for this that I would

Re: [sc-dev] Automatic date recognition

2009-01-13 Thread Leonard Mada
Hello Stefan, Stefan Weigel wrote: Hi Leonard, Leonard Mada schrieb: it should work with: http://loinc.org/downloads See the link with title: LOINC Table File - ASCII Text Format (2.9 MB). I got it. I can´t see any problem. Did you set the data type of the columns in the import

[sc-dev] Automatic date recognition

2009-01-07 Thread Leonard Mada
Dear developers, this issue slowly drives me crazy. Unfortunately it is after *much work* that I discover again and again that OOo Calc transforms perfectly valid code string into dates, like in the example below. These are international lab-codes from the LOINC database, but upon

[sc-dev] Re: Data Grid Size element proposal

2008-11-28 Thread Leonard Mada
Dear TC Members, while reading the discussion, I have to express my dismay to the proposal and more broadly to the various spreadsheet concepts. It seems little has been learned from past mistakes. Warren Turkal wrote: [...] This doesn't seem useful to me. If I never address anything in

Re: [sc-dev] Return 0 on Search Instead of Zero

2008-11-27 Thread Leonard Mada
Hello Eike, Eike Rathke wrote: Hi Leonard, 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 implemented IFERROR()

[sc-dev] Return 0 on Search Instead of Zero was Informing users about ODFF was [sc-dev] Rebasing CWS odff05

2008-11-26 Thread Leonard Mada
Hello everyone, 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) And this only because SEARCH() returns an ERROR if the string is not found.

Re: [sc-dev] Formulas interpreted as text

2008-11-07 Thread Leonard Mada
Hello, Regina Henschel wrote: Hi Leonard, Leonard Mada schrieb: Dear develoeprs, Please have a look at iisue 85328: http://www.openoffice.org/issues/show_bug.cgi?id=85328 Formulas entered into column A will be interpreted as text. This is a very strange behaviour. I do not have

[sc-dev] z-Test

2008-11-07 Thread Leonard Mada
Hi Regina, What did you decide with the z-test? I lost slightly the track. I recommended extending the t-test. And I still believe this is the better solution. While for z-test, you may want to implement another parameter specifying the number of tails: lesser, greater or two-tailed So,

[sc-dev] Re: What should ZTEST calculate?

2008-10-30 Thread Leonard Mada
also http://www.statmethods.net/stats/anova.html Hi Leonard, Leonard Mada schrieb: [...] I have found one discussion in http://lists.oasis-open.org/archives/office-formula/200702/msg00047.html and Eike reminds on it in http://lists.oasis-open.org/archives/office-formula/200806/msg00050.html

[sc-dev] Please add CSV-export to Export-Dialog

2008-10-29 Thread Leonard Mada
Dear developers, Please add the CSV-format to the Export-Dialog as suggested in issue 32684. http://www.openoffice.org/issues/show_bug.cgi?id=32684 After a long absence from the statistical horizon (I basically did not have any scheduled work with advanced statistics over the last 2 years), I

Re: [sc-dev] Filling dates in Calc

2008-10-29 Thread Leonard Mada
Hello Niklas, I will present a more global solution addressing the FILL on the OASIS list. Unfortunately, I am rather limited in free time, but I still try to do it over the weekend. Niklas Nebel wrote: On 10/24/08 12:35, Leonard Mada wrote: Oh, I forgot to press shift. Though, selecting 2

Re: [sc-dev] Filling dates in Calc

2008-10-24 Thread Leonard Mada
better alternative. Sincerely, Leonard Leonard Mada wrote: Hello everyone, I worked late last night and needed to fill in dates in Calc. Actually I needed to fill the same date in a variable number of cells. I entered the same date in 2 adjacent cells and tried to drag the right corner (after

[sc-dev] Filling dates in Calc

2008-10-24 Thread Leonard Mada
Hello everyone, I worked late last night and needed to fill in dates in Calc. Actually I needed to fill the same date in a variable number of cells. I entered the same date in 2 adjacent cells and tried to drag the right corner (after selecting both cells), but Calc continued to increment

Re: [sc-dev] =CELL(Width;A1) does not recognize changes of column width ?

2008-10-14 Thread Leonard Mada
Hi Eike, see my comments below. And apologies for cross posting, but this is ODF-relevant. Eike Rathke wrote: 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

Re: [sc-dev] ODFF_Implementation/Schedule Table Style

2008-10-12 Thread Leonard Mada
, 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 readable than before. However, I noticed

[sc-dev] ODFF_Implementation/Schedule Table Style

2008-10-10 Thread Leonard Mada
Hi everyone, 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 However, I noticed the explanatory text: *do not edit as your changes would get overwritten*. Can

[sc-dev] Ugly DATE bug

2008-10-07 Thread Leonard Mada
Dear developers, when are you going to fix the DATE-autoformat BUG? I have a highly official document with various statistics split on age groups and this is what I get: 1 01/04/08 05/09/08 10/14/08 15-19 20-24 25-34 35-44 45-54 55-64 65-74 75-84 85 I hope that anyone agrees that these are

Re: [sc-dev] Regular Expressions in FIND()?

2008-10-01 Thread Leonard Mada
Hello David, Indeed, that did the trick. Thank you very much. There is NO mention in the Help that comes with OOo-m29 that FIND() does not search for regular expressions, and I was fairly convinced that it actually works. Moreover, I had the firm impression that the error lies within the

Re: [sc-dev] Number Autoconvert

2008-09-03 Thread Leonard Mada
Hello Niklas, Niklas Nebel wrote: On 09/02/08 23:10, Leonard Mada wrote: try to paste this table into Calc: http://www.rush.edu/webapps/rml/RMLRangesHem.jsp How do I turn *Date recognition* off?! I have yet to see something as 5-16 being a date! Depending on the browser you use, you may

[sc-dev] Number Autoconvert

2008-09-02 Thread Leonard Mada
Dear all, try to paste this table into Calc: http://www.rush.edu/webapps/rml/RMLRangesHem.jsp How do I turn *Date recognition* off?! I have yet to see something as 5-16 being a date! Sincerely, Leonard - To unsubscribe,

Re: [sc-dev] Calc Very Slow

2008-08-12 Thread Leonard Mada
wrote: Hi Leonard, On Monday, 2008-08-11 23:12:36 +0300, Leonard Mada wrote: Also I noticed that most of the 2,700 entries are redlined as unknown text (the words are medical terms so are not found in the dictionary). That may make a difference. Try disabling AutoSpellcheck

Re: [sc-dev] Calc Very Slow

2008-08-11 Thread Leonard Mada
be highly welcomed. Sincerely, Leonard Niklas Nebel wrote: On 08/10/08 23:41, Leonard Mada wrote: Hello everyone, Calc has become very slow on my computer. My system is an older one: processor 1 GHz with 1 GB RAM. Win2k SP4 Calc-dev m28 is very slow. I noticed it already after installing

Re: [sc-dev] Calc Very Slow

2008-08-11 Thread Leonard Mada
Hi cor, Cor Nouws wrote: Leonard Mada wrote (11-8-2008 21:58) [...] Calc was always slightly slower on this computer, but I perceive it even slower now. In particular, it takes 1-2s for the context-menu to appear, when it should pop up instantly. Also, scrolling is painfully slow

Re: [sc-dev] Calc Very Slow

2008-08-11 Thread Leonard Mada
it in an unusual way (something along these lines). No Crash Report window pops up. Is this known? I do not think it has to do with the extensions. Sincerely, Leonard Leonard Mada wrote: Hi cor, Cor Nouws wrote: Leonard Mada wrote (11-8-2008 21:58) [...] Calc was always slightly slower

[sc-dev] Calc Autoformatting Error

2008-08-10 Thread Leonard Mada
Hello everyone, I try to enter in a Calc cell: Diabetes mellitus Typ IIb but the last part gets converted automatically to Typ Iib. How do I undo this? This is obvious a serious bug. Why does Calc autoformat something it is NOT supposed to do? Tested with OOo-dev m28. Sincerely, Leonard

[sc-dev] Calc Very Slow

2008-08-10 Thread Leonard Mada
Hello everyone, Calc has become very slow on my computer. My system is an older one: processor 1 GHz with 1 GB RAM. Win2k SP4 Calc-dev m28 is very slow. I noticed it already after installing it some 2-3 weeks ago. When working with a spreadsheet with ~2.500 rows (4 columns, 2 text, the

Re: [sc-dev] Issue for #VALUE! on Excel import ?

2008-08-07 Thread Leonard Mada
Hello everyone, Eike Rathke 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 the result of a single

Re: [sc-dev] development status of BETADIST

2008-08-07 Thread Leonard Mada
other tricks that I do not understand. Eike Rathke wrote: 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

[sc-dev] Statistical Articles

2008-08-07 Thread Leonard Mada
Hello everyone, 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 and The accuracy of statistical distributions in

Re: [sc-dev] development status of BETADIST

2008-08-05 Thread Leonard Mada
Hi Regina, Regina Henschel wrote: Eike Rathke schrieb: Hi Regina, I postponed this reply far too many times.. sorry. Too many questions at once ;-) 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.

Re: [sc-dev] just found ;-)

2008-07-11 Thread Leonard Mada
Hello everyone, Loiseleur Michel wrote: Hi *, Leonard Mada a écrit : [...] *Thirteen Prevalent Misconceptions about Floating-Point Arithmetic:* 3. Arithmetic much more precise than the data it operates upon is needless, and wasteful. I have concerns that double

Re: [sc-dev] just found ;-)

2008-07-10 Thread Leonard Mada
wrote: Hi Leonard, On Friday, 2008-07-04 03:07:04 +0300, Leonard Mada wrote: Well, 15-digits might have been intended behaviour in the '70s, but is hardly appropriate in 2008. IEEE 754 double did not change. I am really amazed, that programs still cling to 15-digits. Well

Re: [sc-dev] just found ;-)

2008-07-03 Thread Leonard Mada
Hello Niklas, hello everyone, Niklas Nebel wrote: Oliver Brinzing wrote: have a look: http://www.spiegel.de/netzwelt/web/0,1518,563637,00.html seem's oo has the same problem with: 29513736 * 92842033 = 2740115251665290 Output is rounded to 15 significant digits. That's intended behavior.

Re: [sc-dev] [Issue 90759] ZTEST not same as Excel

2008-06-17 Thread Leonard Mada
Hi all, David King wrote: 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

Re: [sc-dev] any performance test-cases ?

2008-05-27 Thread Leonard Mada
algorithm vs more advanced algorithms in the spreadsheet document. Please read carefully. I hope that this spreadsheet will make it a good test-case to test future performance. Sincerely, Leonard Leonard Mada wrote: Dear Caolan, I have attached a test-spreadsheet to issue 89976. [http

Re: [sc-dev] 2008 Q2 Review of Spreadsheet Project

2008-05-25 Thread Leonard Mada
Hello Niklas, dear list-members, sorry for the late reply. I am trying to work out my backlog. Niklas Nebel wrote: Niklas Nebel wrote: Niklas Nebel wrote: There is now a preliminary planning section on the wiki page. It can be discussed for a week, and will be finalized in an IRC meeting on

Re: [sc-dev] Request some assistance

2008-05-25 Thread Leonard Mada
Hello everyone, I am revisiting an old BUG. Leonard Mada wrote: Hi Bruce, Hi Leonard, Leonard wrote: Now, to give a usefulness to the 'CTRL'+'A' key, I return back to my previous post: give the user 2 choices 1.) first choice: display window where user can select the number

Re: [sc-dev] Request some assistance

2008-05-25 Thread Leonard Mada
Hi Regina, Regina Henschel wrote: Hi Leonard, Leonard Mada schrieb: I needed today to fill up exactly 30,000 rows. How do I do this? Enter the cell range - for example A2:AMJ30001 - into the 'Name Box' (the drop down list on the left side of the formula bar) and hit enter. Now

Re: [sc-dev] 2008 Q2 Review of Spreadsheet Project

2008-05-01 Thread Leonard Mada
Hello Niklas, hello list members, I have outlined a medium and long-term strategy for Calc, see: http://wiki.services.openoffice.org/wiki/2008_Q2_Review_of_Spreadsheet_Project#mid.2Flong_term_planning This is work in progress and I did not finish writing everything I planned to cover

Re: Re: [sc-dev] 2008 Q2 Review of Spreadsheet Project

2008-04-30 Thread Leonard Mada
Hi Eike, hello list-members, Eike Rathke wrote: Hi Leonard, On Tuesday, 2008-04-29 22:54:02 +0300, Leonard Mada wrote: 1.) AUTOMATIC DATE RECOGNITION I strongly support modifying this behaviour in a short timeframe and implementing a date input-mask, where every user can accurately

Re: [sc-dev] 2008 Q2 Review of Spreadsheet Project

2008-04-29 Thread Leonard Mada
Hello everybody, this is good news. I will add some important strategic suggestions in a later post. This is only a short comment. TOC === 1.) AUTOMATIC DATE RECOGNITION 2.) TEXT-vs-NUMERIC 1.) AUTOMATIC DATE RECOGNITION == Regina Henschel wrote: Hi, Niklas

[sc-dev] Re: Date Input

2008-04-07 Thread Leonard Mada
was: Date input (was: Re: [sc-dev] Pasting from HTML as unformatted text adds space t... from December 2007 Dear all, as previously discussed: determining whether the input is a date without any other clues has been (almost) proven to be error-prone... [see

[sc-dev] Multidimensional Spreadsheets and OLAP Servers

2008-02-03 Thread Leonard Mada
Hi all, After a long period of inactivity, I have recently filed the 3rd issue in my *Major Spreadsheet Design Flaws* series: see http://www.openoffice.org/issues/show_bug.cgi?id=85825 This issue was long overdue and, although I mentioned it a couple of times, I never found the time to finish

[sc-dev] Re: SC - ANOVA

2007-12-14 Thread Leonard Mada
Hi, Per Eriksson wrote: Dear Leonard Mada, I have received an inquiry about our Calc component and ANOVA features. I do not know if anyone works on implementing natively ANOVA in Calc. I did some preparatory work (see http://www.openoffice.org/issues/show_bug.cgi?id=4921), but I am

Re: [sc-dev] New features about Data Filter

2007-12-14 Thread Leonard Mada
Hi all, Mathias Röllig wrote: Hello! Am 12.12.2007 20:59 schrieb Leonard Mada: 1.) I do not have a strong opinion on this. Somehow, I find autofiltering very limited and useful only in very simple situations, not on really big tables. (See my issue http://www.openoffice.org/issues

Re: [sc-dev] Date input

2007-12-14 Thread Leonard Mada
. Niklas Nebel wrote: Leonard Mada wrote: Formatting dates based on the system locale is BAD, BAD, BAD in a *mutli user environment*, because you end with both MM/DD and DD/MM and a lot of confusion. Whatever step is taken, please consider that multi-user environments contain usually also

Re: [sc-dev] New features about Data Filter

2007-12-12 Thread Leonard Mada
Hi all, Mathias Röllig wrote: Hello! ... Imagine that you have a big table with many columns and data rows. Now you set a autofilter in 3 or 5 columns. Which was the first that you have set? OK, you can remember it. But if you save the file and another person want to work with it? The person

Re: [sc-dev] Date input

2007-12-11 Thread Leonard Mada
Hi all, Cor Nouws wrote: Hi *, ... The current system allows fast working. With typing in dates, once you know how it works and /or set your cell formatting / styles correctly, it is OK. No, it is not OK. If you work in a multi-user, multi-locales environment, you will feel the heat

Re: [sc-dev] Date input

2007-12-09 Thread Leonard Mada
Hi all, Kohei Yoshida wrote: ... * determining whether the input is a date without any other clues has been (almost) proven to be error-prone, can never reach an acceptable level, and leads to the wrath of users, largely due to localized date formats. So, what can we do? The rough idea I've

Re: [sc-dev] Pasting from HTML as unformatted text adds space to cells

2007-12-06 Thread Leonard Mada
Hi, my vote for turning the Auto-Date OFF! I hate this date thing. I use the english version of OOo, because I hate localised versions, and also their handling of number/date-formats (and other problems with localised versions). But I often write dates as non-standard dates. However, OOo

Re: [sc-dev] Name for RCalc - tentative R4Calc

2007-10-23 Thread Leonard Mada
Wojciech Gryc wrote: Okay! So I guess this means we're going with R4Calc and R4Calc - R Statistics for OOoCalc... Yay! Niklas -- can we set up a CVS, in this case? Thanks, Wojciech Hi Wojciech, Great! I still don't understand why the paste is broken (and some other things - it's still

[sc-dev] RCalc (R4Calc) OOo-java issue?

2007-10-18 Thread Leonard Mada
Hi all, I mentioned already the many problems that I have with RCalc on OOo dev2.3 m231. There are also problems on OOo 2.3 stable, and commands that did work do not work anymore, while some obvious NON-RCalc things are broken, too. I came across this message:

Re: [sc-dev] R/Calc 0.1.11

2007-10-14 Thread Leonard Mada
if you feel R_Calc is OK, I do not mind using it. [However, I feel that R_Calc and RCalc are too similar, and underscores are usually not used in package names because they tend to confuse users.] Sincerely, Leonard Thanks, Wojciech On 10/10/07, Leonard Mada [EMAIL PROTECTED] wrote: Hi, I

Re: [sc-dev] R/Calc 0.1.11

2007-10-10 Thread Leonard Mada
Hi, I found a very annoying bug with the Coding Window: Whenever I try to paste something inside the coding window, the following message is displayed and nothing gets pasted: The inserted text exceeded the maximum length of this field. The text was truncated. Actually, nothing gets

Re: [sc-dev] Re: R / Calc Name ?

2007-09-03 Thread Leonard Mada
Hi, This has proven a difficult task! :) I definitely prefer debugging... Sometimes. I really like RCalc -- it was a natural way to go, but Google's search results made it pretty clear we'd be way too similar to the currently existing RCalc program. Aside from that, roose is good...

[sc-dev] Re: R / Calc Name ?

2007-08-28 Thread Leonard Mada
Hi to everyone! Wojciech Gryc wrote: Hi, ... Finally... Should we name the add-on? I'm not very good at this, but I'd like to get your thoughts. Thanks, Wojciech I was thinking more thoroughly about a filename and I came up with the following proposals: 1.) RCalc = current name;

Re: [sc-dev] Re: R / Calc Name ?

2007-08-28 Thread Leonard Mada
Hi, Sorry for the many posts, but I became even more creative: 1.) ROOSE = R-OpenOffice Statistical Extension/Environment 2.) iCaRuS = integrated Calc-R utility for Statistics 3.) StatOOR = Statistics in OpenOffice with R Sincerely, Leonard

Re: [sc-dev] Re: R / Calc Name ?

2007-08-28 Thread Leonard Mada
Leonard Mada wrote: Hi to everyone! Wojciech Gryc wrote: Hi, ... Finally... Should we name the add-on? I'm not very good at this, but I'd like to get your thoughts. Thanks, Wojciech I was thinking more thoroughly about a filename and I came up with the following proposals: 1.) RCalc

Re: [sc-dev] R/Calc - 0.1.6

2007-08-22 Thread Leonard Mada
Hi, Wojciech, Niklas Nebel wrote: Wojciech Gryc wrote: From an administrative point of view, I am supposed to stop working as a Google Summer of Code student today at 3 pm EST. As such, I've leased a new version of the package: 0.1.6, with links at

Re: [sc-dev] A problem need assurance!

2007-08-20 Thread Leonard Mada
Hi, maoyg wrote: Hello all, 1.create a new Calc. 2.input characters into any cell,select part of the characters , click 'background color'. Result: 1).The cell can be colored. 2).When undo, characters disappear,the cell color still exists. I'm looking forward to your help! this is

Re: [sc-dev] R/Calc - 0.1.6

2007-08-20 Thread Leonard Mada
Hi Wojciech , I did some further tests this afternoon. The results are encouraging, though I found additional errors: 1.) spaces before {$OUT:...} prevent any output, e.g. _{$OUT}-...something... where '_' is a space won't work. 2.) I still have problems with the PLOT. Both with Win XP SP2

Re: [sc-dev] Re: Exciting News

2007-08-17 Thread Leonard Mada
Hi, Eike Rathke wrote: Hi Leonard, On Wednesday, 2007-08-15 23:04:55 +0300, Leonard Mada wrote: be careful when pasting from the wiki, as the wiki-features required to insert a space between 2 braces, changing '[[' to '['_space_'[' which breaks the code. One has to convert back

Re: [sc-dev] Re: Exciting News

2007-08-17 Thread Leonard Mada
Hi Wojciec, I detected some further potential bugs: Can you please look into the following code: [in the coding window] 1.) IF there is NO input from the spreadsheet first, the script won't run: e.g. {$OUT#E1}-HELLO WORLD or x-25 {$OUT#E1}-{$BASE} 2.) for some reason, the PLOT

[sc-dev] Re: Exciting News

2007-08-15 Thread Leonard Mada
? Thanks, Wojciech On 8/14/07, *Leonard Mada* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi Wojciech, nice to see further development. I had some problems to run the package and did not have time until now to look into the issue any further. But I installed today v 0.1.4

Re: [sc-dev] Duplicate Data

2007-08-11 Thread Leonard Mada
Hi Eike, Eike Rathke wrote: ... Nice idea, but I doubt we'd implement that soon. Apart from that, a hard link to a cell containing a formula should be prevented, and entering a formula in A1 would have to break all hard links pointing to A1 and change them to soft-linked usual cell

Re: [sc-dev] i20496 : Enhanced formula input

2007-08-09 Thread Leonard Mada
Hi all, there is one thing I definitely want to avoid - at all cost: namely converting non-formula input into a formula. Lets say the user enters: +some_string IF 'some_string' is NOT a valid formula, then: A.) IF this would be converted to a formula, Calc would evaluate it and display

Re: [sc-dev] i20496 : Enhanced formula input

2007-08-09 Thread Leonard Mada
Hi all, sorry for another post. Eike Rathke wrote: ... 2. And w.r.t to the ++ - =++ its for the similarity with excel (and also + - =+). Excel converts +number+number to =number+number and ++number to =+number, but converts +name to =+name Note that Excel does not convert single

Re: [sc-dev] all the icons are on at the same time

2007-08-03 Thread Leonard Mada
Can reproduce this bug with OOo 2.2.1 (en locale) on Win XP. When the 'Design Mode' is ON, clicking sequentially on the 'Forms Control' icons will highlight them all (select them all). [Altough, when drawing the control inside the spreadsheet only the lastly selected control is actually

Re: [sc-dev] Is printing 0-values from formula's normal?

2007-08-03 Thread Leonard Mada
Hi, I would vote for BUG. But lets ask other folks, too. Sincerely, Leonard Cor Nouws wrote: 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

Re: [sc-dev] Is printing 0-values from formula's normal?

2007-08-03 Thread Leonard Mada
Hi, Regina Henschel wrote: 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

[sc-dev] Duplicate Data

2007-08-03 Thread Leonard Mada
:07 +0300, Leonard Mada wrote: For i80139 please note that for 3.2 DATA LINKS external references are already implemented (could be enhanced though to not create an internal sheet and handle things a bit different) Nahh, a bidirectional-link does not work (neither for 2 different

Re: [sc-dev] Formula import for OOXML

2007-08-03 Thread Leonard Mada
extending the simple spreadsheet to multidimensional spreadsheets. I will file a new feature request when I will have some time. Sincerely, Leonard Mada -- GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS. Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail

Re: [sc-dev] Formula import for OOXML

2007-08-03 Thread Leonard Mada
Daniel Rentz wrote: Leonard Mada schrieb: What are shared formulas? Is it the same as the concept I presented in a previous e-mail, where one can have a default formula for a column? This is indeed a very useful feature to have in OOo Calc and is one issue that gets into my TOP 5 of major

[sc-dev] MOVE Calc Usability Page?

2007-07-30 Thread Leonard Mada
Hi, there is a new Calc Usability wiki page (see http://wiki.services.openoffice.org/wiki/Calc_Usability_Activities). However, I think the page should be moved to /Calc/Usability to bring some structure to the OOo site. Should I proceed with the move operation? By the way, I have filed 2

Re: [sc-dev] Updating Statistical Wiki Page

2007-07-20 Thread Leonard Mada
Hi, Eike, thanks for the help. Eike Rathke wrote: ... 1. Move (! by using the wiki's move mechanism, visible when going to edit mode) the Statistical_Data_Analysis_Tool page to Calc/To-Dos/Statistical_Data_Analysis_Tool Moved! Unfortunately, I did not manage to create a new page,

[sc-dev] Updating Statistical Wiki Page

2007-07-16 Thread Leonard Mada
Hi, I would like to update the statistical wiki page a little bit, and started yesterday to think about some enhancements. [see http://wiki.services.openoffice.org/wiki/Statistical_Data_Analysis_Tool] The reason is, that the page looks already too cluttered and I would like to reorganise

Re: [sc-dev] stable algorithm for statistic functions issue 78250

2007-07-05 Thread Leonard Mada
Regina Henschel wrote: ... I'll work on CORREL, PEARSON, RSQ, STEYX, SLOPE, INTERCEPT and FORECAST (all in interpr3.cxx), which I think all suffer from the same square-problem. The function GetStVarParams in interpr1.cxx is OK in this respect and therefore also the DEVSQ, STDEV and VAR.

[sc-dev] Table Highlighting

2007-07-05 Thread Leonard Mada
Hello Niklas, helle Eike, I posted some time back a feature-request to implement a special spreadsheet-view in which rows get *highlighted* (see http://www.openoffice.org/issues/show_bug.cgi?id=78181). Virtually every table on the net is displayed this way. Also, most web applications have

Re: [sc-dev] Slow copy in SC

2007-06-28 Thread Leonard Mada
? Sincerely, Leonard Mada Original-Nachricht Datum: Thu, 28 Jun 2007 11:13:17 +0800 Von: zhaosheng [EMAIL PROTECTED] An: dev@sc.openoffice.org Betreff: [sc-dev] Slow copy in SC Hi,all I found something in SC, IMHO, it may be annoying to some people. it is the inserted picture

Re: [sc-dev] Request some assistance

2007-06-10 Thread Leonard Mada
Hi Bruce, Hi Leonard, Leonard wrote: Now, to give a usefulness to the 'CTRL'+'A' key, I return back to my previous post: give the user 2 choices 1.) first choice: display window where user can select the number of columns and rows (for default values see paragraph 2.) )

Re: [sc-dev] Something about Filter function

2007-06-05 Thread Leonard Mada
Wouldn't issue 66588 (see http://www.openoffice.org/issues/show_bug.cgi?id=66588) make for a great filter enhancement? Sincerely, Leonard Kohei Yoshida wrote: On Thu, 2007-07-05 at 10:42 +0800, gaozm wrote: Hello all: I'm Gao Zemin, I would like to do some contribution to the

Re: [sc-dev] Re: R Questions

2007-06-04 Thread Leonard Mada
it correctly and it works perfectly on Linux but crashes in Windows. At this point I do not know why, but this is my first priority... I am asking around on the IRC channel right now and will let you know as soon as possible about a fix. Thanks, Wojciech On 6/3/07, Leonard Mada [EMAIL

Re: [sc-dev] Re: R Questions

2007-06-03 Thread Leonard Mada
Hello, I have some additional questions: I tried the following R-commands inside RDump(): search() should output attached packages (.packages()) print(.packages()) Neither (.packages()), nor print(.packages()) work. They should output the attached packages [ '.packages()' won't print

[sc-dev] Re: R Questions

2007-05-31 Thread Leonard Mada
Hi Wojciech, this issue is really tough. Indeed, my first response probably still holds. It is still the most simple solution to use: s - summary(the_nls_object) and retrieve the information from 's'. Yes, I know this is probably a suboptimal solution. In the meantime, I have serious doubts

[sc-dev] Calc/R GUI Crash

2007-05-25 Thread Leonard Mada
Hi Wojciech, Wojciech Gryc wrote: Hi Leonard, Thanks very much for your thoughts. First, if you want to try the GUI package it's all up now on the wiki ( http://wiki.services.openoffice.org/wiki/R_and_Calc). ... 1. I began playing around with the package. While the RDUMP() is working, I had

Re: [sc-dev] Request some assistance

2007-05-18 Thread Leonard Mada
jim wrote: 开源技术部-唐全发 wrote: Hello jim Thank for your suggestion! It's highly possible that the bug is introduced by AutoSpellcheck. The bug will disappear if AutoSpellcheck is disabled. If AutoSpellcheck is enabled, paste can work well if the string is just one word. But paste can

Re: [sc-dev] Request some assistance

2007-05-17 Thread Leonard Mada
welcome any comments on that proposal. Sincerely, Leonard 开源技术部-唐全发 wrote: Hello Leonard Mada Thank for your suggestion! It's highly possible that the bug is introduced by AutoSpellcheck. The bug will disappear if AutoSpellcheck is disabled. If AutoSpellcheck is enabled, paste can work well

Re: [sc-dev] Easy moving of rows and columns in Calc

2007-05-08 Thread Leonard Mada
Hi, Thomas Benisch wrote: Currently in Calc neither rows nor columns can be easily moved manually. It is possible to drag drop e.g. a column into a new position, but the dropped column is not inserted, but overwrites the existing cells. ... 3.) ask user when dropping

  1   2   >