Re: [sc-dev] Adding a page number in the header/footer
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? See http://api.openoffice.org/SDK/snippets/ Thanks Eike -- OOo/SO Calc core developer. Number formatter bedevilled I18N transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-dev] Re: [dev] 1.9.100 script library duplication
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] list. In the mean time issue 49239 was created for the problem you described, and already fixed. Furthermore, as you're not subscribed your mail might only show up after a delay, because the moderator has to manually forward it. mail lists: dev, [EMAIL PROTECTED], [EMAIL PROTECTED] It is almost never a good idea to crosspost to several lists, as most times it ends up in broken threads because answers only go to one list. Sorry that I cannot offer an example attachment. My mail firewall seems to delete any mail (both inbound and outbound) with attachments of unknown formats. I don't think so, your previous mail Message-Id: [EMAIL PROTECTED] had a junk.zip attached. Just that on most OOo mailing lists attachments are stripped if they exceed a certain size. Eike -- OOo/SO Calc core developer. Number formatter bedevilled I18N transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Article: OpenDocument office suites lack formula compatibility
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 0DB3 9E96 2F1A D073 293C 05FD - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Article: OpenDocument office suites lack formula compatibility
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 draft mentions UI at all. It looks like it is trying to overspecify things in several ways and nobody would be getting anywhere with it. Frankly said, I'm mainly interested in it because I fear that there's developing some standard away from real life and people might jump on the wagon just because they think standards are good, no matter what. If that is the case then there is already a standard, MS Excel. Given the complexity and prevalence of it's evaluation engine it seems wasteful for us to produce a standard that does anything that is not a superset of Excel's conventions. Well, yes. Some may not like it, but this faces reality. The most useful thing we could do for interoperability is to define a table of differences, which function uses what parameters and whether they're optional in different applications and thus in their ODF namespace. This could be used during reading a file. Specifying all the intricacies (first time I encountered that word, btw ;) would drive us nuts in the end. Just my personal 2cts. Eike -- OOo/SO Calc core developer. Number formatter bedevilled I18N transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Isssues 19991 and 26836
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 submit it under JCA (if that's allowed)? Or would the code need to be written from scratch in a clean-room? Only if you're the copyright owner of code you can decide to relicense it under a different license. Eike -- OOo/SO Calc core developer. Number formatter bedevilled I18N transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-dev] Spreadsheet functions' issues
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 issues he listed and following is the status, or was on December 15th. On Fri, Dec 02, 2005 at 23:33:40 +0530, Muthu Subramanian wrote: Are you working on any of these: let's see.. Function Incompatibility http://www.openoffice.org/issues/show_bug.cgi?id=3866 : NETWORKDAYS http://www.openoffice.org/issues/show_bug.cgi?id=32269 : SERIESSUM Daniel, your AddIn area: are you planning to work on it? http://www.openoffice.org/issues/show_bug.cgi?id=54529 : MOD already fixed for 2.0.2 http://www.openoffice.org/issues/show_bug.cgi?id=25808 : COUNTIF was a pending RFE, but in fact is a dupe of 53946, closed it - will require support for Excel style (Sheet!foo) addresses http://www.openoffice.org/issues/show_bug.cgi?id=30172 : INDIRECT Jody also works on this in CWS calcr1c1 http://www.openoffice.org/issues/show_bug.cgi?id=3851 : DATE wasn't specific to DATE, but strings as values related, already closed as dupe of http://www.openoffice.org/issues/show_bug.cgi?id=5658 RFE pending, will be addressed with a new feature. http://www.openoffice.org/issues/show_bug.cgi?id=4695 : INDIRECT already scheduled, will be done by either me, or Jody if he likes to ;) http://www.openoffice.org/issues/show_bug.cgi?id=16435 : VLOOKUP I changed its summary, it isn't related to VLOOKUP, but automatic row/column names instead. This is quite a hairy thing, especially if not familiar with, are you sure you would like to work on it? This leaves us with the following: I am planning to work on the ones you are not working on.. http://www.openoffice.org/issues/show_bug.cgi?id=35718 : SUBTOTAL RFE pending, implementation can be done after having a specification, for QA and documentation. http://www.openoffice.org/issues/show_bug.cgi?id=8946 : FREQUENCY http://www.openoffice.org/issues/show_bug.cgi?id=8947 : MATCH 8946 first, test case of 8947 depends on it http://www.openoffice.org/issues/show_bug.cgi?id=33295 : MATCH http://www.openoffice.org/issues/show_bug.cgi?id=27597 : XIRR http://www.openoffice.org/issues/show_bug.cgi?id=50331 : COUNTBLANK http://www.openoffice.org/issues/show_bug.cgi?id=53642 : RAND http://www.openoffice.org/issues/show_bug.cgi?id=53946 : SUMIF http://www.openoffice.org/issues/show_bug.cgi?id=35483 : VALUE http://www.openoffice.org/issues/show_bug.cgi?id=15090 : RATE not scheduled yet, you may pick some Eike -- PGP/OpenPGP/GnuPG encrypted mail preferred in all private communication. Key ID: 0x293C05FD - 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Volunteering to work on OpenOffice.org
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 improvements need to be made in this area? I could not find out more on the website. I'm not sure which ToDo list's CSV import enhancements you're talking of, there's nothing CSV specific on http://sc.openoffice.org/ and if it was on the feature and enhancement queue mentioned there, giving an issue number would had been helpful. Anyway, since I already assembled this list recently, I'm posting again: We currently have at least these open issues and requests for enhancement in queue: http://qa.openoffice.org/issues/show_bug.cgi?id=15509 http://qa.openoffice.org/issues/show_bug.cgi?id=60110 http://qa.openoffice.org/issues/show_bug.cgi?id=67432 http://qa.openoffice.org/issues/show_bug.cgi?id=37668 http://qa.openoffice.org/issues/show_bug.cgi?id=19369 http://qa.openoffice.org/issues/show_bug.cgi?id=24076 http://qa.openoffice.org/issues/show_bug.cgi?id=14675 Note that quite a few of these are not just coding issues, but need specification and maybe UI design first, and some may depend on other work not only related to CSV. Also, if there is anything you need to know about me, just let me know. Of course we would be interested in your areas of expertise, level of experience in C++ coding and such. Not as in a hiring interview but just a rough overview :) If you plan to submit code please file your Joint Copyright Assignment (JCA), see http://contributing.openoffice.org/programming.html#jca Eike P.S.: As you're not subscribed to the mailing list you were posting to, you will miss replies that are directed to the list only. When answering, please reply only to the list (Reply-To header is set), not to my personal account. Thanks. -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Calc doesn't open html table
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. Damn ! I have to hack into swdetector.cxx ? Sorry, when recommending to hack in a check for a leading 'table' as a special case in our filter detection if no filter was preselected, I didn't think of that it isn't even called in this case because the type detection is configured to load html in Writer. So yes, Writer detection and, as Niklas mentioned, maybe even filter confguration would have to be touched, and these are full of quirks.. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] cws_src680_scsolver02 integration help
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 have it in solver/680/${INPATH}/bin/cliureversion.mk Also, right now, the scsolver and lpsolve modules are enabled globally (i.e. they get built notmatter what). I had tried to find a way to make these two modules a build time option, but I couldn't find out how to make it optional at module level. If someone knows how to do it, please share it with me. This should be possible using a configure --disable-... option or similar, the build dependencies then would get a prefix that tells the dependency generator to ignore those modules, for example see the BINFILTER:binfilter entry in postprocess/prj/build.lst, which is connected to the --disable-binfilter configure option. Be sure to add the prefix to the scsolver module in every build.lst where it is mentioned. However, I'm by no means an autoconf expert, so don't ask me how to exactly specify this other than copying already existing entries in config_office/{configure,configure.in,set_soenv.in} Eike -- PGP/OpenPGP/GnuPG encrypted mail preferred in all private communication. Key ID: 0x293C05FD - 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD signature.asc Description: Digital signature
Re: [sc-dev] Conditional menu item
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 conditionally excluded during build time. You could dynamically enable/disable the menu entry depending on whether your component is installed and provides it's service. However, I think this would need the dispatch mechanisms and deeper integration with the Calc code. Maybe someone on the [EMAIL PROTECTED] list has an answer to this special problem, IMHO it's the first time a component is conditionally built but likes to have integration with an application menu-wise. A solution could be to use the general UNO package integration mechanisms provided for components instead, and add the menu entry in pre-registration during the install set creation by means of Addons.xcu, which again would place the menu entry into the AddOn submenu, which may not be desired. Though I'm not sure how that pre-registration works exactly.. you may want to ask on the [EMAIL PROTECTED] list. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun, use the [EMAIL PROTECTED] account instead. Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] String Operations in Calc and Advanced Utilities
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 possibilities: *method 1* // DOES NOT WORK IN CALC OR EXEL FIND(string 1, A1) OR FIND(string 2, A1) *method 2* using ISERR(): take a small break, a cup of coffee and enjoy: [this actually works in Exel] - we will need 7 additional columns (B-H) in addition to the data column (A) - B: =FIND(string 1, A1) - C: =FIND(string 2, A1) - D: = ... here will be our final result - E: =ISERR(B1) - F: =ISERR(C1) - G: =IF(E1=FALSE,B1,0) - H: =IF(F1=FALSE,C1,0) - and now lets return to column D, where the final result will be stored: - D: = OR(G1, H1) I'd shorten that to B: =IF( ISERROR( FIND( string 1; A1)); FIND( string 2; A1); FIND( string 1; A1)) Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Statistical Functions Implementation
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 semantics. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Statistical Functions Implementation
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 = 0; j count; j++) { // NOT j = count Noticed. 3. the x and y values (fValX[count] and fValY[count]) must be stored, so we have to define (variable) arrays. I do not know which method is best suited/ will affect speed less. I usually prefer vectors when dealing with such a situation, but might be too much for this one, especially if we do NOT do any sorting. Size is unfortunately not known beforehand. A maximum size is known: there can't be more than nC1*nR1 elements, so pre-allocating new double[nC1*nR1] is fine. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] CSV enhancements
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 enhancement in queue: http://qa.openoffice.org/issues/show_bug.cgi?id=60110 http://qa.openoffice.org/issues/show_bug.cgi?id=67432 http://qa.openoffice.org/issues/show_bug.cgi?id=37668 http://qa.openoffice.org/issues/show_bug.cgi?id=19369 http://qa.openoffice.org/issues/show_bug.cgi?id=24076 http://qa.openoffice.org/issues/show_bug.cgi?id=14675 Note that some are not just coding issues, but need specification and maybe UI design first, and some may depend on other work not only related to CSV. Eike P.S.: As you're not subscribed to the mailing list you were posting to, you will miss replies that are directed to the list only. When answering, please reply only to the list (Reply-To header is set), not to my personal account. Thanks. -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] we find a new bug
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 http://qa.openoffice.org/issue_handling/project_issues.html Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Importing .dbf, encoding selection - is there a way to reduce the list?
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 of hacking config files or somehow)? Not to my knowledge. Calc just uses the encoding list offered by the database project, I doubt that is configurable other than hacking source code. You might want to ask on the [EMAIL PROTECTED] or [EMAIL PROTECTED] mailing lists. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Whom should I assign i56202 to (for QA)?
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 information, that is to be filled in the EIS application: - Owner, (!) probably because that is not set the CWS also doesn't show up in the list of CWSs that SeekQA. - Description, what the CWS is about. - Release, you should set that to OOo2.3 if that's the target). - Estimated due date ready for QA (when the CWS approximately will be ready for QA. This is to give QA an idea when the CWS will be ready. - Estimated due date, when the CWS should be ready for integration. Note that the time span between ready-for-QA date and the final due date needs to be communicated with the QA-rep. This is to give release engineering an idea when a CWS will show up for integration. - Level of impact, in this case One Application. After having resynced to the latests SRC680 milestone you'll have to build install sets QA can use. Talk with the QA-rep (see below) what he'll accept. As a new feature/enhancement is implemented, you'll have to send a feature announcement, in EIS that's under Changes-Mails - external feature. - Product: Spreadsheet - Type: new - Title: make up a good one, self-speaking - Effective from version: CWS msba01 - Module(s) affected: sc - Flags: select Configuration, Help/Guide, Translation, UI relevant - TaskId: i56202 - Description: describe the feature such that QA can test the feature, documentation authors are able to digest the necessary information for the online help system, and the description can also be taken for the automated what's new guide. - Specification URL: - (a literal minus/hyphen character, as the feature doesn't have an external specification document) Whom should I 'assign to', in EIS, for QA? For Calc QA, you may ask Frank Stecher [EMAIL PROTECTED] or Oliver Craemer [EMAIL PROTECTED] if they can do QA or know someone who would. Next time, how do I find out whom to assign it to (when I fix some other issue)? Get in contact with the project's dev-list, or ask on [EMAIL PROTECTED] As mentioned above, if proper information is filled in EIS, the CWS is also listed under SeekQA and someone might jump on it. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] SDK Java Examples Windows XP
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, e.g. if written in Java. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Something about Filter function
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. It's not a question of being hard or not. It's a question of time. If the change isn't proposed to the OASIS TC very soon within the next 2-3 weeks it may not make it into the next ODF version scheduled for fall this year. As OOo can't implement file format changes before they are standardized this would mean that implementation would have to wait for the next ODF version then. There currently is no schedule, but most certainly the then next ODF version will not come before the end of next year. OTOH, I'm not sure about adhering to the specification part. I just checked the ODF specification v1.1 section 8.7.4 entitled Filter Condition, but it doesn't specify how such multi-string values should be stored. You have to extend ODF, just storing a new setting enumeration probably isn't enough, you also want to somehow store the multi-strings. I hope we will not have to extend the ODF itself to get this enhancement in. Given how many years (2 years so far) I've been waiting for the very old natural sort patch[1] to make it in, Actually that's only 1 year for the file format now, since May 2006. I'm not very enthusiastic about bringing a change request to the ODF spec. Well, that's the the draw-back of using a fully standardized file format.. Btw, I suggest you become a member of the OASIS ODF TC, to have more Calc eyes and hands on it ;-) Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] SDK Java Examples Windows XP
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 restarted the computer and the functions are now there. Sounds like the perfectly intuitive Windows way to restart an application ;-) SCNR Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Request some assistance
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 needs exactly 65536 rows x 256 columns. No, but a fast way to select the entire sheet, whatever size it has, and apply some attribute or style. BUT then, Calc could change only the default settings for the master cell (or the 256 cells). NO need to copy the value _value_ here to every single cell, and 65536 x 256 becomes *irrelevant*. Calc could *fast scan* all cells, to see IF any attributes and from here on about _attributes_ are explicitly set (IF that would circumvent the master attribute), and reset them. This would be much faster and surely more efficient (and elegant) then setting explicitly every attribute. This doesn't mix. I repeat again: Calc doesn't store attributes per cell, but in ranges per column, so if you have all cells of a column identically formatted there is one single attribution entry stored for this column. If you change attributes of one cell somewhere in between you get three entries, above, the cell and below. Setting another attribute on the entire column will change only those three entries, no need to touch 65536 cells. [...] I definitely recommend studying more advanced spreadsheet models, They do exist for at least 10 years, and newer designs are really powerful. When I will have some spare time, I will elaborate on my top 5 of spreadsheet issues (this multidimensionality and the data typing/transformation discussed on the OASIS list are just 2 of them). As long as the top 80% issues are about do it like Excel, I can't import that Excel file, I can't export this to Excel you'll get exactly nowhere with whatever sophisticated new spreadsheet models. It may all be nice and needed by a minority of users wanting to do very serious business with it. It may be a highly anticipated and accepted niche product, but in an Office suite, if you don't offer at least a mode for Excel interoperability it just doesn't sell. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Increasing maximum worksheet size
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 http://wiki.services.openoffice.org/wiki/Calc/hacks/number_of_rows It would be nice if you added your experience to that page and list quirks and bugs you encounter. Thanks Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Re: Whom should I assign i56202 to (for QA)?
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 the SRC680 code line instead of OOD680, I told you to use m214 or later, which was ready by then. Usually QA now rejects builds based on milestones earlier than m213 because there the new chart module was integrated and automated test scripts have been adapted and don't run with earlier versions anymore. m215 and m216 were quite broken and the latest known to be good master is m217. I tried building it on the buildbot - it succeeded only on one bot: http://termite.go-oo.org/Sun-Soli1/builds/91/step-Install_Set/1 (Some) Failed ones: http://termite.go-oo.org/Sun-Sols1/builds/118/step-compile/1 http://termite.go-oo.org/Sun-Win1/builds/60/step-compile/1 [Looks like the failures are due to bot-problems.] Did you inform the maintainers/admins of those? Would be nice, the problem might also already be known though. (to confirm) Things that I have to do next: 1. Mark as 'ready for QA' (already marked) There is no QA-rep assigned to the cws. Contact Frank Stecher [EMAIL PROTECTED], or ask on the QA mailing list [EMAIL PROTECTED] if someone is willing to take it. 2. What is 'estimated due date'? The estimated date when the cws is due to be integrated, which of course depends on how long QA will need to finish the tests on it. Usually 2-3 weeks after the ready-for-QA date. 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. Please contact Frank Stecher [EMAIL PROTECTED] for how to proceed. If the cws won't make it into OOo2.3 anymore, the release target will have to be updated to OOo2.4 and the issue's target milestone accordingly. 3. Send a feature announcement. Yes. Use the announcement form in EIS I already gave a description for, also available at http://wiki.services.openoffice.org/wiki/Feature_announcement Is there anything else that I have to do? See http://wiki.services.openoffice.org/wiki/CWS#When_you.27re_happy Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] About issue 70277#,please review patch file!
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 transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Re: Whom should I assign i56202 to (for QA)?
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 you checked in on branch cws_src680_msba02. If there are no problems with it I'll take a shortcut and commit the changes to cws dr55, which is scheduled as a feature cws. Actually it should had gone ready-for-QA today, but we'll do another build with your changes included if appropriate. Please stay tuned for further proceeding. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Re: Whom should I assign i56202 to (for QA)?
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: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] ScRange::Parse return values
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 doesn't look like, as source/ui/vba/vbarange.cxx doesn't test for the flags returned (I think it should, but then again I didn't dive deeper into the code), but the usage in the ScRange methods is wrong and other flag combinations should be returned upon success to indicate a valid range. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] stable algorithm for statistic functions issue 78250
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 much higher that patches seamlessly apply. Thanks Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] stable algorithm for statistic functions issue 78250
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 only a normal PC with WinXP. Nevertheless, that would be practicable for me. Would it be OK with the m218 version? Sure, m218 is fine. Thank you. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Finance Functions
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 information about which functions are declared, defined and used in what source code files, such as LXR, GNU id-utils, cscope and exuberated ctags, see http://wiki.services.openoffice.org/wiki/Little_Helpers Static information not part of the source code is outdated just too quickly. What would help instead might be a small perl tool that, given a UI function name such as STDEV, looks up the chain compiler.src - compiler.hrc - opcode.hxx - interpr4.cxx - interpr*.cxx to retrieve the implementation. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] External cell reference implementation
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 if created for an external ref. Indeed. It has to be named like [ file:///path/to/extref.xlsx#Sheet1 ] with the quotes, just to conform to the existing implementation. Actually it would be 'file:///path/to/extref.xlsx'#$Sheet1 if we're talking about our core implementation. Not the single quotes and their placement. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Entering certain date in certain cell automatically decrements the date by 1 day - issue 78199
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 developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Updating Statistical Wiki Page
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 moving the *Descriptive statistics* to a dedicated page(something like *Descriptive Statistics*), and - later - moving other parts as well to their dedicated pages. I further suggest to give it some structure: 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 2. Create subpages for topics directly belonging to that article, for example Calc/To-Dos/Statistical_Data_Analysis_Tool/Descriptive_Statistics The wiki link for this to be placed in the Statistical_Data_Analysis_Tool page would simply be [[/Descriptive_Statistics]] Unfortunately, I did not manage to create a new page, despite countless attempts and searches on the site for such help. A new article can be created by either attempting to direct the browser to a non-existing article, for example http://wiki.services.openoffice.org/wiki/Calc/To-Dos/Statistical_Data_Analysis_Tool/Descriptive_Statistics and then follow the edit tab respectively edit this page link. Or by placing a wiki link (the [[pagename]] tags) in the article you want to link from, and then follow that link when the page is displayed, which generally is more convenient. You have to be logged in with your wiki account to be able to edit pages. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS pgp5weBVxNEIt.pgp Description: PGP signature
Re: [sc-dev] about issue60590
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 other Lotus 1-2-3 files may not load anymore. The value 0x01 was there with a reason, I guess.. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgp6MVwCmyZSF.pgp Description: PGP signature
Re: [sc-dev] why add '_'before 'c'when creating names
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 would designate row 1 column 1, identical to the cell address A1. An expression C1 refers the entire column 1, a C without a number the very same column the formula resides in, so if positioned in cell B5 you entered =R1C it refers to the first row in that column, cell address B1. Hence =C creates a circular formula dependency, but still is a valid reference expression. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpZ8nAFmO11P.pgp Description: PGP signature
Re: [sc-dev] Dropdown list box
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 method is also used for AutoFilter, as the name may suggest. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpnsVIV1fUfW.pgp Description: PGP signature
Re: [sc-dev] all the icons are on at the same time
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 mean that all icons are enabled if you switch on the design mode again? This is how it is supposed to work. 5.There is no such phenomenon in Writer. Writer works identical. If not, which version are you using? I tried m222. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpIqYIBsbf1t.pgp Description: PGP signature
Re: [sc-dev] filled cells cannot be shifted beyond the sheet
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 course they can not. Where should they go? In certain sense, we can shift cells right. I didn't understand that. What do you mean? Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgp7gTVL9WCJz.pgp Description: PGP signature
Re: [sc-dev] Rubber/Pencil function for Calc
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 information about the UNO context in which your component was constructed, such as the service factory used. To obtain the current spreadsheet document that has UI focus (!) use service com.sun.star.frame.Desktop interface com.sun.star.lang.XDesktop method getCurrentComponent(), see also http://api.openoffice.org/docs/common/ref/com/sun/star/frame/XDesktop.html Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpLVWV4tJBtO.pgp Description: PGP signature
Re: [sc-dev] Update: R and Calc
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. I haven't updated the wiki with this yet but will do so soon, and will also begin writing a manual. Thanks, I'll take a look at it next week. Other versions before needed editing some scripts and tweaking here and there to be able to build the extension. Is changing that to a convenient build process using makefiles as usual on your radar? Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpMETQOADU5a.pgp Description: PGP signature
Re: [sc-dev] XActivationBroadcaster - crash after switching from printPreview back to sheet ...
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. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpOgwKNvlWm8.pgp Description: PGP signature
Re: [sc-dev] Saving Filter Options (i#35579)
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 of a published enum. :-) Yes, the (from a core implementor's view) always hated enums-are-fixed-sets ABI ... What is the best way to solve this, so that we can persist the new FilterOperator values to the .ods file? I have one working (hackish) solution [2], but I doubt that this would be ideal. Au contraire, it would forbid using the new values via API and break already existing extensions written in Java (and maybe other languages) that query the filter operator. The usual approach to extend such an API is to introduce a second new enum range, or if adding to the values is planned for the future using a constant is more appropriate, since extending constants is no problem. To use the new enum/constant all structs using the old FilterOperator enum need a derived version, optional properties been added, and additional interfaces need to be implemented for all these data types, and offered either as an optional interface at the already existing service, or via inheritance. For example constants FilterOperator2 {...}; struct TableFilterField2 : TableFilterField { com::sun::star::sheet::FilterOperator2 Operator2; }; service DataPilotSourceDimension { ... [optional, property] sequence com::sun::star::sheet::TableFilterField2 Filter2; }; interface XSheetFilterDescriptor2 : XSheetFilterDescriptor { sequence com::sun::star::sheet::TableFilterField2 getFilterFields2(); }; service SheetFilterDescriptor { ... [optional] interface com::sun::star::sheet::XSheetFilterDescriptor2; }; and so on.. be sure you don't miss interfaces and services that make use of XSheetFilterDescriptor and derived, there are a few. And yes, having to carry out this work is extremely nasty just to add some values to an enum. And yes, this is the reason why I refrain from using enums in new interfaces if there is only the slightest chance that another value would had to be supported in future. Which makes enums pretty much useless, IMHO. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpDaESCx07hM.pgp Description: PGP signature
Re: [sc-dev] A compatible problem
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 page as the Excel does. I found that it was related to the default row height of Calc, I suggest to change the default row height to 0.52cm, but how to achieve it, I hope you can give me some help, thank you very much! This seems to be a resent message, we already had that discussion back in July, see Message-id: [EMAIL PROTECTED] respectively http://sc.openoffice.org/servlets/ReadMsg?listName=devmsgNo=2386 and thread. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpug88E4sCUC.pgp Description: PGP signature
Re: [sc-dev] i20496 : Enhanced formula input
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 should a leading -- trigger conversion to formula? Btw, why should a leading - minus trigger conversion at all? What if * multiplication and / division operators are used, as in +number/number, I guess these should be treated identical? Since this feature is primarily useful when entering numbers on the number keypad, I guess that when the input is +any_non_number+... conversion to formula should never apply? There are ambiguous situations where conversion to formula may be wanted or not, for example +number-number-number which may as well be an international telephone number including the common notation of +region code, e.g. +49-40-..., these would be converted if the input wasn't preceded with a ' single quote (apostrophe). The behavior if and when to enter reference input mode if cursor keys are pressed needs to be defined. Please follow-up on the [EMAIL PROTECTED] mailing list, Reply-To header is set. Thanks Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpW6JtoHmrCe.pgp Description: PGP signature
Re: [sc-dev] i20496 : Enhanced formula input
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 and -+1 to =-1 (all without any other trailing operators) which I find pretty disturbing. What is the purpose of '--1' = '=--1' I don't know. As I wrote, I don't like the attempt to handle anything that does not involve at least two non-operator tokens (in the sense of numbers, names, ...) as formulas. I brought these Excel examples into play because Muthu argued that ++number should be converted to =++number because that would be what Excel did, which it doesn't. My examples are all cases where we should not follow Excel. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpdFiLnWIUNf.pgp Description: PGP signature
Re: [sc-dev] Re: Inserting Images?
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) on the Calc API Programming wiki: http://wiki.services.openoffice.org/wiki/Calc_API_Programming#Graphics That looks a bit cumbersome. What's wrong with http://codesnippets.services.openoffice.org/Calc/Calc.InsertGfx.snip ? Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpXK5sakRnjc.pgp Description: PGP signature
Re: [sc-dev] I have a question
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. Somebody hopes it should show 2 rows. 2 values could be expected there.. I want to know whether it is a bug and whether it is necessary to fix.I hope you give me some advices.Thank you! Please check if an issue already exists for this and create one if it doesn't. Implementation is in sc/source/core/data/table3.cxx ScTable::TopTenQuery(). Looks like the number of entries displayed needs some rounding. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpo1LxPRFEHA.pgp Description: PGP signature
Re: [sc-dev] Our plan to improve Calc functionality related tophonetic text
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 complicate synchronization. Now, this is our first choise considering - memory waste - easy development (reducing modification) I actually consider that the most error prone approach of all attempts discussed. It is not easy development, additionally to that you'd have to spot each place where ruby attributes are to be stored like with any other approach as well, you'd also have to keep track of places where they have to be removed or changed. Deleting, changing or replacing a ScStringCell then would need extra handling, and you'd complicate things for developers that want to modify or add code in future. I strongly suggest to not go the attribute way in Calc. Or to line this out more clearly, I strongly oppose this approach. So: -1 Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpaSIQH5GJxF.pgp Description: PGP signature
Re: [sc-dev] R/Calc - 0.1.6
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 check if it's supposed to be that way. Well, now that the culprit is found, I hope in a fast solution. One small note with R: - on Windows, IF you want to use a path with '\'-slashes in R, you need to escape the slashes, like: '\\' - R accepts the '/'-slashes on windows, too - I don't know IF one needs to additionally escape the '\'-slashes in Rserve, too (like in some regexp's, having to write '' for a single literal '\') Usually path munging library functions on Windows consume '/' instead of '\', even the ones shipped with MSVC. It's only command line arguments that may confuse applications with '/' (e.g. dir c:/windows ) because they take it for an option switch. IMHO, in a programmatical context there shouldn't be need to use '\' in paths on Windows, so they can be written transparently on all platforms. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpaCc8m23uDU.pgp Description: PGP signature
Re: [sc-dev] Re: R / Calc Name ?
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 GNOME desktop, or a resistor calculator. Regarding iCaRuS: you wouldn't name a tool after someone who flew too high and burnt his wings, would you? ;-) Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpaDYrGUdS9T.pgp Description: PGP signature
[sc-dev] Back from vacation
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 attention please be patient, I'll keep on wading through the pile until I reach it ;-) Thanks Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpNVVxCr8tHX.pgp Description: PGP signature
Re: [sc-dev] Name for RCalc - tentative R4Calc
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 work as well. It could be a combination of both, short name and descriptive name, so: R4Calc - R Statistics for OOoCalc At the end of the day, I believe that R4Calc is the best option, but I would like a 2nd opinion. Googling for R4Calc did NOT give any hits, so maybe this is indeed the best name. Apart from R4 being the popular Renault car, R4 is also a graphics generator syncing to music. That shouldn't be confusing though. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpHdiQ07sy34.pgp Description: PGP signature
Re: [sc-dev] Values depending on linked and not available spreadsheet - xls-viewer OOO
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. At least they require this in the help for the function. So they break the own rules. They probably don't break the rule, but for unsorted data the so-called sorted range lookup may deliver any result that fits for a less-or-equal query. The actual result delivered depends on the algorithm used. It is coincidence that Calc for that data constellation delivers #N/A. So whoever used the data for vital tasks in Excel or some viewer should carefully check the results it delivered with reality ;-) Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgp9cygRQqQKk.pgp Description: PGP signature
Re: [sc-dev] ScRange::Parse return values
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 a) the client of ScRangeList::Parse must take care of this OR b) ScRangeList::Parse should detect the single range was parsed by ScRange::ParseAny and it should apply the remaining flags ( SCA_VALID_COL2 | SCA_VALID_ROW2 | SCA_VALID_TAB2 ) OR Yes, that's what I meant. Of course apply them only if the corresponding bit is set for the single address as well. c) ScRange::ParseAny should apply the extra flags it successfully parses the string a) would mean finding every caller :-( Aren't that many, most just check for the SCA_VALID flag. b) has some merit because it's an internal change c) you could argue that if someone calls something called ScRange::parseAny they would expect success to mean the full set of flags to be set regardless of whether the range was formed from single address or not Not necessarily. The parse methods return flags for what they parsed, and if that's just a single address ... You probably also don't want a sheet.a1 to expand to sheet.a1:sheet.a1 in case you use the flags to redisplay the range, so IMHO that should be under control of the caller. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgp6NJZL0INPp.pgp Description: PGP signature
Re: [sc-dev] patch for i71814
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 findings were, what the problem was, what the patch changes and why it would be a solution. Or at least some of that ;-) This would ease discussion a bit, I think. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpfx2pKGa4uC.pgp Description: PGP signature
Re: [sc-dev] Page margins in print preview
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 formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpu2TKPWtdvf.pgp Description: PGP signature
Re: [sc-dev] Page margins in print preview
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 http://wiki.services.openoffice.org/wiki/Calc/Drafts/Page_margins to fit it nicely into our wiki hierarchy and adjusted categories to make it appear in http://wiki.services.openoffice.org/wiki/Calc/Drafts and http://wiki.services.openoffice.org/wiki/Calc/To-Dos Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpcaOCVY4b29.pgp Description: PGP signature
Re: [sc-dev] patch for i71814
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 the result.Findings is shown in ImpEditEngine::GetChar. the original position of text is up to aPaperSize and nTextWidth, position of mouse is up to aTempView and OutputArea. Well, yes, I think we know what the variables are used for, but that doesn't explain why setting a new paper width would be necessary, as it is done in the patch. Also, the portion around if ( nTextWidth nThisColLogic ) introduced in the patch is very similar to the already existing one near line 4741 if ( nTextWidth nThisColLogic ) that treats the aLogicEdit's nStartX, so I wonder whether it is coincidence that these cases differ from the default path, or maybe could be rewritten to generalize the behavior. This especially because Rectangle aOutputArea = PixelToLogic( aEditRect, aEditMode ); is essentially the same as Rectangle aLogicEdit = PixelToLogic( aEditRect, aEditMode ); at line 4705 (line numbers as present in m236). Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpaX37UMSAhn.pgp Description: PGP signature
Re: [sc-dev] New features about Data Filter
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. Now, I want to know whether these issues should be fixed? If the answer is yes, what should we do in featrue(Data Filter)? When specifying and developing the feature the issues should be kept in mind and specification should address the issues. When done right, implementing the specification will fix these issues. Note that the issues currently are of type 'patch' but nevertheless would introduce new features. Depending on the outcome of the specification the patches may have to be reworked. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpmAADYcfWzM.pgp Description: PGP signature
Re: [sc-dev] Pasting from HTML as unformatted text adds space to cells
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 pasted. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpMvF9xqm84s.pgp Description: PGP signature
Re: [sc-dev] Patch for i38759
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 mail of an already existing thread, as this will hide your mail in that thread instead of starting a new one. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpfoOmdIWq7U.pgp Description: PGP signature
Re: [sc-dev] Date input
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 input box is not used Argh, no, I would hate that. I don't want be forced to use a dialog to be able to enter dates. As soon as I wanted to enter more than one date I'd just wish to kick it away. or be more strict about what format is considered a date in that scenario. This is what we need. That would also allow us to localize the date format too without causing too much headache. The date input format actually is halfly localized, the YMD order and separator are taken from the locale, but the parser accepts other separators [-./] as well. An additional problem is that, for example, US folks like to write 12/10 for Dez-10 current year, Germans wouldn't expect 10.12 to get parsed as a date, which it currently is, but 10.12. instead (note the trailing dot). And of course you want ISO 8601 -mm-dd always to be parsed in any locale, and probably also 12-10. Heck, and you want Monday, December 10, 2007 be parsed as well. And you want input to be parsed in the same format that the cell is displayed with, if possible. What's still missing is input in other calendar systems than Gregorian for several reasons, even if output works fine. So, localize without causing too much headache doesn't apply at all, that would need date input rules from locale data. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgp7xeM7c3dju.pgp Description: PGP signature
Re: [sc-dev] Date input
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 Would be a possibility. A list of acceptable input formats, predefined in locale data and customizable by the user. (also note the *dd.mm* which is different from the American *mm.dd* format!). Which isn't American, but mm/dd is en_US. Then only such string would be converted to dates, and NOT *xx.xx*, which would most probably be a number and NOT a date. Depends on the locale. Just my thoughts. [This should be settable either at OOo level, or at document level.] Document level wouldn't be good, as documents are sent around to users used to different locales. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpTu54MF4PmB.pgp Description: PGP signature
Re: [sc-dev] New features about Data Filter
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 with the featrue. Keep on nagging them ;-) Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpeIzYAuWgmR.pgp Description: PGP signature
Re: [sc-dev] A question of i38759
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 definition: If there is no numeric value return 0, else return min/max of numeric values. If that, then what is the difference between MIN/MAX and MINA/MAXA? MIN/MAX would return 0 only if no other numeric values are encountered. For MINA/MAXA, a string value does always count as zero, so if we have A1: empty A2: string A3: 3 =MIN(A1:A3) = 3 =MINA(A1:A3) = 0 =MIN(A1:A2) = 0 // new behavior, currently results in Err:502 =MINA(A1:A2) = 0 =MIN(A1) = 0 // new behavior, currently results in Err:502 =MINA(A1)= 0 // new behavior, currently results in Err:502 Note that MIN(A1:A3) is identical to MIN(A1;A2;A3) I think one parm can be considered empty only if there is not any value, neither numeric nor string. As MIN/MAX act only on numeric values and ignore strings, emptiness is already fulfilled if in all arguments no numeric value was encountered. For MINA/MAXA of course it is the condition of neither numeric nor string. As I think it that way, I count every matrix element to determine wether it is empty. Besides, nEmpty... are used for counting the number of parms, not the number of cells. If I misunderstand your meaning, please explain it again. Matching conditions of emptiness against the number of parameters passed is not needed. The minimum/maximum is determined over all parameters, not separately, so emptiness is also a over all condition. Hope that helps. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgp62SCVj6xQS.pgp Description: PGP signature
Re: [sc-dev] Patch for i38759
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 only one of the parameters does not evaluate as a value (or text with bTextAsZero==true). Instead, only if all parameters do not contain any value the condition of returning 0 unconditionally should be met. So, =MAX(A1:A2;B1:B2) should result in the maximum value of A1:A2 if the range B1:B2 does not contain numeric value cells. Btw, in the case of svString the SetError(errIllegalParameter) should not be replaced. Passing a literal string to MIN/MAX (as opposed to MINA/MAXA) should still result in an error. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpWcUzZirqKf.pgp Description: PGP signature
Re: [sc-dev] Date input
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 decimal separator a date is generated (where usually one wanted to enter a numbered list instead). Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpVQFBduPhcH.pgp Description: PGP signature
Re: [sc-dev] Re: Invalid characters in sheet names - Issue 6087
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). The requirements are quite clear. See comment I just added to the issue. Also, few tips/directions might be helpful here... I don't think there is much to it, it may be a bit twisted though. - The ScDocument::ValidTabName() method that currently restricts names to valid characters should be implemented empty. Similar ScDocument::ConvertToValidTabName(). - ScCompiler::Convention::Convention() needs some bits set here and there for the non-Excel cases (not CONV_XL_A1 and not CONV_XL_R1C1) - Some parts may need a bit tweaking in ScCompiler::NextSymbol(). - Adapt ScCompiler::NextSymbol() to accept an ODFF reference (but only if the grammar set is an ODFF grammar!) enclosed in [] in one pass without trying to break it up into pieces, and feed that directly to some token creation in ScCompiler::NextNewToken() instead of falling through the !IsString() !IsOpCode() !IsReference() chain. This certainly is the most challenging part. However, note that implementation of compiler interna change significantly in CWS 'odff', so if you want to touch these take that CWS as base line. Otherwise patches wouldn't apply. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpTwyVlkq0HN.pgp Description: PGP signature
Re: [sc-dev] A patch for issue71158
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 notification mail upon issue changes. Please check the patch, thank you:-) I'll do so today. Thanks Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpMEH7qpP6Hl.pgp Description: PGP signature
Re: [sc-dev] RATE function; issue 15090
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(), SetIllegalParameter(), and SetError(errIllegalParameter). What is the right one in this case? Depends on.. as this is about generating an error in the case that an argument had a bad value, it is one of the IllegalArgument values (yes, this is inconsistently handled throughout all functions, I'm about changing that). SetError( errIllegalArgument) and SetIllegalArgument() differ in that SetError(...) only sets the error, while SetIllegalArgument() also pushes a value to the stack. Yes, bad naming, I already changed that in CWS odff to PushIllegalArgument(). So, if the code will reach a place where some value is pushed using one of the other Push...() methods, SetError( errIllegalArgument) is appropriate, else SetIllegalArgument() if bailing out of the function early is required. Btw, in CWS odff I changed (and will change) a lot of things and diffs created against earlier code respectively current milestones probably won't apply anymore without adapting them. If possible I would appreciate patches based on that CWS. This would require though that you build a CWS version for your changes, not a master milestone. Would that be feasible for you? (2) The parameter Nper has the type 'number'. May it be non integer? For non integer Nper there must be RATE=-1 because of (1+Rate)^Nper. Should RATE-1 be excluded in all cases or only if Nper isn't integer? The ODFF draft working document has a comment about this: | TBD: In Gnumeric, Nper seems to be truncated if it is not an integer. In | OOo2, Nper seems not to be truncated if it is not an integer and the | fractional part is included in the calculation. What does excel do? We | should include a test for this, but what is the right thing to do? For | example, in Gnumeric, RATE(12.9,-100,1000) is 2.92% but in OOo2 | RATE(12.9,-100,1000) is 3.88%. It wasn't decided yet whether it should be required to truncate Nper to integer. Usually, if there is no mathematical requirement to do so, so far we did not put constraints on argument values. From your view as a mathematician, does it make sense to allow non-integer Nper values? If the implementation works correctly for both, integer and non-integer, I'd say support also non-integers. In case we'll define integers only should be supported it should be fairly easy to restrict implementation accordingly. (3) „RATE solves the equitation...“ In many cases there is not only one solution but there are two, sometimes three. Currently OOo returns solutions, which are far away from 0, Excel doesn't, what the issue is about. But what to do, if the user starts with a GUESS that will lead to such a solution and the user sets GUESS to that value with the intention to get such solution? Would the result be correct then? Even if far away from 0? If not, we should generate an error, I think. Leaves the question to define a limit for far away ... (4) What role should GUESS have? start the iterative computation makes not sure, that different implementations will return the same value. Unfortunately algorithm and implementation are not defined, also ECMA/MOOXML doesn't tell anything, as usual. Do you know algorithms that would yield better results than others? Maybe we can define them in ODFF. (5) What should RATE return, if solutions exist, but values are far away from 0? Example: Nper=4; Pv=-1; Payment=0.82; Fv=2. It has one solution round RATE=100% and another one round RATE=-215%. Excel gives an error in this special case. If you can detect that, I think generating an error is appropriate. (6) Technical questions: Should I use tabs or spaces for indent? Spaces please for new code. Shift width / indenting is 4 spaces, if you also set your editor's tabs to stop at multiples of 4, code will be legible. The current text has German identifiers and parameters and German comments, for example fBw (which means 'Barwert') instead of fPv, which would fit to the specification. Change it? Yes, please. Doing so will clarify the code for other developers. 'fSchaetzwert' and the like look ugly anyway, I guess some other German mathematician introduced them ;-) The internal function 'GetZinsIterationEps' returns fEps, the last difference between neighbored values. That is used to determine whether the result is valid or not. This will fail, if you decide, that resolutions far away from 0 should not be valid although they solve the equation. May I change it to boolean in that case? Sure, if it serves your purpose. Which boolean type has it to be, if I change it? Use C++ bool type instead of the old BOOL typedef. Does a document exist for conventions for source text? Actually we
Re: [sc-dev] RATE function; issue 15090
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 other values. The parameter 'PaymentType' in the equation can be interpreted as constant offset to the regular date of payment. So other values are meaningful too. Therefore the description should explicitly allow or forbid values others than {0;1}. The current implementation in OOo uses silently the value 1 for all values but 0, but makes no use from it in the Newton-algorithm. I'll not change that. Thanks for the comment. Yes, this indeed is an open question and should be clarified in ODFF, just wrote a mail to the committee's list. Looks like implementations constrain the parameter to {0;0} because that's what the other spreadsheet application documented to do. However, what it docuemented is not what it does. It seems to interpret the value as an offset (in periods) to the end date of the payment period instead. Would it be feasible to add that to our implementation? However, the PayType corresponds with FV, NPER, PMT and PV so should be treated consistent. Btw, in CWS odff I changed (and will change) a lot of things and diffs created against earlier code respectively current milestones probably won't apply anymore without adapting them. If possible I would appreciate patches based on that CWS. This would require though that you build a CWS version for your changes, not a master milestone. Would that be feasible for you? I have not done it yet. Now I have installed WinCvs and have been able to check out the sc modul with the tag cws_src680_odff. Therefore I think, that it will be feasible for me in principle. If I get problems, I will surely get help on the German mailing list. Or here or on [EMAIL PROTECTED] EIS says the current milestone of that cws is m243, but I find no download for it. Do I need to get the whole source via check out? Is it right, that I had to use that milestone for the cws odff? Yes, that's correct, and to get the source you'd need the commands cvs co -P -rSRC680_m243 OpenOffice2 cd sc cvs update -dP -rcws_src680_odff But I'll resync the CWS to m244 soon (this week) because some things don't work in m243 and Lvyue would also benefit from being able to use m244 after Chinese New Year break, so you should wait before checking out and building m243 if you didn't do it yet. I'll give a heads up when the CWS will be resynced. (2) The parameter Nper has the type 'number'. May it be non integer? [...] I would say, that non-integer Nper values are questionable. You can use such non-integer Nper values in the given equation and the Newton-algorithm will work and the results will be valid roots. But the term '((1+x)^Nper-1)/x' is a shortened result of the underlaying sum 'sum from i=0 to (Nper-1) (1+x)^i' and therein a non-integer Nper value makes no sense. That sounds like it would be a good strategy to have an integer constraint on the Nper parameter. If the implementation works correctly for both, integer and non-integer, I'd say support also non-integers. In case we'll define integers only should be supported it should be fairly easy to restrict implementation accordingly. The right side of the equation has a domain of [-1;infinity[ for non-integer Nper values. If Nper is an integer value, one can use a domain including values -1, for a pure mathematical view. For real live use cases, I think, that mathematical solutions -1 are senseless. That claims the reporter of the issue too. Therefore I like to set such solutions to invalid, if you agree. Doing that, it would make no difference in the central algorithm whether you use only integer values or not. Sounds good to me. (3) „RATE solves the equitation...“ [...] Yes, the results are correct in a pure mathematical view. Leaves the question to define a limit for far away ... That's the problem. I like to set results -1 to invalid, whether they are mathematically correct or not, see above. I think that's ok in this context. (4) What role should GUESS have? start the iterative computation makes not sure, that different implementations will return the same value. Unfortunately algorithm and implementation are not defined, also ECMA/MOOXML doesn't tell anything, as usual. Do you know algorithms that would yield better results than others? Maybe we can define them in ODFF. The now used Newton-algorithm works fine in most cases and is very fast (quadratic). Another one is Regula falsi. The latter requires a second initial value, so that the function has a change of sign in between. Depending on the way how this value is determined, the solution from Regula falsi might differ from that of the Newton-algorithm. better than that of the Newton
Re: [sc-dev] CWS odff resynced to m244
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 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpWwDJCwNjvx.pgp Description: PGP signature
Re: [sc-dev] RATE function; issue 15090
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 core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpTzwhCKJgBA.pgp Description: PGP signature
Re: [sc-dev] GCD/LCM in other spreadsheet
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 direction? Let's be consistent and check for 0 before doing the approxFloor() call. So this would basically be the first version of your patch. Are there other differences between that and the last version you attached? BTW, I'm updating sc to the -rcws_src680_odff tagged revisions. but it runs slow. I think it will be finished tomorrow. Did it run well? and I will see the issue86171. If I get any progress or meet troubles, I will tell you as quickly as possible. :) Hopefully silence means good news in this case ;-) Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpQevWxpOJuO.pgp Description: PGP signature
[sc-dev] Functions with bTextAsZero (was: [sc-dev] GCD/LCM in other spreadsheet)
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 also have some question. You may see my attachment of i86171. See my comment I just added there. and I wonder what nNumFmtType and nNumFmtIndex are used for. These can be used later in a call to ScValueIterator::GetCurNumFmtInfo(), in the bTextAsZero case of pure text cells they are predetermined and don't have to be obtained through calls to GetNumberFormat() and the like. For formula cells situation is a bit more complicated and should be left as is for now. Wish you a nice weekend! Thanks, nice weekend to you too! I'm going to FOSDEM now, http://fosdem.org/2008/ Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgp2b9Hkkkw1e.pgp Description: PGP signature
Re: [sc-dev] About i86643(Make COUNT ignore error results)
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 =COUNT(A1), the result will be 0. and before I change, the result was Err:522. Is that right? Good that you mentioned. Comparing with Excel this is indeed a strange case. Also there A1:=COUNT(A1) results in 0 (after having popped up a warning about circular reference), but A1:=COUNT(A1:A2) and the value 1 in A2 still results in 0, which looks broken to me. I find many formulas will return Err:522 in this case, All circular references should result in that error, except for formulas where ISERROR() or ISNUMBER() or similar check for the type or evaluate the error. And now COUNT() and COUNTA() as well. but for COUNT, I think it is ok. however I don't know if this is the result you want. Error values are to be ignored, this is also what the ECMA/MOOXML spec says, so not counting the formula cell producing the circular reference error and not propagating the error is the logical consequence. Also =COUNT(1/0) as an error case example should ignore the error and not increment the count. To make that work a check for the stack type svError is needed in ScInterpreter::IterateParameters() and ignore that for the case of ifCOUNT, setting nGlobalError to 0. In ScInterpreter::Interpret() the OpCode ocCount needs to be added to the CASE_OCERRFUNC macro. I also found formula =COUNTA(A1) returns 1, not Err:522. Which fits well. Also =COUNTA(1/0) should return 1, and ocCount2 be added to the CASE_OCERRFUNC macro to make that work, and the check for svError in IterateParameters() counting the error for ifCOUNT2, again setting nGlobalError=0. It gets more complicated now though: for incorrect references, after having called PopSingleRef() or PopDoubleRef(), nGlobalError is set. To be consistent this must be checked as well, and the error ignored for ifCOUNT respectively counted for ifCOUNT2. A test case for that would be: - B1: 1 - A1: =COUNT(B1)= 1 - A2: =COUNTA(B1) = 1 - Delete column B = result A1==0, A2==1 Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpgArHqSv9JK.pgp Description: PGP signature
Re: [sc-dev] precision of GAMMALN
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 could be copyrighted or fall under the same license the source code is licensed, and of course IANAL, so I can't give any legal advice. The result would be excellent. If you compare in a Calc cell the values calculated with GAMMALN with the directly calculated values (which is possible for GAMMALN(n) and GAMMALN(n+0.5) with positive integer n) you will get TRUE. Sounds nice, but ... Btw, do you happen to know the Cephes library? It also has gamma (didn't test, could you take a look at it?) among other nice algorithms, and is said to be numerically accurate, several other software products use it as well. See http://www.moshier.net/#Cephes I currently favour that library, it looks like it could solve our numerical stability problems, and maybe more. Unfortunately the license is somewhat unclear, respectively there's just a may be used freely statement. I'll get in contact with Steve and see whether we can arrange something for the legal department. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpGQVPckx5ax.pgp Description: PGP signature
Re: [sc-dev] OFFSET in array formulae
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 core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpTZx3pC7dKi.pgp Description: PGP signature
Re: [sc-dev] Preparation of localizable separators in CWS koheiformula01
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 ScGrammar I'll be happy to use it instead. [... the separators ...] They should be merged into the SymbolsNative map instead. Sure. I'll look into that. Thanks. I have one question, though. Do we still need to differentiate between the address convention and the formula convention in general? Different address conventions may be used with the same formula language / function names. For example, once we implemented configurable address conventions at the UI, the native formula language could be used with different conventions. For this, additionally to GRAM_NATIVE, I prepared GRAM_NATIVE_UI (used as GRAM_DEFAULT throughout most calls), GRAM_NATIVE_XL_A1 and GRAM_NATIVE_XL_R1C1. They all share FormulaLanguage::NATIVE. See sc/inc/grammar.hxx. Also GRAM_PODF and GRAM_PODF_A1 are identical except the address convention used, with (file format) or without (API compatibility) bracketed references. GRAM_ODFF of course has only one convention, but if needed later GRAM_ODFF_A1 could be used as well, again with the only difference that references wouldn't be enclosed in brackets then. The idea I envisioned was just to use one global formula convention to control both the address convention and the rest of the formula convention (such as the argument and array separators), and expose that to the UI as well. If I didn't get you wrong that is what ScGrammar effectively does or is prepared for, take a look at the details. It tells the compiler how to parse/stringize. Note that the enum value has room for bits to be used for such things if we had to, the language part is certainly not needed in its full length (kConventionShift). However, I think that because localizable separators would only affect FormulaLanguage::NATIVE (and maybe FormulaLanguage::ENGLISH as well if we wanted to) we simply can store the configured separators in the symbol map and either dynamically adapt the bits in the ScCompiler::pConventions tables according to the current symbol map or setup a localized and UI configured address convention table, and probably have to massage ScCompiler::NextSymbol() somewhat to support that. That's just my quick brainstorm, does it sound feasible? Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpBSD6exmbJ7.pgp Description: PGP signature
Re: [sc-dev] Preparation of localizable separators in CWS koheiformula01
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 conventional OOo style separators. Why not? It should be possible to exchange those few values during runtime, or did I miss something? But is that desirable? My original intention was to support switching between the two separator styles, but using mxSymbolsNative that will not be possible unless I'm missing something. But you wouldn't switch arbitrarily between styles, would you? If the user selects a style, that style would be valid for all formulas. It would not be a per cell setting, not even per document. Again, maybe I missed something and there's a scenario I'm not aware of. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpBq6jCKR2pc.pgp Description: PGP signature
Re: [sc-dev] About i78781(Excel INDEX() compatibility)
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 row number acts as a column number. 2. while input: =INDEX(($D$27:$P$27;$D$29:$P$29);2) the result also should be value of E27. Also correct, because if the area number is omitted area 1 is taken. so I made some change, and attach the patch on issue78781. please check it, and if I miss anything, please tell me. I think that's all what i78781 is about and your approach looks like it would work. Similar behavior should of course still be observed for a column vector, see ODFF spec. Note that the current version available for download has an error and mixed up terminology of row vector with column vector and vice versa, I already corrected that in my editorial copy, sorry if that caused any confusion. Corrected version should read: | If DataSource is a one-dimensional column vector, Column is optional or | can be omitted as an empty parameter (two consecutive ;; semicolons). If | DataSource is a one-dimensional row vector, Row is optional, which looks | as if Row is taken as the column offset into the vector, or can be | omitted as an empty parameter (two consecutive ;; semicolons). I didn't check implementation yet, the patch looks good, I'll create a new CWS odff03 to apply and test all pending patches. Unfortunately there's more to the INDEX() function, as there are combinations of omitted parameters possible, as described in the ODFF spec. Could you please check what the function's implementation is missing? I implemented much of it in CWS odff but noted down that we're not fully compatible yet for the array cases. For example, related is http://qa.openoffice.org/issues/show_bug.cgi?id=66930 Don't get confused by the original submitter's description, the issue is not about LOGEST() not working correctly but INDEX() not returning a vector for the array case. BTW, did you see the 4th patch of i86643? I'm not sure if the handle of errNoName is right, but it is indeed a disturb of counting correctly. I don't quite understand the reasoning there. Why do you restrict the precondition to errNoName and only then set nGlobalError=0? Also, why ignore an error only if nGlobalError!=NOTAVAILABLE? IMHO all errors are to be ignored for COUNT() respectively counted for COUNTA(). Btw, the expression nCount += ( eFunc == ifCOUNT2 )? 1:0; should better be written as if (eFunc == ifCOUNT2) ++nCount; Ok, that's all about the issue, I have a personal question. :) Sometimes I feel confused about the ODFF, I have seen the document about ODFF, it introduced many formulas. But I'm still not sure what I should do on ODFF. Make the formula act as the document says and keep it compatible with Excel? Is that all I should do? In general yes. If there is a discrepancy between ODFF specification and Excel behavior that is not explained in ODFF please drop me a note so I can investigate. Please also give me a heads up if the ODFF spec isn't clear enough or lacks details one must know to implement the desired behavior, also if observing Excel behavior clarifies something that wasn't clear in the ODFF spec. Wish you a nice day! :) Thanks, same to you :) Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpalQGVlgymd.pgp Description: PGP signature
Re: [sc-dev] label and array formula
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 array instead, similar to {=A1:A3} as opposed to =A1:A3. However, the other spreadsheet application generates a #N/A error in that case. Not sure if there is a reason other than implementation details, will have to investigate. Should i file a issue? I haven't find any related to this. Yes, please file an issue. Thanks Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpruI3qJ7dpR.pgp Description: PGP signature
Re: [sc-dev] Preparation of localizable separators in CWSkoheiformula01
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 it modifiable at run-time, or force it to re-initialize when the user changes the setting. Indeed there is this ScCompiler::DeInit() that could be useful for this (which I didn't see). :-) ScCompiler::DeInit() though entirely deinitializes all maps, which isn't needed here. It should probably be sufficient to only remove the elements in question from the map and reinsert them. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpl9sodtXW1C.pgp Description: PGP signature
Re: [sc-dev] Preparation of localizable separators in CWSkoheiformula01
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. Though not being accessible in the UI, an English mapping is available through the experimental and so far undocumented environment variable OOO_CALC_USE_ENGLISH_FORMULAS to be able to use English function names in any UI localization, which may also be used by QA in future to test mere functionality of localized versions even if they don't know what a function's name was translated to ;-) If set, mxSymbolsNative simply points to mxSymbolsEnglish, see ScCompiler::InitSymbolsNative(), which also has to be taken care of when exchanging the separators. Just for completeness: the English function names (not separators) of mxSymbolsEnglish are also used by the XFunctionAccess implementation. For now, I've just taken care of the separators (committed to koheiformula01 cws). I still need to work on switching the address convention based on the grammar, but I'll get to that later, probably tomorrow. Umm.. the address convention is already switched based on the grammar. Or what is missing? Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpJbRLUgcWf7.pgp Description: PGP signature
Re: [sc-dev] Preparation of localizable separators inCWSkoheiformula01
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 FormulaLanguage::NATIVE)) Always use the inline methods provided by ScGrammar instead, in this case that would be if ((ScGrammar::extractFormulaLanguage( eGrammar) == FormulaLanguage::NATIVE)) If we ever had to rearrange internal representation of the grammars that would still work then without having to adapt such places or even worse miss them. Thanks. In compiler.cxx +1396 there's aRef.Ref1.CalcAbsIfRel( rComp.GetPos() ); duplicated from line 1402, intentional? I think that had to be moved instead. Umm.. the address convention is already switched based on the grammar. Or what is missing? Ah no. I didn't see it the first time. Now I do. This means I won't have to do any extra work, which is good. ;-) Sure :-) Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpE3gzIgKbNL.pgp Description: PGP signature
Re: [sc-dev] About a question!
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 downwards arrow, U+2193 I will add a down arrow to a string that appears in ScInputHandler::UseFormulaData() which will call ShowTip(aNew) method to display hint information. I use aNew.Insert(sal_Unicode c, position), but the down arrow in the string is not displayed . In the meantime, I use String aBlack, aBlack.AppendAscii(RTL_CONSTASCII_STRINGPARAM( ↓ )), aNew.Insert(aBlack,position), there is no down arrow. Of course not, since that is not an ASCII value, so you can't use RTL_CONSTASCII_STRINGPARAM and AppendAscii. Use the Unicode value instead, which would also simplify things to aNew.Insert( 0x2193, position); Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgp9w3O34qhNr.pgp Description: PGP signature
Re: [sc-dev] How to run OO.o calc (from 2.4.0, windows) without installing it ?
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 executed and the application(s) will be installed on the memory stick. See http://portableapps.com/support/openoffice_portable#installing For OOo usage questions please don't use the dev@ mailing lists, use [EMAIL PROTECTED] for general questions respectively [EMAIL PROTECTED] for Calc specific topics. Thanks Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgp1Cxl0kdyau.pgp Description: PGP signature
Re: [sc-dev] constraints for ODF gamma function
Hi Regina, On Tuesday, 2008-04-08 15:24:33 +0200, Regina Henschel wrote: Therefore the constraint should be N in setR setminus setZ sup{=0} (use OOo Math to see the formula) Thanks, I just gave the ODFF-SC a heads-up on this. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgp1cWJiLo3Vk.pgp Description: PGP signature
Re: [sc-dev] ODFF: minor change re. LOOKUP
Hi Niklas, On Monday, 2008-04-14 16:53:53 +0200, Niklas Nebel wrote: =LOOKUP(6.1;[.B51:.B57];[.C51:.C57]) I believe the correct result there is 19, not 11. DEV300_m5 gives 19. Did you enter the formula in a locale where 6.1 is parsed as a date (with a value larger than those from the lookup list)? That would indeed be a possibility. One more cause to change the implicit relaxed date recognition to something more reasonable, respectively do not attempt to detect dates in formulas. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpufVmmaeLVD.pgp Description: PGP signature
Re: [sc-dev] three issues
Hi YunJingtao, On Tuesday, 2008-04-15 09:43:32 +0800, YunJingtao wrote: hi, Daniel As you Cc'ed Daniel's personal account I assume that he answered directly, as usual. However, for transparency I'd prefer if people didn't Cc personal accounts if the receiver reads the mailing list anyway, in order to make replies go always to the mailing list. Otherwise it looks like your questions were never answered.. Either that, or Daniel should use the GroupReply/ReplyAll function of his mail reader to break the silence ;-) Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpgPmjSSLQZu.pgp Description: PGP signature
Re: [sc-dev] Values depending on linked and not available spreadsheet - xls-viewer OOO
Hi Cor, On Thursday, 2008-04-17 10:10:19 +0200, Cor Nouws wrote: Easy to fix as you suggested. Only saving as xls and re-opening, again shows #NA ... Saving as ods does save the results. It seems that interim results of external references aren't saved to Excel file format. Daniel? Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpWFcZ25mIsx.pgp Description: PGP signature
Re: [sc-dev] 2008 Q2 Review of Spreadsheet Project
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 direct OOo as to what input is a date (e.g. only dd.mm.yy, and not xx.xx) short timeframe and implementing a date input-mask are contradicting in itself. In a short time frame, removing the relaxed date recognition and allowing only full dates would be possible. Note that doing so would affect all applications that use the number formatter/parser. In a medium time frame I would see input masks for abbreviated date input being defined in locale data, plus API to access them, plus have that handled in the number parser. Implementing some date recognition mask would need a configuration item, a dialog, sensible defaults in locale data, dialog input checking whether the input masks match the locale's date order definition, make the number parser handle that masks list, react somehow when the locale was changed, and maybe more. 2.) TEXT-vs-NUMERIC 1.) convert text-to-numbers automatically I don't know why you come up with this again, I thought I lined out in issue 5658 why that is not a good idea because results would be locale dependent. 2.) raise error / flag results where such text occurs Raising an error for single cell references containing text and literal string arguments where a number is expected IMHO is the only real solution. 3.) offer easy recognition and conversion of text to numbers This may be implemented as well then, after we treat text-if-number as error. Unfortunately, separating numbers from strings is a very *artificial* separation. It is NOT the way spreadsheets and humans function. 3 is always 3, independent of it being addressed in a numerical or textual context. Number recognition is only safe during user input. If not done in the input locale's context, guessing numbers from text is error prone. Numbers have to be a distinct type to make the spreadsheet work if loaded in another locale or a different application that might even not know the locale the document originally was created in. Btw, cross-copying to more than one mailing list quite assures that the discussion will be scattered over the lists. Either because people replying are not subscribed to all of them and the replies have to be moderated through, or because of the unfortunate Reply-To mangling on OOo lists that directs a reply to one list only if not circumvented by the person replying or a capable mail user agent knowing how to handle mailing lists. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgp3Pmumoz3ip.pgp Description: PGP signature
Re: [sc-dev] About i46681(ODFF: Repeat values of single array vector if used in second array dimension)
Hi Yue, On Tuesday, 2008-05-06 15:59:29 +0800, Lvyue wrote: I will attach a patch on i46681, which only changed a few functions, including ScIfJump(), JumpMatrix(), ScMatRef(), MatAdd(), ScMatrix::Get() and ScMatrix::GetDouble(). See your IRC log from today ;-) and another thing is that, I wonder if the error information should be changed frome #VALUE! to #N/A, when we can not get value from THEN or ELSE condition(like Excel). What exactly are you referring? Could you give an example? and at last, have a nice day! :) Thanks, you too :) Btw, when creating a new mail topic please don't reply to a mail of an already existing thread, startwith a new mail instead to keep threading meaningful. Otherwise your mail may get buried in the old thread and be overlooked at first sight. Thanks Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpwnBeNBsHh4.pgp Description: PGP signature
Re: [sc-dev] 2008 Q2 Review of Spreadsheet Project
Hi Leonard, On Friday, 2008-05-02 00:26:50 +0300, Leonard Mada wrote: 2.) TEXT-vs-NUMERIC Let's ask a simple question: I cannot hide my disappointment that no one did try to answer these questions. Well, your previous mail was dated May 1, I don't know about your country, but in Germany that's a public holiday and most people took an extra day off on Friday for a long weekend. Besides that I don't think that one should get disappointed just because a mail wasn't answered within one day. People have also other work to do. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgptykDJW63hK.pgp Description: PGP signature
[sc-dev] Vacation
Hi, I'll be on vacation until May 28, please have patience. Thanks Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgp1036yf68uI.pgp Description: PGP signature
Re: [sc-dev] Need help with error handling in interpr
Hi Regina, On Sunday, 2008-05-25 18:58:20 +0200, Regina Henschel wrote: SetError( errNoConvergence); [...] if (nGlobalError) OK, that's clear. I have used it now in the gamma function and it works. But what to do, if I detect a NoConvergence in a function, that is not member of ScInterpreter, like local functions which are used as helper? Make the helper function a private member function of class ScInterpreter. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpp46WcTIZcR.pgp Description: PGP signature
Re: [sc-dev] Issue 88967: PROB, FORECAST functions: scalar evaluation of array parameter
Hi David, On Wednesday, 2008-06-25 20:55:12 +0100, David King wrote: Say we have A1:C1 = {7|6|5} In cell A2 we enter, as an array formula: =PROB({5;6;7};{0.2;0.3;0.5};A1:C1) and, correctly, A2:C2 = {0.5|0.3|0.2}. Now in cell D4 we enter, as a normal (non-array) formula: =PROB({5;6;7};{0.2;0.3;0.5};A1:C1) Sorry, I misinterpreted the issue's description. Yes, indeed that should result in an error and not evaluate A1:C1 as array. I'll reopen the issue. I hold that the relevant part of ODFF is: 3.2 Non-Scalar Evaluation (aka 'Array expressions') snip 1)Normal evaluation in non-'array' mode does an implicit intersection of the argument with the expression's evaluation position. snip 1.1)References If the target reference is a row-vector (Nx1) use the value at the intersection of the evaluation position's column and the reference's row. in cell B2 : =ABS(A1:C1) = ABS(B1) if there is no intersection the result is #VALUE! in cell B4 : =ABS(A1:C1) = #VALUE! OK, clearly there's an error in this ODFF draft, because B4 intersects A1:C1 at cell B1. Let's say it should read in cell D4 : =ABS(A1:C1) = #VALUE! Thanks for the hint, I set that on the list of things to be corrected. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpyK3yvdgLTd.pgp Description: PGP signature
Re: [sc-dev] wrong display for special function result near 1
Hi Regina, On Wednesday, 2008-06-25 23:42:16 +0200, Regina Henschel wrote: I'm working on BETADIST. For certain inputs my version of that function returns a value, which is near to 1. The formula in the cell is =BETADIST(B$3;$B$1;$A8) with B3=0,999 and B1=1e-9 and A8=1,5. The result should be shown as 1,00E+000 but it is shown as 10,00E+000. I couldn't reproduce that, using a number format code 0.00E+000 Did you do something different? It is really a display problem and not a problem of my function, because the result of the formula =BETADIST(B$3;$B$1;$A8)+1 is correctly shown as 2,00E+000. To see the problem, you need my interpr3.cxx and the interpr6.cxx from cws DEV300/odff04. You cannot use the normal version, because there the function is not accurate enough to get that problem. I tried in odff04, no problem with Linux .pro and non-pro and Windows .pro builds. I have simulate the algorithm with MuPad, a high precision CAS. There I get the value 0.9993332933300668465 (first digits) for my result. But I don't know which value OOo has internally. For the raw unformatted result you could set a breakpoint where BETADIST pushes its value and display it in the debugger or analyze the IEEE 754 double bits. Does anyone know the reason or like to have a look at it or show me a way to get the root of the problem? If it turns out to be really a display problem, it's probably the number formatter to look at, svtools/source/numbers/zformat.cxx method SvNumberformat::GetOutputString(double fNumber,...) the case NUMBERFORMAT_SCIENTIFIC However, as I can't reproduce the problem here I'd consider that the very last resort. Maybe rebuilding the zformat.obj object file, linking and replacing svtmi.dll in the installation already helps? Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpQPnpaWFjQA.pgp Description: PGP signature
Re: [sc-dev] About i46681 and IF()
Hi Yue, On Thursday, 2008-06-26 16:56:14 +0800, Lvyue wrote: Really long time no see. :) Our network ultimately works today :-/, and I was sorry that we can not talk on IRC. No problem. We'll meet again next week. If you feel the need to discuss things in between, we could arrange some day where I could be available on the channel before I leave home. I have fixed the problem we mentioned on last IRC, and the work on i66930 is getting progress too. Fine, good to hear. but, seeing the code, I found 2 problems: 1. in sc\source\core\tool\interpr5.cxx, void ScInterpreter::ScMatRef(), the branch of if (ScMatrix::IsStringType( nMatValType)). I think we should do if (ScMatrix::IsEmptyPathType( nMatValType)) first, because of SC_MATVAL_EMPTYPATH = SC_MATVAL_EMPTY | 0x08, which means if value type is emptypath, ScMatrix::IsEmptyType( nMatValType) will also return true. Actually not, see scmatrix.hxx: /// Empty, but not empty path or any other type. inline static bool IsEmptyType( ScMatValType nType ) { return (nType SC_MATVAL_EMPTY) == SC_MATVAL_EMPTY; } /// Empty path, but not empty or any other type. inline static bool IsEmptyPathType( ScMatValType nType ) { return (nType SC_MATVAL_EMPTYPATH) == SC_MATVAL_EMPTYPATH; } 2. a question. also in ScMatRef(). pDok-GetNumberFormatInfo( nCurFmtType, nCurFmtIndex, aAdr, pCell ); nFuncFmtType = nCurFmtType; nFuncFmtIndex = nCurFmtIndex; my question is why we use that cell's type? if we need a value, but the cell's type is logical, the result would be wrong. Note that, unlike Excel, you can format any nmeric value as boolean, it displays FALSE for the value 0 and TRUE for any other value. Anyway, the inheritance indeed looks questionable. It is in there since times when we didn't have different value types in a matrix, probably for user convenience so a format set at the upper left cell is inherited. Which also isn't correct in all cases and would had to be overridden with a different format if needed. I'd suggest to remove that, but only for the matrix case, not the cell value in the if(!pMat) case. I guess it could even be replaced by setting a boolean number format type if ScMatrix::IsBooleanType( nMatValType) says so. However, for now please keep it and file a separate issue so we can properly track the change, as it would result in different behavior for already existing documents. For i46681 and i66930, later I will submit patches, before that I will test them. I know you are very busy now, you can take your time to reply, I'm not in a hury. :) Well, I'm taking my time today to do some administrative tasks waiting, including writing some mails ;) Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgp2mf5LrAMDd.pgp Description: PGP signature
Re: [sc-dev] wrong display for special function result near 1
Hi Niklas, On Thursday, 2008-06-26 14:30:11 +0200, Niklas Nebel wrote: Eike Rathke wrote: On Wednesday, 2008-06-25 23:42:16 +0200, Regina Henschel wrote: I'm working on BETADIST. For certain inputs my version of that function returns a value, which is near to 1. The formula in the cell is =BETADIST(B$3;$B$1;$A8) with B3=0,999 and B1=1e-9 and A8=1,5. The result should be shown as 1,00E+000 but it is shown as 10,00E+000. I couldn't reproduce that, using a number format code 0.00E+000 Did you do something different? I don't see it with BETADIST either, but with =1-7E-16 and that format code, on Windows and Solaris/Sparc, but not Linux. Lovely :-( I filed http://www.openoffice.org/issues/show_bug.cgi?id=91100 Thanks for reproducing. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpSWrnJ44cEB.pgp Description: PGP signature