Questions tagged [openoffice]

Oracle's OpenOffice.org (OOo) was a popular, cross-platform office suite which has been replaced in many distros by LibreOffice

Filter by
Sorted by
Tagged with
0
votes
1answer
17 views

How to convert string to date with the accuracy of seconds?

I would like to convert a string into a date with the accuracy of seconds, for example: "12.12.2020 14:02". It seems that this is not possible? The DATEVALUE(datetext) culls the hours/mins/...
0
votes
0answers
9 views

In Which Order Calc Processes Interative Formulas: Row After Row Left to Right or Column After Column, Top to Bottom

I am using a spreadsheet with iterative formulas. It worked well in Microsoft Excel and I tried to addapt to Calc with no luck. Trying to find where the bug is, I set iterations to run one by one. In ...
0
votes
0answers
14 views

On-premise enterprise grade office solution for Linux/Unix based enterprises

My company has been increasingly been adopting Linux in its R&D department and we have been considering switching from Windows to Linux on other non-R&D departments as well, one barrier we ...
0
votes
0answers
11 views

“init registries failed” with cppumaker (OpenOffice SDK)

I'm trying to build header files for OpenOffice SDK. Based on this source, I ran the following command (where RDBS=/opt/openoffice4/sdk/programs): ./cppumaker -Gc -O"/usr/include/openoffice/com/...
0
votes
0answers
15 views

Calc: Customize formula autocomplete key

If I type =aver in a cell, Calc shows me a list of formulas. I can hit the Enter key to autocomplete the formula. However in Excel, and a ton of other apps, the autocomplete key is TAB. This is quite ...
0
votes
0answers
26 views

What controls date format in OpenOffice writer?

I'm filling out a form which someone else created in OpenOffice. There is (apparently) a date field which is annoying. OpenOffice changes what I've typed into a date format NN/NN/NN. I'd rather ...
0
votes
0answers
26 views

How can I permenantly change language on Open Office?

I download Open Office and found ooo_albanian_dict_1.6.2.oxt (the language I need to use). Now though, every time I want to write in Albanian I have to change this setting I tried going to ...
1
vote
1answer
30 views

Why are the indents visible? Did I press a button?

So there are dots for spaces and some character every time I hit enter... why are these showing?
1
vote
0answers
18 views

How do I add an extra dictionary/ custom dictionary for fiction writing in Open Office?

So as I add custom definition using my story, it's just adding them to Standard. Is there some way to split off custom words just for my fic?
-2
votes
2answers
2k views

How to open Calc from terminal and insert files?

How to write a command to terminal in Linux that open LibreOffince Calc and inserts files in it? All files consist of one column.
0
votes
1answer
134 views

Formula to convert UTC date time string to date/string in different timezone

I am getting date with time in UTC format. 2018-12-13T03:36:11+00:00 2018-12-10T19:26:48+00:00 I want to convert it to date in different timezone. So take above example and the target timezone is ...
0
votes
0answers
19 views

How to do desktop-integration while installing openoffice on F28

I am installing Openoffice on Fedora28 but libreoffice is already installed meanwhile I am installing Openoffice too but when I am trying to do desktop-integration output is conflicts in symlink of ...
2
votes
1answer
2k views

Password-protect a LibreOffice or OpenOffice ODT file from Bash

From a Bash terminal in a popular GNU/Linux distro, how can a non-password-protected [OpenDocument Text (.odt)](OpenDocument Text) document be transformed into a password-protected one? Unfortunately,...
3
votes
0answers
538 views

Color cells based on text value in LibreOffice Calc

I have a column of containing the days of the week. |dow | |----| |Tue | |Wed | |Thu | |Thu | I would like to color the background of each day differently. So every Mon would have the same color ...
1
vote
0answers
425 views

Converting .odm to .odt or .pdf - command line

I saw this question: Converting .odm to .odt, where someone shows to convert an .odm file into .odt or .pdf. Is there also a way to do this in a command line? I have an Open Document Master file, ...
1
vote
1answer
405 views

KDE Plasma 5 on Fedora 22 - clicking desktop link to .odt (or .doc) file fails to launch OpenOffice

Recently this started happening for no apparent reason: If I click a desktop link to a .odt or .doc file (and presumably others), I get a warning dialog that says: This will start the program ...
0
votes
1answer
260 views

choose ODF vs OOXML [closed]

I just found out about the "war" between ODF and OOXML and I was wondering which was "winning" and whether I should support one over the other in an project that I am about to start up soon. I have a ...
0
votes
1answer
2k views

how to use libreoffice --headless export more than one png image from ppt or pptx

I use libreoffice export images, command like: $ libreoffice --headless --convert-to png ./ /tmp/example.ppt but this command only export one page, is first page image, how can export few image or ...
1
vote
0answers
50 views

