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

learn more… | top users | synonyms (1)

0
votes
0answers
11 views

How to create a reference line between a name and a value in LibreOffice

In the figure (which is a part of the table of contents of some book) the doted lines help our eyes to easily spot the page number of the mentioned chapter. When creating similar contents using ...
1
vote
1answer
16 views

Book like page numbering in LibreOffice

How can I achieve the following goals using LibreOffice Writer? The first few pages should be numbered in Roman numbers (like i, ii, iii, iv, ...), but the very first page number should be hidden, ...
0
votes
0answers
15 views

Automatic backups (history) in LibreOffice (OpenOffice)

LibreOffice can create a backup copy when you enable it in settings (Options > Load/Save > General), but it saves only the previous state (one only). It has also an versioning feature (File -> ...
0
votes
0answers
31 views

Search and replace with different formatting style

In LibreOffice or OpenOffice Calc spreadsheet, is it possible to search-replace while changing formatting of the replacement text to subscript or superscript at the same time? I have a spreadsheet ...
2
votes
0answers
33 views

Convert rtf to pdf removing the hidden text of rtf file

I am using Ted on CentOS 6, for conversion of RTF to PDF documents via shell_exec command from php script like: shell_exec(rtf2pdf.sh test.rtf test.pdf) But the issue is that if the RTF file has any ...
0
votes
0answers
6 views

TrueType fonts in openoffice-writer? Why after installation they don't appear there?

Very silly question. Every tutorial or instructions for the installation of fonts like Arial, Times and so on in Openoffice, say I have to install the »TrueType« fonts. Altough Synaptic says I have ...
0
votes
0answers
20 views

Convert OO4 ODS to XLSX using Excel 2010 VBA

I am trying to bulk convert OpenOffice documents to Microsoft Office. Using built-in VBA, I use the following code (ODS to XLSX is shown, but same code is being used for ODT and ODP with some ...
1
vote
1answer
34 views

OpenOffice Secure? [closed]

As I know OpenOffice was mantained by Oracle earlier. I want to use it now but I am concerned if it is possible that some developer/programmer can smuggle malware into the programm code? OO was ...
0
votes
0answers
20 views

Open Office checking values from one column in a sheet to another

There are few answer similar to my question, but not quite. I have let's say column A, that are names, and column B, that are dates, in one sheet. In another file I want to have same column A (names) ...
0
votes
0answers
12 views

What software can I use to generate realistic workloads in Windows?

I am looking to configure Windows Server 2012 and 2008 hosts to serve as different types of servers and generate or play back workloads for these servers automatically. The intention is that the ...
2
votes
1answer
92 views

LibreOffice 4.2.1.1: do not display list of recent documents

Today I installed LibreOffice 4.2.1.1. When opening LO, it displays a list of recent documents with screenshots, similar to Firefox and Chrome. I don't want this. How can I disable this setting?
0
votes
0answers
6 views

OpenOffice Writer: Show “go to lines”

I'm appending code to a report. Some of the lines of code are too long to be displayed on a single in the Writer document. Is there a way to display a little sign, like an arrow, to indicate where a ...
-1
votes
1answer
54 views

Change background fill of cells in LibreOffice worksheet containing specific text

How can I change the background fill of all the cells of a LibreOffice spreadsheet worksheet that contain a specified text? In Excel that could be done by configuring the settings in the find and ...
1
vote
0answers
26 views

Default font and cell padding when opening files in LibreOffice/OpenOffice Calc

I've seen solutions for setting a default font when creating new files. What about a default font (and cellpadding) when opening an existing CSV file? LibreOffice seems to always default to Liberation ...
0
votes
0answers
29 views

Disable prompt when opening a CSV file in LibreOffice/OpenOffice Calc

Every time I open a CSV file, LibreOffice presents me with a prompt asking to confirm Character Set, Language, and Separator options (tab, comma, semicolon etc). This prompt is not present in ...
2
votes
1answer
31 views

How do I check if the document formatting is right?

I have to submit a paper to a competition. They have strict rules on the formatting that is to be used. For example, the size of the font, the margin, the space between the paragraph and so on. I ...
0
votes
0answers
17 views

Printer shows up in control panel but not in office programs

So the printer is setup and working, shows up in the control panel, but on programs like openoffice libreoffice, and another one I can't remember at the moment it's just gone. I reinstalled it and it ...
0
votes
0answers
16 views

Inserting a web page in an OpenOffice Writer document and keeping (some) style

I'm writing a report for school and I would like to include a html document as an appendix. So far all my attempts have resulted in a seriously malformed appearance. The results are hardly readable ...
2
votes
1answer
39 views

How to count the number of review comments from a specific author in Word?

I have a large MS Word document with a high number of review comments (track changes feature). I'd now like to get a list of authors and the number of review comments. The number of authors is not too ...
0
votes
0answers
20 views

I've created a “section” in Open Office Org, but how to I exit from it & continue with my regular page parameters?

Using Open Office Org on my Mac os x 10.5.8, I typed text into my page, using my regular document parameters/margins, then I inserted a "section" so that what I typed in next could be entered in 2 ...
0
votes
1answer
50 views

Libre Calc error on a float in decimal notation. Err. 519 (#value error)

There is a problem with my libreoffice. I doesn't calculate cells with decimal points, possibly seeing them as text. I have checked my locale settings (you can see them in the picture above) that ...
0
votes
0answers
9 views

How can I include a chapter title in a header in Word or OO Writer? [duplicate]

I would like to include a chapter title in a page header in either (Mac) MS Word 2011, or OpenOffice writer. How can I set a segment of text (the title) on either a chapter-by-chapter basis, or ...
2
votes
2answers
47 views

How to autofilter for given strings in common spreadsheet softwares?

I know I can create an "autofilter" at the top of an XLS table.. But how can I create a filter that filters for given strings? example TABLE input: [email protected] [email protected] ...
2
votes
0answers
16 views

Evenly-spaced table rows, where table encompasses entire available height

Consider a page which may have a header, footer, and a list of questions with a heading: Some Company Header These are your questions: 1. What is your name? 2. What is your quest? 3. ...
0
votes
2answers
71 views

How to hide paragraph marks in OpenOffice.org Writer?

How do I remove the blue P-marks that indicate paragraphs from my documents when working? I have looked under the 'Tools' menu but have been unsuccessful.
5
votes
1answer
115 views

How to show full document path in Open Office title bar?

How can I automatically show the FULL PATH of the currently loaded document (not just only the file name) in the title bar of Apache Open Office 4, e.g. OO-Writer?
0
votes
0answers
16 views

How to search for strings in OpenOffice 3.4.1?

There is an ODS file. In this ODS file I need to search in C2:C216. And there is the C2:C216 cells where I write stuff (yes, the same place where I need to search..). There is the E2 cell where I ...
0
votes
0answers
10 views

mass conversion OpenOffice to MicrosoftOffice [duplicate]

My problem is that I can't convert manually each file from OpenOffice to MicrosoftOffice; I need some software, program, whatever that could convert in mass all of them (the files).
0
votes
0answers
82 views

How to resize page to fit drawing contents in Open office/Libre Office Draw

I am programmatically drawing a flowchart in open office draw by means of Java UNO Runtime Reference api.After I have drawn the flowchart I want to resize the page according to the area aquired by the ...
2
votes
0answers
75 views

Is it possible to remove the hyperlink background in OO Calc?

Hyperlinks in OpenOffice Calc are displayed with a solid background which covers the background color of the cell. I don't want a solid background; I want the background color of the cell to show ...
2
votes
1answer
63 views

How to embed formulas in a line of text using OpenOffice Impress?

I want to create a presentation in Impress and need to embed a formula in text. I only found very old forum posts (over five years old), which said it is not possible. Has this changed by now? How ...
0
votes
0answers
30 views

how can I merge in master record details to each row in excel or openoffice?

Say I have sheet 1 with: company1 90230 CA company2 80014 CO company3 15090 PA And sheet 2 with: company1 Bob Smith company1 Sue Smith company3 John Doe How can I produce sheet 3 with: company1 ...
1
vote
1answer
35 views

How to add a diagram in OO Writer

I would like to insert a diagram in OpenOffice Writer. Is there a toolbar to do it from Writer, or I would have to create it in OpenOffice Draw and then somehow add it to Writer. I also want to edit a ...
0
votes
1answer
139 views

Open office spreadsheet, export as PDF as single large page?

I have an open office spreadsheet. I need to export a selection as a PDF. Everything I do this it creates a PDF document with multiple pages and moves some columns to the next page as they dont fit. ...
0
votes
0answers
52 views

Excel or OpenOffice Table Summary: how to reconstruct a table from another, with “missing” values

I have a table of values (partial) with 3 columns: month (from 1 to 12), code and value. E.g., MONTH | CODE | VALUE 1 | aaa | 111 1 | bbb | 222 1 | ccc | 333 2 | aaa | 1111 2 ...
1
vote
1answer
169 views

Move rows with the keyboard in Calc

How might one move a row to a different location with the keyboard? I have found this guide for the mouse but due to disability I have trouble using the mouse for this. Note that I am not looking to ...
1
vote
2answers
43 views

Controling number of spaces per tab character in openoffice

I want to print a program file from OpenOffice Writer, so I use a mono font and adjust size and margins to my liking. The indentation in the program file is based on tab characters, so I would like to ...
0
votes
0answers
49 views

How to delete objects from master in OpenOffice Impress?

I have added background image to the master slide and now I see it on all slides. But also master slide contains several fields with text like "Click to edit the title format" and "Click to edit the ...
3
votes
1answer
129 views

Chapter outline numbers as initials in LibreOffice Writer?

I am trying to have the chapter title (outline) level 1 numbers as initials in LibreOffice Writer. I have set up a character style which gives me the big title numbers, but they are all from the base ...
0
votes
1answer
517 views

The JPG file on my Open Office document is blurry when exported to PDF

I have tried both Open Office and Word, and the issue is the same. All looks fine until the document is exported to PDF, then the JPG image on the document becomes blurry. I hope someone can help.
0
votes
1answer
732 views

How to Custom Folder Access when users Login using SFTP,SSH,SCP?

I have problem when I want to config my SSH server, I have username root and guest. I want root still can access SSH and for guest users , only can transfer file (copy and paste) some directory. in ...
1
vote
0answers
92 views

How can I debug formatting in LibreOffice?

I am using LibreOffice Writer 4.0.2.2 to edit a Word document sent to me by a Microsoft user. It contains certain formatting that I can't figure out how to change (a gray background on some of the ...
1
vote
1answer
22 views

Why do inserted photos not stay where I put them in Openoffice Writer 4.0?

I am trying to write an illustrated memoir of a recent trip, inserting photos into the text, sometimes several photos per page. Once my document gets to be more than about 10 pages, the photos seem to ...
0
votes
1answer
79 views

Set CSV as default import into a spreadsheet

In Libreoffice I can import a CSV file into a spreadsheet by simply double-clicking on the text file. In Openoffice 4.0 I have to click once on the text file to select it, then in the file type ...
0
votes
0answers
50 views

OpenOffice - No 'Fixed' Option for 'Line Spacing' in Textbox

OpenOffice has always frustrated me in its terribly unfriendly ui. Now I'm trying to change the line spacing for text in a textbox. So, I went to Format > Paragraph > Indents & Spacing > ...
1
vote
1answer
123 views

Is there a way to set the default quotation mark in LibreOffice Calc from smart quotes (“ ”) to dumb quotes (the straight kind)?

I use LibreOffice Calc to make lists of programs with different parameters to run on an hpc cluster. For each batch of commands I must do a find and replace on the smart quotes, as they cause errors ...
1
vote
0answers
58 views

Conditional Formatting a date/time comparison

The function I'm working on specifically compares & colors a daily recurring time range set in 2 different cells. A specific date in the target cells (produced by a formula) compare to that daily ...
0
votes
0answers
43 views

OpenOffice - Save all documents as HTML using macro

I am newbie to Open Office Macro. I have a requirement of Save documents(PPT,PDF,XLS,DOC) as HTML format using macro code. Is it possible to save documents as HTML by macro recording in open ...
0
votes
1answer
60 views

Open Office Calc truncates my data on paste, how do I fix this?

Just as the title says, I am using Open Office Calc as a flat file to upload data. One column is my description and therefore can be a bit lengthy. Unfortunately it truncates this text. Anyway to ...
0
votes
4answers
1k views

How can I create a PDF file that my Nook Simple Touch won't reformat?

I've written a document in Open Office Writer and I'm trying to read it on my Nook Simple Touch. I'm exporting the .ODT file to a PDF file, and it works perfectly. The pages are all behaving as ...