Questions tagged [openoffice]

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

Filter by
Sorted by
Tagged with
1
vote
0answers
8 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 ...
0
votes
0answers
50 views

Can subdocuments be edited from a master document in LibreOffice?

I've got a master document with a large number of subdocuments linked to it. However, I am unable to edit any of them unless I open the individual files. I'm fine with doing this, but for convenience, ...
0
votes
1answer
111 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 --...
1
vote
1answer
41 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,$&...
1
vote
1answer
68 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 ...
0
votes
0answers
14 views

OpenOffice Calc - Highlighting the higest value in multiple columns

Question is similar to a the following question: OpenOffice Calc - Highlighting the higest value in a column but it's not quite what I'm looking for. I have a table that looks like the following I'...
0
votes
0answers
32 views

Greek shows up as gibberish in both .odt and .rtf, regardless of font

I recently translated a legal file from English into Greek. It was saved fine (both as .odt and as .rtf using OpenOffice). I also printed out a draft. Today I went back on the same computer to edit it ...
0
votes
1answer
44 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 ...
0
votes
0answers
20 views

Filtering long lists in OpenOffice Calc

I have 3 keyword lists separated into columns: Column A, Column B, and Column C Column A is the primary list, containing 100s of keywords. Columns B and C are secondary lists, containing many, but ...
0
votes
0answers
83 views

Libreoffice Impress Does Not Display Full Screen Slide Properly?

I'm trying to display a slide as full screen, however it displays the slide like this instead of taking up the full screen: Strangely enough, it does the proper behavior (Showing the slide as full ...
0
votes
0answers
25 views

Convert LibreOffice Writer formula to plain text

Is there a way to automatically "flatten" all formula objects in a LibreOffice Writer document into plain text, e.g. to the plain-text representation one uses to type the formulae in the formula ...
1
vote
1answer
59 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 ...
0
votes
0answers
42 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 ...
0
votes
1answer
230 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 ...
0
votes
0answers
11 views

how to search and replace within a table cell till the very end of the cell in libreoffice writer?

I have a word (2010) / LibreOffice Writer document, containing a table in the following example format: Table Header| some column descriptions ------------------------------------------------------ ...
0
votes
1answer
76 views

ssh X11 forwarding from multiple clients simultaneously always opens openoffice windows on the same screen - bug or feature?

Situation: Three "computers": A. a desktop with its own display B. a virtual machine on A (kvm) C. a small PC with its own display I generally work on A, ssh -Y to B from A, work with firefox --...
1
vote
0answers
129 views

How to stop Libreoffice from adapting row height

How do you disable row height adapting in Openoffice/Libreoffice? I have a very large spreadsheet, with about 5000 rows and 1000 columns. I routinely do a lot of copy/paste operations to/from various ...
0
votes
0answers
16 views

How can I use formulas with secant, cotangent, and cosecant math symbols in OpenOffice/Libreoffice writer's formulas?

I wanted to create a page full of important stuff to remember for my Calculus 2 class, but I've noticed both OpenOffice and LibreOffice don't seem to have the function symbols for the secant, ...
0
votes
0answers
36 views

How do I set Calc to copy to clipboard in csv format?

Looks like when I select cells and press ctrl+c, Calc exports it in a tab-separated format to the clipboard. How can I make it export in csv format, instead?
0
votes
1answer
92 views

How can I stop Open Office Calc from changing the data?

I am using Apache Open Office Calc to view CSV data. I just noticed that Calc rounds the data on saving, reducing its precision, or at least I think that's what's going on. I show below the same data ...
1
vote
0answers
54 views

Adding language (Dutch) to LibreOffice Writer

I'm having trouble doing a spelling check in LibreOffice (in Dutch). It supposed to come with the package but it doesn't show in my screen (see image: no abc mentioned before 'dutch'). I tried: ...
1
vote
1answer
92 views

LibreOffice fails to export PDF containing arabic letters

I used LibreOffice to write an arabic document. When exporting this document to PDF through the LibreOffice "File -> Export...", I get an unexpected result: the PDF is different from the original ...
1
vote
0answers
30 views

Widowed pilcrow (non printable ¶ at line begining) in LibreOffice

I'm struggling with widowed pilcrows (i.e. non-printable ¶ at beginning of lines). This happens only in footnotes, on page-breaks, and it adds a space between the footnote's rule and the first ...
0
votes
0answers
51 views

Change the default font used in diagrams in LibreOffice 6.1

I'd like to change the default font used in diagrams in LibreOffice. I created a new document, changed the font to Arial and saved it as a template. However, when I open a new document, this only ...
0
votes
1answer
26 views

Stop OpenOffice from removing decimal places

In a table-cell when I type 1.00 and move the focus from the cell OpenOffice removes the decimal places from the number and makes it 1! Why is this happening? How do I stop this from happening?
0
votes
1answer
18 views

How to order column in open office

I have a column like this RA1 RC4 RJ9 RA3 RA2 RA10 RD14 RA11 and I want to get RA1 RA2 RA3 RA10 RA11 etc.. Not RA1 RA10 RA11 RA2 etc... There's any way to change the behavior?
0
votes
1answer
117 views

How to Use KDE File Chooser In Libreoffice 6.2.2.2?

I changed the file chooser a while back because my version of Libreoffice Writer crashed all the time when I would go to choose a file. There have been a few versions between then and I would like to ...
1
vote
1answer
123 views

OpenOffice Calc import special characters in CSV incorrrectly?

I'm trying to import a CSV file to OpenOffice Calc, but the program is reading special characters incorrectly. For example, one of the fields in the CSV is "Puma La Cerámica", but Calc imports it ...
0
votes
1answer
163 views

