Hot answers tagged

79

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.


29

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

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.


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 ...


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 ...


14

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 ...


14

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.


13

Tools | Options | OpenOffice.org | General | Tips


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.


12

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


12

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.


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: ...


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.


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. ...


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

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

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 ...


8

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.


8

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 ...


8

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


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

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


7

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 ...


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 ...


6

Found answer: Add custom animation Go to Effect Options Under Text Animation set Group text to By 1st level paragraphs Answer found on Ubuntu forums. Couldn't find anything up-to-date on the OOo support site.


6

I think the most straightforward way would be to setup a pdf printer on your box and then just: ooffice -pt pdfprinter studentwhodoesntfollowdirectionswell.odt Edit: Just found a post on the Ubuntu forums with someone who arrived at the same solution I suggested (with handy dandy instructions). printing to pdf from command line [SOLVED] Edit 2: I just ...


6

Well since you mentioned your computer crashed, Im going to assume you are using windows. check for a backup folder located in: XP: C:\Documents and Settings\\Application Data\OpenOffice.org\3\user\ Vista or Win7: C:\Users\\AppData\Roaming\OpenOffice.org\3\user If that doesnt work you can always try a program called Recuva which helps restore deleted files....


6

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



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