You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/04/02 17:46:09 UTC
[Issue 124581] New: opening a template using "ALWAYS_EXECUTE
_NO_WARN"
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: issues@openoffice.apache.org
Reporter: tbmechler@gmail.com
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.
[Issue 124581] opening a template using "ALWAYS_EXECUTE _NO_WARN"
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124581
--- Comment #5 from Edwin Sharp <el...@apache.org> ---
(In reply to mroe from comment #4)
> (In reply to Edwin Sharp from comment #3)
> > Please create a dummy price list.
>
> With "my" dummy price list all is working correct.
> But because there are no macros in the attached document (is?) what is the
> meaning of this issue?
Prices in the deer processing plant haven't changed so no need to update links.
Why is the unit price calculation failing?
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124581] opening a template using "ALWAYS_EXECUTE _NO_WARN"
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124581
--- Comment #3 from Edwin Sharp <el...@apache.org> ---
(In reply to mroe from comment #2)
> In all of the IF-statements the second parameter refers to the file
> "PRICE LIST SEASON 13-14.ods" which is not provided as attachment to this
> issue.
> So the problem is irreproducible at the moment.
>
> The cached values that been shown if the links are not updated at load of
> the document maybe right or maybe not.
Please create a dummy price list.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124581] opening a template using "ALWAYS_EXECUTE _NO_WARN"
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124581
--- Comment #8 from Edwin Sharp <el...@apache.org> ---
(In reply to tbmechler from comment #7)
> Ok i messed around with the spread sheet and re-typed "BREAKFAST, PATTY,
> SMOKED" the items that were not testing correctly. Stopped OO and restarted
> my computer. Don't really know which action fixed the problems but its
> working now?????
https://wiki.openoffice.org/wiki/QA/HowToFileIssue
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124581] opening a template using "ALWAYS_EXECUTE _NO_WARN"
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124581
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |elish@apache.org
Latest|--- |4.1-dev
Confirmation on| |
Hardware|Other |All
Ever confirmed|0 |1
OS|Windows XP |All
Severity|major |normal
--- Comment #1 from Edwin Sharp <el...@apache.org> ---
Confirmed with
AOO410m14(Build:9760) - Rev. 1582709
2014-03-30_04:11:07 - Rev. 1583103
Debian
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124581] opening a template using "ALWAYS_EXECUTE _NO_WARN"
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124581
--- Comment #4 from mroe <mr...@gmx.net> ---
(In reply to Edwin Sharp from comment #3)
> Please create a dummy price list.
With "my" dummy price list all is working correct.
But because there are no macros in the attached document (is?) what is the
meaning of this issue?
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124581] opening a template using "ALWAYS_EXECUTE _NO_WARN"
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124581
--- Comment #6 from mroe <mr...@gmx.net> ---
(In reply to Edwin Sharp from comment #5)
> Prices in the deer processing plant haven't changed so no need to update
> links.
If the prices was 0 (as cached) ...
> Why is the unit price calculation failing?
... there is no failing. And there are always no macros.
I wait for a clarification by the reporter. Everything else is speculation.
I do not and will not speculate!
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124581] opening a template using "ALWAYS_EXECUTE _NO_WARN"
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124581
mroe <mr...@gmx.net> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |needmoreinfo
Status|CONFIRMED |UNCONFIRMED
Ever confirmed|1 |0
--- Comment #2 from mroe <mr...@gmx.net> ---
=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;
" "))))
In all of the IF-statements the second parameter refers to the file
"PRICE LIST SEASON 13-14.ods" which is not provided as attachment to this
issue.
So the problem is irreproducible at the moment.
The cached values that been shown if the links are not updated at load of the
document maybe right or maybe not.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124581] opening a template using "ALWAYS_EXECUTE _NO_WARN"
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124581
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |IRREPRODUCIBLE
--- Comment #9 from Edwin Sharp <el...@apache.org> ---
Irreproducible per comment 7
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124581] opening a template using "ALWAYS_EXECUTE _NO_WARN"
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124581
--- Comment #7 from tbmechler <tb...@gmail.com> ---
Ok i messed around with the spread sheet and re-typed "BREAKFAST, PATTY,
SMOKED" the items that were not testing correctly. Stopped OO and restarted my
computer. Don't really know which action fixed the problems but its working
now?????
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.