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
0
votes
1 answer

LibreOffice Calc: overriding hide-if-zero for individual cells?

I'm using LibreOffice Calc version 5.0.2.3. I have my spreadsheet configured to hide zero values. However, for a small number of individual cells on this spreadsheet, I want to override the default behavior and explicitly show the zeros. I can't…
HippoMan
  • 2,119
  • 2
  • 25
  • 48
0
votes
1 answer

Bootstrap Uno LibreOffice exception

With the following code: static void Main() { try { var context = uno.util.Bootstrap.bootstrap(); } catch (Exception ex) { Console.WriteLine(ex.toString()); } } This code works fine in win 7 but getting "SEH…
Kavitha Guruswamy
  • 59
  • 1
  • 6
0
votes
3 answers

unoconv return error when running as www-data

When running this from command line as root it works unoconv -f csv $file But when running it as www-data this error is returned Traceback (most recent call last): File "/usr/bin/unoconv", line 1114, in office_environ(of) File…
clarkk
  • 27,151
  • 72
  • 200
  • 340
0
votes
2 answers

Libreoffice macro how to use external python (not embedde) script througth shell function

Libreoffice macro shell function work fine when shell, PHP or something not python, But shell("x.py") is forced use only embedded python. I want to use external python , maybe some work around exists.
Tadashi Nagao
  • 75
  • 1
  • 6
0
votes
0 answers

XOR codin text Macro LibreOffice

I have an assignment to make a macro in LibreOffice that I have to code a text using XOR operations. the instructions are following. izracunajHash function (password zacetni_hash) - This function will implement a hash function that will calculate…
Domen Lisjak
  • 45
  • 1
  • 7
0
votes
1 answer

Check LibreOffice presentation for picture license

I have a presentation that I would like to publish. I am pretty sure most of the images are CC-By-SA, but I would like to make sure. Is there a tool that: exports all images in an .odp-file searches for these on Google Images finds the…
Ole Tange
  • 31,768
  • 5
  • 86
  • 104
0
votes
0 answers

Libreoffice base report's total

I've found a lot of info about how to add "total" row to report, but none of them worked as needed. As for the moment I have a report, made of query and additional query, calculating only totals. the report shows the first query's values as a table.…
Alex Tiger
  • 377
  • 3
  • 22
0
votes
1 answer

soffice socket is not opening via commandline

I wana use the pyoo.py package to control libreOffice via Python. There are good tutorials available. First step is to open a socket with following command. soffice --nologo --norestore --nodefault…
Peter
  • 1,629
  • 2
  • 25
  • 45
0
votes
1 answer

Link External File LibreOffice

I Have an Excel of my customer, and I have to link a column to another File. In my column I can see =VLOOKUP(F2,'file://myfile.xlsx'#$Foglio1.$A$2:$E$65,3,) with right Path, but if I change myfile.xlsx, my data doesn't changed. When I do a Csv, my…
monkeyUser
  • 4,301
  • 7
  • 46
  • 95
0
votes
1 answer

Insert new row into LibreOffice writer table using UNO

I have recently tried to code a small java file which will insert a row into an already existing table in a .odt document. The table itself has 4 rows and 3 column, but I would like to implement a check which will expand that table if the content to…
Danut Niculae
  • 17
  • 6
0
votes
2 answers

Create string in CELL B1 from multiple rows in ColumnA

I have a column in a worksheet: ColumnA wer rfvg swe dfe I would like to create a string 'wer','rfvg','swe','dfe' for use in a TSQL query SELECT value FROM table WHERE code IN ('wer','rfvg','swe','dfe') What I do now: 1. put…
Henrov
  • 1,610
  • 1
  • 24
  • 52
0
votes
2 answers

How to highlight text using macros and visual basic in LibreOffice

I have to write a macro that highlights specific numbers (to set the background color to yellow). I have already written a macro that finds these numbers using object Cursor but i don't know how to change the background color. Dim Cursor As…
Izak
  • 307
  • 5
  • 12
0
votes
1 answer

Opening large ODS file takes a long time (48 min) on Windows 8.1 x64

Tried using LibreOffice 5.0.3 rc2, 2015-11-03-nightly, and 4.4.6.3, all with the same result. I've tried: Deleting my user profile Upping the Memory settings Opening the file on an Ubuntu 14.04 VM (it opened immediately) Opening the file on a…
ijustlovemath
  • 703
  • 10
  • 21
0
votes
1 answer

LibreOffice Mail Merge with Java

I'm trying to use the libre office mail merge functionality automatically from an java application. I have tried to install the libreoffice sdk but without success because they require software that is not available anymore (e.g. zip-tools). Anyway…
Arthur Welsch
  • 269
  • 2
  • 15
0
votes
1 answer

Incorrect graph export as PNG using macros on LibreOffice

I am trying to export all charts on multiple sheet within my spreadsheet. I've looked some examples online to came up with a code that extracts all graphs within my file as PNGs. But I may be missing something, because every time I run this macro,…
Danmaxis
  • 1,710
  • 4
  • 17
  • 27
1 2 3
…
99
100