93

Enable Complex Text Layout (CTL) support using (sources: 1, 2, 3): Tools → Options → Language Settings → Languages It may be necessary to restart LibreOffice after enabling CTL. Then: Ctrl+Shift+D or Ctrl+Right Shift - switch to right-to-left text entry Ctrl+Shift+A or Ctrl+Left Shift - switch to left-to-right text entry. If the ...


28

Select what you want to strikethrough, rightclick, style and select strikethrough. I believe this works the same way on every modern wordprocessor I've come across


20

Is there a way in which I can tell LibreOffice to save in a Git friendly format? You can save your files as flat XML (fodt) instead of odt: If a document is saved as .fodt file it keeps the same data the .odt file would contain. Only that this time the data is represented as human-readable text (which makes the work much easier for the version control ...


19

You can modify the application background using the appearance settings (Menu Tools -> Options -> LibreOffice -> Appearance): The "Application Background" is the gray area around the sheets, and the "Document Background" setting affects the entire sheet (margins and editable area). Together with the "Font color" setting, you can modify the appearance ...


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


16

You can assign keyboard shortcuts to styles in the Tools > Customize menu. In the "Keyboard" tab, the bottom of the Category field, you can expand Styles to find your custom styles. Then just assign them a shortcut in the top field, click Modify and OK.


15

Perhaps you have the same problem as this guy did. Make sure your user owns ~/.config and everything in it. This should do it: sudo chown -R --reference="$HOME" ~/.config It'll change everything in that directory to have the same owner and group as your home directory, which should have the proper values.


14

There are two problems here. The first is that www-data (the apache user) does not have a $HOME so libreoffice cannot run if there is no $HOME defined. The second problem is, unless you specifically set it up this way (and you really really really shouldn't), apache does not have access to the system /tmp directory. A web server normally runs in a restricted ...


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

To combine pages from two PDFs in LibreOffice Writer follow these steps. Open the first PDF document in LibreOffice Writer using File -> Open. Open the second PDF document in a new LibreOffice Writer window using File -> Open. Select a page in the first PDF document Pages pane before where you want to add a new page in the PDF document. Select the page you ...


12

When you export a CSV file, go to File > Save As, select Text CSV as file type and then go to Edit filter settings. In this dialog you can select the cell delimiter and change it from Tab to a comma.


12

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


10

Add Direction Buttons like MS-WORD As you remember in MS WORD there were to buttons in standard menu which acted as shortcut. Go to VIEW>TOOLBARS>CUSTOMIZE Select the tab "TOOLBARS" Select "STANDARD" Press the button "ADD" Select Category " Format" From the right pane select "RIGHT TO LEFT" & "LEFT TO RIGHT"


10

For some users (thoses using KDE), the "edit filter settings" box is gray. A workaround is to use Openoffice dialogs. Tools > Options > LibreOffice > General > Open/Save dialogs > Use LibreOffice dialogs Then you will be able to choose the field delimiter wanted. That bug was reported here : https://bugs.freedesktop.org/show_bug.cgi?id=72187


10

When foreign documents use an unknown font you don't have installed, that font's name still gets displayed in LibreOffice Writer, but it automatically picks one of your installed fonts that it thinks is most similar to what you might want to see. So what you describe is the perfectly normal and intended behavior in the situation that you just don't have ...


9

Take a look at the answer here of LibreOffice configuration. According to the post, the choice of saving a preview thumbnail is a setting that you can change: Tools → Options... → LibreOffice → Advanced → Expert Configuration Select the preference named: org.openoffice.Office.Common/Save/Document/GenerateThumbnail Double clicking on it toggles the ...


9

To add the option to the tool bar, right-click the tool bar, then click "configure". Then click "add" and browse to "format", then "strikethough" and click "add". (You can move it next to the underline button by marking it and using the arrows under "modify".)


8

You can't pass lpr command line options to libreoffice. Two possible solutions are: One step solution (the best solution in my opinion): use unoconv outputting a PDF to stdout piped to lpr: $ unoconv --stdout filename.doc | lpr -U username -P the_printer_name Three step solution (if you don't want / can't use unoconv): use libreoffice --print-to-file to a ...


8

I have got the same problem, OpenOffice + black theme looks ugly. Is seems there's nothing which is as convenient as the old GTK2_RC_FILES variable, but take a look at this: An application can cause GTK+ to parse a specific CSS style sheet by calling gtk_css_provider_load_from_file() and adding the provider with gtk_style_context_add_provider() or ...


8

I know this is a very old question but this is how to do it in GTK+3. GTK_THEME=Adwaita gnome-calculator or use GTK_THEME=Adwaita:dark gnome-calculator for the dark variant of Adwaita theme.


8

As long as I know how these printers work, we can have two solutions, I think. when printing the document, instead of just print, use the print dialog and choose pages to print, you type 1,1,1,1 so it'll print 4 times the page one. Repeat in the document the first page (at least 4 times, or 8 times if you want to print it at one).


7

Does this solution work? Ctrl+Shift+D or Ctrl+Right Shift Key - switch to right-to-left text entry Ctrl+Shift+A or Ctrl+Left Shift Key - switch to left-to-right text entry from https://help.libreoffice.org/Common/Languages_Using_Complex_Text_Layout


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

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

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

I dont use spreadsheets other than Excel, but Excel is capable of doing just about anything using VBA, including custom functions. Check out this article to see a basic example.


6

You can use VipJ on each paragraph: V: start linewise selection. ip: select entire paragraph. J: joins lines together. Because you separate each paragraph with a double newline, we can record a macro to do this for us automatically: qqVipJ2jq To join N paragraphs together, simply use N@q now.


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


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