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

learn more… | top users | synonyms (1)

1
vote
0answers
25 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
12 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
28 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
37 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
5k views

What file types can OpenOffice read and write?

I would like a comprehensive list of the file types currently supported by OpenOffice, both what it can open and what it can export to.
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 ...
0
votes
0answers
15 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 ...
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 ...
12
votes
3answers
20k 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
17 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.
0
votes
2answers
40 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?
1
vote
0answers
13 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 ...
1
vote
2answers
21 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
24 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
402 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
16 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
40 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
27 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
29 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
7 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
0answers
19 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
29 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
626 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
48 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
18 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
180 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
156 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
11 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
51 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
958 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 ...
5
votes
4answers
57k views

How to open ods files in Excel?

What is the best way to open ods files in Excel 2003? Is there some plug-in available? Should I use some convertor to xls? Or would it be best if I just used LibreOffice (or OpenOffice)? The file I ...
4
votes
1answer
785 views

Custom CSV (.csv) filter for OpenOffice.org or LibreOffice?

Is it possible to create a some kind of 'custom CSV filter' for OpenOffice.org or LibreOffice spreadsheet program. What I need is to have the program to use predefined CSV settings for loading and ...
1
vote
3answers
3k views

OOo Draw Import / Export Visio Diagrams [closed]

Just read this question by Jason S and it reminded me that I'm interested in a means of importing / exporting between Visio & OOo Draw (primarily using OOo to edit Visio files). Is this possible? ...
3
votes
2answers
3k 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 ...
6
votes
6answers
21k views

Is there anything to open .docx documents on Linux (Ubuntu)?

My mother has some serious issues using Windows (viruses, spywares, and so on) and I seriously think about setting up Ubuntu as a replacement. (That would ease my "job" as well) The only concern I ...
0
votes
0answers
26 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 ...
5
votes
1answer
305 views

How to open an OpenOffice document and scroll to a bookmark?

How to open an OpenOffice document and scroll to a bookmark or chosen page number? Can I do this with the command-line?
1
vote
0answers
30 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
398 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
36 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 ...
1
vote
2answers
981 views

OpenOffice.org Defective JRE

I installed the ODT to LaTex converter for OpenOffice under Ubuntu 9.04 because I wanted to convert my basic document template and even though it found the proper Sun JRE (Version is 1.6.0_14, ...
8
votes
1answer
8k views

Copying just text, not formulas, in OpenOffice Calc

How do I copy and paste the text (not the formulas) from one Calc sheet to another in OpenOffice?
2
votes
1answer
215 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
61 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 ...
4
votes
3answers
3k views

Keyboard shortcut in OpenOffice to incrementally increase or decrease font size?

Is there a keyboard shortcut in OpenOffice Writer that will allow me to incrementally change the font size? If I'm switching between 12 and 14 and 16 often, it would be much easier to be able to tap ...