Questions tagged [openoffice]

Open source application suite that includes Writer, Calc, Impress, Base, Draw and Math

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

Use a subset of system fonts for LibreOffice, on GNU/Linux

I have a lot of system fonts in my GNU/Linux distribution (in /usr/share/fonts/): most of them are useless for me when I'm using LibreOffice to write or to open a document. I'm using my distribution ...
eliotlencelot's user avatar
0 votes
2 answers
40 views

Copy value from one worksheet to multiple worksheets

I just switched back to Microsoft Excel after years of using OpenOffice and I am struggling to do something that works in OpenOffice. I hope I'm not missing something obvious. I have sheets for every ...
Gregg Ayers's user avatar
1 vote
2 answers
102 views

Associate .docx with swriter.exe LibreOffice (with PowerShell)

I would like to associate .docx with OpenOffice $extension = ".docx" $executable = "$MyPrograms\LibreOffice\program\swriter.exe" $fileType = "docxfile" if (Test-Path $...
YorSubs's user avatar
  • 919
0 votes
1 answer
618 views

How do I open and edit a Microsoft Word document file without Microsoft Word?

I have downloaded a Microsoft Word (.docx) file which was created using a template. I want to open and edit it but I have not installed Microsoft Word in my computer (I am using Windows 10 by the way)....
Dimitrios Savvaoglou's user avatar
1 vote
1 answer
61 views

cannot scroll down to click okay in libreoffice settings

I tried to follow the instructions here - LibreOffice 4.2.1.1: do not display list of recent documents Open the LibreOffice config: Menu "Tools" -> "Config"; In the TreeView: &...
cardamom's user avatar
  • 175
0 votes
0 answers
80 views

LibreOffice Impress: Distorted image in presentation mode

When using the SlideShow option in LibreOffice Impress, some images that were totally fine on the document appear distorted on the slide show (see example below). The problem doesn't happen when ...
Matifou's user avatar
  • 141
0 votes
0 answers
63 views

Does libre office writer encrypt temp files when .odt file is encrypted?

I used Libre Office Writer to create an encrypted .odt file. LibreOffice uses temp files by default. Are the temp files encrypted while working with the file if the file has been encrypted in the ...
ThomasHunter's user avatar
0 votes
1 answer
115 views

How to make an object permanently disappear after clicking on it once in Libreoffice Impress?

I am hosting a trivia night in my middle school next week. I plan to use LibreOffice Impress. In the first slide there are multiple topics to choose from. When I click on one, it moves to the slide ...
mhgx676's user avatar
0 votes
1 answer
146 views

Write on MS Word or any text editor with an electronic pen

I have pain in my fingers when typing on my ergonomic keyboard. However, I can write perfectly with a pen. Is there any writing app. that allows to write normal text (like "Times New Roman text&...
Dan's user avatar
  • 113
0 votes
2 answers
809 views

How to Print in Landscape Mode with Open Office Calc

I have three .ods files that I am trying to print using ver 4.14. It wants to print on 2 pages. I select Print Selected Cells Landscape Orientation However, it still prints on two pages rather ...
Rohit Gupta's user avatar
  • 3,529
1 vote
2 answers
613 views

Polynomial regression In libreoffice

If we have certain X-Y columns, and the data does not look linear when plotted, we may want to use a polynomial to fit the data. How do we fit a polynomial model other than using a ax+b fit on the ...
mundaba's user avatar
  • 21
0 votes
0 answers
49 views

Interaction with Libreoffice Impress: how to identify relevant slide when using "Go to page or object"?

In Libreoffice Impress, I am using the Interaction command to create button/links between slides. When clicking on Interaction then Go to page or object, this open a dialog with Slide 1 Slide 2, etc ...
Matifou's user avatar
  • 141
0 votes
1 answer
451 views

Cannot execute LibreOffice macro on Docker Linux

I want to execute a macro file on Linux created by Docker with the following docker file. from ubuntu:22.04 run apt-get update \ && apt-get -y install --no-install-recommends \ default-jre ...
Issei Morita's user avatar
0 votes
0 answers
68 views

Unsetting bash function having name of executable prevents further use of executable

I created a function to enable me to run libreoffice from the command line (under MacOS): libreoffice () { open -a libreoffice "$@"; } Wanting access to the base functionality of libreoffice,...
user3897315's user avatar
1 vote
0 answers
89 views

Is there a way to find the two smallest numbers in a column in openoffice without repeats

The obvious but incorrect answer would be Small(Range;2) except that if there is more than 1 cell with the smallest value then it will return the smallest value instead of the 2nd smallest value. ...
Goku Gohan's user avatar
2 votes
1 answer
270 views

What file extension do OpenOffice Dictionary files have?

I have a program that supports importing OpenOffice Dictionary files for use with its own spell checker, which I would like to do since the language I want to write in isn't available as a built-in ...
Newbyte's user avatar
  • 136
0 votes
1 answer
147 views

How to set the resolution of a macro exporting images of LibreOffice Writer pages?

Previously I've asked how to export all pages of a LibreOffice Writer document to images. I've got this answer. I've adapted the macro towards my needs and this is my current code: Sub ...
Robin's user avatar
  • 652
0 votes
0 answers
16 views

(MacOS) OpenOffice dies within 30 seconds of starting

Starting a few days ago, OpenOffice suddenly crashes within 30 seconds of starting, even if you do absolutely nothing. Monterey, the Java JRE, and OpenOffice are all "the very latest." ...
Mike Robinson's user avatar
0 votes
1 answer
30 views

How do you get multiple statements working within the same open office calc cell

I am trying to create a check register in open office. I want the Balance column to remain blank if I don't enter a transaction. If I do enter a transaction I want it to do the math and display the ...
Preston Bartlett's user avatar
0 votes
2 answers
130 views

Corrupted ODT/DOC files in Raw form -- How do I get the text?

I have an old hard drive I had professionally recovered, and they were only able to give me the files in code that looks like this: talledBannerText{\VSI_MS_Sans_Serif16.0_1_0}[ProductName] ¼³Ä¡...
Makaze's user avatar
  • 103
2 votes
1 answer
1k views

Timestamp (date/time) system used by LibreOffice Calc / OpenOffice Calc spreadsheet applications?

What system does LibreOffice Calc / OpenOffice Calc use to represent timestamps (dates/times) as numbers? It's apparent that they don't use the standard integer epoch times that are common in computer ...
End Anti-Semitic Hate's user avatar
4 votes
1 answer
725 views

Issue with IF statement in Libreoffice Calc

Here is the statement =IF(L7>7,"$500",IF(L7>11,"$1200",IF(L7>15,"$2000",$0))) I simply need this to resolve a value based on the set conditions. I've tried ...
Val's user avatar
  • 43
0 votes
0 answers
47 views

Find one value and replace value inside quotes within the same row

I translated values for a JS calculator but the script that I am using treats the option value the same as a value inside a parenthesis. Currently have it on notepad ++ but can migrate to anything ...
Arnaldo J Acosta's user avatar
0 votes
2 answers
62 views

I cannot recognize what type of formatting element it is in this Word document and how to get rid of it

I have got a big Word document that contains what I believe are input forms. How on earth can I delete them without deleting the table cells and what kind of formatting is this? And this is not the ...
off-signer's user avatar
0 votes
1 answer
130 views

Where is the bundled `python` executable in OpenOffice, in general?

As described in the Apache OpenOffice wiki, OpenOffice should be bundled with its own version of Python, which on Windows is located by default at C:\Program Files\OpenOffice.org <version>\...
shadowtalker's user avatar
0 votes
3 answers
157 views

Turn a row's background black if cell has #VALUE! - OpenOffice Calc

I'm currently playing around with formulas and made one that works perfectly for me. Some row will get the value #VALUE! due to them being empty when imported and I am trying to make the whole rows ...
itsolidude's user avatar
0 votes
1 answer
2k views

Extract string after a delimiter like "/ " OpenOffice Calc

I have a file that converts inputs for me into an SKU-number (Stock Keeping Unit). The names and attributes I have are in one line and one cell like so: Temperature Displaying Smart Ring / Rose Gold – ...
itsolidude's user avatar
1 vote
0 answers
464 views

How to change the app associated to a protocol to one that doesn't appear in the available app list?

I want to change the app associated to the 'ms-word' protocol to Apache's OpenOffice (reasons for doing so can be found here). However, when I go to the Choose default apps by protocol menu, and try ...
Sukessh Velusamy's user avatar
0 votes
0 answers
823 views

Can't Open Password-Protected Word Document With LibreOffice Writer

I have a .doc document that I can't seem to open properly with LibreOffice. The only content is some text noting that I need to open it with MS Office: This document has been protected. Please use ...
trysis's user avatar
  • 332
0 votes
0 answers
26 views

How does the text formatting or styling defined by Open Office XML get rendered on the screen?

My understanding of the Office Open XML standard used in word processing is, that it's a set of rules for how to display an office document. So documents look the same on all devices and multiple ...
lukaskruede's user avatar
0 votes
3 answers
203 views

How to open .XLS in excel viewer without changing default program?

I have two excel .XLS files. We need one of the files to be opened using Excel Viewer and the other is being opened using OpenOffice. the file using excel viewer cannot be edited hence using the ...
SkylarP's user avatar
1 vote
0 answers
37 views

Searching indexed spreadsheets from Windows 10 explorer “search”

I have a client that used to use Windows 7, and was able to search directly from the Windows explorer (start menu) to find spreadsheets by searching a number that was on column B within. Now that they'...
Crabtree's user avatar
0 votes
1 answer
99 views

How to make Open Office Writer correct spelling?

It will not automatically correct spelling. Instead it underlines bad words in red. How do I automatically correct spelling?
felwithe's user avatar
  • 834
0 votes
0 answers
59 views

Mac Big Sur repeatedly tries to open "Open Office" for no obvious reason. I suspect malware

Something is periodically (every hour or so) trying to open "OpenOffice" while I'm working in other apps. Because OpenOffice was previously downloaded onto my machine, I get a warning about ...
jbbenni's user avatar
  • 143
1 vote
2 answers
64 views

Excel formula help please?

I'm hoping someone can help me figure this out as I am frying my brain with this. I am trying to figure out how to input the formula so if and when numbers are entered, the total is shown. Like for ...
user1263388's user avatar
0 votes
1 answer
22 views

OpenOffice Macro - How to append text to "Author" field

currently I have an OO macro that processes a document and then sets the "Author" by using: oDoc.getDocumentProperties().Author = cAuthor However that replaces any existing text in that ...
Marko's user avatar
  • 1
1 vote
0 answers
106 views

OpenOffice Calc: Is it possible to create conditional formatting to highlight a row based on checkmarks?

This is kind of a two-part question. Is it possible to create conditional formatting to highlight an entire row with a certain color based on whether the checkmark object in the row is selected? For ...
Talkinglikeacat's user avatar
0 votes
1 answer
35 views

XLS: 'if statement' calculation

I have a cell B19 which consists of taking the value of another cell and dividing it by 5: =B15/5 However I'd like to change it so that it only divides it by 5 if the B15 is more than 1000... and for ...
user avatar
2 votes
1 answer
237 views

How prevent objects from snapping back into position in LibreOffice Writer?

How can I disable this super-annoying "feature" causing objects (e.g. a drawn rectangle) to snap back into its original position when doing drag & drop? I simply want to translate a ...
david's user avatar
  • 337
0 votes
0 answers
42 views

Can OpenOffice Calc AutoInput reference data on a different sheet?

I've set up a spreadsheet in OpenOffice for project estimation at a contractor. The first column is a description of the item or service that I'm adding into the price. Since there are many commonly ...
user158922's user avatar
1 vote
1 answer
8k views

How can I escape commas in a CSV file?

I thought there were two ways to do this: either enclose the field containing the comma in quotes, or place a backslash before the comma. However neither of these is working; when I load up the CSV ...
ekolis's user avatar
  • 479
0 votes
0 answers
274 views

OpenOffice: different font weights

I'm using OO for Mac, although I've had this same problem with LibreOffice and I think maybe MS Office too. And the problem is that, for fonts that have a lot of different weights, I can only use ...
user avatar
1 vote
0 answers
53 views

How do I turn off autoformat OpenCalc / OpenOffice Spreadsheets

Without context and background: Read the title, How do I turn off AutoCorrect in OpenCalc, specifically time, preferably turn off all AutoFormat. I am using a spreadsheet to track how fast my online ...
FlashGem's user avatar
0 votes
1 answer
585 views

Mime type of MS Office documents saved from OpenOffice etc. is not recognized in Debian 9

Just today I faced the problem that document created by OpenOffice package and saved in XLSX format, recognized in Debian 9 as octet-stream instead of valid MS Office format: root@linux# file -b --...
Oleg Bolden's user avatar
  • 1,717
1 vote
1 answer
68 views

Can I get this Perl command on Windows to not generate dates with apostrophes in LibreOffice?

Based on the help I got on this question, I have this Perl command that I run in Windows 10 PowerShell: ls |% { $_.Name } | perl -pe 's/(.)(.*)_(\d{4})(\d{2})(\d{2})_(\d+).jpg/\u$1$2,$3-$4-$5,$6,$&...
Questioner's user avatar
1 vote
1 answer
362 views

Is it possible to combine two IF(AND functions into one? (OpenOffice Calc 4.1.7)

Is it possible to combine two IF/AND functions into one? (OpenOffice Calc) I have two IF/AND functions that work perfectly well, however I need them to both work on the same line. Is there anyway to ...
BinaryGuy's user avatar
0 votes
1 answer
640 views

How to Install LibreOffice Python on MacOS

I'd like to use Python to manipulate LibreOffice documents using the UNO API. I have LibreOffice 6.3.4.2 and Python 3.7 on MACOS (OS X). I find doc which says UNO is available in the Python shipped ...
Kevin Kleinfelter's user avatar
1 vote
1 answer
387 views

How to copy a new line from libreoffice calc to txt?

I have the following function in cell 'B2' a libreoffice calc document: =CONCAT(A1,CHAR(10),A2,CHAR(10),"end") Which, with in cell A1="function plotName = getPlotName(plotData)" and A2=" plotName ...
a.t.'s user avatar
  • 413
0 votes
0 answers
634 views

Excel turns my floats into integers

The following is part of the output of a code I have written. When I open it with excel part of the floats turn into integers while others remain. Wrong: Correct: When I sort them in ascending ...
Paschalis's user avatar
0 votes
1 answer
825 views

I can't uninstall open office 4.1.7

I just got a brand new laptop. I install open office but could not make it run. So I try to uninstall it. But I can't do that either. :( When I try using the Windows remove program option from the ...
Francis Blanchet's user avatar

1
2 3 4 5
12