Tag Info

Hot answers tagged

37

Libre Office Start page. This doesn't exist in Microsoft office. From here you can: Launch any of the 6 Office programs (create a new document) Open a recent file, from the grid of recent files. Open any file on your computer, from the Open File button Edit your templates Access Help and the Extensions webpage. Libre Office Writer. Libre Office ...


29

As @Braiam helpfully pointed out - using a different user I didn't have the issue anymore. I digged a little deeper and it seems I had set unity-tweak-tool to use the Dhikr1_cursor for the cursors theme. It came as part of a theme called Sabily which I probably installed along with a bundle of other themes. The part causing the weird behavior is ...


29

The solution is using odt2txt. Now, this command is provided by two different packages, namely one called odt2txt that you can install with sudo apt-get install odt2txt and by the package unoconv (that offers also command-line conversions between more libreoffice formats), that is installed by sudo apt-get install unoconv If you have the two, you can ...


19

The PPA mentioned by jbuch14 is bleeding edge and not for you if you just want the 4.3 LibreOffice release. For that, use sudo add-apt-repository ppa:libreoffice/libreoffice-4-3 sudo apt-get update sudo apt-get dist-upgrade This leaves you stuck on 4.3 until you decide to switch in a new repo and repeat this process but it will ensure you get all the ...


15

Libreoffice 4.4 was just released - the corresponding repository was created just some hours ago, it seems. As a result, the mentioned commands work now: sudo add-apt-repository ppa:libreoffice/libreoffice-4-4 sudo apt-get update sudo apt-get dist-upgrade [...] The following packages will be upgraded: fonts-opensymbol ...


14

