Re: [sc-dev] Adding a page number in the header/footer

2005-04-14 Thread Eike Rathke
Hi Kohei, On Thu, Apr 14, 2005 at 10:54:22 -0400, Kohei Yoshida wrote: For everyone's benefit, let me just post the following Basic code as an example of inserting a page number and a page count into a header/footer of a Calc document. Nice. Could you please add it to the code snippets base?

[sc-dev] Re: [dev] 1.9.100 script library duplication

2005-05-18 Thread Eike Rathke
Hi Jahn,, On Tue, May 17, 2005 at 12:59:15 -0400, Jahn, Ray (R.) wrote: possibly related OO issue 48147 If you actually subscribed to the mailing lists you're posting to you would have noticed that your question was already answered 4 days before you reposted it, also on the [EMAIL PROTECTED]

Re: [sc-dev] Article: OpenDocument office suites lack formula compatibility

2005-09-20 Thread Eike Rathke
Hi M., On Tue, Sep 20, 2005 at 20:36:36 +0200, M. Fioretti wrote: http://software.newsforge.com/article.pl?sid=05/09/09/192250tid=93 Thanks for the pointer. Eike -- OOo/SO Calc core developer. Number formatter bedevilled I18N transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149

Re: [sc-dev] Article: OpenDocument office suites lack formula compatibility

2005-09-22 Thread Eike Rathke
Hi Jody, On Thu, Sep 22, 2005 at 14:04:59 -0400, 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. This is also what I assumed. Which left me even more puzzled why the

Re: [sc-dev] Isssues 19991 and 26836

2005-10-04 Thread Eike Rathke
Hi Kohei, On Tue, Oct 04, 2005 at 09:28:44 -0400, Kohei Yoshida wrote: Thanks. I actually didn't realize that a BSD licensed code is incompatible with ours. It is, because of its advertising clause. Just for a clarification, could I just take the same code which is BSD licensed and

[sc-dev] Spreadsheet functions' issues

2006-01-02 Thread Eike Rathke
Hi, Last year ;) Muthu Subramanian sent me a mail in which he asked whether we're already working on specific issues he picked to work on. I asked him to repeat the question on the mailing list because I want to keep discussion public, but he didn't show up since. Nevertheless I investigated the

Re: [sc-dev] Volunteering to work on OpenOffice.org

2006-08-22 Thread Eike Rathke
Hi Sherrel, On Sat, Aug 19, 2006 at 15:37:21 -0400, Sherrel D. Harris II wrote: This is my first offer to volunteer for a programming project, so I am not sure how to proceed. First: welcome! :) I noticed on of the items in the todo list is CSV import enhancements. What type of

Re: [sc-dev] Calc doesn't open html table

2006-08-30 Thread Eike Rathke
Hi Loiseleur, On Wed, Aug 30, 2006 at 11:07:45 +0200, Loiseleur Michel wrote: In that code, pFilterHtml and pFilterHtmlWeb are the two filters for loading HTML files into Calc (normal HTML and WebQuery). Loading into Writer/Web is done without executing any Calc filter detection code.

Re: [sc-dev] cws_src680_scsolver02 integration help

2006-10-03 Thread Eike Rathke
Hi Kohei, On Sunday, 2006-10-01 11:57:36 -0400, Kohei Yoshida wrote: The error message obviously calls for adding 'cliureversion.mk' somewhere, but I'm not really sure where. Does anyone have a clue? cliureversion.mk gets built in module cli_ure and is delivered to the solver, you should

Re: [sc-dev] Conditional menu item

2006-10-06 Thread Eike Rathke
Hi Kohei, On Thursday, 2006-10-05 21:55:07 -0400, Kohei Yoshida wrote: menu items are controlled by the 'menubar.xml' file located in sc/uiconfig/scalc. The question is, how do I conditionally exclude a menu item from this xml file? I may be wrong on this, but I don't think items can be

Re: [sc-dev] String Operations in Calc and Advanced Utilities

2006-10-31 Thread Eike Rathke
Hi Leonard, On Tuesday, 2006-10-31 19:57:17 +0200, Leonard Mada wrote: It's possible using ISERROR. One day, for compatibility, we'll need an IFERROR-like function, which will also make such cases easier to handle. Easier to handle sounds a little bit cynical. Here are the 2 search

Re: [sc-dev] Statistical Functions Implementation

2006-11-10 Thread Eike Rathke
Hi Leonard, On Friday, 2006-11-10 17:13:00 +0200, Leonard Mada wrote: unsigned int count = 0; // Counter for values // DO WE NEED AN ??? fCount ??? Nah.. there won't be more than 2^32 matrix elements.. OR is (unsigned int) count OK size_t respectively SCSIZE is preferred instead for clear

Re: [sc-dev] Statistical Functions Implementation

