Error message in open office.

Asked by Myroslav

I am using Jaunty amd64 and open office 3.1.0 Build: 9399. Any time I try to open any open office file I get the following message:

Error loading BASIC of document.
file:///home/mg/openoffice.org/3/user/basic/dialog.xlc/:
General Error.
General input/output error.

At the bottom of the message window there is a box marked ok. When I click ok, the same message reappears. When I click it a second time it disappears, and my open office session appears to proceed normally.

This issue came up suddenly about a week ago. All was normal before that. I can still open new and existing documents and can edit and save them, but I worry that some trouble might lie ahead.

Does anyone know how to get rid of this annoyance?

M

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
Isak Frants
Solved:
Last query:
Last reply:
Revision history for this message
Isak Frants (isakfrants) said :
#1
Revision history for this message
Myroslav (mgalan) said :
#2

Isak Frants wrote:
> Your question #76253 on Ubuntu changed:
> https://answers.launchpad.net/ubuntu/+question/76253
>
> Status: Open => Answered
>
> Isak Frants proposed the following answer:
> http://ubuntuforums.org/showpost.php?p=3640148&postcount=6
>
>
Thank you for your response, but I do not think it will help me.

In essence you are asking me to copy files from one directory to
another, but the paths to these files are different in my setup than the
paths suggested by the post you pointed me to.

I copy the instructions you pointed me to here.

> * Close any OpenOffice instances that are running,
> * Go to '<where_OOo_is_installed>/presets/basic/'
> * Copy 'script.xlc' and 'dialog.xlc' to
> '$HOME/.openoffice.org2/user/basic'
> * Go to '<where_OOo_is_installed>/presets/basic/Standard'
> * Copy 'script.xlb' and 'dialog.xlb' to
> '$HOME/.openoffice.org2/user/basic/Standard'
>
and, your case here.

> cd /usr/lib/openoffice/presets/basic
> cp dialog.xlc ~/.openoffice.org2/user/basic
> cd Standard
> cp dialog.xlb ~/.openoffice.org2/user/basic/Standard

It appears as though the files in question are "dialog.xlc" and
"script.xlc". I can get to these files in my system by either one of
these paths:

1) usr/lib/openoffice/basis3.1/presets/basic
2)| usr/lib64/openoffice/basis3.1/presets/basic

Does it matter which path I chose? Then, where do I copy these files
to? My system has no path $HOME/.openoffice.org2/user/basic OR
HOME/.openoffice.org2/user/basic/Standard.

I must mention that I updated to oo3.1 from oo3.0 through the repositories.

Are we on a correct path to a solution and I'm missing something, or
does anyone know of another solution to this persistent annoying problem?

Thank you,

M

Revision history for this message
Isak Frants (isakfrants) said :
#3

This fix is from the official manual, however for the 2.x version. This will work since this is a known problem. I just can't tell you right now the right paths since I'm at work sitting in Windows.

Many many people have had this problem if you search on Google. I didn't find anyone with 3.x release having this though.

Revision history for this message
Best Isak Frants (isakfrants) said :
#4

I found something!
Can you do this?
1. Go to: /usr/lib/openoffice/basis3.1/presets/basic
2. Do you see script.xlc and dialog.xlc ? Copy these into ~/.openoffice.org/3/user/basic/ . (Make backup of the files found here first)
By the way, "~/" is "/home/YOURNAME/". The dot "." before openoffice.org means that the folder is hidden and you have to press Ctrl H in Nautilus to see it.

3. Go to: /usr/lib/openoffice/basis3.1/presets/basic/Standard
4. Do you see script.xlb and dialog.xlb ? Copy these into ~/.openoffice.org/3/user/basic/Standard . (Make backup of the files found here first)

If you like to do it in a terminal:
First we make backup:
cp ~/.openoffice.org/3/user/basic/script.xlc ~/backup/basic/script.xlc
cp ~/.openoffice.org/3/user/basic/dialog.xlc ~/backup/basic/dialog.xlc
cp ~/.openoffice.org/3/user/basic/Standard/script.xlb ~/backup/basic/Standard/script.xlb
cp ~/.openoffice.org/3/user/basic/Standard/dialog.xlb ~/backup/basic/Standard/dialog.xlb

Then we replace the corrupted ones with proper stuff:
cd /usr/lib/openoffice/basis3.1/presets/basic
cp script.xlc ~/.openoffice.org/3/user/basic/script.xlc
cp dialog.xlc ~/.openoffice.org/3/user/basic/dialog.xlc
cd /usr/lib/openoffice/basis3.1/presets/basic/Standard
cp script.xlb ~/.openoffice.org/3/user/basic/Standard/script.xlb
cp dialog.xlb ~/.openoffice.org/3/user/basic/Standard/dialog.xlb

Revision history for this message
Myroslav (mgalan) said :
#5

Dear Isak,

Thank you very much for your time and patience for walking me through my problem.

In following your instructions (very clearly explained by the way), I noted that the file "dialog.xlb" was missing in my original "~/.openoffice.org/3/user/basic" path. This I think was the source of my problem. Now all goes well.

Thank you for solving my problem. I am grateful to you and to this helpful forum.

M

Revision history for this message
Isak Frants (isakfrants) said :
#6

Great!