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
92
votes
6 answers

Command `libreoffice --headless --convert-to pdf test.docx --outdir /pdf` is not working

I have to wait for long after using this LibreOffice command which is intended to convert DOCX into PDF: libreoffice --headless --convert-to pdf test.docx --outdir /pdf But I'm getting no response and no error. No file is converted. It looks like…
vishal
  • 1,368
  • 2
  • 15
  • 34
88
votes
12 answers

How to convert OpenDocument spreadsheets to a pandas DataFrame?

The Python library pandas can read Excel spreadsheets and convert them to a pandas.DataFrame with pandas.read_excel(file) command. Under the hood, it uses xlrd library which does not support ods files. Is there an equivalent of pandas.read_excel for…
Lamps1829
  • 2,231
  • 3
  • 24
  • 32
84
votes
5 answers

Quickest way to apply a formula to an entire column?

I want each row in column B to be f( column A), so that b[n]=f(a[n]). I could go row by row and apply the formula, but is there an easy way to just drag the formula down and have it increment the cells it's referencing automatically?
Eamonn M.R.
  • 1,917
  • 2
  • 17
  • 23
52
votes
9 answers

How do I embed source code or HTML in Open Office Org Presentations without using screenshots?

I need to write a lot of class courses presentations to my programming class, and I constantly need to show source code (mainly C code). I don't find a easy way to: Copy my source code from my editor (kate) and Paste it formated and with source…
DrBeco
  • 11,237
  • 9
  • 59
  • 76
36
votes
5 answers

Libreoffice/Openoffice Calc - append string to cells

I need to add .jpg at the end of all he cells in one or more columns 9788895249971 into > 9788895249971.jpg 9788867230129 into > 9788867230129.jpg 9788867230273 into > 9788867230273.jpg 9788867230280 into > 9788867230280.jpg Detailed…
Gabriele
  • 503
  • 1
  • 5
  • 9
34
votes
1 answer

OOo/LibreOffice UNO / Java: How to get calling spreadsheet cell of a calc function?

In an UNO extension for OpenOffice/LibreOffice Calc (Spreadsheet), written in Java, how can you determine the calling cell inside the implementation of a UDF (spreadsheet function)? Remarks In Excel/VBA this is possible via Application.Caller The…
Christian Fries
  • 16,175
  • 10
  • 56
  • 67
29
votes
1 answer

The ant/ folder is suddenly missing from Android SDK. Did Google remove it?

I've tried compiling libreoffice core project (choosing Android module) (with make, no Gradle involved yet), and I'm getting this error: /home/aleksandar/libreoffice/workdir/UnpackedTarball/owncloud_android_lib/build.xml:90: Cannot find…
Aleksandar Stefanović
  • 1,583
  • 2
  • 20
  • 36
29
votes
5 answers

How to run python macros in LibreOffice?

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 macros elsewhere and then just execute them. But I do…
Martin Drozdik
  • 12,742
  • 22
  • 81
  • 146
26
votes
8 answers

how to create an odt file programmatically with java?

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 clear.
baris
  • 261
  • 1
  • 3
  • 3
25
votes
1 answer

Excel VLOOKUP where the key is not in the first column

"The range where the lookup value is located. Remember that the lookup value should always be in the first column in the range for VLOOKUP to work correctly. For example, if your lookup value is in cell C2 then your range should start with C." But…
BrianFreud
  • 7,094
  • 6
  • 33
  • 50
25
votes
2 answers

Change the font size of the formula in libreoffice impress

I want to change the font size of the formulas(math) in libreoffice impress. How can I do it?
user34790
  • 2,020
  • 7
  • 30
  • 37
23
votes
6 answers

Warning: failed to read path from javaldx

An error occurs when converting a file using Libreoffice on ubuntu: CompletedProcess(args=['soffice', '--headless', '--convert-to', 'txt:Text', '/var/www/Project/temp/e4bac2c2e7c04eb79cfa522967a30dd3.docx', '--outdir', '/var/www/Project/temp/'],…
Evgenij Tsvetkov
  • 331
  • 1
  • 2
  • 4
23
votes
10 answers

Libreoffice only convert from odt to pdf, not other formats

I'm trying to convert documents from html,txt to pdf,odt and vice versa.. But only odt to pdf seems to work.. No other file formats are converted Here are my commands libreoffice --headless --convert-to pdf test.html [Not working] libreoffice…
casper123
  • 1,736
  • 4
  • 21
  • 39
21
votes
3 answers

How can I tell git to ignore LibreOffice lock files?

I have a git repo which contains some XSLX files. I edit them with LibreOffice every once in a while. Sometimes LibreOffice won't remove the lock files ( ./folder/.~lock.filename.xslx#). This causes those files to be liested as new on every git…
ignasi35
  • 885
  • 6
  • 14
21
votes
2 answers

How to keep one field fixed in a formular when using auto-fill?

I want to autofill a formula to a bunch of fields in one column. I can do that by filling two fields manually then select them and drag down. I want column B's cells to be =D1*A1 , =D1*A2,... Note D1 should not change. When I drag the fields down…
Seeker
  • 1,250
  • 1
  • 16
  • 23
1
2 3
…
99 100