LibreOffice is a free and open source office suite. The LibreOffice suite comprises programs for word processing, the creation and editing of spreadsheets, slideshows, diagrams and drawings, working with databases, and composing mathematical formulae. It is available in 110 languages. LibreOffice uses the international ISO/IEC standard OpenDocument file format as its native format to save documents for all of its applications. LibreOffice is also compatible with other major office suites through a variety of import/export filters. LibreOffice is available for a variety of computing platforms, including Windows, OS X) and Linux.

Share tech news, updates, or what's on your mind.

Sign up to Post


I have a document and in that document I'm having links to other documents. It has worked all the time, but sudden I'm getting this error message:

\\fileserver\sharedfolder\sharedfile is not an absolute url that can be passed to an external application to open it.

Anyone can help me on this?
I am creating a self-filling spreadsheet in LibreOffice. I have searched but I can't find out what code to make an API call to change a spreadsheet cell type to "Date" in LibreOffice/OpenOffice.

REM  *****  BASIC  *****

sub Main
rem ----------------------------------------------------------------------
rem define variables
dim Doc   as object
Dim Sheet As Object
Dim Cell As Object 
Dim DatesStuffWasRecieved (20) as Date
Dim QuantitiesRecieved (20) as Integer

rem initialize everything
Doc   = ThisComponent
Sheet = Doc.Sheets(0)
DatesStuffWasRecieved(1) = DateValue("12/02/2011")

	Cell = Sheet.getCellByPosition(0, 6)
Rem Here is where I want to change the cell format to display the date rather than the cryptic number DateValue("12/02/2011")

end Sub

Open in new window


I work in openoffice calc. I set up product calculations in separate sheets. I have a summary page where I collect basic information from each product. One of these things is the number of products sold per year.

What I would like to achieve is to change this value both from a product sheet and from the overview page. Maby some kind of reffernce.

Trying to search for it, but its hard to describe what i want.
Hi all,

I am stuck and have been spent a long time. Any help to get me started is appreciated.
I have created some presentation slides using :

oDoc1 = StarDesktop.loadComponentFromURL( ....document 1... )

But, I can't put a timer between the slides. I am trying to do a pause of a couple of seconds before the slide advances to the next slide. And then, when the presentation finishes, it starts from the first slide again.

I think, i need a timer. Could please direct to any function to get me started , i would appreciate it very much.
Hello. I use the latest version of LibreOffice version 3.5.3, English (US) on my Linux Ubuntu v.12.04 64-bit LTS system.

Often when I am working with any one of the components of the entire suite of LibreOffice like LibreOffice Writer, Calc, Impress, and Draw to name a few; I notice that if 'I accidentally' close a component program (That is close the window.) WITHOUT saving my work; by sheer stupidity out of my part (Honestly, it has happened even when I received the message if I wanted to save my work; I have ignored it and went ahead and closed the LibreOffice component program.); therefore I have lost my work. Yes, normally I always save my work; but yes, I will be sincere, 'stupid' accidents happen to me because I am not thinking and 'too window happy' closing the open windows when many windows are indeed open in Linux Ubuntu and not just the LibreOffice suite program components. I have to think in reality, this has even happened to you too.

Questions – please answer both:

1. Now, if I make a stupid accident and lost my work; is there a fail proof way or means where in the background (out of the sight and interaction of the actual user) where LibreOffice's component programs have the ability to 'automatically' make backups in some specified folder directory location within Linux Ubuntu operating system? For example: a LibreOffice Writer file (*.odt) would be saved under some specifiable conditions, special event, or immediate action at a specified folder …

I want to add some text to the body in the presentation using a macro. Any example or links is apprecaited. I can title using this, but to add the text in the body ?


in a file I have a list with following columns:
Inventorynumber:Ordernumber:Software:User:Computer:Serial key
this is in the first sheet of that file. Now for every different software, I created a different sheet. The goal is to, for instance for MS Office Pro 2010, see if a line with ms office pro 2012 is present in the first sheet, it's also shown in the sheet that I created for ms office pro 2012.

Is there a way to get this working?

Hello. I have a question to ask you.

In LibreOffice Writer v. (latest), part of LibreOffice Productivity Suite, regardless of the distribution version for compatible operating systems like Windows or Linux like Ubuntu; when you go to save a document it ALWAYS BY ‘default’ saves [such as selecting “As Save” and “Save”] – it saves the document file as “Untitled 1”, “Untitled 2”, etc. When I save a document file with Microsoft Office Word 2003/2007/2010, it will save by default (No user modifications – it is per-programmed (“out of the box”) to behave that way.) by the first few words or phrases within the first few words or phrases in the file document itself where ever you wish to save the document file in the system.  

Question I am asking:

Is there a way or means with LibreOffice Writer to save by default’ the first few letters of the words or phrases within the first few words or phrases in the file document itself – much like Microsoft Office Word 2003/2007/2010 does?

Yes, I obviously will need to ‘change’ LibreOffice Writer to a different and new ‘default’ format to save the document file in that manner, but once setup in that manner; it will always be the ‘default’ manner in which to save document files with LibreOffice – by the first few letters of the words or phrases within the first few words or phrases in the file document itself.


