Hot answers tagged

70

I found a more simple way to do that: Select the whole column Data > Filter > Standard Filter Change 'Field Name' to -none- , click on 'More options' and check on 'No duplication' box That's it. You can copy and paste the filtered fields if you want contiguously numbered cells.


27

Go to "Format" , "Page...", Header/Footer to set up the pages how you want them Edit 2015 I´m using Libre Office these days but a similar set of commands works there too. I´m suprised this answer still gets so many hits, glad it helps!!


20

From Wikipedia: Compared to OpenOffice.org 3.3, LibreOffice 3.3 has some unique features, including [15]: SVG image import Lotus Word Pro and MS Works import filters Improved WordPerfect import Dialog box for title pages Navigator lets you unfold one heading as usual in a tree view "Experimental" mode that allows users to test out ...


19

This is a special auto-correct behaviour that is only active for tables in Writer (not in Calc). It is controlled under: Tools > Options > OpenOffice.org Writer > Table > Input in tables > Number recognition Uncheck that option to disable the autocorrection.


18

You can do this with the OpenOffice advanced filter (on the main menu..Data/Filter/Advanced Filter) Ensure your column of data has a title at the top, e.g. title and that the data is contiguous (no empty cells) or select the whole column including empty cells by clicking on the column header., Create a filter criterion that would include all the data in ...


13

Tools | Options | OpenOffice.org | General | Tips


13

Select a cell in Column M. Select all cells in the spreadsheet with Ctrl-A. Open the Data->Filter->Standard Filter menu. Set the first row of the filter so that Field Name is "Column M", Condition is "Not Equals" and Value is "on". Click OK to apply the filter to the spreadsheet. Select all rows in the spreadsheet with Ctrl-A. To unselect any column header ...


12

Put a $ in front of the A column number in your formula, like this: =B1-A$1 You can then copy and paste the formula and it will preserve the A column number. This should work in both Excel and Open Office.


11

Select the cells you want to copy, and use Ctrl-C to copy them. Select the cell where you want to copy the cells. Open the Edit->Paste Special menu. In the Selection section, ensure that the Paste All and Formulas options are not selected. Select all other options in that section. Click OK, and the cells will be copied without the formulas.


11

The best option I found so far: extract the file (this is a regular archive) take a look at /QuickLook/ directory, there is a Preview.pdf with the basic contents of the presentation.


11

Found the answer om the OpenOffice.org forum. Rather than inserting newline, {}newline{} should be used instead. In my case: (x^6+x^4+x^2+x+1)(x^7+x+1){}newline{} = x^13+x^11+x^9+x^8+x^7+{}newline{} x^7+x^5+x^3+x^3+x^2+x+{}newline{} x^6+x^4+x^2+x+1{}newline{} = x^13+x^11+x^9+x^8+2x^7+x^6+x^5+x^4+x^3+2x^2+2x+1 To get it nicely aligned to the left, I used: ...


11

I've actually figured this one out, here is the answer: =(C2 - DATEVALUE("1/1/1970"))*86400


10

Use Edit-->Copy then Edit-->Paste Special (or Copy and Paste Special... from the context (right-click) menu). In the dialog uncheck paste all, check numbers and uncheck formulas. This is in every version of OO/LO, that I've used.


10

When SUN was acquired by Oracle, the open source community was afraid that Oracle kills SUN's open source software, which included OpenOffice.org, OpenSolaris, MySQL, etc. While some of these fears turned to reality (with Oracle dumping OpenSolaris), the database giant plans for OpenOffice.org were not so clear and the office suite future seemed in danger. ...


10

Type the first bit of text normally. Then, go to the Insert menu, choose Section, click on the Columns tab, and then choose two columns. That will give you two columns just for that section, rather than for the entire page.


9

Select the first row below that which you would like "frozen" and select Window | Freeze. EDIT: In fact, this works to freeze rows and columns. For example, if select cell C3 and Window | Freeze, then the first two rows and the first two columns will be frozen.


9

The most important difference between Lotus Symphony and OpenOffice that really matters, would be the fact that Symphony is, while based on OpenOffice code, still closed-source, whereas OO is entirely open source. Engine-wise, it should not differ too much from OO since Symphony is a derivative fork from the OO project under IBM's heading. For now, ...


9

To get sub-string excluding first 4 characters (plus space) you can use MID function: MID(A1,6,LEN(A1)) It will result in 'John Smith Cell A2 says 0002 Bill Snyder'. You can also imitate text splitting with FIND function, for example this formula will output '0001': LEFT(A1,FIND(" ",A1)-1) Further, this will output John (assuming original text is in A1 ...


8

In Excel the $ in front of the Rownumber fixes the row to a constant. A $ in front of the column letter fixes the column. So you have: A1 if you copy down, the 1 will change to 2,3, etc; if you copy across, the A will change to B,C, etc A$1 if you copy down, the 1 stays 1, if you copy across the A changes $A1 if you copy down the 1 changes, if you copy ...


7

Start the list as usual and select from Formats->Bullet and Numbering->Outline an appropriate style (I often use the all-numeric 1/1.1/1.1.1 style but there is a 1./1./1./ that should provide the effect you are looking for). At the end of the first point (default: 1.) press enter '2.' will be displayed. If you now press tab this will change to '1.1' ...


7

Yes, there is a way to move whole columns using the mouse like in Excel: To move: press ALT, then left click somewhere in the selected column (not the column header) and drag. To copy: press Ctrl + ALT, then left click somewhere in the selected column (not the column header) and drag. Tested with OpenOffice 3.2 Calc, Windows XP.


7

OpenOffice used to have a LaTeX export functionality, which was later removed, I guess. Nevertheless, there is a LaTeX writer: sudo apt-get install openoffice.org-writer2latex writer2latex Or, if your distribution uses LibreOffice, use libreoffice-writer2latex instead of the above. Just confirm all messages with y. After installing, you can use it with ...


7

There is an online conversion service at http://www.zamzar.com/ (assuming that your file does not contain confidential information ...)


7

The two main options are: OpenOffice, previously from Sun/Oracle and now under the wings of the Apache Fundation, and LibreOffice, the main fork from the previous one. Both are similar and can open the Microsoft Office suite documents with most, but not all unfortunately, functionality and layout preserved. Other options include: Google Documents, but ...


7

Goto Tools -> Autocorrect Options Uncheck Replace in the Double Quotes section of the Localized Options tab.


6

Whenever I'm faced with the old extra blank page in Microsoft Word or other word processors, I do one of the following: A. Get rid of the blank page Move the cursor to the end of the document. Press Delete until you remove all trailing hidden objects or whitespace. (As mentioned by @Desingh) Set the font size for the last line to 1 or smaller. Decrease ...


6

It doesn't appear in the Replace list, because it is an option on its own. To disable it, go to Tools -> AutoCorrect Options... -> Options and uncheck Replace dashes.


6

1) Select cell B2 2) Window -> Split 3) Window -> Freeze


6

I would suggest the JODConverter. It is a java wrapper around the OpenDoc Api for conversion. Allows you to convert files like this: java -jar jodconverter-cli-2.2.0.jar foo.html foo.rtf It's also available in python. instead of using the openoffice SDK DocumentSaver class like this: java -classpath .;./bin;\ ...


6

I found the answer. It is CSVed I have been using CSVed for about 10 minutes. It is fast and way more powered than I could have imagined. In fact, as a data manager of a single table it is absolutely fantastic and fast. In fact spreadsheet and database programs look downright clumsy compared to CSVed. Those other programs are good when one is caculating ...



Only top voted, non community-wiki answers of a minimum length are eligible