← Back to team overview

desktop-packages team mailing list archive

[Bug 585867] Re: Missing VBA functions

 

Francis, this bug report is being closed due to your last comment
regarding this being fixed with an update to LibreOffice. For future
reference you can manage the status of your own bugs by clicking on the
current status in the yellow line and then choosing a new status in the
revealed drop down box. You can learn more about bug statuses at
https://wiki.ubuntu.com/Bugs/Status. Thank you again for taking the time
to report this bug and helping to make Ubuntu better. Please submit any
future bugs you may find.

** Summary changed:

- [Upstream] Missing VBA functions in OOo
+ Missing VBA functions

** Changed in: openoffice.org (Ubuntu Natty)
       Status: Triaged => Won't Fix

** Changed in: libreoffice (Ubuntu)
       Status: Incomplete => Invalid

** Changed in: libreoffice (Ubuntu Natty)
       Status: New => Invalid

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/585867

Title:
  Missing VBA functions

Status in The OpenOffice.org Suite:
  Fix Released
Status in “libreoffice” package in Ubuntu:
  Invalid
Status in “openoffice.org” package in Ubuntu:
  Won't Fix
Status in “libreoffice” source package in Natty:
  Invalid
Status in “openoffice.org” source package in Natty:
  Won't Fix

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://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/110663 : I have the same problem since upgrade to lucid.

  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("Sheet1").Cells(Row,1)

  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.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openoffice/+bug/585867/+subscriptions