https://issues.apache.org/ooo/show_bug.cgi?id=124581
Issue ID: 124581
Issue Type: DEFECT
Summary: opening a template using "ALWAYS_EXECUTE _NO_WARN"
Product: Calc
Version: 4.0.1
Hardware: Other
OS: Windows XP
Status: UNCONFIRMED
Severity: major
Priority: P3
Component: programming
Assignee: [email protected]
Reporter: [email protected]
Created attachment 83063
--> https://issues.apache.org/ooo/attachment.cgi?id=83063&action=edit
the spread sheet is used to place orders for a deer processing plant
I have a workbook set up with a sheet that has a cell that uses a dropdown list
of 4 choices. I then test the cell for contents and assign a dollar value in
another cell depending on the choice that was made. The resultiong value is
selected from another spreadsheet. When I manually approve macro execution the
test works fine.
To make things a bit easier for my users, I set up a macro that I use to close
the file with a name derived from various cells (works fine). Next the macro
opens a fresh copy of the template and I use the MacroExecuteMode constant
"ALWAYS_EXECUTE_NO_WARN" to allow the macros in the spreadsheet to run. Here's
when the problems occurs.
The test of the four valid entries only puts the correct dollar value in the
associated cell when testing for "LINK" second entry in the list. If I select
any of the other three (selection BREAKFAST,PATTY,SMOKED) the corresponding
dollar value results in a 0. Here is the test I use to evaluate the 4 choices
and select the appropriate value from a workbook that contains the associated
dollar amounts.
=IF(D19="BREAKFAST";'file:///C:/Users/tbmechler/Documents/2014-15 PLP
SEASON/PRICE LIST SEASON 13-14.ods'#$'Price
List'.$B$10;IF(D19="LINK";'file:///C:/Users/tbmechler/Documents/2014-15 PLP
SEASON/PRICE LIST SEASON 13-14.ods'#$'Price
List'.$B$11;IF(D19="PATTY";'file:///C:/Users/tbmechler/Documents/2014-15 PLP
SEASON/PRICE LIST SEASON 13-14.ods'#$'Price
List'.$B$12;IF(D19="SMOKED";'file:///C:/Users/tbmechler/Documents/2014-15 PLP
SEASON/PRICE LIST SEASON 13-14.ods'#$'Price List'.$B$13;" "))))
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
