There are two consecutive errors in the original csv, line 133 and line 134. Line 133 \" Line 134 \" Ecran001.png In each case the person filling data wanted to indicate a length in inches . Probably from the same person, other errors like &xxx; appear in lines 167, 174, 631, 654, 908,...

Learn how to program in Basic...
Basic Guide : Procedures and Functions

I want to prevent the user to close the Writer pushing the button "close" because, the next time i open it, i receive the error "RPC not available". Perhaps because you have not disconnected your link to OpenOffice between two uses of the document. Repeat ConnectOpenOffice; do y...

Read Developer's Guide Closing Documents.

Now you should understand that "Reacting Upon Closing" is not simple. You have to use listeners. And handling listeners through COM-Automation is not easy.

I can reproduce on my Windows 7 computer. I first typed mmmm then I inserted some characters just in the middle. I repeated this with different national characters in font Tahoma. TahomaFont.png The extra "spaces" at left and right sides of the Thai text are not added characters. In Arabic...

For other readers, calc-learner created Issue 126981.
My comment :
The problem is not due to a dynamic contents, it appears on a fixed list of a cell range.
Bug : if option Allow empty cells is NOT checked, there is no reason to display an empty item.

It is astonishing, but there is a connection between Mozilla Firefox/Thunderbird and Apache OpenOffice ! Bug report 125431 concerns Linux and MacOSX only . It is a very long and complex report. Comment 52 starts the suspicion of Firefox / Apache OpenOffice interference. Comment 76 explains that Wind...

What I understand :
- you have html documents.
- you want a PDF of these documents.
Answer:
Install a PDF printer (example: free FoxIt PDF Reader).
Display the documents in a web browser. Print the web page using the PDF printer.

Even if you could change the width of the sheet tabs space it would not solve the problem if your spreadsheet has numerous sheets and/or long names: Apache OpenOffice spreadsheet may contain 256 sheets. LibreOffice spreadsheet may contain 10 000 sheets. In Apache OpenOffice the same line is shared b...

Albireo uses the script language of AutoHotKey to manipulate OpenOffice through COM-Automation of MS-Windows. It's the first time I see someone using this language to work on OpenOffice. For Albireo : working on OpenOffice through COM-Automation is described in chapter Automation Bridge of the Deve...

Hi, You cannot understand without reading the Developer's Guide. Some fundamental elements are described in chapter First Steps . You have to understand what is a service, an interface, a structure, etc. The Developer's Guide is lengthy and hard to read, because the OpenOffice API is huge and comple...

Hi,
You have to create an Issue describing your request for improvement. And perhaps it will be added in the future (if a developer is interested).
To create an issue : https://bz.apache.org/ooo/

Use a typed variable when you only need a specific type of data. Here, an empty variant is not equal to an empty string. Replace the first declaration by: Dim Dollars As String, Cents As String, Temp As String Instead of this naive and inefficient code, use function MONEYTEXT, provided by extension ...

Hi, You can open the Styles and Formatting dialog with the dispatcher: dim document as object, dispatcher as object document = ThisComponent.CurrentController.Frame dispatcher = createUnoService("com.sun.star.frame.DispatchHelper") dispatcher.executeDispatch(document, ".uno:StyleNewBy...

Hello, Here is a Basic example of using EnumerableMap Option Explicit Sub Main1 Dim PostCodeFR As Object Dim k As String Dim enu As Object, elem As Variant PostCodeFR = com.sun.star.container.EnumerableMap.create("string", "long") With PostCodeFR .put("EMBRUN", CreateUn...

Hi, _savage wants to export a graphic object from a Writer document. Zizi64 code works because it contains shapes, but not a graphic object. If the Writer document contains an image ( = graphic object), the code throws : IllegalArgument Exception. Throws com::sun::star::lang::IllegalArgumentExceptio...

See XUpdateListener

Read the Windows register to find out which application is associated to a particular extension. Example in VBScript, searching extension .ods for Calc im Key, wsh, fileExt, appli, cmdAppli fileExt = ".ods" Set wsh = CreateObject("WScript.Shell") Key = "HKCR\" & fil...

Property Anchor points to the paragraph where the graphic is anchored. From the paragraph, getText() returns the text the paragraph belongs to. In the general case, this text may be the ordinary text you write, or the text inside a text frame, or the text inside a cell of a table, or the text of the...

You are right : gotoEndOfUsedArea supposes that the columns are "clean". If somewhere down in a column a cell has hard formatting (a cell border, or a background color), or simply a cell value that you forgot to delete at row 12586, the EndOfUsedArea will go there. Typical case : you have ...

When searching the end of used area, skip the column header. Simplified code, using Basic For Each in an enumeration Dim sh As Object, rg As Object Dim visiCells As Object, pack As Object Dim cursor As Object Dim nbRows As Long sh = ThisComponent.Sheets.getByName("yourSheetname") rg = sh.g...

Your range must be limited to the length of your table. Or you will count empty rows.

Hi,
Use Xray or MRI to display properties and methods of your object. And read available docs.

First, close completely your OpenOffice (including the Quick starter if exists in the Mac version). Then start again OpenOffice and check the Tools menu. The new item may appear now. This is what I have on MS-Windows: Ecran004.png Perhaps the Add-Ons submenu is elsewhere in MacOs version ? Hopefully...

Hi, Menu Tools - Add-ons - History Master : List handling... Change the size of each list from 0 to 100. Eliminate the useless names. Change the order of the names. Menu File - Recent of same type... Find recent documents of a same type in one of the lists. Once you have opened List Handling, click ...

Here is a solution. Align_cells_AtLeft.ods Somewhere in columns D to L, it is expected to find 4 data in succession. Empty lines are skipped. Adapt to your needs. Option Explicit Sub AlignToColumnLeft Dim sh As Object, zone As Object, dataRow As Variant Dim y As Long, x1 As Long, x2 As Long Const mi...

What do you want to achieve ?
As an example, write in sheet2 of the document the result you want.

The format depends on the Locale setting.
Menu Tools > Options > Language Settings > Languages > Locale setting.

But when I try to print out the Value of the documentId i always get an exception. I used system.out.println(propertySet.getPropertyValue("documentId")) If I understand correctly the Java lingo, you tried to get the value from a propertySet obtained from the document, instead of from user...