← Back to team overview

desktop-packages team mailing list archive

[Bug 585867] Re: [Upstream] Missing VBA functions in OOo

 

Hello,

I confirm that LibreOffice PPA solved this issue.

-- 
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:
  [Upstream] Missing VBA functions in OOo

Status in The OpenOffice.org Suite:
  Fix Released
Status in “libreoffice” package in Ubuntu:
  Incomplete
Status in “openoffice.org” package in Ubuntu:
  Triaged
Status in “libreoffice” source package in Natty:
  New
Status in “openoffice.org” source package in Natty:
  Triaged

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