I'm working with an ODS file in LibreOffice, and every now and then I want to convert it to CSV from the command line. I have found two tools for this: libreoffice --headless --convert-to csv and u...

I have to create a table with LibeOffice Calc in another language than my native one. If I run the spellchecking, I manually have to change the language for every word in the document. How do I ch...

I want to change the font size of the formulas(math) in libreoffice impress. How can I do it?

I have got many cells in my file whose content is of the form '14.05 I want to mass convert these cells, which contain text, to numbers, which I can compute with. 14.05 Is there a build-in f...

I am trying to convert an image in EMF format to PNG using Imagemagick on Red Hat Enterprise Linux Server release 5.5 (Tikanga), but I am running into the following error: convert: no decode del...

LibreOffice Draw allows you to open a non PDF/A file and export this a PDF/A-1b or PDF/A-2b file. The same is possible from the command line by calling on macOS /Applications/LibreOffice.app/Co...

I'm trying to find a way to convert a PDF file to a .docx file with Python. I have seen other posts related with this, but none of them seem to work correctly in my case. I'm using specifically imp...

I have a spreadsheet with existing date values that I'd like to convert from MM/DD/YYYY to DD/MM/YYYY format. Is there any way of doing this? The spreadsheet comes from a csv file from someone els...

Inside a docker container I am trying to convert an XLSX file to PDF using LibreOffice. The relevant command works on the command line but fails with "Application Error" when called from R. I use t...

The LibreOffice Calc (version 6.3.4.2) shows the definition of the formula in the cell instead of executing the formula and displaying the result. What affects the behaviour? I am starting to use L...

An error occurs when converting a file using Libreoffice on ubuntu: CompletedProcess(args=['soffice', '--headless', '--convert-to', 'txt:Text', '/var/www/Project/temp/e4bac2c2e7c04eb79cfa522967a30...

I have column with cell format date or time (DD.MM.YYYY HH:MM:SS) and values like 03.12.2013 14:01:49 04.12.2013 10:19:27 04.12.2013 12:44:56 04.12.2013 14:20:12 04.12.2013 18:30:21 I need those ...

When I go to Tools -> Macros -> Organize Macros -> Python I get this dialog: It is not possible to create new Python macros. Apparently LibreOffice has no Python editor so I have to write the m...

I'm trying to convert a .xls file to .pdf using LibreOffice via command line on Ubuntu. I have a kind of report on the .xls file with some colors in the background of the cells and etc. The proble...

I am happily converting docx files to PDF via the command line (controlled via C# process calls) out of my service. Unfortunately I could not find any internet search results on how to set the opti...

I have created a table that has a value on one column that I have used to generate a background colour (Format -> Conditional Formatting -> Color Scale... -> Colour Scale). Now I would lik...

I've been searching all day for a solution and can't seem to find anything that works, just a bunch of a leads that seem outdated or non-functional. I'm basically trying to get to a hello-world st...

I want to export formatted text from LibreOffice to HTML. By default, it is exported with lot of inline styles. Is it possible to keep the semantics of the formatting (<p>, <ul>, <...

I can replace a formula in one cell by its calculated value by selecting the cell, hitting F2 then F9 and Enter. When I want to do this for every cells in a column, and height of that column == N,...

Running headless Ubuntu server 12.something. root@server: chown www-data /my/path/ -R root@server: chgrp www-data /my/path/ -R root@server: chmod 755 /my/path/ -R root@server: libreoffice --he...

How can I create an odt (LibreOffice/OpenOffice Writer) file with Java programmatically? A "hello world" example will be sufficient. I looked at the OpenOffice website but the documentation wasn't ...

I want to obtain the sum of several cells containing a period of time in the format HH:MM:SS. In LibreOffice Calc 4.0.3.3, I've copy-pasted the periods of time in the range G14:G21, and formatted t...

How do you make Python (any Python) know about PyUno in LibreOffice? When I do: import uno python says that it knows no module "uno". (This question came up re. this question.)

I have installed libreoffice headless on a freebsd-server with apache in order to convert documents programmatically (e.g. odt->pdf). It works from the command line! But my goal is to be able to do...

I have a column in open office like this: abc-23 abc-32 abc-1 Now, I need to get only the sum of the numbers 23, 32 and 1 using a formula and regular expressions in calc. How do I do that? I t...