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

learn more… | top users | synonyms (1)

-1
votes
1answer
23 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
21 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
5 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
7 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 ...
10
votes
3answers
18k 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. ...
0
votes
1answer
19 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 ...
1
vote
1answer
512 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
8 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
39 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
11 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
167 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
61 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
7 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
45 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
27 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
2answers
646 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
55k 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
777 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
20k 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
13 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
292 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
20 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
123 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
24 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
979 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
7k 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
146 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
67 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 --> ...
0
votes
1answer
55 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 ...
3
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 ...
0
votes
0answers
33 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
2answers
2k views

How to remove unused columns and rows from being displayed in calc

Does anyone know how to remove unused columns and rows from being displayed in an openoffice.org calc file? I want the display to just be solid grey or white with no grid or column/row names.
1
vote
1answer
75 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
25 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 ...
2
votes
1answer
648 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
vote
2answers
575 views

Make OpenOffice Portable the Default Program?

How do I make OpenOffice.org portable be my default document viewer on Windows?
1
vote
0answers
117 views

Unable to set a default language in OpenOffice.org programs

I'm having lots of problems with the default language in OpenOffice.org applications. I've set the language in Tools > Options > Language Settings but whenever I open the app it has no language set ...
1
vote
1answer
888 views

OpenOffice 3.3.0 menu entry “Send -> Document as e-mail” does not work with Zarafa Web-Client

We have a Windows XP SP3 (German) with OpenOffice 3.3.0 installed and use Zarafa as Groupware. We modified the registry in order to set Zarafa WebAccess (Browser -> website) as the default mail ...
4
votes
6answers
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
40 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
50 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
90 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
1answer
288 views

OpenOffice Calc getting slower and slower

I am running OpenOffice 3.2.0 Calc on my Ubuntu (10.04) desktop. I have a huge data entry task to complete today and Calc is getting slower and slower moving between cells on the sheet. When I rename ...
0
votes
0answers
13 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
1answer
151 views

page-specific bullets in openoffice impress

I need to switch the bullets in an openoffice impress slideshow. In one page I need the "normal" round ball, in another I need a check sign, in another I need the x sign. What I do is select the list ...
0
votes
0answers
57 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 ...