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

learn more… | top users | synonyms (1)

2
votes
1answer
11 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 ...
1
vote
1answer
48 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
25 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 ...
-2
votes
0answers
21 views

Surface Pro 3, OneNote and Open Office [closed]

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
2answers
68 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?
2
votes
1answer
3k views

How do I use conditional formatting in a spreadsheet based on dates?

I have a spreadsheet in OpenOffice V3.3.0 (used in Windows 7 32 bit). One column contains dates (in the format: 14 August 2011 ) and I want to use conditional formatting on those cells depending on ...
2
votes
3answers
217 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
1answer
2k views

Make cells automatically shrink to fit text in OpenOffice spreadsheet

Is there a way to get the widths of cells to automatically shrink themselves to fit the longest line in a column?
0
votes
0answers
9 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
18 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
1answer
180 views

Open Office Calc formating table

Instead of data, I would like the first row to be the names of the columns. How can I do this? One of the reasons I want this is so that if the rows are rearranged the names wont be jumbled up. I ...
0
votes
0answers
83 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 ...
4
votes
3answers
4k views

Inserting an image into a OpenOffice.org Calc cell

Is there a way to insert an image inside a cell? When I choose "Insert -> Picture" it inserts it so it's floating over the cells. That's not what I want. I want to be able to insert the image into ...
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
49 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 ...
4
votes
4answers
5k views

How to create diagram in spreadsheet with dates on x-axis?

I recently became a father to twin boys. Naturally there is a lot of weighing and measuring, and we record these numbers in a spreadsheet. I use OpenOffice.org Calc (but I'm open to solutions for ...
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: ...
5
votes
1answer
286 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 ...
0
votes
2answers
59 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
291 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 ...
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 ...
1
vote
1answer
120 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 ...
1
vote
3answers
4k views

OpenOffice ruined my CSV file - (how to save CSV on Linux with OpenOffice?)

I am running OpenOffice 3.2 on Ubuntu. I had a CSV (comma separated value) file which I had manually created. I opened it in OpenOffice, and entered about 100 items (to make use of using formulas to ...
0
votes
4answers
4k views

Where are openoffice templates stored?

My computer has somehow gotten out of sync. I can save a document as a template in a directory of my choosing, but when I go to use the Templates and Documents dialog, I get this: I have no idea ...
0
votes
0answers
116 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
2answers
91 views

Ubuntu to Windows openoffice save issues?

I just finished working on my teacher's paper, which is due to her an hour ago... For 2 hours I've been trying to find my paper anywhere on ubuntu, or my windows installation. It is nowhere, anymore. ...
5
votes
7answers
6k views

Which doc format should I use in LibreOffice if other users open it in MS Office

I often share documents with colleagues. I use LibreOffice (and OpenOffice). But my colleagues use Microsoft Office. My documents always look differently when opened in MS Office (.doc and .odt ...
1
vote
3answers
1k views

how to open files as read only in openoffice

I'm a student and I often find myself opening lecture notes (in PPT format) to study. I don't need to edit them (and I don't want to accidentally edit them). After opening the file I usually click on ...
17
votes
3answers
23k views

OpenOffice: get distinct values from column

How do I get a list of all distinct values from a column of values? Basically, this question: Excel: Get distinct values in column but I need the answer for Open Office Calc instead of MS Excel. ...
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 ...
1
vote
1answer
421 views

“Search” not working in Open office Calc (*.xls)

I can't find any strings in the open office calc(version 3.2.1 in windows) document (*.xls) by doing a search(Ctrl+F).I tried with all options and then also i didn't get any positive result. All ...
0
votes
1answer
25 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?
0
votes
1answer
44 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 ...
-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 ...
0
votes
4answers
3k views

Rotate image with open office 3.2

I import a picture into an open office document from file. However, I cannot figure out how to rotate image in open office 3.2 writer. Is there any way to do that?
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 ...
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 ...
2
votes
1answer
723 views

How to prevent OpenOffice from running file recovery every time at startup?

Whenever I start my computer and start OpenOffice, the file recovery option is always displayed. How do I turn this off?
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 ...
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
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 ...
3
votes
3answers
193 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
2answers
282 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 ...
1
vote
2answers
1k 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 ...