Stack Overflow
Stack Overflow

Questions tagged [libreoffice]

LibreOffice (LibO) is a free and open source office suite, developed by The Document Foundation. It was forked from OpenOffice.org (OOo) in 2010.

LibreOffice (LibO) is a free and open source office suite, developed by The Document Foundation. It was forked from OpenOffice.org (OOo) in 2010.

The tag can be used for all LibreOffice questions. If your question is limited to one of the programs included in LibreOffice you can further add , , or . Questions targeting LibreOffice API and extension development should additionally be tagged with .

Resources:

1725 questions
20
votes
5 answers

unoconv not working while trying to convert. throws Error: Unable to connect or start own listener. Aborting

I am trying to convert docx to pdf using unoconv, but getting Error: Unable to connect or start own listener. Aborting. when I run unoconv -f pdf 1234.docx. So, there must be some listener. I then started the listener via unoconv --listener. I tried…
Krishna Prasad Varma
  • 4,670
  • 5
  • 29
  • 41
20
votes
4 answers

How to convert PDF files to spreadsheets

I have been trying the whole day to convert several. pdf files which contain traffic flow for São Paulo to spreadsheets like MS Office Excel, or LibreOffice Calc in Ubuntu. When I open the .pdf file with LibreOffice Calc it opens LibreOffice Draw,…
Sergio
  • 714
  • 1
  • 8
  • 24
19
votes
3 answers

Replace LibreOffice formulas with their calculated values in an entire column at once

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, then the repeating of this job N times is not happy…
user3766478
  • 641
  • 2
  • 7
  • 16
19
votes
4 answers

Losing superscript tag when converting HTML to DOCX using libreoffice

I have the following HTML:

nth

I am using the command: $ libreoffice --convert-to docx:"MS Word 2007 XML" test.html To convert that HTML into a DOCX file. However I notice that the resulting DOCX file…
Jason Ward
  • 191
  • 6
19
votes
1 answer

How to resize page to fit drawing contents in Open office/Libre Office Draw

I am programmatically drawing a flowchart in open office draw by means of Java UNO Runtime Reference api.After I have drawn the flowchart I want to resize the page according to the area aquired by the contents drawn.I have noticed that Microsoft…
Alok
  • 929
  • 10
  • 26
17
votes
4 answers

Libreoffice Calc: convert many cells with text to numbers

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 function in Libre Office for such mass conversion, or do…
shuhalo
  • 5,732
  • 12
  • 43
  • 60
17
votes
4 answers

How do I make vba code compatible with libre office

I have recently migrated to pclinuxos from windows and seem to like it. The only problem I am facing is that libreoffice, the default spreadsheet package is not compatible with excel macros. Below is the vba code I have: Option VBASupport Sub…
user3125707
  • 399
  • 2
  • 5
  • 20
16
votes
5 answers

OpenOffice command line PDF creation

I have some documentation written in OpenOffice, and I would like to include some of it as PDF files in the final build deliveries. I would like to do this with the automated build script. Is there a way to create a PDF file from OpenOffice with a…
Drejc
  • 14,196
  • 16
  • 71
  • 106
16
votes
1 answer

Can I use OR in LibreOffice calc IF statement?

I'm trying to achieve something like: =IF( N2="string1", "high", IF( N2="string2" or N2="string3","middle","low") ) Or, in psuedo code: String input = if( input.equals("string1") ) { return "high" } else if ( input.equals("string2)…
DaFoot
  • 1,475
  • 8
  • 29
  • 58
14
votes
8 answers

Running libreoffice from php exec()

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 it from php. This demands that the web-user (www)…
user1176941
  • 141
  • 1
  • 1
  • 3
14
votes
2 answers

How to convert .docx to .odt with Libreoffice on Ubuntu bash

There is a problem for converting DOCX to PDF using Libreoffice.(in RTL documents) but converting same document saved in ODT format will works fine. Anyone knows how to convert an existing DOCX file to ODT using Ubuntu bash?
wtayyeb
  • 1,879
  • 2
  • 18
  • 38
14
votes
6 answers

Parallel Document Conversion ODT > PDF Libreoffice

I am converting hundreds of ODT files to PDF files, and it takes a long time doing one after the other. I have a CPU with multiple cores. Is it possible to use bash or python to write a script to do these in parallel? Is there a way to parallelize…
timlev
  • 143
  • 1
  • 1
  • 4
14
votes
2 answers

Export a LibreOffice Calc Chart to PDF witouth margins and empty space

My aim is to export a LibreOffice Calc chart in PDF in order to use it with LaTex later. I made a 16cm width and 9cm high graph. I would like to get a PDF without border and lot of empty space. So I went to : file -> export as PDF->…
S12000
  • 3,345
  • 12
  • 35
  • 51
14
votes
2 answers

what language do I need to write macros in LIbre Office Calc?

I've written a bunch of VBA code for various things in Excel. I'm looking at migrating to libreOffice. Under Tool->Macros->Organize Macros: the two choices are LibreOffice Basic and Python. Should I learn one of those, both, or something else. Am…
DBWeinstein
  • 8,605
  • 31
  • 73
  • 118
13
votes
3 answers

How to convert pptx files to jpg or png (for each slide) on linux?

I want to convert a powerpoint presentation to multiple images. I already installed LibreOffice on my server and converting docx to pdf is no problem. pptx to pdf conversion does not work. I used following command line: libreoffice --headless…
user2718671
  • 2,866
  • 9
  • 49
  • 86
1
2
3
…
99 100