How to Remove Paragraph Breaks in openoffice

I am using openoffice 4 and i have a Paragraph Breaks between two pages and i want to avoid it
0
votes
1answer
69 views

Calc pie chart for 25000 rows with long tail

I have a file that contains 25,000 rows, each row containing a number, looking like this: 4000 3000 1500 700 ... 2 1 1 1 From this I want to make a pie chart. The first few pie parts will be ...
0
votes
0answers
24 views

Merge ttwo tables using order id number where one table has multiple rows with the same id number

I'll first explain what I'm trying to accomplish then give the table details. I'm trying to export sales data from my website and organize it by order id number so I can easily see which orders were ...
2
votes
0answers
28 views

How get text lines larger than 69cm?

I’m using Apache OpenOffice 4.1.6 and I want to convert a text file to ᴘᴅꜰ without automatic line returns. In practice this requires using very wide page sizes. I enabled landscape mode set page as ...
0
votes
2answers
95 views

Calc print several sheets in same page

I have a Libreoffice Calc spreadsheet that holds around fifty sheets (each one with no more than a dozen valued rows); this is good for data organization — each sheet holds a sequence of events ...
0
votes
2answers
749 views

OpenOffice/LibreOffice Calc how to not print column but show it in sheet?

I have a column with hyperlinks to other parts of the same spreadsheet and I want this column to be visible inside the program, but hidden when printed: it should not take up space. The only solution ...
0
votes
1answer
1k views

What to Save As when exporting Visio .vsd to OpenOffice or LibreOffice to minimize differences?

I have a Microsoft Visio Pro. 2010 file (.vsd), and I want to work with it in LibreOffice (or OpenOffice, as a secondary option). When I import the .vsd file to LibreOffice, there are many ...
3
votes
1answer
81 views

Opening a .doc file, which is actually an HTML file, as a .doc file

My software generates .doc files which are actually HTML files but with the ".doc" extension. When I open them in Microsoft Office they open as a .doc file and the user does not know that it is ...
2
votes
2answers
291 views

Document shows text in “Khmer UI”, but that font is not in available list

I received a Document (*.doc) and am able to open it in OpenOffice (3.4.1), where I see that the font shown in the font selection dropdown is "Khmer UI". When I click the dropdown, the font name ...
1
vote
1answer
84 views

How to delete a large image from my libre office doc?

I'm using Libre Office Writer 5.4.5.1 (x64); I added a very large image (81 MB) to a doc (which already has several images, but none that large). The document keeps going into "Not Responding" mode, ...
1
vote
0answers
39 views

Windows 7 remove “Application Link” from open and save explore window in OpenOffice

Been digging around for an answer for a couple hours, and all the results I am getting are completely irrelevant. For some reason OpenOffice, in its "Open" and "Save as" file explorer windows, has ...
1
vote
1answer
1k views

How can I add duplicate rows to LibreOffice Calc to make there be one per day?

I have some data like this (it's stock market data) 29/07/2015 35972.82 32056.2 17751.39 30/07/2015 35961.86 32046.43 17745.98 31/07/2015 35848.13 31945.08 17689.86 03/08/2015 ...
0
votes
0answers
98 views

Can't see VBA when I open XLS in OO or Libre Office

I've got some spreadsheets in Office 97 format. When I open the spreadsheet in Open Office 4.15 (or any version), none of my VBA is visible in the OO Basic editor. I can save the spreadsheet as ODS, ...
0
votes
2answers
44 views

Need to delete specific rows that are missing an email

I have a spreadsheet I want to delete the rows that are missing an email. How do I sort and delete each of those rows?
2
votes
1answer
112 views

Word/Writer — Bible-like two column layout

Is there a way to create a "standard" bible-like layout in Microsoft Word or OpenOffice Writer without using tables? It should be a two column layout but the columns are not "global": Paragraph 1 ...
2
votes
1answer
22 views

Rule based highlighting in open office

I use notepad for some rule based highlighting of text... but I need more control/formatting. So I moved to open office... rather than search and replace, which requires repeated use ever time I ...
0
votes
1answer
465 views

Remove blank cells containing a formula in OpenOffice Calc

I am attempting to remove blank cell values which also have a formula, from a column in OpenOffice calc. Row numbers and corresponding data: 1 A1 2 A4 3 4 A9 5 6 A98 Each cell in the data ...
0
votes
0answers
44 views

Recovering OpenOffice password - CL_INVALID_BINARY

I have an OpenOffice Document that I protected with password (its length should be 4 characters). Unfortunately I forgot the password I set so I am trying to recover it by using brute force. I have ...
0
votes
1answer
625 views

Put transparent form fields/text areas on an image in Openoffice Writer?

I'd like to create a few pages with a background image and (different) text at the same areas on the image. Think of invitation cards or recipes - there is some structure (recipient and location, or ...
0
votes
1answer
2k views

“File Access Denied” when using “Remove Properties and Personal Information” from ODT files

Trying to use the Remove Properties and Personal Information feature in Windows 7. To use this feature, you right-click the file in question and select Properties. On the Details tab, there is a link ...
0
votes
1answer
446 views

GhostScript | LibreOffice. Is there a way to change page order before printing?

I've got one typed story to print as a small (A5) book, and my wife is willing to sew pages together. But one problem is, pages in document must be in specific order: 4-1-2-3-8-5-6-7-etc. First I ...
0
votes
1answer
236 views

How to open csv with blank columns correctly in open office [closed]

I have a CSV file that looks like this: "column1",,"column3" "column1",column2, Sometimes the CSV contains blank column(s). Is it possible to open it correctly in Open Office?

1
2 3 4 5
12