This document file renaming gives me some limited knowledge about what the document file is about …

Our customers want to export the results of our application into the LibreOffice Calc (instead of to MS Excel, because of price of the Excel license).  Is anybody here who was able to export any data into LibreOffice Calc (earlier OpenOffice) from a C++ application on Windows?

Hi experts, I need to find a way to obtain the cell color code from, something like

I'm using OpenOffice/LibreOffice
thanks in advance

I need to hyperlink several references within a word document, to open a specific file that is located within the sub folder of the source word document.

When opening the document additional parameters need to be passed to open the document on specific page, I can do this with an absolute hyperlink, however the location of the document will change.

For example the current location of the MS Word file is C:\Temp and the linked document is located in C:\Temp\Document.
Absolute Hyperlink = "file:///C:/temp/document/abc.pdf"

Can this be done using a relative path?
Take the following concatenate function:


If B2=abc123, this results in the following link, which is not clickable in Calc:

How can I make this link clickable without copy and paste. It should be directly clickable when copied over many lines with different B-values.
I'm looking for a quick solution to create a macro in a LO Spreadsheet that will search a range of cells for a text string, then when finding one, move it into a second range of cells.

Here's what I have so far:
Sub ExtractByString()

Dim FindAddress As String
Dim extString As String, WCString
Dim oSheet
Dim oInCells, oOutCells
Dim Found

oSheet = ThisComponent.Sheets.getByName("Sheet1")
oInCells = oSheet.getCellRangeByName("A1:A50000")

extString = InputBox("Please Enter String.", "String Entry!")

WCString = oInCells.createSearchDescriptor
WCString.SearchString= "*" & extString & "*"
WCString.SearchSimilarity = True
WCString.SearchSimilarityAdd = 2
WCString.SearchSimilarityExchange = 2
WCString.SearchSimilarityRemove = 2
WCString.SearchSimilarityRelax = False

If "" = extString Then
    Exit Sub
   Found = oInCells.FindFirst(WCString)


End Sub

Open in new window

Now what I'm stuck on is I can't find any documentation on the properties/methods available to do what I want, particularly where the cell range that was found is returned so that I can move it to a different location.

Any thoughts appreciated....

I'm trying to create macros to handle a number of spreadsheet routines in LibreOffice Calc.

The output of every single function has suddenly become #VALUE in the spreadsheet.

And as a corollary, the numeric output when they did work had four decimal places -- no amount of formatting would convert them to currency.

Can you help?

Capt Alberta
I'm tracking money in libre office calc (spreadsheet). The rows show  the values of columns for successive years.

Column "n" contains the value of an interest accruing account.  
Column "p" has my age for each year.

I want to print my age (p) when the value(n) of the account is greater than a million.
Hello Experts,

I have several dbf files (example attached) that vary in the number of rows for each, but the columns remain the same for all.  I would like to use either Vlookup, index, or a macro to look at Column C on Sheet2 and Column C on Sheet1.  Then whenever the values match, move Columns C through W on Sheet2 to Sheet1 beginning on Column M of Sheet1.

For example, on the file provided, I would like to have Sheet2 Row 1 Columns C through W move to Sheet1 Row 11 Columns M through AG.  

Any help would be greatly appreciated.

We have software that takes CSV files as input.  A user is using a Mac laptop to enter her data into Excel, then saving the file as CSV.  The problem is this:  If we look at the CSV file (that was saved by Excel) in a text editor (ex: TextEdit on the Mac), the output delimiter is a semi-colon instead of commas appearing between each data item.  The format we need for the other software must have commas.

Saving this file as CSV is hurdle enough for this user, so I don't want to as her to do save as CSV, open the CSV in TextEdit, do a find/replace for ; to , ...  That would be confusing for her to do.

I did try changing the language on the laptop to English, then doing the save as CSV from Excel, and commas do correctly appear.  This too is not a solution, as she doesn't speak English very well, and should be able to have her laptop in Norwegian if she wishes.

Are there any other solutions to this problem?
Is there another way to force commas to appear as the delimiter?

We also tried OpenOffice's Calc, but had the same results (so, it definitely seems to be an issue stemming from the language setting).  Actually, OpenOffice worked better at correctly opening the CSV file initially, but still saved the semi-colons out.  

Any solution with OpenOffice Calc, Excel, or any other CSV Editing software that will work on a Mac is welcome!
Hello Experts.

I have the following macro that works with Excel, but I would like to have a version that works with libreOffice as well.  I get an error with "dim r as Range" when I try to run it in libreOffice Calc.  It says "Basic syntax error.  Unknown data type Range".  Here's the macro:

Sub RemoveSelectColumns()
    Dim iColumn As Integer
    Dim strCell As String
    Dim strColumnName As String
    Dim r As Range
    iColumn = 1
        strCell = Cells(1, iColumn).Value
        If strCell = "" Then
            Exit Do
        End If
        If UCase(strCell) = "MOE" Then
            ' case-independent
            strColumnName = Split(Cells(1, iColumn).Address, "$")(1)
            Columns(strColumnName & ":" & strColumnName).Delete Shift:=xlToLeft
            iColumn = iColumn + 1
        End If
