You are using things like WScript in your macro code, which is a global object in the Windows Scripting Host environment. The classical language for COM objects is Microsofts Visual Basic. The Windows Scripting Host is the younger (and less capable) cousin of the Visual Basic. Apache OpenOffice is a...

I spot the words DAO and recordset and you talk about a VBA macro in the subject. All this is indicating that you are working with Microsoft Office (DAO stands for Database Access Objects and is a (outdated) technology that Microsoft used with MS Access (see Wikipedia on Jet Data Access Objects and ...

I'm confident that any XML parser would be quicker than UNO (Universal Network Objects). This sounds evident because for each character a UNO object for a character style has to be created. So we have something that is slow (lets assume 80 milliseconds for this UNO object operation for a single cha...

There is no easy way to get this done in OpenOffice. There are at least two steps required: Download the XML file from the URL Import the downloaded XML into Calc with the help of XSLT filters See the thread Data import from a website to get an idea what needs to be done. We can help you to get star...

Hm, this sounds easier than it actually it is. So if I got this correctly you want to paste something like <ul><li><b> bold text </b> and some less important </li> <li> another list item </li></ul> and you want to see the following in your Writer document: bold text and some less important another l...

The main purpose of OpenOffice Base is to operate as a link or a bridge to make tabular data (from databases, from csv files, from addressbooks of certain email clients) available to the Office applications Writer and Calc. For this reason Base can be used to read data very easily. There is a visual...

Normally you would need to join the Barrels table with the Orders Table. But this cannot be done cleanly because you don't know if you should join it to Barrel_ID1 or Barrel_ID3 or Barrel_ID12. You would need something like ON b.barrel_ID IN (o.Barrel_ID1, o.Barrel_ID2,...o.Barrel_ID12) but this is ...

Have a look at SimpleXML and particularly at the first two user content examples that talk about converting an XML file/string into a PHP array. In your case you would need to feed the internal content.xml into simplexml_load_file() . And most probably it is best if you let do PHP the unzipping of t...

changed the shortcut from <%windir%\System32\odbcad32.exe> to <%windir%\SysWOW64\odbcad32.exe> in both the ODBC souces (32 bit) and (64 bit) in turn. Some clarirfication is needed, because the path names that Microsoft has used for the 32bit subsystem on 64 bit windows machines is contrary to what ...

Oracle doesn't like the AS keyword in table aliases. It is okay with column aliases though. If you go to Edit->Database->Advanced Settings you can configure this for each database connection. The deactivation of table aliases (as seen in the screenshot) was sometimes ignored (I think the queries tha...

The handling of character data is complicated in databases. As you have said CHAR type data will be padded, but there are also some database engines that automatically remove the padding when the CHAR column is used with certain operators. This typically happens for the equality comparison (where na...

Out of curiosity I had to verify the substitution of placeholders for Oracle and JDBC drivers. If I create a main form and a subform (both based on a table on their own), the classical master-detail forms I can see in the statement cache of the Oracle Database: SELECT * FROM "A_USER"."...

Actually I am only a user of OpenOffice. Though I work as software developer I don't do any cpp development for Openoffice. My general experience with development project is that you can always get them integrated if you don't fear hand-crafting your project files. Usually all tools have options to ...

According from what I know about Eclipse it can integrate third party (read as Open Office) Makefiles or generate Makefiles on each one (using some standard (and configurable) rules. The CDT can generate a makefile for you, such projects are called Managed Make projects. Some projects, known as Stan...

So when you use any bind value like :Surename that is handled by Base before Base hands over the query to the database. I wouldn't be 100% sure about this. Mainly because Base supports quite a lot backend database engines, some of them even with different drivers (native, JDBC, ODBC, ...). Any dece...

Can't say this for sure, because I have used Server 2008 R2 only rarely. But you should at least check and verify the following areas: 64bit vs 32bit if you start JScript in a 64bit environment chances are that you won't be able to the 32bit UNO objects of OpenOffice. (If your Windows 7 runs on a 64...

It seems like you haven't fully understood the idea behind this queries?! They are not meant as a interactive tool (like a shell or terminal) but are intended to be designed once but then later on used many times. Of course that why you usually save them. You want to reuse them at the next day. What...

The steps that you need to do are: List all the files in a certain directory . Depending wether all files are located flat in a single directory or if you also have subfolders the way to do it is different. (see Using Shell in Base to Execute Linux Commands ) Loop through the list of found spreadshe...

My installation of OpenOffice Apache OpenOffice 3.4.1 installed a Javascript macro into the folder <open-office-install-path>/Basis/share/Scripts/javascript/ExportSheetsToHTML . Right, it looks more complicated then it should be. But it gives you the right concept: "Hide all other sheets and ex...

As you were wondering about the differences between DDE and macros here is what Wikipedia says about DDE: In computing, Dynamic Data Exchange (DDE) is a method of interprocess communication under Microsoft Windows or OS/2. It allows one program to subscribe to items made available by another program...

I have to admit, I did not test my code from my last post. It just seemed to be what is expected by the API. Obviously it is not. For the records I gave it another go with the .getDataArray() method of the XCellRange interface. At least the name of the method seems to promise that an array is return...

::com::sun::star::table::XCellRange for a SheetCellRange object that contains the data. this means the second parameter should be a CellRange , not a string that specifies a cell range. So you better try: Dim oFunctionAccess As Object Dim oSheet As Object, oRange As Object oFunctionAccess = createU...

As the error message says something about a .odb.log file in a SQLite subdirectory I am assuming that you are using a SQLite database as Backend in your .odb file? Correct us if this assumption is wrong. SQLite is more like a single user database, at least its locking mechanism is not optimized for ...

If you are really still running OpenOffice.org 3.3 as your signature is saying, I would doubt that you had a working environment with JRE 8 (1.8). Unfortunately the update procedure of Sun/Oracle Java has become strange. I just experienced this last week, when I did a manual Java Update. It asked me...

As you mentioned port 3306 I assume that you are running a MySQL database server. port is forwarded in modem db name user password i have verified over and over.. driver loads.. When it tries to connect the error is packet sent none recieved. How did you verify the username and password? Did you use...

The OpenOffice COM Automation doesn't come with a type lib. It only supports late binding. No intellisense or any of the nice IDE features available. But this doesn't matter. Any of the available interfaces is simply a wrapper around the core UNO objects. Most of them have the phrase bridge in their...

An answer to this question has been given in another thread, that was unfortunately hijacked for this purpose. Please read the Survival Guide why this is not a good idea and actually a bad habit.

As I am reluctant to read SQL code that is optimized for machines and not for humans (consists of 30 or more percent of quotes and the SQL keywords like SELECT, FROM or WHERE are hard to spot) I can only make a guess. You are using a nested CONCAT , but MySQL supports a CONCAT(string1, string2, ...)...

Do you mean I should create a 32 bit application (separate process) which used the SDK. And then I communicate with this process via... TCP? You got it. As you mentioned you can't call a function in a 32bit DLL from within a 64bit process. But calling functions that can be dynanmically loaded into ...

I guess the missunderstadning is in the following lines of your code: string docText = "<b>This will</b> be my first paragraph.\n\r"; docText += "This will be my second paragraph.\n\r"; ((XTextDocument)oDoc).getText().setString(docText); You are passing the plain string docText t...