Issue 37155 - Impossible to create a working macro containing a goal seek feature
Summary: Impossible to create a working macro containing a goal seek feature
Status: CLOSED DUPLICATE of issue 20046
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 1.1.3
Hardware: All Windows XP
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: joerg.skottke
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-11-15 09:41 UTC by ruggerop
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
r (6.85 KB, text/txt)
2004-11-15 09:43 UTC, ruggerop 		no flags Details
Operands in B1 and B2. B3 contains the formula (B3=B1*B2). A macro has been created that invokes goalseekr to calculate the exact value of B1 so that B3 is 15 (any value reproduces the defect, anyway) (6.85 KB, text/txt)
2004-11-15 09:44 UTC, ruggerop 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description ruggerop 2004-11-15 09:41:34 UTC 
Create a spreadsheet with the two operands in cell B1 and B2 and a formula in
cell B3 (eg B3=B1*B2).
Creating a macro that invokes the goal seeker to calculate the value of cell B1,
given the value of B2 so that B3 is equal to a given number yields to a non
working macro.
Comment 1 ruggerop 2004-11-15 09:43:02 UTC 
Created attachment 19294 [details]
r
Comment 2 ruggerop 2004-11-15 09:44:42 UTC 
Created attachment 19295 [details]
Operands in B1 and B2. B3 contains the formula (B3=B1*B2). A macro has been created that invokes goalseekr to calculate the exact value of B1 so that B3 is 15 (any value reproduces the defect, anyway)
Comment 3 frank 2004-12-02 12:04:04 UTC 
Hi Joerg,

please have a look at this one.

Frank
Comment 4 joerg.skottke 2005-01-14 13:41:21 UTC 
I prefer to send this to NN because i can hardly determine what is expected to
work and what not. Since the macro has been created with the macro recorder, i
do not believe this can be fixed in a reasonable timeframe. 

According to the OpenOffice.org PCD i confirm the issue but leave the target of
"OOo Later", set it dupe to issue #20046

*** This issue has been marked as a duplicate of 20046 ***
Comment 5 joerg.skottke 2005-01-14 13:42:20 UTC 
close