Missing VBA functions
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenOffice |
Fix Released
|
High
|
|||
libreoffice (Ubuntu) |
Invalid
|
Undecided
|
Unassigned | ||
Natty |
Invalid
|
Undecided
|
Unassigned | ||
openoffice.org (Ubuntu) |
Won't Fix
|
Undecided
|
Unassigned | ||
Natty |
Won't Fix
|
Undecided
|
Unassigned |
Bug Description
A few days ago I upgraded to Ubuntu 10.04. I wish I hadn't! I have now discovered that vba macros in Open Office Calc have stopped working.
To enable VBA in OO, I had included the command
From: https:/
VBASupport 1
This worked OK in earlier versions. I have also checked
Tools > Options > Load/Save > VBA properties
and everything is ticked
As an example of the error I am getting
a=Worksheets(
gives an error “Basic runtime error. '35' Worksheets”
I have searched the web, and I believe Ubuntu 10.04 includes Go-OO, which should have VBA support. I have installed Go-OO as per the Go-OO site instructions.
Changed in openoffice.org (Ubuntu): | |
status: | Incomplete → Confirmed |
Changed in openoffice: | |
status: | Unknown → Fix Released |
Changed in openoffice.org (Ubuntu): | |
status: | Confirmed → Triaged |
Changed in openoffice: | |
importance: | Unknown → High |
Changed in openoffice.org (Ubuntu): | |
status: | Triaged → Won't Fix |
[This is an automatic notification.]
Thank you for taking the time to report this bug and helping to make Ubuntu better. Please execute the following command, as it will automatically gather debugging information, in a terminal:
apport-collect -p openoffice.org-core 585867
This will help us to find and resolve the problem. Bear in mind that you may need to install the python-launchpadlib package from the universe repository. Additionally, when prompted to give apport-collect permissions for Launchpad you will need to give it at least the ability to "Change Non-Private" data as it will be adding information to your bug report. Thanks in advance!
When reporting bugs in the future please use apport, either via the appropriate application's "Help -> Report a Problem" menu or using 'ubuntu-bug' and the name of the package affected. You can learn more about this functionality at https:/ /wiki.ubuntu. com/ReportingBu gs.
ubuntu-bug openoffice.org-core
Please do not set bugs back to 'New' after adding this information.