If you're looking for setting security within the PDF itself, LibreOffice can do so. Use the Export as PDF option from the File menu. The resulting dialog has a tab named 'Security`: For command line conversion, the man page suggest that convert can use the options set in the Writer's Export as PDF dialog. So I suppose you could set it once in an instance ...


13

To get the latest version of LibreOffice (the one not directly located in the Ubuntu Repositories) add the libre ofice PPA. sudo add-apt-repository ppa:libreoffice/ppa sudo apt-get update sudo apt-get dist-upgrade This should upgrade you to the latest version of Libre Office available. Do note that the 4.3 package is not YET added to the PPA.


11

Yes, we can use the UCanAccess JDBC driver to connect to Access databases (.mdb and .accdb) in LibreOffice Base. Here's how I did it on a clean install of Ubuntu 14.04 LTS. First, I installed LibreOffice Base itself sudo apt-get install libreoffice-base Then I downloaded UCanAccess to my Downloads folder and unzipped it. I launched LibreOffice (not ...


9

Close all CALC windows open a new one Go to bottom right slider and move it to 100% (or whatever value you need) Close CALC open it again; cells are now in correct size :) you can also do it from Menu > View > Zoom


9

Give Zim a chance! I don't fully know MS One Note but maybe you could try zim. Zim is a graphical text editor used to maintain a collection of wiki pages. Each page can contain links to other pages, simple formatting and images. Pages are stored in a folder structure, like in an outliner, and can have attachments. Creating a new page is as easy as ...


9

I followed a thread on Ubuntu forums to solve this problem. There seems to be a line missing from this maintenance script file: /var/lib/dpkg/info/libreoffice-base.postrm The missing line, /usr/lib/libreoffice/share/basic/script.xlc needs to be added to the end of the file's second if statement, just above the closing fi, like so: --divert ...


7

For OneNote, you might have to look outside LibreOffice. There are a few alternatives, and none that I use, so no recommendations. I think each Desktop Environment (GNOME, KDE, etc.) has their own notes app. Tomboy - I think this used to be available by default on Ubuntu. This is the GNOME notes app. Gnote - And I think this replaced Tomboy as the default. ...


7

The Libreoffice packages depend on libreoffice-core, and libreoffice-core alone drags in 90+ packages: # apt-get install libreoffice-core --no-install-recommends Reading package lists... Done Building dependency tree Reading state information... Done The following extra packages will be installed: fontconfig fontconfig-config fonts-dejavu-core ...


7

It depends on how you installed the font. Font installed system-wide If it was installed system-wide (like most fonts are AFAIK) just pull Nautilus (Ubuntu's file manager) as root (Alt+F2 then enter gksudo nautilus) and navigate to /usr/share/fonts/truetype. then then Delete the file and then run sudo fc-cache -f -v in Terminal. Log out and back ...


6

Alt+F7 The keyboard shortcut to move a window is Alt+F7 To use this, click somewhere within the misbehaving libreoffice window to make sure it has focus. Then use the keyboard short cut. The mouse grab will occur - just move you mouse downwards to move the window from under the panel. Other useful shortcuts can be viewed in the System Settings - ...


6

Libreoffice does not have an equivalent to Onenote, but nobody says you should use only Libreoffice on your PC. Along with some of the very good alternatives already pointed out by Pedro Sardinha U94410 and muru, you may want to use a program with sync capabilities. In that case you should keep in mind that: Evernote works great for taking notes and ...


6

This a way you can hide and then remove duplicate rows (or 'records') in Libreoffice Calc Go to the worksheet that has the duplicate entries, and select 'Data' > 'Filter' > 'Standard Filter' (it seems to automatically select the data in the sheet that it will filter, you may want to do this manually beforehand). Then in the box that pops up, select the ...


6

On the first page, do the following steps: Insert Footer -> Default style Insert Fields -> Page Number Double click on the 1 in the footer to choose the roman format: Quit the Footer edition to go back to the top of the first page then add 5 page breaks to get the first 5 roman pages: Now to restart the numbering with the usual page number insert a ...


6

Click on Format --> page, and you can get it done that way.


5

The preferred way is to use the PPA, as answered by Jbuch14 above. The 4.3 packages aren't there yet, but should be in short order. The maintainer will have probably fixed packaging errors, (if any) and worked out the dependencies, but... If you can't wait, and feel brave and adventurous, remove the 4.2 version, get the debs from ...


5

Spreadsheet Tutorial - Libre Office, Calc by TheFrugalComputerGuy:


5

[Note: because icons are for the Desktop users (and not server users), the following steps use as little terminal as possible. For noobs: nautilus is the standard file manager.] Download the icon pack from http://dfiles.eu/files/k2dq3mwkq Go to the directory in which you downloaded it, right-click on the zip file and choose "extract here" Navigate in the ...


5

How to convert FDF to CSV? Option A: awk -F "[()]" '{ if ($1=="/V ") value[$2];} \ END {printf( "CompanyName\tEmailAddress\t\tCountryOrRegion\n" ); \ for (x in value)printf("%s\t", x);print "" ; \ }' filled_form.fdf > filled_form.CSV Option B: grep -oP '(?<=\/T \(txt).*(?=\))' filled_form.fdf |awk '{ORS=(NR%3?",":RS)}1'; \ grep ...


5

odt2txt file.odt the source code and compilebale working zip can be downloaded here: https://github.com/dstosberg/odt2txt/ or installed by sudo apt-get install odt2txt


5

You can browse through text without any special utility. ODT file is a renamed zip archive. Unzip it and you will see several files. One of them, content.xml contains all text and is more or less readable.


4

First export your data as .csv file format like below: F001,IC500 F003,IC501 F006,IC502 F008,IC503 Then switch to your main directory that you have all 700 directories there and use mv command inside a while-loop to rename the directory to new names: $ cd /path/to/main-dir ~/main-dir$ while IFS=, read -a name_dir;do echo mv -v "${name_dir[0]}" ...


4

You can get the Sifr icon set (very similar to the Faenza set depicted in another answer): Much more simply by using the PPA available for Ubuntu 14.04: sudo apt-get install libreoffice-style-sifr To chose this icon set, then go to Tools > Options > LibreOffice > View and then select "Sifr" under "Icon size and style" drop-down.


4

The welcome screen shows the "Base Database" option but actually Base is not installed by default (See the 14.04 manifest). Open a Terminal (Ctrl+Alt+t) to install the missing package, then type: sudo apt-get install libreoffice-base Now you should be able to open the Base Database application:


4

Here's my interface : This is the Sifr theme for LibreOffice 4.2 If you have LibreOffice 4.2, you can install the Sifr theme with : sudo apt-get install libreoffice-style-sifr If you don't have Libreoffice 4.2, install it with : sudo add-apt-repository ppa:libreoffice/ppa sudo apt-get update sudo apt-get dist-upgrade A few other themes are ...



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