End Sub

Open in new window

Any help would be greatly appreciated.
Sometimes I have to write user manuals with lots of screenshots in it. I have to insert these images into a Writer document, and it always bugs me that there is no easier way to insert an image. I have to open the Insert-menu, go to the Picture submenu, then select From file. I would like to have a button that is just one click. For two or three images the current method is OK, but for 100 pics not anymore.

I've tried to add image-buttons, but these are for other functions. Is there a way to do this?
I need to remove a address from my Microsoft Outlook addresses.  I already changed the user name on the server but it still shows up in the address. How do I get rid of it?
Is there a function, or does somebody have a formula or way of attacking these 3 problems, all in MS Excel (could also give an answer using Open Office Calc):  

(1) (a) How do you round to the nearest 10?  (b) Better yet, express the answer more generally.  So, the question, ideally, is, "How do you round to the nearest x, where x = a given, real number?"

(2) (a) How do you round up to the nearest 10?  (b) Same follow-up as in question (1).

(3) (a) How do you round down to the nearest 10?  (b) Same follow-up as in question (1).

I have Excel 2003.  I'd prefer an answer in Excel to one requiring Open Office Calc, but if there's a much easier way to do it in the latter, I'd be very interested in knowing that fact.  It will probably be easiest to follow this thread if people specify which problem they're addressing, for example, "Problem (2b)".

Hi there I am attaching this table. Can you all fix this for me? I want all those blank space in the end to be deleted and also I want that footer with the signature to be at the end so that the person can sign.... CUSTOMS-AND-EXCISE-DIVISIONnew.docx

i need this for this evening
Hello. I have a question.

I know in the Writer and LibreOffice Writer has an effective and wonderful feature called something to the effect called or named 'word auto-fill' that when you type a 'longer' word, it automatically suggests the remainder of the word (I believe based on same word used elsewhere in the document.) and completes it if you desire too. This obviously saves time by fewer keystrokes. Please see the attached screen capture image below named/titled; "Open Source Writer Programs - Word Auto Fill Example". Please see the blue highlighted texted type in this attached screen capture image below for details and clarity.

My question:

Is there such a feature in Microsoft Office Word 2007 and 2010 that offers 'word auto-fill'? I have been doing some preliminary searching and I do not see any reference to it, but then again; I may not be looking at the right online sources since the terminology may be different for Microsoft Word 2007 and 2010. Is it some, internal, native Word 2007 and Word 2010 setting; and/or some add-on installation feature, and/or some third party program installation to enable this 'word auto-fill' feature?

Please provide your own best possible well written, detailed and documented website links; and/or your own detailed facts, suggestions, hints, and tips.

DO NOT USE or similar-like web links in your reply. I consider its use very unprofessional for EE experts. If you do, you will not get acknowledged …
What is the best way to edit PDF:s?

To do this directly in a PDF-editor like Adobe Pro, Foxit Phantom or Nitro PDF Professional works to some extend fairly good. But when it comes to page layout (inserting extra rows, moving text pieces, formatting of text) it gets more cumbersome.

So I was wondering if the preferable way would be to export a PDF to Word (or OpenWord) and edit there and when finished just import as PDF (create PDF)?

Or, for more advanced tasks (complex texts and complex page layouts with a lot of different objects and format), which DTP-software or page layout software would be useful for me?
Hello. I have an issue to ask you.

After I have initially installed  either of the 2 popular Open Source office products called 3 or LibreOffice 3 into my Windows 7 Professional 64-bit operating system, and then I wanted to modify my installation files of both products [“Custom Setup” features]. When I attempted to re-run the setup files of each Open Source office product by modifying the “Custom Setup” features, and at the moment of installation process following a Windows 7 User Account verification; I was unable to complete the installation operations of both products from the Installation Wizard as Windows 7 messages appeared on my screen. Therefore I was unable to complete the modified the “Custom Setup” features. Please see my attached Windows 7 messages as screen image clippings for clarity with this issue for both Open Source office products.

I then decided to try to uninstall both Open Source office products and then re-install then again with the “Custom Setup” features I wanted; maybe this would work. However, again, through the same set of sets as I have outlined above, I get the same Installation Wizard's Windows 7 messages appearing on my screen. Therefore, I am stuck with both Open Source office products on my system, unable to uninstall if I wished to and even modify both.

Could you please help with me with this issue so I can:

1. “modify” BOTH Open Source office products during a re-installation process on my Windows 7 Professional…






LibreOffice is a free and open source office suite. The LibreOffice suite comprises programs for word processing, the creation and editing of spreadsheets, slideshows, diagrams and drawings, working with databases, and composing mathematical formulae. It is available in 110 languages. LibreOffice uses the international ISO/IEC standard OpenDocument file format as its native format to save documents for all of its applications. LibreOffice is also compatible with other major office suites through a variety of import/export filters. LibreOffice is available for a variety of computing platforms, including Windows, OS X) and Linux.

Top Experts In