Category Archives: LibreOffice / OpenOffice

LibreOffice global menubar still not working properly in Ubuntu 12.10

I upgraded to Ubuntu 12.10 Quantal Quetzal about two weeks ago. As usual, there are a number of new or improved features and changes, the arguably most controversial being the Dash’s Amazon integration. What has not changed, unfortunately, is the problem of the global menubar in LibreOffice. Even more unfortunate, the temporary solution using “unity –reset” I wrote about before does not work anymore. Continue reading

Freezing LibreOffice icons on the Ubuntu Unity launcher

LibreOffice is still not playing nicely with the Unity interface of Ubuntu. For a start, it does not support the global menu. You can enable this by installing the lo-menu package (available in Ubuntu software centre). This doesn’t work for me though; after installing the Window menu disappears. This means loosing access to the split and freeze functions in Calc. Continue reading

Annoying problem converting ODF to Word 2003 documents – solved

Although I almost exclusively work with Libreoffice, most people I work with still use Word 2003 or later MS Word versions. Not too much of a problem; converting ODF documents back and forth to Word 2003, 2007 or 2010 is usually fairly smooth. However, the last couple of weeks I got complaints from colleagues who could not select, copy or paste figure captions. And they couldn’t add or edit comments in the text either. Continue reading

Filling in the blanks

Some worksheets contain cells that have been left blank, e.g., in order to make the headings and subheadings easier to read. However, if for example you want to sort or filter the list or you want to use the table for analyses, you need to fill in the blanks. You could manually copy the value from the first filled cell above the blanks. An easier and faster way to do this is described on this site. The technique they describe requires the Go To function, which unfortunately is not available in Openoffice’s Calc. However, there is an alternative way (which works also in Excel). Continue reading