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
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
