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

learn more… | top users | synonyms (1)

1
vote
1answer
6 views

Clear cell changed metadata in OOO Calc

I am trying to figure out how to clear the red highlighting around cells in Calc (OpenOffice 4). Here is an example: It is not affecting my work but I would like to clear them as they are ...
-2
votes
0answers
21 views

Surface Pro 3, OneNote and Open Office [on hold]

I'd like to export a drawing from OneNote as an OpenOffice document but it doesn't work. Any idea on how to do it?
0
votes
0answers
8 views

Convert Formula to Text in Libreoffice Writer

I have a Libreoffice Writer file. I have near to 1000 mathematical formulas. I want modify them because all of them have small font. So I want convert them (formulas) to normal text then I should be ...
0
votes
0answers
17 views

Open Office: Simple Chart with dates/numbers?

I'm using OpenOffice Calculator. I have some data like this: Date | Messages Jun 2 2011 | 345 Jun 4 2011 | 212 Jun 5 2011 | 221 I'd like a very simple graph with the dates on the x-axis and ...
0
votes
0answers
15 views

How to make caption not connected to figure in OpenOffice / LibreOffice (like in MS Word)?

When adding a caption to figure in LibreOffice (and I expect also in Apache OpenOffice.org), it is automatically "glued" to the figure, and stays with figure. From what I understand, it is done using ...
0
votes
1answer
48 views

OpenOffice Calc - calculating percentage for every cell in a column

I have a somewhat common task of calculating percentage of column. For example I have a column with 20 numbers on each row. I add 21st row with formula for the sum of all those 20 rows and then I need ...
0
votes
0answers
14 views

Alternate row colors only if there are contents in them

I want to alternate row colors in an OpenOffice spreadsheet, but only if the first cell in the row has contents in it. The following function works great to return the correct value: ...
0
votes
2answers
57 views

How to change the default font in LibreOffice 4

How do I change the default font in LibreOffice / OpenOffice. So that when I open a new spreadsheet document it doesn't revert to use the standard default font (Liberation Sans/Serif) How to set the ...
1
vote
0answers
287 views

microsoft visual c++ 2008 redistributable package x64, error 1935

I am working on Alienware 17, OS Windows 10 preview. When I try to install Open office it in turn tries to Install Microsoft visual c++ 2008 redistributable package x64 which then gives me following ...
1
vote
1answer
119 views

Openoffice / Excel combine multiple worksheets into one

I have not yet found the exact answer to my specific problem, so let's give it a shot : The Layout : 1 SharePoint Farm on which a report was run, returning 6 Excel Files with each containing 250 ...
0
votes
1answer
43 views

.odt vs .fodt: which is most space effective for git repositories?

Which is most space effective for git repositories: LibreOffice/OpenOffice .odt files or .fodt files? I think that it should be .fodt, since with the uncompressed XML format .fodt the repository ...
0
votes
0answers
114 views

How to convert html to doc/docx with OpenOffice or LibreOffice?

I am trying to convert a html to doc or docx. I used some of the available php classes but the results are not good. I wonder if I can convert a html file to doc using some office software like ...
0
votes
1answer
23 views

OO Calc: Detecting Blank Cells and Replacing with Cell above?

So annoyed I can't find a simple answer to this simple question! I'm using OpenOffice Calc. I want a formula which will detect if the cell is blank, and if it is to replace it with the contents in ...
4
votes
1answer
22 views

Removing functions from a column, but keeping data (convert to normal text)?

I have a column that contains the results of a few different formulas. I want to convert all of these cells to normal text, getting rid of the formulas. I know I'm missing something obvious here.
1
vote
0answers
24 views

OpenOffice doesn't copy charts properly

I'm using OpenOffice 4.0.0 and I have charts in them. Whenever I try to copy and paste them into another program it just copies and pastes a white rectangle (of the same size as the chart). I've tried ...
0
votes
2answers
33 views

OOO: Increment sheets for fill down

I have a row of cells on "sheet1" referencing a set of cells on a different sheet. I want to fill down identical sets of cells while incrementing only the sheet. Another way to describe the problem: ...
0
votes
1answer
28 views

Is there a way to have groupings of bars in a bar chart in?

I know this may be bad style, but I want a bar chart that groups certain bars together. For example if I was comparing the speed of two models of cars, and considering the speed under wet and dry ...
0
votes
1answer
24 views

Stop OpenOffice Writer from adding trailing cents after dollar sign

Whenever I precede a number with a dollar sign in a table in OpenOffice.org Writer, the autocorrect forces .00 on the end of the number. How do I turn this auto-correct off?
-1
votes
1answer
35 views

Excel: Shortcut key to move selection to specific row

I am creating a bot where I need to move the selection (cursor) to a specific row, like row 1, or row 5. Does such shortcut feature exist or is it possible to create it? Alternatively, does ...
1
vote
1answer
33 views

spreadsheet: sorting by the first n characters of the entries of a column then by another column

Is there any way to sort an OpenOffice Calc spreadsheet by the first n characters of a given column then by another criterion? For example suppose that we have the following 4*2 spreadsheet (Note ...
0
votes
0answers
9 views

input data that automatically finds and places in its position in another sheet(s)

What I want to do is create a simple data entry form at the start of a series of monthly sheets in one document. I need the date, amount(£) and a category(choice from drop list would be good) to be ...
1
vote
1answer
47 views

How to accept LibreOffice Calc autocomplete suggestion without leaving the cell edit mode?

Whenever I start typing a sentence in a LibreOfice Calc cell it suggests autocomplete options based on other cells contents. I usually would like to accept it and make a slight modification but when I ...
0
votes
1answer
37 views

openoffice transfromed decimal separator for an xlsx file in server machine

i try to configure openoffice in linux server to use comma as decimal separator,i search and i found that have a relation with regional parametre so i configure etc/locales.conf to use french as ...
0
votes
0answers
9 views

“Insert manual row break” doesn't work on some docs?

In OOo Writer I linked the Return Key with "Insert manual row break" Basically this works fine. However, in some documents it simply does not, but I don't know why. Instead it gives me a new stanza ...
0
votes
1answer
30 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
280 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
15 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
60 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
67 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
35 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
34 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 ...
-5
votes
2answers
747 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
41 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
250 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
0answers
49 views

Database columns dependent on another table column

For illustrate suppose I have two tables, let's say "Client" and "Cart": Client: ID; Primary; Autovalue Name; Debt; Cart: ID; Primary; Autovalue Client; value of Client->ID Product; Value; ...
0
votes
1answer
65 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
226 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
33 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
54 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
55 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
66 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
122 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
20 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
93 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
40 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
19 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
1k 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
7 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
213 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 ...