Base toolbars not showing up

[Jesse Avilés]

1) lsb_release -rd
Description: Ubuntu 10.04.3 LTS
Release: 10.04

2) apt-cache policy libreoffice-base:
libreoffice-base:
  Installed: 1:3.3.2-1ubuntu2~lucid1
  Candidate: 1:3.3.2-1ubuntu2~lucid1
  Version table:
 *** 1:3.3.2-1ubuntu2~lucid1 0
        500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ lucid/main Packages
        100 /var/lib/dpkg/status

apt-cache policy openjdk-6-jre:
openjdk-6-jre:
  Installed: 6b20-1.9.10-0ubuntu1~10.04.2
  Candidate: 6b20-1.9.10-0ubuntu1~10.04.2
  Version table:
 *** 6b20-1.9.10-0ubuntu1~10.04.2 0
        500 http://pr.archive.ubuntu.com/ubuntu/ lucid-updates/main Packages
        500 http://security.ubuntu.com/ubuntu/ lucid-security/main Packages
        100 /var/lib/dpkg/status
     6b18-1.8-0ubuntu1 0
        500 http://pr.archive.ubuntu.com/ubuntu/ lucid/main Packages

3) What is expected to happen in LibreOffice Base via the Terminal:

cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/912734/+attachment/2668874/+files/EMS.odb && lobase -nologo EMS.dob

secondary click frmEvaluation -> Edit -> View -> Toolbars -> Form Design and the Form Design toolbar shows up.

4) What happens instead is no toolbar shows up, nor is a checkbox shown next to View -> Toolbars -> Form Design. This is demonstrated in the video https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/912734/+attachment/2668904/+files/lo_base_error.ogv .

[penalvch (penalvch)]

Thank you for reporting this bug and helping make Ubuntu better. The LibreOffice 3.3.x branch is no longer supported by upstream http://wiki.documentfoundation.org/ReleasePlan#3.3_release .
LibreOffice Productivity Suite → Invalid
As well, your crash report is missing. Please follow these instructions to have apport create a crash file. One may execute at the Terminal:
sudo service apport start force_start=1

If you are running the Ubuntu Stable Release you might need to enable apport in /etc/default/apport and restart.

Now open your file manager, navigate to your /var/crash directory and attach to this bug the crash report you wish to submit.
Thanks in advance for your cooperation and understanding.

[Jesse Avilés (notbitmonk)]

Turned on apport but I was not able to duplicate the crash and get a crash report. The error did occur as I was not able to run the report (reported same error as above). Although you mention that LibreOffice (version above) is no longer supported, the version I have is the latest Ubuntu supports following their procedures to use the LibreOffice PPA for 10.04 (https://launchpad.net/~libreoffice/+archive/ppa). I will continue developing the database and report back here.

[penalvch (penalvch)]

notbitmonk (jesseaviles), please answer the following questions:

+ regarding your comments:

> Turned on apport but I was not able to duplicate the crash and get a crash report. The error did occur as I was not able to run the report (reported same error as above).

Ok, then this bug will focus only on the non-crash problem previously noted.

+ Regarding the Java Sun Microsystems, Inc. version 1.6.0_20 you noted is installed, is this something downloaded from Oracle directly? If so, this bug will be marked Invalid in Ubuntu as it is not from a Ubuntu repository.

In order for this bug not to be invalidated in Ubuntu, you would need to upgrade Java to the following supported Java, then try to reproduce the problem:
https://launchpad.net/ubuntu/+source/openjdk-6 -> 6b20-1.9.10-0ubuntu1~10.04.2

openjdk-6 is recommend as sun-java6 is being phased out in Ubuntu and will stop being supported: https://lists.ubuntu.com/archives/ubuntu-security-announce/2011-December/001528.html

[Jesse Avilés (notbitmonk)]

I think that even when it says Sun Java, it is using the openjdk. The location of the Java used by LibreOffice is reported as /usr/lib/jvm/jave-6-openjdk/jre. After checking the Software Center, the only java installed packages in my computer are the openjdk java. A file search for the term "openjdk" shows only the same location mentioned above. I guess I am on the clear. :-)

[penalvch (penalvch)]

notbitmonk (jesseaviles), could you please attach the following to this bug report:

+ the results of the following from the Terminal:
apt-cache policy openjdk-6-jre

+ the results of the following from the Terminal:
apt-cache policy libreoffice-base

+ an example Base document that this problem is reproducible in?

[Jesse Avilés (notbitmonk)]

Results from apt-cache policy openjdk-6-jre:
openjdk-6-jre:
  Installed: 6b20-1.9.10-0ubuntu1~10.04.2
  Candidate: 6b20-1.9.10-0ubuntu1~10.04.2
  Version table:
 *** 6b20-1.9.10-0ubuntu1~10.04.2 0
        500 http://pr.archive.ubuntu.com/ubuntu/ lucid-updates/main Packages
        500 http://security.ubuntu.com/ubuntu/ lucid-security/main Packages
        100 /var/lib/dpkg/status
     6b18-1.8-0ubuntu1 0
        500 http://pr.archive.ubuntu.com/ubuntu/ lucid/main Packages