2006-11-10 Thread Eike Rathke
Hi Leonard, On Friday, 2006-11-10 18:32:23 +0200, Leonard Mada wrote: 1. I forget a count++; in the first for LOOP [inside the: if (!pMat1-IsString(i,j) !pMat2-IsString(i,j)) {} body] 2. because this count would be from 1 to n, the 2nd for LOOP should be modified accordingly: for(j

Re: [sc-dev] CSV enhancements

2006-11-24 Thread Eike Rathke
Hi Raghavendra, On Friday, 2006-11-24 20:19:26 +1100, Raghavendra Rao wrote: I'd like to help with the CSV import enhancements, what can I do? Thanks for your offer, and welcome! Do you have any specific enhancements in mind? We currently have at least these open issues and requests for

Re: [sc-dev] we find a new bug

2007-03-06 Thread Eike Rathke
Hi, On Tuesday, 2007-03-06 10:37:03 +0100, Niklas Nebel wrote: Please use IssueTracker for bugs (see http://qa.openoffice.org/issue_handling/index.html). Actually for non-members of the QA project a more comprehensible entry page is at

Re: [sc-dev] Importing .dbf, encoding selection - is there a way to reduce the list?

2007-05-21 Thread Eike Rathke
Hi Kirill, On Thursday, 2007-05-17 11:09:38 +0400, Kirill S. Palagin wrote: One of our customers is greatly affected by the problem described in http://www.openoffice.org/issues/show_bug.cgi?id=18728. Is there a way of reducing the list or putting desired entry first in the list (by way

Re: [sc-dev] Whom should I assign i56202 to (for QA)?

2007-05-31 Thread Eike Rathke
Hi Muthu, On Monday, 2007-05-28 21:51:39 +0530, Muthu Subramanian wrote: I fixed i56202 in msba01. [http://www.openoffice.org/issues/show_bug.cgi?id=56202] Beside being on the wrong branch and needs to be resynced to SRC680, as Niklas already mentioned, the CWS lacks the following

Re: [sc-dev] Re: Whom should I assign i56202 to (for QA)?

2007-06-01 Thread Eike Rathke
Hi Muthu, On Friday, 2007-06-01 22:16:43 +0530, Muthu Subramanian wrote: It would take me ages to resync msba01 to src680 (since I have a very slow internet connection). But, since i56202 is a small one - is it really necessary? Yes, for the following reasons: 1. To be sure the change

Re: [sc-dev] SDK Java Examples Windows XP

2007-06-05 Thread Eike Rathke
Hi Wojciech, On Tuesday, 2007-06-05 02:07:15 -0400, Wojciech Gryc wrote: Do I need to compile my add-ins in both Windows *and* Linux? Yes, sure, executables compiled on/for one platform won't run on another. That would only be possible if a package contained only platform independent code,

Re: [sc-dev] Something about Filter function

2007-06-05 Thread Eike Rathke
Hi Kohei, On Tuesday, 2007-06-05 14:46:55 -0400, Kohei Yoshida wrote: With such changes, don't forget the file format. Filter settings are saved, and we have to adhere to the specification about how they are stored. Adding extra bits into the file format itself shouldn't be too hard.

Re: [sc-dev] SDK Java Examples Windows XP

2007-06-06 Thread Eike Rathke
Hi Wojciech, On Tuesday, 2007-06-05 21:25:21 -0400, Wojciech Gryc wrote: But for old add-ins, which are only registered as service implementations, there is no such notification, and you have to restart the application so the list is updated. Ah, makes sense! You're perfectly correct: I

Re: [sc-dev] Request some assistance

2007-06-15 Thread Eike Rathke
Hi Leonard, On Thursday, 2007-06-14 00:04:36 +0300, Leonard Mada wrote: [I think there is some confusion here, see next paragraph.] Basically, you cannot set a default *value* for the cell content. [see later for usefulness] You talk about _content value_ here A. I still feel that NO-one

Re: [sc-dev] Increasing maximum worksheet size

2007-06-21 Thread Eike Rathke
Hi Alan, On Thursday, 2007-06-21 17:42:53 +0200, Alan Yaniger wrote: over a million rows. What is involved in implementing this feature in Calc? I'd like to look into working on this, if it's manageable. Niklas mentioned some obstacles. To hack up a test build see

Re: [sc-dev] Re: Whom should I assign i56202 to (for QA)?

2007-06-28 Thread Eike Rathke
Hi Muthu, On Thursday, 2007-06-28 20:07:47 +0530, Muthu Subramanian wrote: I have committed my changes to msba02 (based on src680-m212). I wonder why you created the CWS based on m212, which is several weeks old now, instead of using a more recent milestone. Already when we talked about using

Re: [sc-dev] About issue 70277#,please review patch file!

2007-06-28 Thread Eike Rathke
Hi tangquanfa, On Thursday, 2007-06-28 16:30:13 +0800, tangquanfa wrote: About issue 70277# has been fixed. I have attached the patch to the issue70277#, please check Please see my answer in the issue's comment. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n

Re: [sc-dev] Re: Whom should I assign i56202 to (for QA)?

2007-06-29 Thread Eike Rathke
Hi Muthu, On Thursday, 2007-06-28 22:35:25 +0200, Eike Rathke wrote: The problem now is that probably the cws won't be QA'ed in time anymore before feature freeze of OOo2.3, which is 5th of July. Especially if it has to be resynced again to a recent milestone. I'm currently evaluating what

Re: [sc-dev] Re: Whom should I assign i56202 to (for QA)?

2007-06-29 Thread Eike Rathke
Hi, On Friday, 2007-06-29 14:32:22 +0200, Eike Rathke wrote: we'll do another build with your changes included if appropriate. Just a status update: it's on its way. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun

Re: [sc-dev] ScRange::Parse return values

2007-07-02 Thread Eike Rathke
Hi Noel, On Monday, 2007-07-02 12:00:12 +0100, Noel Power wrote: Finally go a chance to apply the changes from the cws and glad to say these changes don't seem to affect the tests that I have :-) Would changing the flags set in ScRange::ParseCols() and ScRange::ParseRows() have an effect? It

Re: [sc-dev] ScRange::Parse return values

2007-07-04 Thread Eike Rathke
Hi Noel, On Tuesday, 2007-07-03 09:25:13 +0100, Noel Power wrote: Would changing the flags set in ScRange::ParseCols() and ScRange::ParseRows() have an effect? [...] usage in the ScRange methods is wrong and other flag combinations should be returned upon success to indicate a valid

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

2007-07-05 Thread Eike Rathke
Hi Regina, On Thursday, 2007-07-05 10:34:37 +0200, Regina Henschel wrote: For COVAR it looks like this (based on OOF680_m18): Very nice, indeed. Could you do us a favor though and base your changes on a recent SRC680 milestone (latest available now is m219) instead of OOF680, chances then are

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

2007-07-05 Thread Eike Rathke
Hi Regina, On Thursday, 2007-07-05 13:59:32 +0200, Regina Henschel wrote: I'll work on CORREL, PEARSON, RSQ, STEYX, SLOPE, INTERCEPT and FORECAST (all in interpr3.cxx), Much appreciated! Thanks Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer.

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

2007-07-05 Thread Eike Rathke
Hi Regina, On Thursday, 2007-07-05 13:06:15 +0200, Regina Henschel wrote: recent SRC680 milestone (latest available now is m219) m219 is not on the mirrors and I have used CVS not yet. The m218 tarballs are available on the mirros. I would then have to do another 18 hours build. I own

Re: [sc-dev] Finance Functions

2007-07-06 Thread Eike Rathke
Hi Leonard, On Thursday, 2007-07-05 20:58:02 +0300, Leonard Mada wrote: A spreadsheet with ALL functions defined inside the interpr*.cxx files can be downloaded from: I don't see what that should be good for. Developers working on the code preferably have tools that dynamically create

Re: [sc-dev] External cell reference implementation

2007-07-06 Thread Eike Rathke
Hi Kohei, On Friday, 2007-07-06 11:55:43 -0400, Kohei Yoshida wrote: On Fri, 2007-07-06 at 17:39 +0200, Niklas Nebel wrote: Kohei Yoshida wrote: How about making it invisible? Property IsVisible. But in fact there is a problem: You can't set the sheet's name to what it would be

Re: [sc-dev] Entering certain date in certain cell automatically decrements the date by 1 day - issue 78199

2007-07-12 Thread Eike Rathke
Hi Frank, On Thursday, 2007-07-12 10:03:07 +0200, Frank Stecher wrote: for now I can't. Neither the French version nor the Russian one. WIll try it again. Please also try with different OOo locale settings and Windows regional settings and time zones. Thanks Eike -- OOo/SO Calc core

Re: [sc-dev] Updating Statistical Wiki Page

2007-07-16 Thread Eike Rathke
Hi Leonard, On Monday, 2007-07-16 09:37:40 +0200, Leonard Mada wrote: The reason is, that the page looks already too cluttered and I would like to reorganise slightly the information. In this respect, I consider that it becomes imperative to move some of the content to a new page. I think of

Re: [sc-dev] about issue60590

2007-07-17 Thread Eike Rathke
Hi tangquanfa, On Monday, 2007-07-16 16:46:48 +0800, tangquanfa wrote: I commited a patch about issue60590,please check it! I don't think that was the correct approach. First, what was the reason that the file could not be loaded? Then, by changing the LOTUS_EOF define from 0x01 to 0x08

Re: [sc-dev] why add '_'before 'c'when creating names

2007-07-23 Thread Eike Rathke
Hi os-yunjingtao, On Monday, 2007-07-23 10:59:48 +0800, os-yunjingtao wrote: Does 'c' have any special meaning when we name something or Is 'c' related to any convention in R1C1 As the name R1C1 reference style may suggest, the C stands for column as R stands for row. A reference R1C1

Re: [sc-dev] Dropdown list box

2007-07-31 Thread Eike Rathke
Hi Alan, On Tuesday, 2007-07-31 18:13:51 +0300, Alan Yaniger wrote: Where can I find the code which displays a dropdown list box containing valid values for a cell? source/ui/view/gridwin.cxx ScGridWindow::DoAutoFilterMenue(), data obtained via ScDocument::GetDataEntries(). Note that the

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

2007-08-02 Thread Eike Rathke
Hi yunjingtao, On Thursday, 2007-08-02 10:53:08 +0800, yunjingtao wrote: 2.View-Toolbars-Form Controls 3.Design MOde On/Off-Check Box-Text Box-Push Button-List Box-... 4.You can find that all the icons are on at the same time. I'm not quite sure I understand what you're referring to. Do you

Re: [sc-dev] filled cells cannot be shifted beyond the sheet

2007-08-02 Thread Eike Rathke
Hi yunjingtao, On Thursday, 2007-08-02 11:49:44 +0800, yunjingtao wrote: 2.input letters at the end of any row 3.select any cell except the row that has letters 4.click right button-Insert Cells-Shift cells right-OK 5.it will warn you that filled cells cannot be shifted beyond the sheet. Of

Re: [sc-dev] Rubber/Pencil function for Calc

2007-08-02 Thread Eike Rathke
Hi Max, On Tuesday, 2007-07-31 21:55:18 +0200, Max Giesbert wrote: The constructor gets a XComponentContext passed over. Now how do I get the XComponent of the actually opened spreadsheet from it? XComponentContext is not related to the current application or documents. It provides

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

2007-08-03 Thread Eike Rathke
Hi yunjingtao, On Friday, 2007-08-03 11:10:55 +0800, yunjingtao wrote: In other words,make sure design mode is on,only click icons and do not execute their actions,click check box,text box,push button,formatted field,option button,list box... 4.You can find that all the icons are on at

Re: [sc-dev] Update: R and Calc

2007-08-03 Thread Eike Rathke
Hi Wojciech, On Thursday, 2007-08-02 22:48:32 -0400, Wojciech Gryc wrote: I'm very happy with this version because it features a new (and probably final major user interface addition) coding window... Now you can write R code and get various properties inserted directly into the spreadsheet.

Re: [sc-dev] XActivationBroadcaster - crash after switching from printPreview back to sheet ...

2007-08-07 Thread Eike Rathke
Hi Oliver, On Sunday, 2007-08-05 13:42:07 +0200, Oliver Brinzing wrote: everything works fine, but if i change to the print preview *and* back to the sheet, oo crashes ... any hints ? No, but crashing surely is a bug. Please file an issue. Thanks Eike -- OOo/SO Calc core developer.

Re: [sc-dev] Saving Filter Options (i#35579)

2007-08-07 Thread Eike Rathke
Hi Jonathan, On Monday, 2007-08-06 16:45:13 -0400, Jonathan Pryor wrote: Unfortunately, the obvious way of doing this mapping would be to add constants to the FilterOperator enum in offapi/com/sun/star/sheet/FilterOperator.idl, and changing this file breaks my build because it breaks the ABI

Re: [sc-dev] A compatible problem

2007-08-08 Thread Eike Rathke
Hi gaozm, On Wednesday, 2007-08-08 16:11:52 +0800, gaozm wrote: Here is a compatible problem between Calc and Excel, it can be described as follows: Open a Excel document who contains only one whole page(47 rows and 9 columns) with Calc, it will show two pages. I hope it shows only one

Re: [sc-dev] Duplicate Data

2007-08-08 Thread Eike Rathke
Hi Leonard, On Friday, 2007-08-03 18:38:02 +0300, Leonard Mada wrote: I have partially rewritten the wiki in the hope to clarify this issue (see http://wiki.services.openoffice.org/wiki/Calc/To-Dos/Usability#Duplicate_Data). Yes, that in combination with i66817 clarifies. What we need is

Re: [sc-dev] Enhanced formula input

2007-08-08 Thread Eike Rathke
Hi Muthu, On Tuesday, 2007-08-07 20:44:10 +0530, Muthu Subramanian wrote: To continue the discussions, I have attached the Comments from issue 20496 Are my comments/ideas acceptable or do they need changes? We'll see. To add to those comments: 1. We can keep the import/export the same

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

2007-08-08 Thread Eike Rathke
Hi Frank, The spec http://specs.openoffice.org/calc/ease-of-use/Enhanced_Formula_Input.odt for issue http://qa.openoffice.org/issues/show_bug.cgi?id=20496 states: ++ Number Formula: =++Number Why should a leading ++ trigger conversion to formula? -- Number Formula: =--Number Again, why

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

2007-08-09 Thread Eike Rathke
Hi Leonard, On Thursday, 2007-08-09 20:51:26 +0300, Leonard Mada wrote: Excel converts +number+number to =number+number and ++number to =+number, but converts +name to =+name Note that Excel does not convert single numbers like +1 or -1 but does convert ++1 to =+1, --1 to =--1, +-1 to =+-1

Re: [sc-dev] Re: Inserting Images?

2007-08-17 Thread Eike Rathke
Hi Wojciech, On Wednesday, 2007-08-15 23:15:33 -0400, Wojciech Gryc wrote: After playing around some more, I figured out the problem (dealt with getting the services correctly). Just to let everyone know, I added information on how to embed images in a Spreadsheet (rather than link to them)

Re: [sc-dev] I have a question

2007-08-17 Thread Eike Rathke
Hi gaozm, On Wednesday, 2007-08-15 14:08:12 +0800, gaozm wrote: 2. Input characters into any column,for example between a1 and a21 input figures from 1 to 21 3.Select the whole column a1,data-filter-standard filter,condition-smallest %; value-10; ok Result: It will show 3 rows.

Re: [sc-dev] Re: Exciting News

2007-08-17 Thread Eike Rathke
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 these double-braces. Embed such

Re: [sc-dev] Our plan to improve Calc functionality related tophonetic text

2007-08-17 Thread Eike Rathke
Hi Kohei, On Friday, 2007-08-17 10:00:45 -0400, Kohei Yoshida wrote: 3) Store that as a cell attribute. If I understand correctly, Writer uses this approach. That sounds easiest from a first glance, but it dissects content into attribution, which sooner or later will complicate

Re: [sc-dev] Our plan to improve Calc functionality related tophonetic text

2007-08-17 Thread Eike Rathke
Hi Takashi, On Saturday, 2007-08-18 01:05:18 +0900, Takashi Nakamoto wrote: 1) Store that in rtl::OUString. At the beginning of our project, this idea was the first choise, but now we think this implmentation might be very difficult and seek for better ideas. I'd consider implementing

Re: [sc-dev] Our plan to improve Calc functionality related tophonetic text

2007-08-21 Thread Eike Rathke
Hi Takashi, On Tuesday, 2007-08-21 13:45:53 +0900, Takashi Nakamoto wrote: 3) Store that as a cell attribute. If I understand correctly, Writer uses this approach. That sounds easiest from a first glance, but it dissects content into attribution, which sooner or later will

Re: [sc-dev] Our plan to improve Calc functionality related tophonetic text

2007-08-21 Thread Eike Rathke
Hi Kohei, On Tuesday, 2007-08-21 08:35:41 -0400, Kohei Yoshida wrote: IIRC, if the text cell doesn't contain any phonetic text, it will back-translate it into ruby using the IME if the main text contains any Kanji characters, then return that ruby text to replace the Kanji characters in the

Re: [sc-dev] Our plan to improve Calc functionality related tophonetic text

2007-08-21 Thread Eike Rathke
Hi Kohei, On Tuesday, 2007-08-21 08:12:13 -0400, Kohei Yoshida wrote: What I meant to say was that Excel embeds the ruby text directly into string data in the shared string table, instead of storing it as a cell attribute. As part of the string? How is it distinguished? Eike -- OOo/SO

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

2007-08-23 Thread Eike Rathke
Hi Leonard, On Wednesday, 2007-08-22 21:20:49 +0300, Leonard Mada wrote: - The dialog txt files aren't found without strange CLASSPATH settings. - On Windows, R doesn't seem to like the backslashes in the path to the jpeg file. Replacing them with forward slashes seems to work, I didn't

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

2007-08-29 Thread Eike Rathke
Hi Leonard, On Tuesday, 2007-08-28 21:42:06 +0300, Leonard Mada wrote: 8.) CalcStaR = Calc statistics with R I like that one. Quite in the spirit of StarCalc. The current RCalc is fine too, but overlaps with others, e.g. rCalc http://rcalc.sourceforge.net/ a scientific calculator for the

[sc-dev] Back from vacation

2007-10-10 Thread Eike Rathke
Hi, I'm back from vacation. In case you sent mail to the lists or to my personal account(s, if sent to [EMAIL PROTECTED] or [EMAIL PROTECTED] you should had received a vacation notification, if sent to [EMAIL PROTECTED] you did not, see .signature below) or comments on issues that need my

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

2007-10-15 Thread Eike Rathke
Hi Leonard, On Friday, 2007-10-12 00:06:19 +0200, Leonard Mada wrote: There were some interesting suggestions. The most tempting one is in my opinion: R4Calc. Looks good. http://ux.openoffice.org/servlets/ReadMsg?list=discussmsgNo=807 proposes much longer names; I am not sure that these

Re: [sc-dev] Values depending on linked and not available spreadsheet - xls-viewer OOO

2007-10-18 Thread Eike Rathke
Hi Cor, On Thursday, 2007-10-18 11:38:21 +0200, Cor Nouws wrote: Frank Stecher wrote (18-10-2007 10:03) The problem is the unsorted search vector used with the VLOOKUP functions in column H. Excel requires a sorted search vector for the vlookup as used in the column as well as Calc do.

Re: [sc-dev] ScRange::Parse return values

2007-10-23 Thread Eike Rathke
Hi Noel, On Tuesday, 2007-10-23 11:00:01 +0100, Noel Power wrote: Well, I also looked in the archives ( because I only had the last 2 messages in my mbox ) and I noticed Niklas's comment about using ScRange::ParseAny in ScRangeList::Parse - this *seems* to do exactly the right thing ( of

Re: [sc-dev] ScRange::Parse return values

2007-10-23 Thread Eike Rathke
Hi Noel, On Tuesday, 2007-10-23 12:32:25 +0100, Noel Power wrote: yes you are right, I am just passing SCA_VALID as the nMask so I didn't see this. Given if we change this there is a possibility that someone somewhere depends on the full set of range flags being set do you mean either

Re: [sc-dev] patch for i71814

2007-11-13 Thread Eike Rathke
Hi YunJingtao, On Tuesday, 2007-11-13 16:33:44 +0800, YunJingtao wrote: A patch for i71814 was submitted.Check it! I don't know whether it's satisfied, if not, please give some advice. It would be nice if you not just attached some patch to the issue but also explained what your

Re: [sc-dev] Page margins in print preview

2007-11-14 Thread Eike Rathke
Hi maoyg, On Wednesday, 2007-11-14 12:59:20 +0800, maoyg wrote: I have sent the mail to [EMAIL PROTECTED] and I also created the wiki page: http://wiki.services.openoffice.org/wiki/Page_margins. What purpose is the wiki page meant for? Eike -- OOo/SO Calc core developer. Number

Re: [sc-dev] Page margins in print preview

2007-11-15 Thread Eike Rathke
Hi maoyg, On Thursday, 2007-11-15 10:20:13 +0800, maoyg wrote: I created the wiki page because I want to put Page_Margins_Specification on it. Ah, I see, you uploaded the specification document to the wiki as well. Ok, as this is about drafting a Calc feature I just moved the page to

Re: [sc-dev] patch for i71814

2007-11-20 Thread Eike Rathke
Hi YunJingtao, On Thursday, 2007-11-15 17:13:34 +0800, YunJingtao wrote: aLogicEdit is to show the area of hyperlink with mouse,when the text is beyond the cell border, border of aLogicEdit has to be coordinated with cell. the coordinates of text and mouse are different, and it leads to

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

2007-12-06 Thread Eike Rathke
Hi gaozm, On Thursday, 2007-12-06 17:11:46 +0800, gaozm wrote: You have added 3 issues to the wiki, but some of them are the same as our featrue, for example: Empty and Non-Empty conditions in AutoFilter and so on. That's why I added the issues, because they touch the same topic.

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

2007-12-06 Thread Eike Rathke
Hi Cor, On Tuesday, 2007-12-04 21:49:26 +0100, Cor Nouws wrote: I can't find any spaces in the HTML. Not even in the raw HTML source? Note that there are several kinds of blanks, even non-spacing blanks that you won't see in a browser display but may get transformed into usual blanks when

Re: [sc-dev] Patch for i38759

2007-12-10 Thread Eike Rathke
Hi Lvyue, On Monday, 2007-12-10 15:31:26 +0800, Lvyue wrote: I have submitted a patch for issue 38759. Please see my answer in the issue's comments. If you need some help or there's anything to clarify please write to the mailing list. Btw, when starting a new topic please don't reply to a

Re: [sc-dev] Date input

2007-12-10 Thread Eike Rathke
Hi Kohei, On Friday, 2007-12-07 10:09:50 -0500, Kohei Yoshida wrote: The rough idea I've just come up with is to do what web applications do: provide a date input box. This way Calc also knows that the user is about to enter a date, and try not to even parse an input as a date if the date

Re: [sc-dev] Date input

2007-12-10 Thread Eike Rathke
Hi Leonard, On Monday, 2007-12-10 00:19:55 +0200, Leonard Mada wrote: Aloow the user to specify, what should be interpreted as a date (and how). E.g., IF the user specifies that dates are only strings of the form: dd.mm.yy or dd.mm., then only such strings would be converted to dates

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

2007-12-10 Thread Eike Rathke
Hi gaozm, On Friday, 2007-12-07 17:06:36 +0800, gaozm wrote: I'm glad to hear that, so we should continue discussing the spec. with UX, right? Yes. But now, we have not get any feedback about this featrue from UX. I want to know how can we get their replies, and now what should we do

Re: [sc-dev] A question of i38759

2007-12-11 Thread Eike Rathke
Hi Lvyue, On Tuesday, 2007-12-11 10:35:18 +0800, Lvyue wrote: I want to ask if there is no numeric value, but string value in a cell, range or matrix, should MIN/MAX return 0? Yes. Only if there are no other numeric values that would result in a different min/max, of course. Short

Re: [sc-dev] Patch for i38759

2007-12-18 Thread Eike Rathke
Hi Lvyue, On Tuesday, 2007-12-18 15:20:21 +0800, Lvyue wrote: I have submitted the third patch, please check it. Better, but not to the point. Maybe there's still some misunderstanding about what the outcome should be. With the patch the function currently treats bEmptyCells=true if already

Re: [sc-dev] Date input

2007-12-18 Thread Eike Rathke
Hi Cor, On Tuesday, 2007-12-11 09:05:10 +0100, Cor Nouws wrote: How about problems when entering by key board? If those are rare, maybe an option to turn of auto-date by importing/pasting is enough? There are enough complaints that when entering 1.2 in a locale where the dot is not the

Re: [sc-dev] Re: Invalid characters in sheet names - Issue 6087

2008-01-07 Thread Eike Rathke
Hi Muthu, after xmas vacation.. On Monday, 2007-12-24 14:40:49 +0530, Muthu Subramanian wrote: I was contemplating on looking at this issue. I saw that the issue was assigned to requirements - is it ok if I look at it? Sure. (I mean, since the requirements might not be clear as yet).

Re: [sc-dev] One question about i35579

2008-01-21 Thread Eike Rathke
Hi Thomas, On Friday, 2008-01-18 10:48:51 +0100, Thomas Benisch wrote: Just to clarify. This part of the patch if fine, but the code for exporting/importing the new filter conditions is not finished yet. For completeness: the new attribute values have been approved, I just added that to the

Re: [sc-dev] A patch for issue71158

2008-01-21 Thread Eike Rathke
Hi Lvyue, On Monday, 2008-01-21 10:20:57 +0800, Lvyue wrote: I submitted a patch for issue71158 on last Friday. Sorry, I forget to tell you. No need to be sorry, and no need to explicityl notify me (of course you can if you wish), as submitter/owner/CC of an issue get an automatic

Re: [sc-dev] RATE function; issue 15090

2008-01-31 Thread Eike Rathke
Hi Regina, On Thursday, 2008-01-31 12:57:35 +0100, Regina Henschel wrote: I'm working on issue 15090 Yes, I received a mail from IZ on your comment saying so, thank you! (1) The error result for Nper=0 is not implemented yet. I have seen SetError(errIllegalArgument), SetIllegalArgument(),

Re: [sc-dev] RATE function; issue 15090

2008-02-04 Thread Eike Rathke
Hi Regina, On Sunday, 2008-02-03 01:27:55 +0100, Regina Henschel wrote: a remark on the ODFF-spec: The parameter 'PaymentType' has got type 'number'. In the description only the values 0 and 1 are mentioned. But there is no constraint to {0;1}. The description doesn't say what to do with

Re: [sc-dev] CWS odff resynced to m244

2008-02-11 Thread Eike Rathke
Hi Kohei, On Monday, 2008-02-11 10:37:05 -0500, Kohei Yoshida wrote: I just had a minor build issue on Linux with gcc 4.1.2. The attached patch fixed it. Thanks, I applied that to the CWS. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign

Re: [sc-dev] RATE function; issue 15090

2008-02-11 Thread Eike Rathke
Hi, On Monday, 2008-02-11 12:56:00 +0100, Eike Rathke wrote: the filters aren't essential anyway. This if course was not meant to misclassify Daniel's great work! The filters are just not needed for the area Regina works on. Sorry if that could had been mistakable.. Eike -- OOo/SO Calc

Re: [sc-dev] GCD/LCM in other spreadsheet

2008-02-21 Thread Eike Rathke
Hi Lvyue, On Wednesday, 2008-02-20 14:19:13 +0800, Lvyue wrote: In Excel: Negative will cause error, no matter how small it is. I have tried -1.00E-307, GCD still return err. And in Gnumeric: The handle of negative is the same to Excel. Shall we be consistent with them, or keep our

[sc-dev] Functions with bTextAsZero (was: [sc-dev] GCD/LCM in other spreadsheet)

2008-02-22 Thread Eike Rathke
Hi Lvyue, On Friday, 2008-02-22 15:37:42 +0800, Lvyue wrote: About i86171, I find 7 functions using bTextAsZero. They are MIN, MAX, AVERAGE, VAR, VARP, STDEV and STDEVP. They all have the same result as MINA(range)=MIN(range), and it's not right. As expected.. I made some change, and

Re: [sc-dev] About i86643(Make COUNT ignore error results)

2008-03-05 Thread Eike Rathke
Hi Yue, On Wednesday, 2008-03-05 11:00:37 +0800, Lvyue wrote: I have made a little change on issue86643. now COUNT() can ignore errors, and give correct count of numbers. See also the comment I added to the issue. but I found it ignores all errors. for example, if the cell A1 has a formula

Re: [sc-dev] precision of GAMMALN

2008-03-11 Thread Eike Rathke
Hi Regina, On Monday, 2008-03-10 18:15:29 +0100, Regina Henschel wrote: significant digits. I looked around for some better coefficient and found them in Apache Library Are we allowed to use this values? You mean to use only the coefficient values? I have no idea whether coefficient values

Re: [sc-dev] OFFSET in array formulae

2008-03-18 Thread Eike Rathke
Hi David, On Monday, 2008-03-17 21:23:07 +, David King wrote: On the other hand ;) in Calc {=ISLOGICAL({TRUE;cat;dog})} returns {FALSE;TRUE;TRUE} Can I raise that one as an issue? Can't be right, can it? That indeed is a bug, please file an issue. Thanks Eike -- OOo/SO Calc

Re: [sc-dev] Preparation of localizable separators in CWS koheiformula01

2008-03-18 Thread Eike Rathke
Hi Kohei, On Monday, 2008-03-17 21:23:11 -0400, Kohei Yoshida wrote: [... separators at ScAddress::Convention ...] Well, that code was implemented before ScGrammar arrived in DEV300_m2. So, I couldn't have used ScGrammar at the time I implemented. Understood. Of course now that we have

Re: [sc-dev] Preparation of localizable separators in CWS koheiformula01

2008-03-18 Thread Eike Rathke
Hi Kohei, On Tuesday, 2008-03-18 14:13:43 -0400, Kohei Yoshida wrote: I'd like to make sure one thing before I go with this. It seems to me that, if we tie the separators to ScCompiler::mxSymbolsNative, then it will not be possible to switch between the Excel style separators and the

Re: [sc-dev] About i78781(Excel INDEX() compatibility)

2008-03-18 Thread Eike Rathke
Hi Yue, On Tuesday, 2008-03-18 15:07:56 +0800, Lvyue wrote: I began to work on issue78781 yesterday. Fine, thanks. Compared with Excel, I found there are two things I should modify. 1. while input: =INDEX($D$27:$P$27;2) the result should be value of E27. Correct. For a row vector the

Re: [sc-dev] label and array formula

2008-03-19 Thread Eike Rathke
Hi Mathias, On Tuesday, 2008-03-18 13:28:25 +0100, Mathias Röllig wrote: Should using labels work also in a array formula? Today it doesn't. Indeed, that's an error. In array context using a label should not generate a position dependent reference. Probably correct would be to generate an

Re: [sc-dev] Preparation of localizable separators in CWSkoheiformula01

2008-03-19 Thread Eike Rathke
Hi Kohei, On Tuesday, 2008-03-18 18:19:01 -0400, Kohei Yoshida wrote: I said what I said because the code looked like once the symbol maps are initialized at start-up they don't get modified during run-time. Up to now they weren't, it wasn't necessary. But I guess I could change it to make

Re: [sc-dev] Preparation of localizable separators in CWSkoheiformula01

2008-03-19 Thread Eike Rathke
Hi Kohei, On Wednesday, 2008-03-19 01:03:02 -0400, Kohei Yoshida wrote: Just finished. Now I don't use ScAddress::Convention all over the place but simply put the localized separators in the mxSymbolsNative and mxSymbolsEnglish. I'm not sure if we really want that in mxSymbolsEnglish.

Re: [sc-dev] Preparation of localizable separators inCWSkoheiformula01

2008-03-20 Thread Eike Rathke
Hi Kohei, On Wednesday, 2008-03-19 09:27:11 -0400, Kohei Yoshida wrote: Well, if it's not used in the UI, I guess we can leave the English symbols alone. I'll change the implementation. Btw, please don't use direct bit operations on the grammar value: if ((eGrammar

Re: [sc-dev] About a question!

2008-03-20 Thread Eike Rathke
Hi maoyg, On Thursday, 2008-03-20 17:16:25 +0800, maoyg wrote: In suggestion 8,they want to add a down arrow(↓). Whatever encoding you used to insert that character, your mailer didn't declare it, so I just see a sequence of garbled characters. Assuming that's utf-8 it indeed would be a

Re: [sc-dev] How to run OO.o calc (from 2.4.0, windows) without installing it ?

2008-03-27 Thread Eike Rathke
Hi JoJo, On Thursday, 2008-03-27 13:40:19 +0530, JoJo jojo wrote: How to run OO.o calc (from 2.4.0, windows) without installing it ? You can't. sort of like http://portableapps.com/apps/office/openoffice_portable only *.exe installers are available for download. The installer is to be

  1   2   3   >