desktop-packages team mailing list archive

["Christopher M. Penalver" <christopher.penalver@xxxxxxx>]

Francis, could you please attach a file that demonstrates this problem?
Does LibreOffice Calc work for you? If using Lucid or Maverick feel free
to perform at the Terminal:

sudo add-apt-repository ppa:libreoffice/ppa && sudo apt-get update &&
sudo apt-get -y upgrade && sudo apt-get -y install libreoffice-calc

** Also affects: libreoffice (Ubuntu)
   Importance: Undecided
       Status: New

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

** Summary changed:

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

-- 
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