Posts Tagged ‘libreoffice’

Turn off / Add water Mark in Libre office

May 24, 2013 9 comments

Some cases you need to remove water mark received in MS office file [doc] or you need to add water mark in Libreoffice file.

To remove MS office water mark, You need to understand what it is. It is a word art anchored in ‘header’ positioned in the center of page [Libreoffice treat it as word art].

Selection can be done by change navigation to drawing & delete the word art.

Select ‘navigator’ shown in center button in the ellipse & change the selection mode to’ drawing’ as shown in the rectangle.

Then using navigation arrow shown below rectangle[bottom downward double arrow], select the graphics & delete the water mark.


Same way, you can add water mark in libre office writer odt file.

  • Add a header in the page


  • Add a text box from drawing toolbar anchored in the header .



  • Add text required as water mark & Change text colour to light gray or variation of gray.


  • Rotate Text box to required degree


  • Center Text box to page.


  • Now you will have water mark in all pages.


Note : You can also associate header to one page style & control water mark where ever required. for editing, you can select using navigator –> drawing navigator shown in the above write up. then move text using arrow in the keyboard[mouse is not available to select].

To install Libreoffice 4.0 in fedora 17 / fedora 18

February 11, 2013 2 comments

To install Libreoffice 4.0 in fedora 17 / fedora 18, steps are given below

  • Unpack the downloaded archive
  • Open a terminal window
  • Change directory to “rpms” in the terminal[ eg :cd  /path_of_extracted_content/rpms]
  • Execute the command :  su -c ‘yum install *.rpm’
  • Change to subdirectory called “desktop-integration” in the terminal[eg : cd desktop-integration]
  • Execute the command : su -c ‘yum install *freedesktop*.rpm’

You can access all the LibreOffice applications in your desktop’s Applications/Office menu.

Note: You need to uninstall any other version for desktop integration package to install.

Remove apostrophe used for text formatted number in Libreoffice

January 2, 2013 2 comments

To enter the number as text, the easiest way is to enter the number starting with an apostrophe (for example, ‘00008). The apostrophe will not appear in the cell, and the number will be formatted as text.

If apostrophe is not removed, calculation operations will not be include the cell & result will be wrong. So You may need to remove apostrophe or Formatting Numbers as Text or formatting mark or special non-displaying character to do calculate with this number.

To Convert text formated cells to numbers in libre-office, follow the below steps :

  1. Choose Edit – Find & Replace
  2. In the Search for box, enter ^[0-9]
  3. In the Replace with box, enter &
  4. Check Regular expressions
  5. Click Replace All

Note: ^[0-9] regular expression means ‘other than 0-9 numericals’.

Paste text from pdf viewer or acrobat in Libreoffice / Openoffice

December 7, 2012 1 comment

If we paste text from pdf, You will have single line paragraph instead of full text paragraph.

You can use Libre-office or open-office auto correction to get full paragraph from single line paragraph.

Step are given below :

Copy the text from pdf viewer or acrobat.

Paste the text in libreoffice Writer. Text may look look like below

2012-12-07 12:11:46

go to auto correct option in tools menu

2012-12-07 12:09:53

enable the option combine single line to paragraph.

2012-12-07 12:10:36

Change minimum percentage % using edit button[It is minimum % of single paragraph length used to combine to full paragraph. If it is lesser, it will not combine].

2012-12-07 12:11:05

then go to last format menu & auto correct & press apply

2012-12-07 12:12:28

Then you will get result will like as shown below.

2012-12-07 12:12:57

Note: while pasting text from pdf document, please ensure that the style is default.

This option is very useful in combing single line paragraph.

Paste web pages with text & images in Libreoffice 3.5 / Libreoffice 3.6

February 6, 2012 10 comments

If you copy something from a web page (text & images together) from any web browser like Firefox/chrome/IE and paste it in LO writer, the document save with the images, but images are inserted as links in the documents rather than getting copied to the document.

Screenshot from 2013-02-06 14:49:02

To solve this, go to edit menu — > Links . break the links that are used for images. & save document.

Screenshot from 2013-02-06 14:56:20

This may take a few minutes..

Screenshot from 2013-02-06 14:57:01


Use Libre-office [open-office] extension ” paste from Web”.


For Single images, You can use the paste special option – paste as bitmap

Screenshot from 2013-02-06 14:49:53

Open/save ODF documents as flat XML / flat odf files

December 13, 2011 Leave a comment

When installing, choose custom setup & select to install “XSLT Sample Filters” under “Optional Components”

This will add the “OpenDocument Text (Flat XML or flat odf) (.fodt)” format .

Speed up LibreOffice 3.4 / 3.5 [openoffice 3.4]

November 26, 2011 Leave a comment

Speed up LibreOffice 3.4 / 3.5

Some settings may improve LibreOffice’s loading time and responsiveness. However, some also increase RAM usage, so use them carefully. They can all be accessed under Menu –> Tools > Options.

  • Under Memory:
    • Reduce the number of Undo steps to a figure lower than 100, to something like 20 or 30 steps.
    • Under Graphics cache, set Use for LibreOffice to 128 MB (up from the original 20MB).
    • Set Memory per object to 20MB (up from the default 5MB).
    • If you use LibreOffice often, check LibreOffice Quickstarter.

    Screenshot from 2013-02-06 16:10:56

  • Under Java, uncheck Use a Java runtime environment.

Screenshot from 2013-02-06 16:11:33

Note :
LibreOffice Functionality depending on Java :
Base [Create Form Wizard], Writer [Letter Wizard, Fax Wizard, Agenda Wizard, HTML Wizard,
SaveAs -> AportisDoc (Palm), SaveAs -> DocBook, SaveAs ->Pocket Word (*.psw)]
, Calc [SaveAs -> Pocket Excel], Extensions[Wiki Publisher, Report Builder ], All [OOoBean, JavaScript Macros, Beanshell Macros]