Mixing
Winforms and VSTO Excel ShowDialog() partly modal
The strangest thing ever!
I'm working on an Excel add-in, the ribbon has some buttons that pop some modal dialogs. all of those dialogs are initiated in the same way from the button click event in the ribbon:
SampleForm sample = new SampleForm();
sample.ShowDialog();
so far everything works great - when the modal form appears I can't change cells selection and click the ribbon until the form is closed.
except for one form.
when showing this form only the upper part of excel isn't active (i.e. not responding to mouse clicks) but I still can select cells in the worksheet. plus, I can't hear the beep sounds when the modal open and I click on the ribbon items - as I hear when the other modal windows open.
when this bad form is open I can see that this.modal = true plus since the ribbon clicks are disabled (without making a sound) it's actually partly modal.
My questions are:
does it sound familiar? where to look for an answer? what can be the cause for that behavior?
c# winforms vsto excel-addins winforms-interop
asked Nov 21 '18 at 16:34
yossicoyossico
1,90532959
add a comment |
The strangest thing ever!
I'm working on an Excel add-in, the ribbon has some buttons that pop some modal dialogs. all of those dialogs are initiated in the same way from the button click event in the ribbon:
SampleForm sample = new SampleForm();
sample.ShowDialog();
so far everything works great - when the modal form appears I can't change cells selection and click the ribbon until the form is closed.
except for one form.
when showing this form only the upper part of excel isn't active (i.e. not responding to mouse clicks) but I still can select cells in the worksheet. plus, I can't hear the beep sounds when the modal open and I click on the ribbon items - as I hear when the other modal windows open.
when this bad form is open I can see that this.modal = true plus since the ribbon clicks are disabled (without making a sound) it's actually partly modal.
My questions are:
does it sound familiar? where to look for an answer? what can be the cause for that behavior?
c# winforms vsto excel-addins winforms-interop
asked Nov 21 '18 at 16:34
yossicoyossico
1,90532959
add a comment |
The strangest thing ever!
I'm working on an Excel add-in, the ribbon has some buttons that pop some modal dialogs. all of those dialogs are initiated in the same way from the button click event in the ribbon:
SampleForm sample = new SampleForm();
sample.ShowDialog();
so far everything works great - when the modal form appears I can't change cells selection and click the ribbon until the form is closed.
except for one form.
when showing this form only the upper part of excel isn't active (i.e. not responding to mouse clicks) but I still can select cells in the worksheet. plus, I can't hear the beep sounds when the modal open and I click on the ribbon items - as I hear when the other modal windows open.
when this bad form is open I can see that this.modal = true plus since the ribbon clicks are disabled (without making a sound) it's actually partly modal.
My questions are:
does it sound familiar? where to look for an answer? what can be the cause for that behavior?
c# winforms vsto excel-addins winforms-interop
asked Nov 21 '18 at 16:34
yossicoyossico
1,90532959
The strangest thing ever!
I'm working on an Excel add-in, the ribbon has some buttons that pop some modal dialogs. all of those dialogs are initiated in the same way from the button click event in the ribbon:
SampleForm sample = new SampleForm();
sample.ShowDialog();
so far everything works great - when the modal form appears I can't change cells selection and click the ribbon until the form is closed.
except for one form.
when showing this form only the upper part of excel isn't active (i.e. not responding to mouse clicks) but I still can select cells in the worksheet. plus, I can't hear the beep sounds when the modal open and I click on the ribbon items - as I hear when the other modal windows open.
when this bad form is open I can see that this.modal = true plus since the ribbon clicks are disabled (without making a sound) it's actually partly modal.
My questions are:
does it sound familiar? where to look for an answer? what can be the cause for that behavior?
c# winforms vsto excel-addins winforms-interop
c# winforms vsto excel-addins winforms-interop
asked Nov 21 '18 at 16:34
yossicoyossico
1,90532959
asked Nov 21 '18 at 16:34
yossicoyossico
1,90532959
edited Nov 21 '18 at 19:27
yossico
asked Nov 21 '18 at 16:34
yossicoyossico
1,90532959
asked Nov 21 '18 at 16:34
yossicoyossico
1,90532959
asked Nov 21 '18 at 16:34
yossicoyossico
1,90532959
1,90532959
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
What made the modal window to become partly modal is changing the cursor state of excel.
excelApp.Cursor = XlMousePointer.xlWait;
Removing this call fixed the issue
answered Nov 25 '18 at 12:03
yossicoyossico
1,90532959
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53416635%2fwinforms-and-vsto-excel-showdialog-partly-modal%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
What made the modal window to become partly modal is changing the cursor state of excel.
excelApp.Cursor = XlMousePointer.xlWait;
Removing this call fixed the issue
answered Nov 25 '18 at 12:03
yossicoyossico
1,90532959
add a comment |
What made the modal window to become partly modal is changing the cursor state of excel.
excelApp.Cursor = XlMousePointer.xlWait;
Removing this call fixed the issue
answered Nov 25 '18 at 12:03
yossicoyossico
1,90532959
add a comment |
What made the modal window to become partly modal is changing the cursor state of excel.
excelApp.Cursor = XlMousePointer.xlWait;
Removing this call fixed the issue
answered Nov 25 '18 at 12:03
yossicoyossico
1,90532959
What made the modal window to become partly modal is changing the cursor state of excel.
excelApp.Cursor = XlMousePointer.xlWait;
Removing this call fixed the issue
answered Nov 25 '18 at 12:03
yossicoyossico
1,90532959
answered Nov 25 '18 at 12:03
yossicoyossico
1,90532959
answered Nov 25 '18 at 12:03
yossicoyossico
1,90532959
answered Nov 25 '18 at 12:03
yossicoyossico
1,90532959
1,90532959
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53416635%2fwinforms-and-vsto-excel-showdialog-partly-modal%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