Freeze slide on external display (projecter), when using OpenOffice, and use laptop to do other (secret) thing

I am running kde on debian jessie (X11+Gnu+Linux). When doing a presentation, using LibreOffice (OpenOffice) presenter, the audience sees the external display, and I see the presentation console on ...
1
vote
1answer
4k views

Install OpenOffice from cmd line Redhat Linux 6

I stupidly removed OpenOffice from my work laptop and have not managed to re-install it . As it is a work laptop, I have no internet access (just intranet) so I can't download it directly. I ...
3
votes
0answers
158 views

How is This Symbolic Link Not Being Followed?

I have LibreOffice Writer and OpenOffice Calc installed on my OpenSuSE system. This is arguably not ideal, but before I fully switch to one or the other, I noticed some strange behaviour when calling ...
-4
votes
1answer
60 views

OpenOffice won't execute formula [closed]

I'm running OpenOffice 4.1.1 on OSX. I typed a formula into a cell, but the cell shows the raw formula, not the result of executing the formula. What am I doing wrong?
2
votes
1answer
1k views

Openoffice Calc does not extend formula on cells

I am on this CentOS machine, fighting with openoffice 3 Calc, just to do some very simple operations. I have a column of values, and I want to perform the same operation on a certain number of ...
1
vote
4answers
261 views

Search for variable in OpenOffice/LibreOffice

I am using OpenOffice.org Writer to write a book. I foresee the possibility of some characters' names changing, so I am using variables where their names go "Insert > Fields > Other". However, I ...
5
votes
1answer
567 views

Replace missing fonts in OpenOffice

I have a Word document that uses fonts not available on my system. How can I globally replace these fonts? I've tried both Find/Replace (with formatting) and Tools / Options / OpenOffice / Fonts, but ...
6
votes
1answer
16k views

Headless use of open office or libreoffice in Ubuntu 14.04

I want to install openoffice headless in Ubuntu 14.10, but when I try to install it, it says there is no package for that name. I installed libreoffice-common using apt-get, but I can't find headless....
3
votes
1answer
654 views

How to convert .doc to ODF with a command line?

I'd like to convert many Microsoft Word documents to ODF (the OO.org formata with a command line (because there are many of them). (I need them for reading afterwards on a device where reading OO.org ...
6
votes
7answers
3k views

Is it possible to feed Open Office via STDIN?

I have an Open Office Spreadsheet document stored inside a bash variable. I want to do something like the following to feed Open Office via STDIN: echo "$openOfficeDoc" | ooffice But it doesn't work....
7
votes
1answer
1k views

Open/Libre Office: Restricting Impress to PowerPoint-compatible content?

Is there a way to restrict the Open/Libre Office presentation-program Impress to just PowerPoint-compatible content? Preferably in a way that "shadows-out" or removes non-compatible animations and ...
17
votes
6answers
56k views

Linux PPTX presentation Viewer

Besides Open Office, is there any solution for opening .pptx presentations on Linux (Debian to be more precise)?
32
votes
4answers
112k views

Convert a .xlsx (MS Excel) file to .csv on command line with semicolon separated fields

I realize that this is not an entirely unix/linux related question. But since this is something I'll do on linux, I hope someone has an answer. I have an online excel file (.xlsx) which gets updated ...
4
votes
3answers
2k views

Lightweight feature-rich alternatives to OpenOffice and LibreOffice

I really like LibreOffice however I'm having issues with it freezing up and I can't seem to start a new instance of the writer on multiple desktops (I'm using dwm and want several documents open). ...
0
votes
1answer
59 views

Change tracking in OpenOffice?

If e.g.: I delete/modify a few words in a .doc file that is edited with OpenOffice how can I highlight those changes? Under microsoft office it works pretty good. Where is this feature in OpenOffice?
3
votes
1answer
4k views

Are there any MathType clones for Open/Libre - Office?

Are there any OpenOffice.org/LibreOffice equation editor/makers, similar to MathType?
3
votes
1answer
2k views

Is it possible to uninstall OpenOffice?

I installed OpenOffice using the installer downloaded from openoffice.org on Fedora 14. I went to use it today for the first time and it won't open. I'm assuming with updates that have been ...
0
votes
3answers
297 views

Improving OpenOffice speed [closed]

I'm looking for some tips and tricks on how to improve the performance of OpenOffice on my desktop. Any ideas, tutorials or articles on this? Thanks in advance!
3
votes
1answer
526 views

xorg performance in openoffice

I've just been monitoring my cpu usage in openoffice calc when cells have been copied vs when they haven't and seen a dramatic increase in cpu usage for the Xorg process. The additional rendering ...
15
votes
2answers
7k views

How to invoke an Openoffice macro from the Linux command line

I have an OpenOfice macro that I want to use to process the contents of an OpenOffice file. I am able to do this by opening the file with OpenOffice and then running the macro. How do I invoke the ...