[dba-dev] Re: How to refresh DataSourceBrowser in a FrameControl
Hi Fernand, I am afraid that the parameter stuff is not working at all oForm.setint(1,1000) should gives a value of 1000 to parameter 1 but this does nothing, the oform.parameters stay empty ? Hmm, this might be caused by some special implementation, seems to be some inconsistency here, indeed. and SQL is complaining about missing parameter value's Well - parameters are the means by which sub forms are implemented, so I am pretty sure they work in general. Not sure which concrete commands cause the problem in your scenario :-\ But passing a new command an reloading works like a charm... so we uses this workaround sucesfuly Fine :) Ciao Frank -- - To unsubscribe send email to dev-unsubscr...@dba.openoffice.org For additional commands send email to sy...@dba.openoffice.org with Subject: help
[dba-dev] Re: How to refresh DataSourceBrowser in a FrameControl
Hi Fernand, Point is : my Datsourcebrowser has no model ? Ah ... the pitfalls of the Basic UNO binding! The controller supports both the XController and XTabController interfaces, both have a getModel() method, so oController.getModel() (or oController.Model) is ambiguous in Basic. It is not defined (to my knowledge) to which of the methods this is resolved - seems to be XController.getModel(), which indeed returns NULL - which is expected, since the DataSourceBrowser does not have an associated document (which would be the XModel returned by XController.getModel()). Basic's syntax to access a method *with* specifying the interface it is defined at is oDataSourceBrowser.com_sun_star_awt_XTabController_getModel() Ciao Frank -- - To unsubscribe send email to dev-unsubscr...@dba.openoffice.org For additional commands send email to sy...@dba.openoffice.org with Subject: help
[dba-dev] Re: staus of bugfixes toward OOo 3.4 and dev300: cws fs34b and fs34c, fs35a, hsqldb19
Hi Zoltán, I know correctly that the latest integrated into m106 database connected cws was dba34d. The fs34b in finished status, and fs34 fixed two issue and still open, the hsqldb19 approved by QA still wait for DEV300 integration. In EIS i found that is nmerged to cws dba34d: No, it is the other way 'round: dba34d was merged into fs34b. Sorry, my wording in EIS could have been better :) But I fuond in OOO340m0/DEV300m106 that for example, bug 117454 old report, and bug 117472 is still in. That means fs34b not merged correctly. Not sure at the moment what the finished status for fs34b is supposed to tell us - at least it implies not integrated, yet. http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Id=10194logon=trueOpenOnly=falseTasksInline=falseSection=Overview says that fs34b is in status integrated, but the Milestone (integrated) field is empty - this means that the milestone which the CWS has been integrated into has not been finished, but is ongoing - which means the CWS will be in OOO340.m1. If it were in OOO320.m0, then the Milestone (integrated) field would be filled, since m0 is done already. So, the bottom line is: No surprise that fs34b's bugs are not fixed in m0, expect the fixes for m1. As far as I know, m1 has been built already, or at least it was started (since I got questions 'bout some build breakers caused by a flawed integration of another CWS of mine :) ). Not sure whether it is finished. Also, I don't know the timeline for the upcoming builds, but I know that I am not the only one who thinks we (whatever we means in this context) should at least release a proper 3.4. But again, there's still some dust in the air, which might need to settle beforehand ... Ciao Frank -- - To unsubscribe send email to dev-unsubscr...@dba.openoffice.org For additional commands send email to sy...@dba.openoffice.org with Subject: help
[dba-dev] Re: staus of bugfixes toward OOo 3.4 and dev300: cws fs34b and fs34c, fs35a, hsqldb19
Hi Zoltán, the hsqldb19 approved by QA still wait for DEV300 integration. forgot to answer the hsqldb19 part ... As far as I know, the original goal was to integrate hsqldb19 into 3.4, if possible. Not sure what got of this idea, since EIS currently says Release = OOo 3.5, it might have changed. Ocke should know the details. From what I know, it is still worth pursuing a 3.4 target for the CWS, at least because it is certainly desirable for the HSQL project. On the other hand, the radical change in the CWS (moving to HSQLDB 2) is certainly a risk for 3.4 - and while you and Ocke did a great job in finding and fixing zillions of bugs already, there might be more, undiscovered so far - and if they were to go into OOO340, it might be hard to fix them in time for the release. Ciao Frank -- - To unsubscribe send email to dev-unsubscr...@dba.openoffice.org For additional commands send email to sy...@dba.openoffice.org with Subject: help
[dba-dev] Re: How to refresh DataSourceBrowser in a FrameControl
Hello Fernand, I try to use the com.sun.star.frame.FrameControl in a dialog acting as a subforms'. So i have 2 Framecontrol's loaded with a dataSource browser based on a SQL-statement When selecting a row in the first FrameControl the data in the second must been refreshed (passing a new SQL-statementto the second Framecontrol). I found no way to do that because the activeCommand off the Resultset is readonly. The DataSourceBrowser supports the css.form.FormController service, thus a css.form.XFormController interface, so the getModel method will return the css.form.component.DataForm which represents the data. This, in turn, has a css.form.XLoadable interface, which supports a reload method. So, something like oDataSourceBrowser.getModel().reload() should do (assuming that oDataSourceBrowser is the controller loaded into your Grid2 control). Ciao Frank -- - To unsubscribe send email to dev-unsubscr...@dba.openoffice.org For additional commands send email to sy...@dba.openoffice.org with Subject: help
[dba-dev] Re: OpenOffice Internship-2011
Hello Amit, I am Amit Pal a undergraduate student from IT-BHU, majoring in computer science and eng. I want to be a part of summer internship 2011. I will be very glad if you tell me the procedure. I am new here Hmm, I don't know about any internship program 2011, and given the recent changes in the project, I doubt there will be one soon. We'll have to wait 'til the dust has settled, to see whether there will be any such program under Apache's (OOo is a Apache Incubator project by now) supervision. Ciao Frank -- - To unsubscribe send email to dev-unsubscr...@dba.openoffice.org For additional commands send email to sy...@dba.openoffice.org with Subject: help
[dba-dev] Re: Shared Library registration with regcomp
Hi Rohit, I am trying to register the library (.so) file for the example skeleton sdbc driver using regcomp tool into the services.rdb file. When I try to register the shared library in connection/unxlngi6.pro/lib I suppose you mean connectivity/unxlngi6.pro/lib here, i.e. the local output tree of the connectivity module? http://unxlngi6.pro/lib directory it fails giving CannotRegisterImplementationException exception. However during the build process this library is copied into 'solver//330/unxlngi6.pro http://unxlngi6.pro directory and when I try to register this file it succeeds ! Could anyone tell me what changes happen to the library files during build process when they are copied into the solver directory? I suppose this is a LD_LIBRARY_PATH problem: your library is probably linked against other libraries from URE (the UNO runtime environment), which, in a complete build, also reside in $SOLVER/330/unxlngi6.pro/lib. So, if your library resides there, too, and your LD_LIBRARY_PATH contains ., then loading the lib succeeds. Loading the lib in the local output tree doesn't succeed, since the loader doesn't find the URE libs there. To verify this, try ldd lib_name to see which libs your actual lib needs, and whether the loader finds them. My problem is that the my sdbc driver library is supposed to implement com.sun.star.sdbc.Driver service but when I register it from solver it is implementing some strange services like com.sun.star.comp.svl.PathService and com.sun.star.uno.util.numbers.SvNumberFormatterServiceObject hence I am wondering if something is changing the library during the build process. This means that you don't export the proper symbols from your library, which most probably means your map file is wrong. Look into an other driver's makefile.mk, search for a directive referring to a file component.map, and copy this for your driver. Background: since your driver doesn't export the necessary component_* functions, which are looked by by the UNO component registration process, those functions are taken from another (random) library which your actual library links to. And those other functions, in your case obviously originating from the libsvl* library, write their very UNO component information. Note that what you're doing is a component with so-called active registration, which is deprecated. Passive registration is to be preferred nowadays, it means that instead of adding (active) code to your library which describes the UNO components it exports, you place an XML file near your lib, and describe the components therein. See http://wiki.services.openoffice.org/wiki/Passive_Component_Registration for details. This completely avoids the regcomp stuff, though at the moment, I am not sure how to integrate those passive registration into the build/deployment process. I think you can learn from other modules here, too - VCL comes to mind, look into vcl/util/vcl.component, and how it is used. HTH Ciao Frank -- - To unsubscribe send email to dev-unsubscr...@dba.openoffice.org For additional commands send email to sy...@dba.openoffice.org with Subject: help
[dba-dev] Re: Opening forms in m105
Hi Peter, my forms are not readable anymore (really ugly). That seems due the fact that forms are now opened in printlayout instead of weblayout, but: shouldn't forms created in weblayout continue to open in weblayout? Otherwise all those forms have to be edited oncemore, and people who don't know about this fact may think 3.4 is buggy. For new forms this is ok. What's the reason (issue) for this change? One of those nasty things called bug: http://openoffice.org/bugzilla/show_bug.cgi?id=117545 Ciao Frank -- - To unsubscribe send email to dev-unsubscr...@dba.openoffice.org For additional commands send email to sy...@dba.openoffice.org with Subject: help
[dba-dev] Re: Form wizard changed views?
Hello Zoltán, Two other options, Columnar Labels on Top, and Columnar Labels Left inserts some controls into the form, in way that the controls placed wrongly, not fully within the form, hang out, the field starts in page, but ends out of the page. When investigated further I found changes in form final format, until now the form wizard created forms in web layout, now the form created in print layout, and consequently the the above two settings creates form in weblayout and places correctly within their limits, but the form saved in print layout, and some controls hangs out. In the earlier versions until 3.3 I could switch between print/web layout in data input mode, now this is impossible and form stays in print mode, which is not wrong. users prints forms as reports very often, and usage of web layout in past caused misunderstanding. I have no earlier information about this change, i think no others have this info. My question is that, reopen this bug to fix two other settings in print layout, or submit a new bug. Or this default form layout change was unintentional? To me it looks as if the online layout broke somehow. Normally, Base, at least when opening a form in edit mode, explicitly switches the document view to Web Layout. That was considered a feature so far, not a bug :) This does not seem to work in m103: Initially, forms come up in Print Layout, then you can toggle the mode between Print Layout and Web Layout, and the next form opens in the same mode in which you closed your last form. Now known as http://openoffice.org/bugzilla/show_bug.cgi?id=117545. Ciao Frank -- - To unsubscribe send email to dev-unsubscr...@dba.openoffice.org For additional commands send email to sy...@dba.openoffice.org with Subject: help
[dba-dev] Re: Reports in m102 don't work
Hi Peter, seems the classical Report doesn't work in m102 anymore. Known issue? for the record: submitted (by you) as bug 117454, will be fixed in CWS fs34b, target OOo 3.4. Thanks Ciao Frank -- ORACLE Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com Oracle Office Productivity: http://www.oracle.com/office -- - To unsubscribe send email to dev-unsubscr...@dba.openoffice.org For additional commands send email to sy...@dba.openoffice.org with Subject: help
[dba-dev] Re: Next record in form navigation bar
Hi Peter, if I step to the last record, shouldn't the button Next Record then not be disabled? There's a button New Record for this purpose. Often it happens, that the Next Record button is accidentally pushed after the last record in a filtered recordset. Well, the idea here is (and that's basically an assumption of mine, the behavior is that way for longer than I work on the product) that the insertion row is a virtual (n+1)'th row of our form, so pressing next repeatedly lets you travel through all those n+1 records. Whether or not this is a good user experience - phh. Personally, I never considered it problematic. But my gut feeling is that's question pretty hard to decide. Ciao Frank -- ORACLE Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com Oracle Office Productivity: http://www.oracle.com/office -- To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: sy...@dba.openoffice.org with Subject: help
Re: [dba-dev] Changes to DB are not persistent
Hi Daniel, The code is adding a row to a database (Base-Document with embedded HSQL-DB) every time it gets called. However the changes are lost after closing OOO. To make them permanent it's necessary to flush() the DataSource. First question: This is not exspected bahaviour, is it? Changes should be persistently saved without calling flush(), or am I wrong? Well ... the problem with the ZIP-file approach of ODBs is that it is impossible to immediately write all changes you did to the file. (Anybody wishing to start a discussion how this violates fundamental database principles ... please direct your concerns to the ODF faction. I'd be grateful for any assistance in explaining why ZIP as a database backend is a joke, at best.) That's basically a question of performance. So, some kind of flushing is necessary. This is inconvenient, but in the above sense, expected behavior. However, note that your macro contains a resource leak, in that it retrieves a connection, which it does not dispose afterwards - at the very end of the Sub, you should have a Connection.close() This should free the resources associated with the connection, and at the same time flush its changes. But the trouble gets worse... The flush() - workaround works fine on Linux (Using OOO 3.2.1 and 2.4 on Debian), but it crashes OOO 3.2.1 on Windows (XP) ungracefully. If you can create a small self-contained .odb (including the macro) showing this, please submit an issue at http://www.openoffice.org/issues/enter_bug.cgi?component=Database%20access. Feel free to assign it to me (fs). Ciao Frank -- ORACLE Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com Oracle Office Productivity: http://www.oracle.com/office - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Multiple issues with Calc and JDBC-Oracle queries to large tables
Hello Alexander, Accessing a few thousand rows works just fine, however, I got one table with about 1.2 mio. rows at 11 columns. ... OK, I'm not sure if Calc was made for my certain usecase or for that much data at all - but I thought I'll give you a hint that issues exists. Honestly, accessing 1.2 mio. rows is ... stretching Base's limits. I am not surprised at all OOo doesn't handle this - I don't think our code base is prepared for that stunning amount of data. So, what should I be supplying for a bug report? And against what stream should I write a report? You might want to submit a report at http://qa.openoffice.org/issue_handling/pre_submission.html. Though the reality is that allowing OOo to cope with that kind of data might require a major overhaul, which will not be done without a pressing need - which makes it rather unlikely that the problem will be fixed in a foreseeable future. Ciao Frank -- ORACLE Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com Oracle Office Productivity: http://www.oracle.com/office - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] issue 112706: can I help?
Hi Terry, apologies for us ignoring your question for so long ... I don't really have good excuse except laziness or something equally ... self-bashing, so I don't even try ... Just in case you're still interested in a response: OResultSet::move fails to find a matching bookmark (after 0 interations through the loop starting at line 1600) and raises the assertion. I think this points to the problem here. Well, into its direction, at least. m_aPosToBookmarks is expected to be filled by this method, too. I'd expect to find calls to OResultSet::move with a FIRST and possibly subsequent NEXT parameters. In those calls, the map should be filled. If the method is not called, then it could mean the method is not called - in this case, the problem lies up the stack, again. If the method is called, but the bookmark map is not filled (which I assume), this would mean that m_nUseBookmarks is SQL_UB_OFF. This parameter is set in Statement::setUsingBookmarks. Since OResultSet::move is called with a bookmark request, this means the layers above it assume the result set supports bookmarks - which means they also should have called setUsingBookmarks on the respective statement. If they *did* call it, with the proper value, but subsequently, the ODBC driver returns another value, this means that either setUsingBookmarks didn't deliver the wrong result to its caller (no success), or the caller didn't respect the result, or the ODBC driver didn't deliver the proper result. If setUsingBookmarks has not been called before, then again the bug is in the upper layers, I'd say - since then they're requesting bookmark-based movement from the result set without enabling bookmarks at the statement. So, those would be the next things you could check: Is m_aPosToBookmarks filled? If not - why? Is setUsingBookmarks called? With which parameters, and which result? Does the value passed to setUsingBookmarks match to what later on is retrieved to initialize m_nUseBookmarks? HTH Ciao Frank - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] postgres ODBC problem with view
Hi Josh, If so, that's rather problematic. The CTID is a physical pointer ID, and as such can change out from under a current session if there are concurrent updates. Using the CTID to grab rows could result in errors or even seeing expired data. Which means SCOPE would be something other than bestRowSession - and the bug on OOo side would be to use CTID for the given purpose nonetheless. @Zoltan: Care to submit an issue? Ciao Frank -- ORACLE Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com Oracle Office Productivity: http://www.oracle.com/office - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] How to pass password when opening DatasourceBrowser
Hi Fernand, You clueless, thats new for me :-) Damn, that slipped my attention, normally I do not admit that :) I am still convinced thats your machine knows the Username and passwords, or your sytem is never asking for it :-) ? If I replace the getConnection call to create the connection with connectWithCompletion, then it actually asks for the user/password - so: no, that's not the difference :) Ciao Frank -- ORACLE Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com Oracle Office Productivity: http://www.oracle.com/office - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] How to pass password when opening DatasourceBrowser
Hi Fernand, Is your oconn object, by any chance, invalid? I can Xray it and it shows all details according to the wanted connection, so ?? only passing the password to the com.sun.star.comp.dba.ODatabaseSource password property works for me I'm clueless than :( Ciao Frank -- ORACLE Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com Oracle Office Productivity: http://www.oracle.com/office - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] How to pass password when opening DatasourceBrowser
Hi Fernand, Are you sure you didn' tryed with user/password before you tryed the activeconnection, because OO remembers the connection made by user/password ? Yes. The code who works but is asking for User and pasdword: Dim aProps(7) as New com.sun.star.beans.PropertyValue aProps(0).Name = DataSourceName aProps(0).Value = mysql_native ' deze naam moet dus GEREGISTREERD ZIJN als Database in OO aProps(1).Name = CommandType aProps(1).Value = 0 aProps(2).Name = Command aprops(2).value = pmgdbase.mag_news_export The code who do not works : oDB = CreateUnoService(com.sun.star.sdb.DatabaseContext) oConn = oDB.GetByName(mysql_native).GetConnection(user,password) ' xray oconn Dim aProps(7) as New com.sun.star.beans.PropertyValue aProps(0).Name = ActiveConnection aProps(0).Value = oconn aProps(1).Name = CommandType aProps(1).Value = 0 ' 0 = tabel , 1 = query , 2 = SQL statement aProps(2).Name = Command aprops(2).value = pmgdbase.mag_news_export One difference I see here is that you do *not* pass the DataSourceName in the second case (my macro here does). This might make the difference - can you try passing it, additional to the ActiveConnection? Is your oconn object, by any chance, invalid? Ciao Frank -- ORACLE Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com Oracle Office Productivity: http://www.oracle.com/office - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] LDAP-Mapping
Hi Thomas, I cannot find any way to change LDAP-mapping in OO 3.2.1 (OpenLDAP). In Thunderbird I can map every field successful with user.js. For OO I did this: http://docs.sun.com/app/docs/doc/817-7496/fjdcg?a=view - LDAP.xcu i.e. with Mapping: valuemapping/value - mapping-attr.map i.e. with this: org.openoffice.UserProfile/Data/c = registeredAddress I don't get any data from registeredAddress. I can change whatever I want from fields used in UserProfile.xcs, there is no change... I am also confused about this fields (- fields in UserProfile.xcs ?): http://dba.openoffice.org/FAQ/LDAP_field_mapping.html Any idea, what I am doing wrong? First, you're mixing up two different things :) The documentation at docs.sun.com talks about user profile data in a multi-user installation of StarOffice. LDAP_field_mapping.html talks about the field mapping used by the LDAP address book driver. I suppose the latter - LDAP address book access - is what you're interested in, really. Then the second problem is that LDAP_field_mapping.html is out of date :-\ Since LDAP address book access is implemented using Mozilla code, tweaking the mapping is two-step: First, locate mailnews.js in your installation: It controls how the Mozilla code translates LDAP fields into programmatic address book fields. Second (and probably optional), the org.openoffice.Office.DataAccess configuration (in a DataAccess.xcu file somewhere deep in the share folder in your installation, but also and preferably accessible programmatically) maps programmatic address book field names to UI column names. Those two together should give you control over what LDAP fields are actually displayed, and how. Ciao Frank -- ORACLE Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com Oracle Office Productivity: http://www.oracle.com/office Komplementärin: ORACLE Deutschland Verwaltung B.V. Rijnzathe 6, 3454PV De Meern, Niederlande Handelsregister der Handelskammer Midden-Niederlande, Nr. 30143697 Geschäftsführer: Jürgen Kunz, Marcel van de Molen, Alexander van der Ven - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] ResultSetType Settings in Openoffice Base
Hello Asli, I am currently developing a DB project and I have implemented a database with IBM DB2 and connected it with jcc driver to Openoffice base. I had problems with join queries of several tables. I searched in the source code of oo and in the internet, and I realized that the error arises from ResultSet settings, which are set to TYPE_SCROLL_SENSITIVE, default by openoffice. In order to display the results for a join query, resultSetType should be TYPE_SCROLL_INSENSITIVE. Hmm, I answered this a few days ago over there in us...@dba, but even the web archive at http://dba.openoffice.org/servlets/BrowseList?listName=usersby=datefrom=2010-09-01to=2010-09-30first=1count=8 is missing it, so perhaps it got lost ... Here's my original answer: You should not tamper with the content.xml, instead, set the value programmatically. For this, execute the following macro in the context of your .odb file: Dim settings as Object settings = ThisDatabaseDocument.DataSource.Settings settings.RespectDriverResultSetType = TRUE ThisDatabaseDocument.store This tells Base to be less optimistic with its result set settings. That is, normally Base assumes that it can use the most aggressive result set type/concurrency, and that a database driver will silently downgrade this to what it supports. However, some drivers (and at least IBM's Universe drivers fall into this category) do no silent downgrade, but instead produce an error. In those cases, RespectDriverResultSetType tells Base to ask the driver for the supported types. However, also note that there are known drivers where this setting doesn't work, simply because the driver itself lies about its supported types. Again, some versions of IBM's Universe JDBC drivers fall into this category. So, you simply need to try out whether this setting really helps you. Ciao Frank -- ORACLE Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com Oracle Office Productivity: http://www.oracle.com/office - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Reopen issue or submit new one?
Hi Zoltán, After solving issue 113583 in fs33a, OOo still crashing with Charts. The chart change saving part solved in this issue, but some hanging or crashing not. Opened existing charts some of them worked without problem, but 3D Bar chart and XY charts not picked up fully source data. They showed as Colums1, Column2, Column3, and not contain any data created empty Chart. After editing create normal Chart. Some cases you can not go into Chart area with Double click, OOo hangs or Crashes, no crahsreporter working I created screencast. While symptoms - crashes and wrong data - are still there, the reason why the issues was not completely fixed might be exactly because it mixes different problems. So perhaps it's better to submit separate issues, with one issue describing exactly one problem (the crash, the non-working chart activation, the wrong data). Ciao Frank -- ORACLE Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com Oracle Office Productivity: http://www.oracle.com/office - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Report Wizard Modules
Hi Drew, If anyone happens to have this off the top of their head. which source modules would one look at to find the code for the Report Wizard functionality? All in module wizards. The UI, together with the backend implementation for text-based reports, is in wizards/com/sun/star/wizard/report. The backend implementation for ReportBuilder-reports is in wizards/com/sun/star/wizard/reportbuilder. Ciao Frank -- ORACLE Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com Oracle Office Productivity: http://www.oracle.com/office - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Report Builder Roadmap
Hi Drew, I think that these are implemented: - Rub Reports (partial) I know I'm somewhat out of business with regard to Base and the Report Builder, but I can't remember having seen sub reports :) - Repeatable Group Footer - Hyperlink Controls ditto - Multi-Column support ditto Ciao Frank -- ORACLE Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com Oracle Office Productivity: http://www.oracle.com/office - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] What to do with old type of report issues
Zoltán, From time to time issues coming out with old type of reports. I know that SRB/ORB integration stopped for unknown/possible licensing issues. ? The Report Builder will continue to be available for download, so ...? What will be happens with the open issues of old reports. What to do if new problems arises, confirm it and assign developer who will not correct the problem. Or keep unconfirmed. Targeting to OOo Later would be the most honest thing, I'd say. Ciao Frank - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Anyone on the Base team from Oracle in the office
Hi Drew, There are issues coming in that really look like show stoppers - but a waste of time to send email to release team without anyone in Hamburg to comment on the effort to fix. Ocke will still be on vacation for a while. I'll spend a few cycles for Base, but (sadly) not starting immediately. It might be good if you people collect a list of issues you consider a stopper, and start raising them at relea...@ooo (if not already done so), even if dev cannot comment on the effort so far. Better building early pressure (as it would also help priorizing, ehm, my assignments :) ). Ciao Frank back from vacation the first day. Sorry, /[s|c]ould/ have announced here. - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] MySQL Connector - alive?
Hi Andrew, Wondering if anyone has any information at all about the connector? The main extension site is still holding version 1.0.1 from 2009. The qa-upload alpha verson hasn't updated since Jan 2010 Conanical and OpenSUSE are including 1.0.1 in the repositories. So what's up with this, anyone know anything? There have been minor changes since 1.0.0, which led us to increasing the number for 1.0.1. Those changes are not relevant to functionality (except that in one case, it /could/ fix the localhost problem we were not able to reproduce reliably), but more about adding correct RPATHs to the libs, and technical stuff like that. At the time of 3.3, there should be a 1.0.1 release. Distros include 1.0.1 since they usually take the version from the main trunk, which already is 1.0.1. Ciao Frank -- ORACLE Frank Schönheit | Software Engineer | frank.schoenh...@oracle.com Oracle Office Productivity: http://www.oracle.com/office - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Recovery process
Hi Peter, seems the recovery process for base has some shortcomings yet. Neither a created report nor the basic code is restored after crashing and starting the recovery (WinXP and m6). Hmm ... nor the Basic code? Do you mean that the Basic embedded in your .odb is lost after a crash/recovery? That shouldn't happen at all - is this reproducible? Ciao Frank - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] KOI8-U issue
Hello Alexender, Hello!!! I am from Ukraine and I have found that in KOI8-U database is not correct display some symbols Example: when i send the query or browse the table i get not correct letter і in word Ав╕ац╕йна must be 'Авіаційна' Do you use the integrated HSQLDB database, or do you connect to some other database (e.g. MySQL)? Also, how did you enter the texts into the database - using OOo, or using another tool? Ciao Frank - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Opening a GridControl in a UNO Dialog
Hi Noel, hmm, looks like I lied, there is persistence of sorts, e.g. going from the filter to the dialog it seems the state of the dialog is transferred via the dialog stream so it looks like that I have already introduced some 'unofficial' attributes to support this, Ouch. extending the ODF file format - and I think that the dialog descriptions are part of ODF, too - is asking for trouble. Well, for a lot of work, at least :-\ but like I said, I am not happy to upstream the current scheme and it is not usable in the broader openoffice generic sense. This is the part would to be ironed out as part of upstreaming, I would be happy with your input/help on that. Sure, let's see how far we can get there. Thanks Ciao Frank - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Opening a GridControl in a UNO Dialog
Hi Noel, Andreas knows ( I'll ask him ) confirmation received, neither the dialog or basic streams are ODF ( /me phews a sigh of relief ) /me too :) Ciao Frank - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
[dba-dev] vacation notice
Hi, during the next three weeks, you won't read anything from me in this list, as I'll be on vacation, and hardly be able to access the internet. You probably won't be able to discern this phase from any other three-week phase of silence of mine, but I thought I nonetheless mention it ... Have fun, but don't write too many issues and mails in this time, they all add to the backlog I have to work off after the vacation :) Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] DisposedException - EOF reached
Hi René, Yes, I already found out what IIRC meant. :-) I'm not of the sms generation! I definitely do not belong into this generation either :) I indeed played with the code and during my attempts removed registerObject. I believed it was not so important where this was done Correct. When I restore them BEFORE the props.setPropertyValue (the original position), then I get the errormessage: IllegalArgumentException; the datasource was not stored. Use the interface XStorable to store the data source. Ah, that's something I indeed wondered about, registering should not succeed without the document being stored. So, the error you describe here is completely correct. When I move the same lines AFTER the props.setPropertyValue, then I get the earlier DisposedException - closeConnection message. Quite confusing. Do you have a JAR or your modified sources you could send me (to the sender address of this mail), so I cann have a look at this? Please no fancy 3-pagers of how to set this up, something which runs out of the box and hits the problem would be really nice :) Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] OO database sort problem
Hi Fernand, I suppose Robby is pointing to the use of the filterering who have a bug when making a filter with the GUI OO produce SQL a statement like SELECT * FROM pmgdbase.tbl_leveranciers WHERE ( pmgdbase.tbl_leveranciers.Uithangbord = 'alphadent' ) This gives a error because pmgdbase.tbl_leveranciers, must been pmgdbase.tbl_leveranciers Same behavior when using the filter in a form I filled already a related Issue http://qa.openoffice.org/issues/show_bug.cgi?id=102793 for it Hmm, 102793 does not seem to describe the quoting problem from above, sounds like two different problems. 102793 slipped my attention so far, will have a look. For the first problem: Which database? Which driver? Does somebody know an issue for this, too? Thanks Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] OO database sort problem
Hi Fernand, For the first problem: Which database? MySql native connector Hmm, cannot reproduce. Can you give us a table dump (structure only is sufficient)? Thanks Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] OO database sort problem
Hi Robby, I have been an OO user for years and mostly love your package, however I recently ran up against the sort bug in OO 3.1.0 Base. Excuse my ignorance, but what exactly is the sort bug in OO 3.1.0 Base? Thanks Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] How can I store the default values and column descriptions in odb file?
Hi Michael, I would like to store default values and the column descriptions in the odb files as we do not fully support them in the database. Is it right that base can do this for us or must the driver implement the functionality to store the values in the odb files? I have neither an idea how to tell base to do this for me nor how to do it my self in the driver :( The driver does not need to know about this at all. Assuming that we talk about the ControlDefault as mentioned by Ocke (the DefaultValue is effectively unused), this should work automatically: The table design fills the property with what you enter there, the ODB export filter retrieves and writes it. Uhm, trying that with an embedded HSQLDB in OOo 3.1 it seems this isn't the case ... need to verify that, but it seems that's a general problem then. For the description, the same holds: this shouldn't be a concern of your driver at all, it should all be held in higher layers. (And here it even worked for me with embedded HSQLDB.) So, if with your driver, this is lost, I cannot really think of a reason. However, the object hierarchy in dbaccess/source/core/api is rather complex, and Ocke knows more about this than I do. Perhaps depending on certain characteristics of your driver, the wrapper code behaves differently/wrong. I suggest you start debugging this in dbaccess/source/ui/tabledesign, OTableEditorCtrl::SaveData. Check whether the description is properly propagated there. Then, in TableController::alterColumns, check whether the proper description is set as PROPERTY_HELPTEXT at the column, and, more interesting, where this setPropertyValue call actually arrives - which class implements this property? Compare this with ODBExport::exportColumns in dbaccess/source/filter/xml: There's a getPropertyValue( HELPTEXT ) call - where does it arrive, ultimately? Which implementation provides this value? (Compiling comphelper/source/property/* and cppuhelper/source/propshlp.cxx with debug=1 might come handy, to be able to step through all involved property set helper classes.) Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] sun-report-builder-alpha-1.1.1.m49 and DEV300m50
Hi Zoltán, I tried the SRB alpha 1.1.1 from qa-upload with m50, and found unusable on report wizard. Creates empty report in m50, but works correctly in m49. When click to second steps (labels) SRB hang, if I click on next 3 times after ~40s suddenly go to step 5. When I click on finish, creates empty report, with bot option (create or edit). Without investigating this: m50 had a P1 (102701) which can manifest in a lot of different ways. Basically every feature which uses OOo's storage format for writing files can be affected - and creating reports (by wizard or manually) falls into this category. So, I would recommend wiping m50 from your disc completely, and waiting for m51. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] OpenOffice accessing Access 2007 database under Vista SP2
Hi Rob, I wonder if you can help me. I am trying to read an Access 2007 database from OpenOffice 3.1 on a computer running MS Windows Vista SP2 I am getting an error The connection to the data source could not be established. Function sequence error Unfortunately, Function sequence error is some generic error message which barely tells anything, except that the driver is not in the state it expected to be. If you have sample .accdb and .odb files, and submit an issue, attaching those files, we can investigate the problem. I have researched the internet to find that I need to install 2007 Office System Driver: Data Connectivity Components from http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891displaylang=en (If you hadn't installed those, you should have got another error message. Hmm.) Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Table wizard quirks OOo dev 3.2 m47 (partof SRB for ...)
Hi Zoltan, for the record: On linux m47 still installed, submitted issue: http://www.openoffice.org/issues/show_bug.cgi?id=102450 meanwhile resolved as duplicate of issue 102436 (as you can see from the number, this is pretty recent, too). Thanks a lot for submitting the issue, even though we found out it's a duplicate - using your files in a debug build of OOo tremendously helped to prove that's a duplicate of the above issue. Thanks Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Table wizard quirks OOo dev 3.2 m47 (partof SRB for ...)
Hi Zoltán, From my earlier mail: 1. in table wizard, the personal and bussiness categories content changed with each other, you can find for example CD-Collection in bussiness category. (in both win/linux) I logged out stated new session on linux, same error. Meanwhile known as issue 102019. 2. form wizard when you finished creation, with option work with the form, window closes and not opens back, and not saves into Form area - Form lost. (On linux version caused OOo crash) If you select edit mode, the form opens in edit mode and saves into Form area. (On linux/rpm version caused OOo crash) In this part I made some more observation, it is only happens when creates new table with wizard as in first step. If you create table in design mode forms works as needed. Hmm, cannot reproduce. Creating a ¨Assets¨ table with the table wizard, and subsequently letting the wizard create a form for the table (where the form wizard is started by the table wizard, by checking the proper option on the last page of the table wizard), using all default options of both wizards, works like a charm here. If you creates tables with wizard, and after form with wizard, form cause crash on linux, on win not crate form. It is independent from file creation, it is happens with newly created file or with old file. Crash reports: rvpfwvc and r5pfwvc. Those reports indicate that the crash happens while the generated form document is being loaded. Could you please try the following: Repeat what you did, and at the very moment OOo crashs (and the crash reporter dialog is still open): check your /tmp path for the most recent files. Most probably, you'll find a document named similar to the form you just created. Try copying this file to another location, before closing the dialog in OOo. Then, when OOo restarts, try opening the file - if this crashes, too, then you could send me the file (or submit an issue for it yourself). Thanks Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] 2 Strings appearing in English in Base UI
Hi Sophie, For the background: Those strings were added after the localization freeze, but I wanted to have the feature in, so I decided we can go without a localization for 3.1. But don't tell anybody ;) I promise that the next bug dedicated to you will be written in this language : Ningalkku njan paranjathu manasilakunnille? ;-) I usually ignore all non-English bugs :) Perhaps next time I do such a nasty thing, I will hard-wire the French and German translations in the code. All other NL communities either never notice, or never complain :) Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Some issues on 3.1.0 with macros
Hi Ariel, -- * Create a new database document (menu File - New - Database) * Create a new macro (menu Tools - Marcos - Organize macros - OOo Basic, then select the ODB, and press the New button) * Write a dummy macro * try to execute it You get a macro warning (I my case I set security to Medium level). Now known as issue 102139. css::container::XHierarchicalNameAccess::getByHierarchicalName() does not work * create two forms: Form1 Folder1/Form1 * The following (also attached, may it passes to the mailing list) opens Form1 when trying to open Folder1/Form1 Cannot reproduce. OOO310.m11, WinXP. Hmm, admittedly StarOffice instead of OpenOffice.org, but I doubt this makes a difference. - css::sdb::XSubDocument::open() does not work when the subdocument has no form at all (this happens on OOO310_m11 but not in DEV300_m47): Cannot reproduce, too. Which platform? Sure you used m11 and not some intermediate version? Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Open database document from beamer - Bad Beamer.
Hi Fernand, Can I suppose that 100764 http://qa.openoffice.org/issues/show_bug.cgi?id=100764 is a duplicate and is also been fixed now ? Uhm, no, this sounds like a completely different issue to me, of which I wasn't aware so far. Will have to investigate. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Open database document from beamer - Bad Beamer.
Hi Drew, Yes, it is the same with Linux. http://www.openoffice.org/issues/show_bug.cgi?id=100956 Thanks for finding and reporting this. Interesting bug, from a technical point of view :). Fixed. For 3.1, hopefully. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] i99686 and srb 1.1.0 Beta
Hi Zoltán, I tried to check issue 99686 (http://qa.openoffice.org/issues/show_bug.cgi?id=99686), issued by me, in DEV310m7, and it failed to show pictures in report. I used SRB 1.1.0.beta (2009.03.09, from qa upload server), it raised question, I need to use another version? The fix for issue 99686 was (at least in parts) in the extension, so the old beta does not contain it. I uploaded a new version (Beta 2) to ftp://qa-upload.services.openoffice.org/SRB, however did not try it, yet. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Need i-team for specification [was [dba-dev] New Filter Dialog]
Hi Karl, There does not seem to be much interest in ux and qa... :-( As Liz said, it might indeed be possible that especially UX is on the Cebit ... I have finished a first version of a specification. Lots of details are still missing. I didn't pay, for example, any attention to accessibility yet. However, the first version has enough content (23 pages) to see how I think the new filter dialogue could -- and should -- work. Before I continue, I would like to get some feedback. Maybe my ideas are in complete disagreement with the expectations of the community. So how should we proceed? Shall I stop and move the first version to /dev/null since I do not have a complete i-team, or should I upload it somewhere and wait for being bashed? ;-) The latter :) In case you suggest the latter, how and where should this version of the spec be announced? Did you do this as Writer doc, or do you plan to do it in the Wiki? In the first case, you should find a place. For announcements, annou...@specs.openoffice.org is the ... intended place, though ... I've rarely seen anybody using it, so I in fact suggest to do the announcement in us...@dba and disc...@ux (though feedback/discussion should happen in one list only, us...@dba preferrably). Anyway, I think I should stop now and wait for feedback. Thanks Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Macro Migration Remarks
Hi Fernand, I did the migration from 2.4 to 3.1 (latest snapshot m3)off a complex db-doc with 2 forms containing several libraries with soem dialogs in it. Everyting went extremly well :-) Fine :) well execpted The names of the libraries are changed to a combination off the original librarie name and the name off the form. This renaming, however, is not done in the basic code lines like loading dialoglibraries the load point still to the original dialoglibrary. The renaming is also not done in the basicdialog-control-events who stay pointed to the original macro ibrary names Do not know if this is a wanted behaviour or I should make a issue off it ? http://wiki.services.openoffice.org/wiki/Macros_in_Database_Documents#Migrate Adjusting the names in the Basic code is up to impossible (when we want to do it correctly, without replacing the wrong tokens), without actually running the macro in a sandbox, thus it was not implemented. The dialog events - uhm, as the specification proves, those have been *completely* forgotten. Shame on me! (and the reviewers of the spec :) So, please write an issue for the latter - ideally with a sample document, as always. Thanks Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Need i-team for specification [was [dba-dev] New Filter Dialog]
Hi Karl, So please read on, as I need a member of dev, ux and qa. I might not have all the necessary time, but if nobody else volunteers for the dev part, then count me in. (But be warned that I seldom can resist giving UX-related comments :) On [2] I found some other things that need to be done/checked before I start: In general, do not impose too much meaning into those requirements (but don't cite me on that :). Ts. Didn't I say don't cite me on that? :) Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Form Tablecontrol event: how to obtain column, row and other information
Hi Karl, (1) Was the mouse pressed in a particular cell, and if so, which one? (2) Was the mouse pressed on a column header, and if so, which column? (3) Was the mouse pressed on a row marker, and if so, which row? (4) Was the mouse pressed outside of header, row markers and cells? (5) How can I find out, which rows are selected, if any? In general, the current column position can be obtained via http://api.openoffice.org/docs/common/ref/com/sun/star/form/XGrid.html#getCurrentColumnPosition (at the Source member of the event you got). I am not sure, however, whether this is updated *before* or *after* your listener is called, i.e. if it still returns the old column. The selection, as said by Fernand, can be obtained using the getSelection method (or the Selection property, which is the same in Basic). The current row cannot be obtained, though perhaps implicitly be determined by the current row of the form. Probably the safest way for the concrete row would be taking the pixel position of the mouse, and calculating the affected cell, taking into account the header and row height. However, this probably requires translating the heights from logical units into pixels, which requires the XUnitConversion interface, which is available in 3.1 only. This approach might even work for the concrete column, by calculating with the column widths. However, I am not sure at the moment the width of the row header is available at the grid control model ... All in all, there's pretty much uncertainty in here, so I think fixing the issue with the grid column events might be ... safer. Though, column-related events won't solve the problem of obtaining the current row ... (6) When I press the right mouse button in a cell or on a column header, a pop-up menu appears. Can I add my own menu items to these menus, and if so, how? No, that's not possible. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] New Filter Dialog
is a good place. I of course could recommend Chris Lukasiak to you, who happened to take the UX role in the Base team after our previous UX expert left for other tasks. Personally, I am immodest enough to offer my help in the Dev as well as UX area, though I fear I haven't as much time to spend for the project as I would like to have. --Q4 [i-Team Agreement]: --Do all i-Team members agree on Q1 - Q3? Well, first I need these three people... --What happens if I can't answer all questions mentioned above, with Yes? --The consequence could be that your valuable work won't be integrated --into OpenOffice.org. So, at the moment I should better not start or should I? You should. I consider a specification a very good means to plan a feature, to stay in contact with the stakeholders (which is very important, see above), to ensure that all the time all of them see the same big picture ... I do *not* consider a specification and end in itself, as I do not consider the Qs an end in themselves - if you can reach what they (the Qs, and on a higher level the spec itself) want to ensure by other means, then Just Do It (TM). Although it might not be necessary to meet all these requirements as long as only the spec is going to be written, it would be a good idea to involve at least a User Experience member. Yes. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Which version of SRB use with DEV300m2?
Hi Zoltán, It's normal, my question was non clear. I tried to usa all my SRB's and downloaded m1 version from Pavel's build, and no working version. cannot start any report from m2 as were in earlier last 5 developer version. I searched and I found that issue 98549 fixed and fix cws integrated and found that this was not fully real, reports not working from m2. The fix for issue 98549 did not make it into m2, and I still have to find out whether this is SubVersion's fault, or a mistake of release engineering. Just to know who to shoot ... Ciao Frank PS: Technically, the fix was part of a file which meanwhile had been renamed in the main trunk, and SVN and file renamings aren't really good friends ... -- Frank Schönheit StarOffice/OpenOffice.org Base frank.schoenh...@sun.com+49 40 23 646 663 / +3 Sun Microsystems Germany Hamburg, Nagelsweg 55 -- - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Poll mailing list working?
Hi Regina, are you sure, it works now? There's rarely something I am sure about in collab.net's infrastructure. There's at least one message (except my test messages, which I deleted from the archive to not clutter it) by now: http://dba.openoffice.org/servlets/BrowseList?listName=pollby=datefrom=2009-02-01to=2009-02-28first=1count=1. Sigh. Care to re-send your mail? Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] About hiding the new interface XRecovery for FormDocument
Hello Yan, A new interface com.sun.star.frame.XRecovery is being designed. It will be used by the autorecovery service inside the framework module and supported by all applications. FormDocument of database, which is not used as a top level document, will ignore the new interface. Currently, ODatabaseDocument can inherit XRecovery and implement its method load/save. I want to pass some parameters, which can disable the interface XRecovery, to the sw::ctor() when creating a new FormDocument. I tried to do this in the ODocumentDefinition::loadEmbeddedObject(...) but found no good way. How can I pass some parameters to the sw::ctor() when creating a new FormDocument in database? There already is a mechanism for passing parameters to the document implementation, to disable certain functionality. For instance, for the documents embedded in a database document, we disable the usage of XEmbeddedScripts. For this, we pass a parameter EmbeddedScriptSupport when creating the document, see http://svn.services.openoffice.org/opengrok/search?q=EmbeddedScriptSupportdefs=refs=path=hist=project=%2FDEV300_m40. In SFX, this creation parameter is translated into the SFXMODEL_DISABLE_EMBEDDED_SCRIPTS flag, which is passed to the document factory: http://svn.services.openoffice.org/opengrok/xref/DEV300_m40/sfx2/source/doc/sfxmodelfactory.cxx#176 Then, the factories for the various document types examine the presence of this flag (http://svn.services.openoffice.org/opengrok/s?refs=SFXMODEL_DISABLE_EMBEDDED_SCRIPTSproject=/DEV300_m40), and translate it into a call to SfxObjectShell::SetHasNoBasic: http://svn.services.openoffice.org/opengrok/xref/DEV300_m40/sw/source/ui/app/docshini.cxx#401 This, finally, instructs the SfxBaseModel belonging to the SfxObjectShell to *not* expose the XEmbeddedScripts interface. However, let me ask an important question: Why do you really want to disable this interface? First, it should not hurt if it is present: The auto recovery process iterates over all documents which are known at the desktop, and sub documents of a database document are explicitly *not* known at the desktop. Second, the non-presence of this interface would make the implementation in Base harder: To properly implement a emergency-save and auto-recovery for Base documents, we also need to emergency-save and auto-recover the sub documents. For instance, when you have a database document and one form open, and OOo crashes, then Base needs to save both the database document, *and* the form. The latter is done easiest, if course, if it can be delegated to the form itself. So, the save-code in Base would look like - create a wrapper storage - save my own content - create a sub storage for every opened form - use the form's XRecovery to save it into the sub storage So, the bottom line is: When you remove the XRecovery from embedded forms, this will make final implementations more difficult. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] MWS builds and SRB development
Hi Zoltán, It is a possible to attach to any MWS, versions of SRB which allows new features supported in main code, same way as dictionaries installed with OOo? bundling extensions with the OOo distribution is technically easily possible, but a political issue. People need to decide and *agree* to which extension is/not bundled, and this seems to be a difficult process. Reporting is, in my opinion, an integral part of a database application, so you ask me, SRB should be an integral part of Base (not even in the form of an extension). I took the opportunity to start, again, a discussion about integrating SRB into Base - something I'd really like to see happening, as it would significantly lower the efforts around SRB (e.g. testing different SRB versions for compatibility with different OOo versions). Let's see. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Macro migration wizard in m41
Hi Peter, after migrating the macros from a form to the document (which seems to end successfully), the macro organize dialog neither lists the document nor a opened form. Don't know, if this is a base issue. It is. This problem came in with m38, where two DBA-CWSes were integrated, and a conflict was resolved improperly. The issue is fixed in both dba31g (integrated into m1) and dba31h (will be integrated into m2), so probably also in m42. Thanks for catching this! Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Feature pool
Hi Peter, just a little reminder for the unconfirmed issue http://qa.openoffice.org/issues/show_bug.cgi?id=66593 (alignment property for numeric controls) try the latest developer snapshots :) Ciao Frank PS: submitting issues directly to me, in state UNCONFIRMED, has a high chance of losing them ... leaving the owner blank, so they get assigned to dbaneedsconfirm, is much better. - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Events on Form TableControl-elements not working
Hi Fernand, I tried to put a Mouse Click event on a Textfield (column) in a TableControl ioff aForm. The event is ignored and the macro on the event is not called Puting the Mouse Click Event on the TableControl itself works properly For the moment I found a work around using the properties of the row who is selected by the mouse click. Is this normal behaviour or do I mis something? Neither nor. I'd call it a bug. (Knowing the internals, I suppose this never worked.) Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Developer offers help in PDF Form export
Hi Zoltán, One company offering help in PDF export, on community forum: http://user.services.openoffice.org/en/forum/viewtopic.php?f=53t=14899 As I know, you are the developer of Forms in OOo. I answered in the forum, thanks for the pointer. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] OOo Base 3.1 New Features wiki page
Hi Zoltán, I compiled a wikipage from features mailing list mails, and some cases from requirement documents. that's great - next time somebody asks me what's new in 3.1's Base, I know where to direct him to! Thank you very much! Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] DEV300_m39 breaks in evoab2 NResultSetMetaData.cxx
Hi Ariel, DEV300_m39 breaks in connectivity/source/drivers/evoab2 ... if you're not aware of an issue for this - please submit one. This could be fixed as master fix (i.e. directly for m40, not in a CWS). Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Problems with i_only_updt_1.bas i_only_updt_2.bas in testing m14 linux Hungarian version
Hi Zoltán, I only testing m14 on linux Hungarian version, I finished all required tests and tried to upload test results, and I uploaded all, but two error msg I get. ... I'm not sure Marc (who's in charge of the auto tests) reads here - again, I recommend trying d...@qa. We mortal developers don't know anything about those tests. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] How to keep users away from Tabels ?
Hi Fernand, CWS dba31h any idea when i will be available for us ? it's one of our last CWS' towards 3.1, its timeline depends on the frequency of new 3.1 bugs coming in (the more 3.1 bugs, the earlier dba31h will be full - but please don't feel tempted :) Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Using testtol on Base and screenshots
Hi Zoltán, Base cat0 tests not creating screenshots, all other parts of OOo creating it, nearly all of dialogs. Can be scripts changed to support screenshots? Do not remotely know ... You might have better chances with this question in d...@qa. As a last resort, approach msc at openoffice.org directly, he's responsible for Base automation. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Re: Fwd: [office] ODF 1.2 proposal votes result
Hi Jonathan, I'd love to work on this together again, but it would be nice to have an agreed-upon solution with the TC first. Something that's actually workable, so that we don't waste our time again. Didn't forget you/r mail, but am quite busy at the moment, sorry. Will come back to this. Well, first need to come back to thinking about this ... Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] Radio Button Group Names in ODF
Hi Jonathan, sorry, after pushing you to use the mailing list for all those discussions should have sent my previous mail too the list, too. So, for the record, I copy it here ... - snip - Hi Jonathan, as a preface, let me say that in my understanding (I didn't mention this explicitly yesterday), this week's vote in the TC was not about which proposals are to be accepted or rejected at all, but about which 5 proposals are the most important ones to get int 1.2. Is this correct? If so, then the door would be open for discussing the form:group-name again for 1.3. However, my confidence that this will finally be accepted is fading away ... I am not as near at the TC as you are, so perhaps your impression is different. This was discussed briefly on the office-accessibility list, and in order to fix up the ambiguity/collision between control names and group names both using the same element (form:name), Michael suggested that we instead use xml:id to hold the control name while form:name would be used ~solely for radio button group names. Letting xml:id hold the control name won't work, since xml:id must be unique within the whole document, which is not remotely ensured for form components (not even for sibling components, not to talk about arbitrary components in the complete hierarchy). What I think could be done, perhaps: - introduce an API representation of the xml:id attribute. Other objects in ODF documents support this attribute/property, too, so perhaps there's already some work done. What's interesting here is how the document-wide consistency of IDs is assured. For instance, if you copy'n'paste a control from one document to another, the ID must still be unique in the target document, which implies that the paste operation must be allowed to silently change it. I think there's some ugliness ahead on this way, but it should be manageable. - Introduce some XIdAccess::getByID, analogous to the existing XNameAccess::getByName, which allows scripts to access form components by their id. - Introduce an UI in the property browser, for changing the ID. - rename the Name property to group name, and remove it for all control types except radio buttons. (not sure about the latter. Would make tweaking existing documents difficult, probably.) - don't touch the relation of Name-form:name, for compatibility reasons What I'm uncertain about here is MSO. I know they have old and new controls (at least in excel), with different property sets. Would those in all cases be mappable to the Name/ID pair of form controls? So the question is, in what timeframe do you want a working implementation? The form:group-name proposal is working _now_. Unfortunately, it doesn't produce ODF-conform documents, and not even documents which we can have strong hope for to become ODF conform. From a developer-for-end-users perspective, I do not like this, but in the current form, it has no good chances to get into OOo trunk. The use of xml:id hasn't even been started, it will amount to a complete rewrite of the form:group-name approach (as it's ~completely different), and I have no idea if this will even work. (I can't think of any reasons why it wouldn't, but I haven't worked with the scripting code either). Yes, unfortunately the complete GroupName work would be lost :(, since this property would not even exist anymore. In theory, all those considerations should have been done before implementing this, but in the real world, no developer ever does ... which explicitly includes /me. So if we want something soon, we need form:group-name. If we can wait awhile (no timeframe), we can see if xml:id will work. I want a solution which allows component identity (currently done with Name - in some sense) and at the same time grouping control (currently done with Name, too). Inspired by MSO, I already said this implies implementing the GroupName property, but ... So, how to proceed? As said, in the current form, and assuming that the group-name proposal won't make it into 1.3, either, I cannot include your patch in trunk OOo. Whether or not you like to help implementing the ID approach as sketched above (really: *sketched*. In particular the Excel im/export is something I cannot remotely judge.) is your decision, finally. I'm willing to contribute my part, too - especially the implementation of the ID property, caring for all side effects, is certainly deep inside my core domain. So, what about working together on this, again? Thanks Ciao Frank - snap - And Ciao, again Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe
Re: [dba-dev] OpenDocument event assigned macro can not execute - now what?
Hi Drew, Embedded macros. The current development builds for OO.o 3.1 (DEV300_m37) includes both macro libraries being embedded in the ODB file, versus the individual forms, and supports document events (open document, etc) for the ODB file. Unless really server issues pop up with this feature (which I don't think, of course), it will be part of the 3.1 release. Timing wise then *I think* 3.0.1 is due to ship in early January which http://wiki.services.openoffice.org/wiki/OOoRelease301 would then make 3.1 sometime April/May 2009, I suppose. http://wiki.services.openoffice.org/wiki/OOoRelease31 Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] OpenDocument event assigned macro can not execute - now what?
Hi Drew, Thinking about achieving my goal then it seems there is a second property that wold be needed at the ODB file level. Hide Base window ( Yes / No ) Okay, I wasn't explicit about this, but I fully agree that this is a necessity for addressing your scenario. Finally, it would be something like declaring a certain form as *the* main window for the database. If the DB doc opens, this form comes up (instead of the standard window), if the form closes, the DB doc closes, too. Finally, just a slight shift in responsibilities. Ok - there are few things to think about here. Such as closing the ODB file. It would be really nice if Base had a feature that counted how many child windows where open IF hide_base_window = TRUE, incrementing this counter every time a window was opened and decrementing when one closed. When the counter hits 0, close the parent file - or something similar, it would take a bit more thought to get that right no doubt. This is similar what currently the application controller does. Extending this logic to consider a window different from the default app window as main DB window wouldn't be too difficult, I'd say. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] OpenDocument event assigned macro can not execute - now what?
Hi Drew, Errrm, logically, it shouldn't run the macros. Ideally, you would get a message telling you that macros have been deactivated or that you don't have the rights to run MyMacro etc, but wait, let me guess, OOo just crashes without warning ? Or better still, it runs the macros regardless ? ;-) (Ts. Of course you get a message, but the file is opened then.) Ah - you are telling me what it does...I asked what should it do, and I'll offer my suggestion. It should refuse to open the file. Uhm. I'd have a hard time implementing a logic like do not open this document when you cannot execute on-load-macros, this sounds ... strange. However, together with a open a form when opening the DB doc feature, one could - declare a minimalistic form saying nothing here for you as on-open-form - assign a macro to the OnLoad event of the DB doc (or the form), which replaces the form with the switchboard To me, that sounds more like a legitimate solution to the problem you sketched. Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenh...@sun.com - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] system-jfreereport in m36
Hi Rene, I was just resyncing my configuretoplevel cws (which makes system-jfreereport work without additional patching) to m36 and saw this: You don't mention which module you found this in, and I don't recognize, but what does tell svn annotate tell you about the change? Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Basehttp://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Sitz der Gesellschaft: - - Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten - - Amtsgericht München: HRB 161028 - - Geschäftsführer: Thomas Schröder, Wolfgang Engels, Dr. Roland Bömer - - Vorsitzender des Aufsichtsrates: Martin Häring - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] system-jfreereport in m36
Hi Rene, You don't mention which module you found this in, and I don't recognize, reportdesign, obviously. Sorry, intended to look into makefile.mk but auto-completed makefile.pmk. but what does tell svn annotate tell you about the change? Didn't look. Then please do. To me it looks as if Caolan introduced this change. I don't know his intention with it. Thanks Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Basehttp://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Sitz der Gesellschaft: - - Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten - - Amtsgericht München: HRB 161028 - - Geschäftsführer: Thomas Schröder, Wolfgang Engels, Dr. Roland Bömer - - Vorsitzender des Aufsichtsrates: Martin Häring - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Thunderbird-Addressbook
Hi Mechtilde, Do you mean how to find the directory used for different profiles? I have two different user directories. Isn't that stored in the profiles.ini file found in the directory .mozilla-thunderbird Under Ubuntu for instance this is located at /home/user name/.mozilla-thunderbird there I have also /home/user name/.thunderbird Sigh. I always though that those distro-habit of changing such a folder name to something different is not a good idea, and only causing problems. No, there is no mechanism for declaring a different path for looking for the address books. It would be possible, technically, but if at all, then I would only implement this as configuration option. IMO, that's way too advanced for the average user to be presented at the UI. As always, fell free to submit an issue to ensure this request for enhancement doesn't get lost, though I doubt the core team will put any effort into this issue in the foreseeable future. Thanks Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] [mysqlnative] system-mysql
Hi Rene, Actually they claim have released a 1.0 already ;-) http://downloads.mysql.com/forge/connector_cpp_preview [EMAIL PROTECTED]:~/mysql-connector-cpp-20081125$ head -n 1 CHANGES Alpha 1.0.1 - xx/xx/2008 With an ABI/API change in a *micro* release, and it seems they didn't change SONAME. Not very promising. .oO ( mdbtools ) Some on there's a preview in the download package's name :) Okay, however we call it, there is *no* final release, yet (Ulf/Andrey: uhm, please do *not* correct me on that :). Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] improved SQL view
Hi Max, It seems it is finished? So did you already pass the CWS to Mechtilde, or are there still fixes needed? yes, rebase is finsished and Mechtilde is doing manual test, while André Schnabel is doing the automatic tests on Win/Linux. Just saw that CWS sqlsyntaxhighlighting is nominated - congratulations, and thanks for doing this implementation! Bettina told me that she will be working on the colors this week. hmmm do we still have light green on white? Thanks Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Thunderbird-Addressbook
Hi Mechtilde, I want to create a connection to my Thunderbird addressbook under Linux (Debian) I choose File - New - Database - Choose a connection to an existing database - Thunderbird Addressbook Then I can choose Browse and see 2 addressbooks. My problem now is: I want to know where (in which directory) it browse. My suggestion is to choose the right path to the dirctory myself. This would probably mean larger changes in the driver. Also, I am not sure this is really desired. Finally, isn't it that you need to know the *profile* whose address data you access, instead of the concrete location? I strongly suppose Joe Average would be seriously overwhelmed if we asked him to browse for his Thunderbird Address Book files - he might not even know the location of his TB user profile, not to mention the AB files. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Re: Connecting to an LDAP server
Hi Ferry, It is is not a matter of responsibility, but usability. ... And Base could serve great as front end. After all you need a way to get the data into the ldap server as well as out. Let me put it the other way round: There's a lot of things which *could* be implemented in OpenOffice.org (for instance, people constantly require an Outlook equivalent, a project management tool, and a lot of other applications, and the like). However, I don't think that attempting to implement each and every feature which would be useful is a good idea. Not as long as not each and every developer in the world works on OpenOffice.org. So, as long as we need to prioritize our work, I continue to think LDAP write access is not what belongs to a database application's core functionality. Which doesn't mean we would not accept your (or anybody else's) patch which implements this :) Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Radio Button Group Names in ODF
Hi John, I'm attempting to shanghai an existing thread to (re?)introduce discussion about radio button group names; see: http://www.oasis-open.org/apps/org/workgroup/office-accessibility/email/archives/200811/msg00011.html Let's see how that goes... Can't access this, as it's a members-only archive it seems. But in general I think reviving the discussion about the the group-name attribute is the way to go. The stuff I read in the accessibility list pointed to by Florian is way too ... exaggerated. It sounds to me as if Pete would like to use the frames/fixed texts, which can have the form:for attribute, as means to define grouping. I do not think that this is a good idea. While I would agree that the definition of form:for in ODF 1.1 is sparse enough to allow a lot of interpretations, I would not like to see it jeopardized in this way. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] improved SQL view
Hi Max, Rebase is running right now. It seems it is finished? So did you already pass the CWS to Mechtilde, or are there still fixes needed? Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] improved SQL view
Hi Max, yes, rebase is finsished and Mechtilde is doing manual test, while André Schnabel is doing the automatic tests on Win/Linux. Bettina told me that she will be working on the colors this week. Okay, fine. PS: mechtilde agreed to postpone the Mac issue to a follow up fix in a next CWS You should submit an issue for this, just to ensure it doesn't get lost. I suggest the 3.x target. If you don't really feel like coding in Base anymore after this CWS is integrated :), then you can put the issue on the pile owned by me, otherwise I'd ask you to assign it to yourself. Thanks Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] improved SQL view
Hi Max, Which brings me to: Our QA here in Hamburg is busy with a lot of other CWS' which are targeted for 3.1, too. Mechtilde (German QA-Project) will do the QAing and aggreed to postpone the mac issue. Okay, the CWS is in good hands, I'd say. yes, she told me to have a look rather soon and also align with BASIC IDE as well as report designer colors Thanks for the code review, I fixed it all except the last one, as you pointed out correctly ;-) Rebase is running right now. Okay, thanks for those three, too. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] improved SQL view
Hi Max, [X] I think it's finished, and I just don't dare to say ;-) ouch, now I remember again the last remaining issue. According to [EMAIL PROTECTED], bracket matching does not work on Mac, no idea why. Would you have access to one and could debug there? Otherwise, I get mine in 1 - 3 weeks and could debug it then, but then we might miss feature freeze, which would be really unfortunate. I don't have time at the moment for debugging this on the Mac, sorry (the more since debugging on the Mac is a cumbersome task. Well, to put it the other way round: I have only minimal experience with the tools on this platform.). Sounds like a task which we could postpone, IMO, provided the CWS'es QA rep agrees. Which brings me to: Our QA here in Hamburg is busy with a lot of other CWS' which are targeted for 3.1, too. But hey, nobody says a CWS'es QA rep needs to be a Sun-paid QA engineer, right? I suggest we ask - here and in [EMAIL PROTECTED] - for a volunteer who has a look at this CWS. What do you think? However, you should rebase your CWS to m35, since m34 saw some big changes in dbaccess. I am not sure they would conflict, but we should be sure Yup, will do right after Peking. Okay. Other than that: Did you have a chance to talk about the default colors with Bettina? I still think light green on white is ... eye-hurting :) I also spent some time reviewing your code changes. The following is a list of items I came across - nothing you're required to change, but I mention them for completeness (otherwise my review time would have been wasted :). - Any reason why m_pSourceViewConfig and m_pColorConfig are allocated dynamically? The instances could have been direct members. - overloading OSqlEdit::Notify is superfluous (in case it's just here because of a compiler warning - a using directive on the class declaration should do). - MultiLineEditSyntaxHighlight should be in an own file - crowding one file with unrelated classes doesn't really contribute to code lucidity. (Well ... that's the only item I would really *like* to see be changed :) - I would have preferred making larger chunks of the highlighter code a parametrization of the MultiLineEditSyntaxHighlight and SyntaxHighlighter classes, instead of hard-coding them. That is, IMO the keyword list, the token types, and everything else which is language specific (Basic or SQL), should have been hidden behind an abstract interface, which then is implemented once in basctl for Basic, and once in dbaccess for SQL. This would have been a much cleaner architecture. However, I see that the old code was in no way prepared for this, and changing this is a too big refactoring for now. Okay, enough for now. Please do the resync when you find the time (if you're really too busy, I can try to do myself, so we have chances of hitting the feature freeze, but I can't promise). Thanks Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] improved SQL view
Hi Maximilian, [X] I think it's finished, and I just don't dare to say ;-) So yes, finding a QA person and getting it in for 3.1 would be great. Okay. However, you should rebase your CWS to m35, since m34 saw some big changes in dbaccess. I am not sure they would conflict, but we should be sure. I took the liberty to merge trunk's changes to solenv/bin/cws.pl, solenv/bin/modules/Cws.pm, and solenv/bin/modules/CwsConfig.pm. This way, you should have a working cws rebase command in the CWS. (At least I hope I remembered the needed files correctly ...) Note that it seems that you already merged in some of the changes, at least in cws.pl. However, it seems you did not use svn merge for this, but just applied a patch file - which will confuse subsequent svn merge operations. So I reverted your change before doing the actual merge, hope you don't mind. PS: Bettia and I will have a look at the standard colors tomorrow in Bejing That's good :) Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] improved SQL view
Hi Peter, I darkly remember having seen the Basic IDE code years ago, do I remember correctly that highlighting is done on a per-line basis, so the problem here is that we always generate one-line SQL statements? In this case, it might be an additional ... motivation to make the Query Designer preserve line ends as entered by the user ... ... which is known as (assigned to requirement) http://qa.openoffice.org/issues/show_bug.cgi?id=78523, am I right? Yes, but not completely. I would also like to see switching from SQL view to graphical view and back preserve the line breaks. Possibly even when you do changes in the graphical view - for instance, when WHERE starts on a new line, then it should continue to do so if you just modified the SELECTed columns. Something like this, though this latter part is non-trivial, admitted. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] improved SQL view
Hi Max, here is a new testable version of the cws sqlsyntaxhighlighting[1]. In addition to the last snapshot, which included the following features: - syntax highlighting in SQL view - bracket matching - font and font size configurable this snapshot now support these as well: - syntax highlighting and bracket matching in Tools-SQL as well (sometimes I really love programming ;-)) - configurable colors in tools-options-appearance - parameters are highlighted as well Cool stuff. Great idea to also use the same control in the Tools/SQL-dialog! In general, it's looking better and better. Do you have a list of open issues, or something like that, which shows how far you're from finishing it? Things I noticed while playing with it: - changing the colors is not propagated to currently-open SQL views, you need to close and re-open them - In Tools/Options/Appearance, Strings are listed with color Automatic = White, but in the SQL view, they're light green (which I continue to consider an unfortunate default, given the default background color is white) - (really minor, only worth fixing if it's easy enough) - type SELECT hour(foo, - select the comma - type a closing parenthesis = only the opening parenthesis is bolded That is, when the parenthesis you type replaces a selection, bolding it does not work. Ciao Frank PS: I only played with the installation so far, I did not yet look into the code you wrote. I plan to do so, but this requires a) to find out how, in SVN, to display the changes which happened on a certain CWS branch (excluding changes caused by rebasing the CWS, ideally) and b) time. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] improved SQL view
Hi Max, ... So - just speaking for myself...thank you for the time and effort you are putting in to it. Which is something I'd like to explicitly sign with my name, too. illegible_scribble/ Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Localization issue with error messages
Hello Sophie, I have a localization issue with error messages in Base. They appear to be duplicate in French and English, but the English part is more verbose, for example: - Erreur lors de l'insertion du nouvel enregistrement Attempt to insert null into a non-nullable column... - In case you didn't install the JAR file pointed to by http://wiki.services.openoffice.org/wiki/HSQLDB_Localization, the error messages raised by the *HSQLDB engine* (i.e. the pure HSQLDB Java code) are not translated at all. In this case, the mix is because one message is from the engine, and one is from the UI (where all error messages are translated). At least, this would be my guess from just seeing the messages and not having a concrete scenario. Would it be possible to have only one fully localized message? The fact that some messages are duplicate is a general problem that our error handling is not always ... optimal, which can be fixed on a case-by-case basis only, since it's hard to impossible to judge, just from looking at the code, where this could happen. Is it this file that have not been translated : http://davidf.sjsoft.com/files/hsqldb-po/sql-error-messages.pot This looks like somebody generated a pot file for the engine's error messages. However, there is no process (to my best knowledge) how those translations are packed into the hsqldb.jar, so they never appear in the product. And could it be possible that the file be added to our localization workflow in order to maintain it? That's planned - in the sense of we know that we should do it :-\, though I think there does not even exist an issue, yet. Feel free to submit one, please. I'd aim for some 3.x target for this. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Localization issue with error messages
Hi Sophie, Would it be possible to have only one fully localized message? The fact that some messages are duplicate is a general problem that our error handling is not always ... optimal, which can be fixed on a case-by-case basis only, since it's hard to impossible to judge, just from looking at the code, where this could happen. Ok so if I fill an issue with the necessary steps to reproduce, you might be able to fix it? Usually yes. Sometimes the effort is non-trivial, and in case of *slightly* different messages from the HSQL engine and Base it might be debatable whether it's worth keeping both, however. But as a rule of thumb, I think error messages presented to the user are an important thing, and a message box which shows the same text twice just looks ... unprofessional, so it's worth investigating it. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Re: [qa-dev] HSQLDB 1.9.0 features description
Cor, Zoltán, I find on HSQLDB page the features for coming out in near future 1.9.0 (will in alpha phase) new features description: http://hsqldb.org/web/features190.html Zoltan those are online for quite some weeks now - you're late ;-) All (x-posting now): when can this be expected in OOo? No concrete plans, yet. In particular, quite some of those features would need adjustments to other parts of OOo to benefit from them (except you use them in Tools/SQL or native queries), and it's completely open what resources we plan to invest there. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Radio Button Group Names in ODF
Hi Jonathan, 2. I lack imagination. More specifically, given what little I know about why the original proposal was rejected Let me repeat it: It was not rejected. Florian ended the discussion with open issues, and there was never a decision about the proposal. That's the statement I got from the chair of the TC, and I believe it. So, let me repeat my suggestion: So, in short: I think before going for any non-ODF-compliant extensions to the file format, I think you guys should drive the proposal, until the point where it either has been accepted, or rejected. I cannot make it any more clear than this: Just go for it. It has not been rejected, the discussion was ended prematurely. I'm a clueless noob. More specifically, I'm not exactly sure where to begin. As eluded to above, I think any form of harmonization here is going to need to take place within the context of ODF 2.0 (or any version that can break/alter semantic backward compatibility), so that we can get a consistent and workable picture of scripting (what attribute holds the control name?) and radio button grouping (what attribute holds the group name, and it better not be the same attribute that holds the scripting name, which is the situation for ODF 1.3). As I tried to outline, I think this would be the next step (a difficult one, I agree), needed only when the proposal is actually really rejected. Which must not necessarily happen. So, as a clueless noob, where do I begin? What meetings do I need to attend? From which groups (I suspect more than one will be involved)? When do they meet? etc., etc. I do not know whether you are actually a TC member, or only Florian. My suggestion: Whoever of you is the TC member: Re-submit the proposal, after rephrasing it, removing the (wrong) claim that grouping is impossible, removing the (wrong) claim that the feature is necessary for accessibility, instead focusing on a) the need to have a means to define grouping without interfering with the form:name attribute (whose real-life usage in scripting environments makes its alone usage as group indicator difficult) and b) the need to cope with a feature present in a certain competing office application. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] some issues in cws sqlsyntaxhighlighting
Hi Max, - optcolor.src:448: Should be SQLIDENTIFIER instead of BASICIDENTIFIER (copy'n'paste error) seems like you missed the latest svn update, found that one last night :-) Indee, the SVN version of the CWS is just building, I still used the CVS version this afternoon. Thanks a lot, this indeed fixed the issue. I actually thought about sth. like that myself, so I made sure to have this code in the right order: aSQLBackWN(this), SQLFT(this, ResId(FT_SQL_COMMAND, *rResId.GetResMgr())), Why does the declaration order matter, isn't initialization actually be done at this place? It is, but a common misperception is that initialization is done in the order you write it in the implementation - it isn't. Declaration order is what controls initialization order, nothing else. So no matter how you re-arrange them in the constructor, your members are always initialized in the order in which you declared them. However, I suppose only a few enlightened people :) knew this two years ago - we all learned it the hard way when we switched on warnings-as-errors, together with -wall, since the GCC we use warns if you write your member initialization in a order different from the one in declaration. Glad everything works fine now, have a great holiday Thanks. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Radio Button Group Names in ODF
Hi Jonathan, So, in short: I think before going for any non-ODF-compliant extensions to the file format, I think you guys should drive the proposal, until the point where it either has been accepted, or rejected. Does your silence mean [ ] you decided to go with the non-ODF-compliant extension, anyway [ ] you are too busy currently, but will try to resurrect the proposal as soon as possible [ ] you do not care anymore [ ] other: _ ? :) Thanks Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] some issues in cws sqlsyntaxhighlighting
Hi Max, Thanks, after I fixed another thing, it is now working perfectly fine except the group caption is not showing up, but I'm sure I'll find that one as well soon. Okay, so I won't investigate here ... Thanks for mentioning this possibility again. Although I could swear I did this a million times, it fixed the issue. Fine. I used the opportunity to switch to svn directly as well. So the CWS is now SVN-based? m33? Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] some issues in cws sqlsyntaxhighlighting
Hi Max, (uhm, I did it again, I called you with your full name in my last mail ... sorry :-\ ) just had a quick look, so only a short comment: *trying to get the value does also not seem to work, I always get the default one, although it is saved upon closing and restarting the application. Can reproduce it :), did not investigate. Though, as Ocke already suggested, you forgot adding a new entry to the configuration schema. See the changes I committed to officecfg. - by simply adding svtools::ColorConfig m_aColorConfig to my new control MultiLineEditSyntaxHighlight, it crashes, to verify, just open and close the SQL view. Cannot reproduce. I suppose you have an incompatibility here, i.e. some file which has not been built though it would need to. Try touching the header file of the class, and rebuilding the module. Alternatively, try rebuilding the complete module. (that's effectively what I did, and I did not get the crash. And the place you mentioned sounds indeed like there is a mismatch between the actual class size, and the size which is just being deleted/freed - a typical incompatibility when you don't rebuild all affected files after changing a classes size.) Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] some issues in cws sqlsyntaxhighlighting
Hi Maximilian, back from vacation and exams, I have some issue in cws sqlsyntaxhighlighting, would be great if you could help out once you find some time: need to get a copy of the CWS here to have a deeper look, this will take a while. - I tried adding a new group in the appearance dialog and one new entry.* The group appears, but the caption is not shown * the colorbox and window appear just fine, but I get an assertion that ressource 174 and 175 (the one from the colorbox and window) can not be found in the resource file, what ammissing? Which reminds me of an open issue in the current versions - everytime you open the stylist, you get a similar assertion about a missing resource, because this resource is looked up in the wrong .res file. Perhaps the effect you see is something similar, and not really related to your CWS. But that's just wild guessing for the moment. *trying to get the value does also not seem to work, I always get the default one, although it is saved upon closing and restarting the application. I guess you did all that already once for the Base Extension and know the pitfalls ;-) Ocke did - since he didn't mention pitfalls, there are none :-) - by simply adding svtools::ColorConfig m_aColorConfig to my new control MultiLineEditSyntaxHighlight, it crashes, to verify, just open and close the SQL view. The crash seems to come from ColorConfig::~ColorConfig() when calling EndListening( *m_pImpl), no idea what's going on there. If I use ColorConfig as a local variable in my highlighting routine, it does not crash, but I guess just creating it once makes more sense. ColorConfig has, as all the FooConfig classes in svtools, a ref-counted impl class. So, as long as there's one instance already, creating new ones is cheap. However, since it's not known which other components hold a ColorConfig instance (I thought there was a time when the Application did so, but I did not find such code right now ...), that's in fact nothing to rely upon. I need to have a look into the crash to get an idea of it ... see above. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: AW: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver
Hi Michael, Okay, I went through some documents introducing to the CWS concept. In case using a CWS to apply my changes, I'll need to checkout the most recent milestone via cwsquery, create the CWS via cwscreate, apply my changes locally to the CWS and commit them to the CWS via a CVS commit, right so far. If you want us to, we can create the CWS for you - that's a service for first-time contributors ;) to relieve them from some stuff. but I'll need to get an CWS account, right? How do I get the account? For committing, you definitely need a SSH key submitted to us. Since we just migrated to Subversion, I refer you to http://wiki.services.openoffice.org/wiki/OOo_and_Subversion#SSH_Setup here, which describes how to create and submit your SSH key. When you submit an issue where you attached the SSH key, put me (fs) on CC, so I can approve your request for commit access. Finally, enter your data on http://wiki.services.openoffice.org/wiki/DomainDeveloper, as appropriate (name and OOo login name, IRC nick and company if applicable/desired). Note that since the migration from CVS to SVN realy just happened yesterday, I expect problems on the way - personally, I did not yet work on a SVN-CWS, probably some tooling might not yet be as polished as desired, and so on. So, I beg for your patience when working with this ... Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Radio Button Group Names in ODF
Hi Jonathan, Indeed, this problem hadn't occurred to me until Tuesday of this week - any existing ODF parsers aren't going to know about a group-name attribute, and thus will be relying on the name attribute for grouping semantics. Adding any form of group-name attribute cannot work in this context, not without extending the existing parsers to support the new attribute. I don't think so. Finally, we introduce a new feature here (an additional means to control radio button grouping), which is (to be) reflected in ODF 1.x, and ODF processors which a) do not know about ODF 1.x and/or b) do not have this feature will ignore this particular attribute, and behave differently from what is actually specified in 1.x. But - that's nothing new. That happens all the time in all parts of OOo. So, that alone is not at all an argument against a new attribute which reflects this new property. More in a separate reply. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: AW: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver
Hi Michael, It's been a while since I wrote to the mailing list last time, because I was on vacation. You may remember that we were working on a driver. We are finished with the driver so far and would like to integrate it into the core code base. Probably we need to do some small changes to code to integrate it in base's connection dialog and some more stuff. What is the current OOo built which should be used as foundation for this? I will submit an issue with type enhancement or feature with code patches if this is what you need for integration into the core code base. DEV300 m31 is the most recent milestone (m32 is the first SVN-based milestone, not sure when it will finally be released). If you want, we can create a CWS based on this milestone, and commit your changes (or you can do yourself, if you want, after we granted you permissions to do so). Any adjustments which are possibly needed can then happen in this CWS, and we can fine-tune it without disturbing other development. Such a dedicated CWS would be easier (than a patch in IZ) in case you expect more changes to the first patch version, but has more overhead in case your first patch is perfect :) Your decision. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Outer Join 2.4 vs 3.0
Hi Mechtilde, I'm trying to use queries which I created since 1.9.xxx. In Version 3.0.0 RC2 I see the problem that I can't open these queries in the design view not in the SQL view. But this isn't possible. I get this error message (in German): Verknüpfung konnte nicht ausgeführt werden. (Tranlated like: Relation can't be executed) Further analysis shows that the queries contain LEFT OUTER JOIN. With 2.4.1 I can open the design view. Then I create the query again and can see in the SQL View that there is no LEFT OUTER JOIN. Do you mean you re-create the query in 2.4.1 in the graphical view, and when switching to the SQL view, there is no LEFT OUTER JOIN? In this case, you probably just did not declare the join as Left Join - double click the join line in the graphical query design, and in the dialog which opens then, choose Left as join type. What is happened here? Hmm, don't know. Trying to create a DB with a query with a LEFT OUTER JOIN in 2.4.1, and opening it in OOO300.m7 works like a charm for me. Also, I cannot find the Verknüpfung konnte nicht ... text in the relevant source modules, so I'm not sure where it comes from. Any chance for a bug doc? Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Radio Button Group Names in ODF
Hi Jonathan, To move the discussion from Issuezilla [0] to email... thanks. This solution also adds a //form:radio/@form:group-name attribute to ODF to persist this new property, so that it's actually useful within ODF documents. The problem: The above solution was rejected by the ODF TC, for reasons that aren't fully understood, but apparently are because this @name/@group-name dichotomy was not sufficiently similar to HTML and other W3C standards. The question: Where do we go from here? I'm of the opinion that we _are_ following W3C standards, give or take an attribute name change -- W3C defines two attributes for this scenario (@id and @name), and the above solution has two attributes for this scenario (@form:name and @form:group-name), but I don't think this logic will go anywhere. I see your point here, but the problem with this interpretation is that @form:name has - in ODF versions up to 1.1 - been defined with a different semantics. In particular, it has not the character of an ID, since it must not be unique at all. So, when we continue the line of your arguments, this would mean that ODF 1.2 would re-defined the semantics of @form:name to really be a unique identifier, which would pose problems with existing ODF processors, in particular when writing documents. An example would be OpenOffice.org itself, which would need to prevent, in its API implementation, non-unique names. Alternatively, it would need to store the API-name in a (to-be-introduced) attribute different from @form:name, which would cause even more trouble with document processors which perhaps script OOo to create documents, and process them further. So, as much as your analogy is true when considered for itself, there's no room for it in the existing ODF 1.1 standard, and existing ODF processors. I've noticed that ODF also has a @form:id attribute as well, but it seems that it would be difficult to re-purpose this attribute to store control names (as the value is apparently transient, for use with metadata). It's not for meta data, it's for connecting the form control models to the shapes. I think there could be a way to reuse it, see below. So I'm at a loss as to what to do next. The only other possible solution I've heard is to place the group-name attribute into the interop XML namespace, thus we'd have //form:radio/@form:name and //form:radio/@formx:group-name attributes, where `formx` would be the urn:openoffice:names:experimental:ooxml-odf-interop:xmlns:form: XML namespace. Nice idea - do we already have something similar to this in ODF? Would this namespace be part of the ODF spec? If not, to which degree would such a document be a valid (in whatever weakened sense) ODF document? Is there perhaps allowance in the ODF standard or a certain class of experimental namespaces such as the one you suggested? Another idea might be to in fact introduce a property ID (or so), which we require to be unique within the document. This ID could be written as @form:id, we just need implement some additional logic. For instance, when importing controls in Excel documents, Excel's GroupName would need to be mapped to Name, and Name to ID. Sadly, for UNO dialog controls, this won't work, since their Name (in opposite to form control's name) has always been used with an ID-semantics. So, for those, GroupName would need to be imported as (to-be-introduced) GroupName, and Name as Name. Which is bad, since then the OOo API for form controls and dialog controls would be different, but, well, ... Also, care has to be taken in the form/component implementations since the ID needs to be document-wide unique - this has to be ensured somehow. Perhaps also auto-generation of IDs at runtime is necessary. Import/Export of form controls also would need adjustments, of course. The UI in the property browser might also need to be changed - perhaps we would want to make it more clear that Name in fact is a GroupName property - for some controls, at least. Not sure. Ignoring the open questions for now, do you think this is would be a reasonable approach? Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Image control aspect ratio
Hi Marc, The proper macro has an additional oPipe.closeOutput right after writing the document into the pipe, but before passing the pipe to setBinaryStream. That does work. :) Fine. I assume blocking on giving the exact size as a limit did for the same reason, waiting for the EOF. Yes. Well, it does only partly. I succeeded in writing to JDBC connected databases, using ODBC didn't do, blocking as before. Fixed in CWS dba31c (too lazy to write a dedicated issue). (Strictly, the implementation of setBinaryStream for the dBase driver is broken, as it does *not* do what your macro requests it to do.) Because it doesn't start reading on a stream that hasn't finished getting all data from the writing end? Yes. Thanks for investigating and finding a solution, You're welcome. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Image control aspect ratio
Hi Marc, I was trying to use a css.io.Pipe to connect the two active data sources (doc.storeToUrl and XParameter.setBinaryStream). Using dbase I succeeded in writing othe train to ut a doc this way, for mysql or hsql the office hangs. Now known as issue 94027, targeted to 3.1. Now resolved as INVALID, after I debugged a little bit into it ... Look into the issue for a detailed reasoning why your sample macro is broken, and OOo does exactly what you requested it to do. The proper macro has an additional oPipe.closeOutput right after writing the document into the pipe, but before passing the pipe to setBinaryStream. (Strictly, the implementation of setBinaryStream for the dBase driver is broken, as it does *not* do what your macro requests it to do.) Ciao Frank -- Frank Schönheit StarOffice/OpenOffice.org Base [EMAIL PROTECTED]+49 40 23 646 663 / +3 Sun Microsystems Germany Hamburg, Nagelsweg 55 -- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]