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

Import/export or store/restore xShapes in LibreOffice/OpenOffice Draw via API

I want – as the title says – extract programmatically a shape from a Draw document through the api interface. Beside I want to import such a shape into a document as well. I saw some predefined shapes in XML form and the document is stored as XML…
Jens Bornschein
  • 163
  • 2
  • 11
0
votes
1 answer

LibreOffice Calc two Alignments - One Cell

Is it possible to write one word with left alignment and one word with right alignment in a single cell in LibreOffice Calc? Like that: | normal Cell one | Halli _________ Hallo | normal Cell three | Everytime I try to simulate it with many spaces…
YetanotherQuestion
  • 1
0
votes
1 answer

excel vs awk (delimiters)

I have question. If I open a tsv file in libre office (linux excel), I have every tab delimited string in each column. But if I use awk, I received only first part of string which are delimited by space. F.E.: Libre office: a how much I need …
Vonton
  • 2,872
  • 4
  • 20
  • 27
0
votes
2 answers

Libreoffice convert to pdf unpredictable size

This code I use to convert xls to pdf file: /usr/bin/libreoffice --headless --convert-to pdf $path --outdir $destinationDirectory On localhost desktop with Xorg it works ok. Document converting to one page without problems. But on server pdf file…
johndoek
  • 101
  • 1
  • 9
0
votes
1 answer

sumif doesn't run "not" when cell is blank

I'm trying to summarize cells where field is not a given value. This works in Google Docs and MS Office, but in LibreOffice and OpenOffice it only summarizes when the call has a value. If E7 (see attached image) had a value of foo, LibreOffice…
Marwelln
  • 28,492
  • 21
  • 93
  • 117
0
votes
1 answer

XSLT Export Filter produces unnecessary empty XML tags

I'm using an XSLT export filter to export a part of an OpenOffice Calc spreadsheet into an XML file. One part of the filter uses the xls:for-each iteration because there can be a different amount of entries every time the script is run. But that…
Jdv
  • 962
  • 10
  • 34
0
votes
0 answers

How to make Libreoffice build smallest as possible?

I'm planning to use only LibreOffice to convert files from one format to another. E.g soffice --headless --convert-to doc --outdir D:\output D:\input\filename.docx So e.g I completely don't need GUI support ,etc. What flags/options should I use…
user3305379
  • 35
  • 1
  • 7
0
votes
1 answer

LibreOffice (soffice) issue while converting on Amazon ec2

This is not a repost, I am asking for the Amazon ec2 instance ! Questions that others asked worked fine on my local machine, and those were solved, but not on Amazon. There have been several reports regarding this problem, but nothing solved this…
3xCh1_23
  • 1,491
  • 1
  • 20
  • 39
0
votes
2 answers

LibreOffice Macro always show #NULL! after reopening the file

I wrote a macro in LibreOffice Calc and it is able to run correctly. But if I close the file and reopen, it always show #NULL! instead of the correct value. What am I missing here? My macro code Rem Attribute VBA_ModuleType=VBAModule Option…
rcs
  • 6,713
  • 12
  • 53
  • 75
0
votes
1 answer

Libre office writer macro insert date, and date + n days

There is a similar question here but using calc however teh answer woul seem to be calc specific. I would like to write a macro in libre writer that inserts the current date, a comma and space then the current date + 2 days, a comma and space then…
dmonarch
  • 55
  • 1
  • 8
0
votes
1 answer

LibreOffice Writer: How to Replace Font of Searched Text

I have several documents in .DOC format that includes words in English and Sanskrit (Devanagari). I am using LibreOffice Writer: Version: 5.1.4.2 Build ID: 1:5.1.4-0ubuntu1 Locale: en-US (en_GB.UTF-8) The default font is Liberation Serif, which I…
Arya
  • 566
  • 2
  • 9
  • 22
0
votes
0 answers

Trouble with LibreOffice Calc JRE

I'm brand new to using macros and spreadsheets and am having trouble with LibreOffice Calc recognizing the JRE that I have installed. I've spent a day following advice on this topic on other forums, but to no avail. Any help would be greatly…
AliZ
  • 303
  • 3
  • 8
0
votes
1 answer

LibreOffice set text fixed on frontpage

I would like to know if it's possible to set a text block on a fixed position on the front page using LibreOffice.
PimD1988
  • 307
  • 5
  • 14
0
votes
3 answers

Convert text date format to number date format

I have stored some data entrys in a CSV file in following Format: Thu Jul 28 08:42:33 GMT+01:00 2016 and need to convert it to just a time stamp (eg. h:m:s). How can I quickly and easily do this?
user6411199
0
votes
1 answer

LibreOffice Java package settings vendorData

So I've got a task today, to automatize the proccess of selecting Java package in LibreOffice (when you install new Java version in GPO, you have to select new version of Java manualy in LibreOffice by Tools->Settings->LibreOffice->Advanced). The…
PatrykMilewski
  • 922
  • 8
  • 17
1 2 3
…
99 100