Results from apt-cache policy libreoffice-base:
libreoffice-base:
  Installed: 1:3.3.2-1ubuntu2~lucid1
  Candidate: 1:3.3.2-1ubuntu2~lucid1
  Version table:
 *** 1:3.3.2-1ubuntu2~lucid1 0
        500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ lucid/main Packages
        100 /var/lib/dpkg/status

Attached is the database that I created.

[penalvch (penalvch)]

Jesse Avilés (notbitmonk), this issue is unreproducible using the provided file. Regarding your comments:

> Created a form with the wizards. I noticed some things that I wanted to change so I opened up the form in design mode. At this point is where the problem arose. The toolbars are not showing up. I went to View --> Toolbars to select the form toolbars and nothing happens after I click on them. Opening tables show the total record count at the bottom but the number is wrong. I have a table with 129 records. The record count showed only 16. I had to navigate to the last record to have the correct number show up. This was a slow operation too. I went then to prepare a simple report to see if the problem of the toolbar and speed showed up. Tried the wizard which went good until it tried to show the report. It threw an error.

We need a specific, detailed, click-by-click that reproduces the problem in order to continue. Could you please produce this?

cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/912734/+attachment/2668692/+files/EMS.odb && lobase -nologo EMS.odb

apt-cache policy libreoffice-base
libreoffice-base:
  Installed: 1:3.4.4-0ubuntu1
  Candidate: 1:3.4.4-0ubuntu1
  Version table:
 *** 1:3.4.4-0ubuntu1 0
        500 http://us.archive.ubuntu.com/ubuntu/ oneiric-updates/main i386 Packages
        100 /var/lib/dpkg/status
     1:3.4.3-3ubuntu2 0
        500 http://us.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages

[Jesse Avilés (notbitmonk)]

The file that I supplied did not have the form. I am attaching it now. I remember that one of the previous Ubuntu versions shrink/hid the rulers of Inkscape. This bug reminds me of that. When the wizard is creating the form, I can see that the toolbars appear in the background. I will use Istanbul to create a desktop video to show what I see. I used a 10.04.3 LiveCD to see if the problem existed in the default version of OpenOffice. The form toolbars showed up but the report did not execute. It threw an error of not having the report builder extension. I installed the extension but even then it did not work. The jre was the same.

[Jesse Avilés (notbitmonk)]

Ended up using VLC as Istanbul froze. It started but did not want to stop. Attached is the video of what happens.

[penalvch (penalvch)]

Jesse Avilés (notbitmonk), as you mentioned multiple, potential bugs in your bug description, this bug will focus on the first one noted:

> Created a form with the wizards. I noticed some things that I wanted to change so I opened up the form in design mode. At this point is where the problem arose. The toolbars are not showing up. I went to View --> Toolbars to select the form toolbars and nothing happens after I click on them.

In the future, please keep one bug per report. Thank you for your understanding.

[Jesse Avilés (notbitmonk)]

No problem. Was the screencast enough to show what the problem was? I understand that the other bug is the one related to the report, am I right? If I am, I will open a new bug and have a link to this bug report so as to not add duplicate attachments to the server (to lower our environmental footprint ;-)

[penalvch (penalvch)]

Jesse Avilés, the information provided was enough to reproduce the problem in the modified Bug Description. However, I am closing this bug because the bug has been fixed in the latest testable version of Ubuntu - Oneiric Ocelot.

This is a significant bug in Ubuntu. If you need a fix for the bug in previous versions of Ubuntu, please do steps 1 and 2 of the SRU Procedure [1] to bring the need to a developer's attention.

[1]: https://wiki.ubuntu.com/StableReleaseUpdates#Procedure

lsb_release -rd
Description: Ubuntu 11.10
Release: 11.10

apt-cache policy libreoffice-base
libreoffice-base:
  Installed: 1:3.4.4-0ubuntu1
  Candidate: 1:3.4.4-0ubuntu1
  Version table:
 *** 1:3.4.4-0ubuntu1 0
        500 http://us.archive.ubuntu.com/ubuntu/ oneiric-updates/main i386 Packages
        100 /var/lib/dpkg/status
     1:3.4.3-3ubuntu2 0
        500 http://us.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages

apt-cache policy openjdk-6-jre
openjdk-6-jre:
  Installed: 6b23~pre11-0ubuntu1.11.10
  Candidate: 6b23~pre11-0ubuntu1.11.10
  Version table:
 *** 6b23~pre11-0ubuntu1.11.10 0
        500 http://us.archive.ubuntu.com/ubuntu/ oneiric-updates/main i386 Packages
        500 http://security.ubuntu.com/ubuntu/ oneiric-security/main i386 Packages
        100 /var/lib/dpkg/status
     6b23~pre10-0ubuntu5 0
        500 http://us.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages