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

learn more… | top users | synonyms (1)

0
votes
1answer
69 views

In OpenOffice Writer, how to populate a column of a table with a sequential increase in dates?

I am using OpenOffice Writer. In it I have a table for a time sheet. The first column is for the dates which begin from eg. 01/01/2014 and should end in eg. 20/07/2014. These dates are not already ...
1
vote
2answers
628 views

Filter OpenOffice Calc rows by matching if a cell in one column exists in another column with a certain value

Have a question I cant seem to figure out using the filter. Column A has 1400 rows with 800 additional rows that are duplicates (so 2200 total rows). Column B has inventory amount for only the last ...
0
votes
0answers
23 views

OpenOffice Scroll Tooltip page number and text

When I scroll in an OpenOffice Text document a tooltip with a page number and text from a document I worked on previously displays. How did that specific page number and text get permanently added to ...
0
votes
2answers
173 views

Massive Blank Space To Right Of All Word Pages?

So my grandfather has been working on writing a book. All goes well until he rings me to state that he has somehow messed up the file. If you look at the image below, he has someone added something ...
0
votes
2answers
132 views

IF formula where the test is a logical value in OpenOffice

How can I do =IF(E2,-1,1) * D2 in OpenOffice, where D2 is Currency and E2 is TRUE/FALSE?
0
votes
0answers
88 views

How can view but not print a text from an OpenOffice pdf exported file

I have this pdf file completely generated from Mac 10.9.3 + OpenOffice 4.0.1 OpenOffice Draw -> File -> Export as PDF... -> File1.pdf The original File1.odg file was created with ...
1
vote
0answers
42 views

Merge duplicate text from two columns and put unique text in another column

I've got two columns of about 13,000 email addresses. One has members and the other has newsletter subscribers. There are duplicates between the two(ie. a member who also subscribes to the ...
-4
votes
2answers
2k views

How do I convert a .csv file to a database?

I have an 8GB .csv file with 6 columns and 202,176,000 rows. How would I convert that to an OpenOffice database(.db) file?
0
votes
1answer
59 views

How can I create a PDF with a different full-page background image for each page, perhaps using Word 2011 or OpenOffice Writer 4?

I've searched and seen how I can create a watermarked Word document with a background image that applies to the whole document. What I have not yet found, for Mac Word, 2011 OpenOffice 4.x, or other ...
2
votes
1answer
347 views

Multimedia keys don't work in Foobar2000 when LibreOffice is in focus (Winamp is not affected)

Multimedia keys are ignored while focus is on Calc from LibreOffice. Media keys work in foobar when it's focused, also while other programs are focused. I use Windows 7 Home Premium SP 1. My Foobar ...
0
votes
1answer
92 views

Which version of OpenOffice does TAILS have?

I can't find this information anywhere. TAILS is based on DEBIAN which at some point switched from OpenOffice to LibreOffice. How do I know before I download 0.23 or 1.0rc1 on my slow connection ...
1
vote
1answer
441 views

Open/Libre Office Writer: Display line numbers in frames only

I'm writing a report in which I have to explain some programming code. I'm putting bits of code into a frame so I can place it nicely around the text. I would like to number the lines in the frame. As ...
0
votes
0answers
34 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
2answers
86 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
1answer
87 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 -> ...
2
votes
0answers
142 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 ...
1
vote
1answer
36 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 ...
2
votes
1answer
2k 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?
-1
votes
1answer
396 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 ...
3
votes
0answers
185 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 ...
1
vote
0answers
131 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
40 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
47 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 ...
3
votes
1answer
1k 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
1answer
58 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
356 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 ...
2
votes
2answers
60 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: LASFD@FOO.COM LKXYCVER@FOO.COM ...
2
votes
0answers
41 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
800 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
354 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?
5
votes
1answer
414 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 ...
3
votes
3answers
442 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 ...
1
vote
1answer
78 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
2k 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
95 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
2answers
2k 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 ...
2
votes
2answers
156 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 ...
3
votes
1answer
238 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
2k 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
945 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
353 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
28 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
164 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 ...
5
votes
1answer
1k 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
172 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
1answer
158 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
2k 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 ...
3
votes
3answers
234 views

How do I convert a delimited list to a multicolumn table in excel?

I have a list like this: Friut;Taste;Color;Other;Apple;Good;Red and Blue;1;Orange;Really Good;Orange;12 And I want to convert it by selecting every 4 delimitations and turning them into rows like ...
1
vote
1answer
135 views

Is there another way to display a spreadsheet within OpenOffice Writer besides an OLE object?

I'm writing a paper for college in which I would like to either display or link to a large spreadsheet. I'm using OpenOffice Writer and Calc. I've tried importing the spreadsheet as an OLE object, ...
0
votes
2answers
69 views

Automating OpenOffice Installation

I am attempting to write a shell script which will download the latest version of OpenOffice using wget, and then use the command-line to install the application. I have seen that installing the ...