132

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.


18

Create an iCloud account (https://www.icloud.com). Its free. Upload the keynote presentation. Once uploaded, you can click on the file and "download a copy" the file as either a PDF, PPT. or a key file.


18

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


17

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


15

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.


14

To move a row in Open Office Calc: Select the cell in column A of the row to be moved. Hit Shift-Space to highlight the entire row. Press and hold the ALT key. Drag the row (thick black line appears) up or down to the desired location. If your work looks correct, click the Save icon in the toolbar. Otherwise, ALT-Z to undo. If you want to over-write and ...


13

I like to complicate things so here what I would do: select both columns, right click, Format Cells, select Text format right click first column and select Insert Columns Left insert formula =CONCATENATE(B2,C2) (or whatever cells you need to concatenate) and pull down so the cells will fill with the correspondent concatenation select the created first ...


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.


8

This is an old one, but I ran into it myself today. the trick to using "--headless" is that you need to have libreoffice-headless installed (ie: yum install libreoffice-headless). not all libreoffice installs have libreoffice-headless installed - for example, mine today. Found this nugget buried in the link user1032531 posted. It would be nice if using --...


7

Partly answering my own question: LibreOffice comes with these fonts, as posted here: And here are some of the fonts that come with OpenOffice, accroding to Wikipedia: OpenOffice includes OpenSymbol, DejaVu,the Liberation fonts (from 2.4 to 3.3) and the Gentium fonts (since 3.2). Versions prior to 2.3 included the Bitstream Vera fonts. After 3.4 the GPL-...


7

I'm not sure if there's a way to "move" rows using the keyboard, but using c&p and inserting/deleting rows using the keyboard should offer the same functionality: navigate to the first (leftmost) cell of the row to move; hit SHIFT+SPACE to select the entire row; hit CTRL+C to copy the row; hit CTRL+- to delete the current row; navigate to the target row;...


7

There are two ways to disable the "PickList" / MRU: tweaking the config using an extension Tweaking the config: Open the LibreOffice config: Menu "Tools" -> "Config"; In the TreeView: "LibreOffice" -> "Advanced" Button "Expert Configuration" In the preferences list, scroll down to preference "/org.openoffice.Office.Common/History" Select the second ...


6

Ahhh, damn it, this is so dumb - well, as you can see on the screenshot, my HTML file actually starts with: <?xml version="1.0" encoding="iso-8859-1" ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <!--http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd--&...


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


6

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

Word 2007 does provide support for reading and producing ODF 1.1 .odt documents. You should make sure that the version of Office 2007 is current to at least SP2. The support for ODF 1.1 is also present in Microsoft Office 2010. In Microsoft Office 2013, there is support for ODF 1.2, including interchange of OpenFormula between Excel and OpenDocument ...


6

(I'll keep this answer here because it is more general than using a builtin command as suggested in my other answer — with a macro you can use any combination of paste options, not just a couple of predefined operations.) You can define a macro and bind it to a key combination. The simplest way is probably to use the macro recorder: Ensure that macro ...


6

Is there a way to coax the spreadsheet programs to give me correct results? Probably not. Excel certainly, and I expect other spreadsheet programs (for Excel compatibility) use Floating Point numbers based on the 64bit IEEE format. This is implemented in hardware on most current CPUs and thus is fast (even a moderately sized spreadsheet can involve a lot ...


5

For calculating the difference of two times in hours: =(HOUR(E17)+(MINUTE(E17)/60))-(HOUR(D17)+(MINUTE(D17)/60)) where D17 is the "from time" and E17 is the "to time". Both E17 and D17 should be formatted as time.


5

Just for posterity and for everybody that googles openoffice accept all changes: Edit → Changes → Accept or Reject → Accept All


5

It appears that Libre Office supports what you are trying to do using command line arguments like the following: libreoffice --headless --convert-to doc *odt I found this information from Batch convert .odt to .doc using LibreOffice at the gnuru.org site.


5

you can turn off tips in Tools>Options>General Then you also need to restore the "what is this?" button on your toolbar since all tooltips will be off and the button can give back that functionality when used. Go to tools>Customize>Toolbars and in Standard toolbar turn on the button [at the bottom of the list].


5

You should use MAX($D$1:$D$4) instead, in your condition. To highlight the whole row, you can select Formula is instead of Cell value is, and use the following formula: $D4=MAX($D$2:$D$4) (assuming you selected your block starting from A1 and ending in D4):


5

The Open Document Format (.odt, .odp, .ods, ...) is an open format and free to use. Microsofts Office Open XML Format (.docx, .pptx, .xlsx) is as well an open standard, but it is not free, licensing fees have to be paid to Microsoft. So the answer to your question is: It is all about the money. Microsoft tried to force other products like OpenOffice/...


5

After looking more closely at the “Customize” dialog, I found commands which probably do what you want without using macros: Select Tools → Customize, then switch to the “Keyboard” tab. Select the desired key combination in the “Shortcut Keys” list. Select “Edit” in the “Category” list, then select .uno:PasteOnlyValue in the “Function” list. (According to ...


5

You don't say what program you are using, but it's non-printing character, at least that's what is is named in "Open Office Writer". In that program, go to "View" and toggle "non-printing characters".


5

The answer to this is going to depend heavily upon what version of Excel you're using, but here are two ways of doing it: Option One - A Helper Column In a new column in your table enter the following formula: =IF(OR(RIGHT([@Addresses],LEN([@Addresses])-FIND("@",[@Addresses]))="foo.com",RIGHT([@Addresses],LEN([@Addresses])-FIND("@",[@Addresses]))="bar....


5

That's the margin that appears whenever Track Changes is on, or there are comments in the document. To hide it, in Word: Review -> Track Changes -> No Markup. In OpenOffice I believe it would be View -> Comments (Uncheck). In Word 2016: Review -> Show Comments


4

There is a really handy shell script called unoconv that handles conversion of any files from and to any file format that OpenOffice/LibreOffice supports. You can read up about it on its site and be sure to check out the man page. Many distros have packages for it that you can install easily, including, I believe, cygwin. Once you have it installed, usage ...


4

I was having similar problem (with similar messages): On our server nginx runs under user www-data. When we run OpenOffice (or any other applications we use), for security reasons we run it under user www-apps (user www-data is able to sudo to www-apps). Unfortunately, I was getting this: www-data@server:/tmp$ sudo -u www-apps /bin/bash www-apps@server:/...


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