Public bug reported: Binary package hint: openoffice.org
There are many formulas that can retrieve and process data from various cells and ranges etc. it would be better to have a macro that could do the same thing but I can not find any instruction how to do it. It would be clearer code and easier to document in visual basic. There does not seem to be adequate support for this. IT IS MUCH BETTER, EASIER, AND NEATER TO BE ABLE TO USE VISUAL BASIC. For example replace the formula =SUMPRODUCT(A2:A21="f",B2:B21="c",D2:D21*F2:F21) with VBA code to enter the same data into cell I4 and =SUMPRODUCT(A3:A22="m",B3:B22="p", D3:D22*F3:F22) into cell I5 etc. these are relatively simple formulas and I need to create more complex ones I will try to download this example sheet with this email. Thank you Ed Wahl, PhD ProblemType: Bug Architecture: i386 Date: Fri Jan 15 09:33:20 2010 DistroRelease: Ubuntu 9.10 NonfreeKernelModules: nvidia Package: openoffice.org-core 1:3.1.1-5ubuntu1 [modified: var/lib/openoffice/basis3.1/program/services.rdb] ProcEnviron: PATH=(custom, no user) LANG=en_US.UTF-8 SHELL=/bin/bash ProcVersionSignature: Ubuntu 2.6.31-17.54-generic SourcePackage: openoffice.org Uname: Linux 2.6.31-17-generic i686 ** Affects: openoffice.org (Ubuntu) Importance: Undecided Status: New ** Tags: apport-bug i386 -- how can i replace a formula with a macro https://bugs.launchpad.net/bugs/508036 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs