[api-dev] No more lck file with HSQLDB Base ?
Hi, I am playing with DEV300m37 on Windows XP. I found that when I open a table or form in a Base document using internal HSQLDB, no xxx.lck file appears. In the same situation (same Base doc) in OOo 3.0 the .lck file does appear. Is it intentional ? Perhaps related to Issue 93381 ? Regards Bernard - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [api-dev] How to chenge column formats in DatsourceBrowser
Frank Schönheit - Sun Microsystems Germany wrote: Hi Fernand, I hope Frank is still there :-) forcing me to answer your mails this way won't work forever :) Please do not see it as forcing where the hell sould i find the information who is apparently only in your head ?? But i understood alsoo your point, I will never do it again :-) I Try to change the column format in a Data Source Browser I used following code with no suces, the Formatkey off the column properties is changed but no visual changes oModel = oDataSourcebrowser.com_sun_star_awt_XTabController_getModel oMOdel.columns.getbyname(docdat).setpropertyvalue(FormatKey,2) ' 2 = DATE oMOdel.reset omodel.reload Try omitting the columns. What you access here is the *database column*, not the *grid column*. That is, oModel is an css.sdb.RowSet, which is a ResultSet, which provides the XColumnsSupplier interface, giving you access to the single columns of this result set. Those columns also support a FormatKey property, but the grid columns are not expected to react on their changes. On the other hand, oModel.getByName( gridcolumnname ) would give you the *grid column*. Usually, every grid column is bound to a result set column (in that it fetches from and stores to this result set column). Upon creating the grid column and binding it to a result set column, the FormatKey from the latter is transferred to the former, but there's no life connection. So, a oModel.getByName( gridcolname ).setPropertyValue( FormatKey, 2 ) for the completness: your omodel is oModel = oDataSourcebrowser.com_sun_star_awt_XTabController_getModel oGridModel = omodel.getbyindex(0) and for who wanted to force the format to the local version : oSupp = oGridModel.getbyName(mydatecolumni).FormatsSupplier Dim aLocale as new com.sun.star.lang.Locale, oCell1 as Object, _ aLocale.Language = ne aLocale.Country = BE sFormat = DD/MM/YY ' or wathever other version of the date formats;.. vFormatKey = oSupp.getNumberFormats().queryKey (sFormat, aLocale, TRUE) vFormatkey = oSupp.getNumberFormats().addNew ( sFormat, aLocale ) oGridMOdel.getbyName(mydatecolumn).setpropertyvalue(FormatKey,vFormatkey) next i thanks Fernand should do. Ciao Frank - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [api-dev] How to chenge column formats in DatsourceBrowser
Hi Fernand, I hope Frank is still there :-) forcing me to answer your mails this way won't work forever :) Please do not see it as forcing where the hell sould i find the information who is apparently only in your head ?? But i understood alsoo your point, I will never do it again :-) Just wanted to say that this kind of introduction is unnecessary, I usually find the topics I can/want to contribute to without 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: [api-dev] Calc with two tables
Halle Andrew, again thank you for your answer. I got twice the answer 1 for the printing calls. I interpret this that I have two sheets, namely sheet 0 and sheet 1. As long as I had oo0 2.0, I had no problem. I handled 10 tables in one macro. On the bottom of the sheet, where I had the sheets-numbers, I always got the correct sheet numbers. Now, I use ooO 3.0, and I suddenly have problems. In our example I declare the sheets-numbers Tabelle11 and Tabelle31. As soon as I call the spreedsheet I get the sheet-number Tabelle1, which apparently is being generated by ooO. I see all the cells which I had typed when I created the table. After I call the macro, the routine goes to the point where I want to call Tabelle31. At that position I get the outofboundexception. The spreadsheet does not show either Tabelle11 or Tabelle31. The system acts as if I would have not called either Tabelle11 or Tabelle31. Here is the entire code. Option Explicit Sub Main Dim Desktop As Object Dim Platzhalter() Dim Url As String Dim oTabellenDokument As Object Dim oTabellenListe As Object Dim Tabelle11 As Object Dim Tabelle31 As Object Dim EndSpalte As Integer Dim EndZeile As Integer Dim I As Integer Dim Cursor As Object Dim ZellenBereich As New com.sun.star.table.CellRangeAddress Dim ZellenAdresse As New com.sun.star.table.CellAddress ZellenBereich.Sheet = 0 ZellenBereich.StartColumn = 0 ZellenBereich.EndColumn = 30 ZellenBereich.StartRow = 0 ZellenBereich.EndRow = 300 ZellenAdresse.Sheet = 0 ZellenAdresse.Column = 0 ZellenAdresse.Row = 0 EndSpalte = ZellenBereich.EndColumn EndZeile = ZellenBereich.EndRow oTabellenDokument = ThisComponent rem oTabellenDokument.LockControllers Desktop = CreateUnoService(com.sun.star.frame.Desktop) Url = file:///a:/mist.ods oTabellenDokument = Desktop.loadComponentFromURL(Url, _blank, 0, Platzhalter()) oTabellenListe = oTabellenDokument.getSheets() Tabelle11 = oTabellenListe.GetByIndex(0) Tabelle31 = oTabellenListe.GetByIndex(1) End Sub You question, I I reference the correct document. I run the macro with break-points. The only point where I am nor sure of are the LockControllers and CurrentController statements. I declared them both, for the cell-area (Zellenbereich) and the entire document. I also tried getByName instead of getByIndex. I got the same outofboundexception.. I really appreciate your help. Regards, Rudi - Original Message - From: Andrew Douglas Pitonyak [EMAIL PROTECTED] To: dev@api.openoffice.org Sent: Sunday, December 07, 2008 7:36 PM Subject: Re: [api-dev] Calc with two tables Rudolf Huber wrote: Hallo Andrew, thanks for the prompt answer. Instead of Tabelle31 = oTabellenListe.getByIndex(1) I coded Print oTabellenListe.getCount() Print oTabellenDokument.getSheets().getCount() Tabelle31 = oTabellenDokument.getSheets().getByIndex(1) the macro handled both printing statements. And what did they print? My guess is that they both printed the valued 1. Is this correct? Is this the value that you expected? The statement for Tabelle31 is not executed anymore; the system throws an indexoutofboundexception. The sheet itself does not show on the buttom the sheet-id-numbers Tabelle11 und Tabelle31, but Tabelle1. One line below, the sheet shows Tabelle1/1. Maybe the code for ThisComponent and lockcontrollers is incorrect? I am not sure what you are saying. Are you implying that you are not referencing the correct document? Regards, Rudi - Original Message - From: Andrew Douglas Pitonyak [EMAIL PROTECTED] To: dev@api.openoffice.org Sent: Thursday, December 04, 2008 2:25 PM Subject: Re: [api-dev] Calc with two tables Rudolf Huber wrote: Hallo, the following sequence leads to an indexoutofboundexception. In the beginning I have the opening statements: Dim Desktop As Object Dim Platzhalter() Dim Url As String Dim oTabellenDokument As Object Rem the entire Document Dim oTabellenListe As Object Rem Collection of sheets Dim Tabelle11 As Object Rem sheet Dim Tabelle31 As Object Rem sheet thereafter a little further down: : oTabellenDokument = ThisComponent oTabellenDokument.lockcontrollers EndSpalte = ZellenBereich.EndColumn EndZeile = ZellenBereich.EndRow Desktop = CreateUnoService(com.sun.star.frame.Desktop) Url = file:///a:/test.ods oTabellenDokument = Desktop.loadComponentFromURL(Url, _blank, 0, Platzhalter()) oTabellenListe = oTabellenDokument.getSheets() Tabelle11 = oTabellenListe.getByIndex(0) again further down, the table Tabelle31 throughs the index-error: Tabelle31 = oTabellenListe.getByIndex(1) Up version
Re: [api-dev] OpenOffice Add-On in NetBeans: no java files created
Thanks for the response Steffen. For some reason the feature is working now when I tried creating a new project. I'm not sure why it wasn't working the first time. Very interesting. Thanks Steffen Grund wrote: Hello, no idea why this happens. The original bug was Windows xp only. So your bug is a different issue. Can you go to Tools - Options in NetBeans, open the OOo plugin settings, create some log output and send me the log file after you have tried to create an AddOn? Regards, Steffen glasscat wrote: With 2.0.1 I still did not get my java file generated on Ubuntu. I'm using NB 6.5, OO3.0, OOSDK3.0. On XP it works fine, my OO add-ons java file got generated correctly. r_george wrote: The problem seems to be solved with version 2.0.1 :jumping: see http://www.nabble.com/Intermediate-version%3A-OpenOffice.org-API-plugin-for-NetBeans-2.0.1-td20442526.html Jürgen, thank you! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- View this message in context: http://www.nabble.com/OpenOffice-Add-On-in-NetBeans%3A-no-java-files-created-tp20164866p20899322.html Sent from the openoffice - api dev mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[api-dev] Adding more commands into Addons.xcu
Hi All, How do I add more commands to the Addons.xcu once I've created the Add-ons using OO NB plugins 2.0.1? I could edit the Addons.xcu manually, but it would be great to be able to do it on the IDE. Thanks -- View this message in context: http://www.nabble.com/Adding-more-commands-into-Addons.xcu-tp20899636p20899636.html Sent from the openoffice - api dev mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [api-dev] No more lck file with HSQLDB Base ?
HI Bernard, I am playing with DEV300m37 on Windows XP. I found that when I open a table or form in a Base document using internal HSQLDB, no xxx.lck file appears. In the same situation (same Base doc) in OOo 3.0 the .lck file does appear. Is it intentional ? That's not intentional, and most probably a regression of the update to HSQLDB 1.8.0.10, which happened in DEV300m30. The problem is now known as issue 97032, thanks for finding it! Perhaps related to Issue 93381 ? Not at all. 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: [api-dev] Adding more commands into Addons.xcu
NB 6.5 JZA wrote: On Mon, 08 Dec 2008 11:22:58 -0600, glasscat [EMAIL PROTECTED] wrote: Hi All, How do I add more commands to the Addons.xcu once I've created the Add-ons using OO NB plugins 2.0.1? I could edit the Addons.xcu manually, but it would be great to be able to do it on the IDE. Thanks Which IDE? -- Alexandro Colorado CoLeader of OpenOffice.org ES http://es.openoffice.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- View this message in context: http://www.nabble.com/Adding-more-commands-into-Addons.xcu-tp20899636p20902109.html Sent from the openoffice - api dev mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [api-dev] Adding more commands into Addons.xcu
Hi, no sorry, this feature is not supported yet. We have it on our todo list but we work currently with low prio on the plugin. But as you have already noticed you can edit the xcu file by hand ... Juergen glasscat wrote: Hi All, How do I add more commands to the Addons.xcu once I've created the Add-ons using OO NB plugins 2.0.1? I could edit the Addons.xcu manually, but it would be great to be able to do it on the IDE. Thanks - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
