How to fix "BASIC runtime error 1; Type: com.sun.star.uno.Runtime Exception, Message: Toolbar do not exist " error in Libreoffice calc, Ubuntu 12.04

Posted by PDeb on Ask Ubuntu See other posts from Ask Ubuntu or by PDeb
Published on 2012-07-05T08:31:05Z Indexed on 2012/07/05 9:22 UTC
Read the original article Hit count: 2443

Filed under:

libreoffice-calc

I get the following error while openning a .xls file in Libreoffice Calc, Ubuntu 12.04 [LibreOffice 3.5.5.2; Build ID: 350m 1 (Build:2)]

To overcome this I checked the LibreOffice Security Level to Low under Macro Security (from Tools----> Options---> Security tab. Then I went ahead intalling java by running the following commands from the terminal window (with some tips from various forums)

sudo add-apt-repository ppa:libreoffice/ppa

sudo apt-get update

sudo apt-get install libreoffice libreoffice-java-common libreoffice-math libreoffice-gnome libreoffice-java-common

Still I got the BASIC runtime error (as in the title), even after clicking Tools----> Options ----> Java and checking the 'Use a Java runtime environment option' and then clicking on 'Sun Microsystems Inc' under listed JRE environments installed.

Even I ran the following commands to install latest Java run time environments from terminal window

sudo apt-get install openjdk-7-jre icedtea-7-plugin

But still I get the same Basicruntime error (details as in the title bar).

This particular file opens perfectly in Microsoft Excel 2007, in Win XP Professional.

Related posts about libreoffice-calc

Changing the cell range of conditional formatting in LibreOffice Calc

as seen on Super User - Search for 'Super User'
Is there any way of changing the range of conditional formatting in LibreOffice Calc (version 3.6)? I have a set applied already to a range of cells, but there is no obvious way of changing which cells a given set of conditional formatting is applied to. I either have to copy and paste the formatting… >>> More
LibreOffice Calc SEARCH and FIND functions

as seen on Super User - Search for 'Super User'
I am trying to process some data in Calc. One of the steps involve finding if a certain string is part of one of the column. I tried using FIND and SEARCH functions. Both behave in the same way and I am not getting correct results. E.g. Say I have following strings in Column A NY SF LON CAN US and… >>> More
Flexible argument list in LibreOffice Calc Macro

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to write a function that geometrically links performance data which is usually provided as percentages, so the function will basically return (1+a)*(1+b)*(1+c)* … *(1+x)-1 This should be done using LibreOffice-calc and it should behave similarly to the regular sum function. As you may throw… >>> More
Change the icon color in LibreOffice Calc

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
There appears to be no way of changing icon color in a calc chart. After creating an XY scatter plot, I can select "format data series" and can change the icon symbol and size, but not the color. There is an drop-down for line color, but when I do not have lines displayed this drop-down menu is grayed… >>> More
System crash when trying to drag cells in LibreOffice Calc

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Some time after upgrady to Saucy I noticed several freezes and crashes when simply trying to drag content of selected cells to another place in LibreOffice Calc (version 4.1.2.3 from repository). The system stops responding - although for example Clementine still plays music from playlist - I am… >>> More

Developer IT