Validation about “ignore blank” fails with delete, but works with backspace Announcing the...
How to compare two different files line by line in unix?
AppleTVs create a chatty alternate WiFi network
If Windows 7 doesn't support WSL, then what is "Subsystem for UNIX-based Applications"?
What's the point of the test set?
Electrolysis of water: Which equations to use? (IB Chem)
How does the math work when buying airline miles?
Converted a Scalar function to a TVF function for parallel execution-Still running in Serial mode
How were pictures turned from film to a big picture in a picture frame before digital scanning?
Lagrange four-squares theorem --- deterministic complexity
How does Belgium enforce obligatory attendance in elections?
Would it be easier to apply for a UK visa if there is a host family to sponsor for you in going there?
Why are vacuum tubes still used in amateur radios?
Crossing US/Canada Border for less than 24 hours
Does "shooting for effect" have contradictory meanings in different areas?
What is the chair depicted in Cesare Maccari's 1889 painting "Cicerone denuncia Catilina"?
Strange behavior of Object.defineProperty() in JavaScript
What is the difference between a "ranged attack" and a "ranged weapon attack"?
Central Vacuuming: Is it worth it, and how does it compare to normal vacuuming?
One-one communication
Why do early math courses focus on the cross sections of a cone and not on other 3D objects?
Project Euler #1 in C++
How to run automated tests after each commit?
Why are my pictures showing a dark band on one edge?
Dyck paths with extra diagonals from valleys (Laser construction)
Validation about “ignore blank” fails with delete, but works with backspace
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)date format excelIs there a way that the data value entered into cell F58 can be automatically added to the next empty cell in column F?Excel: Data Validation to make a cell requiredCreate Dependant Data Validation without Cell TablesExcel 2010: Blank pasted cells require activation causing formula issuesNon-macro solution to exclude non-blank empty strings from in-cell data validation listsHow to do Excel data validation on sum of multiple cells including empty cellsMicrosoft Excel - Restrict cell value to percentageData Validation Between 2 adjacent cells for all rowsHow To Apply Multiple Data Validation In One Cell In Excel Worksheet
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
- For a range of cells without empty cells (i.e: 1 to 7)
- For any cell such as A1, with the following settings about
Data Validation
Note observe the ignore blank checkbox, it is unmarked
And
I am able to create the Drop List and select any value from it. Until here all is ok.
- If in that cell I press the
backspacekey (deleting all the data) and thenenterkey is pressed I receive the expected error message
Until here all works how is expected
Problem
- I can select other value from the list, but if later the
deleteorsuprkey is used, deleting all the data, andenterkey is pressed the cell pass to be empty, thus the validation has failed. No error message arises. I can confirm through other cell and using thelenfunction it shows0, and in other cell using thecountblankshows1thus is empty.
Why the validation works how is expected with the cell without data throughbackspaceand not throughdelete/supr?
How can I fix this situation?
Note: just in case, this situation exists even if in-cell dropdown is unmarked
microsoft-excel microsoft-excel-2013
asked 6 hours ago
Manuel JordanManuel Jordan
101
New contributor
Manuel Jordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
- For a range of cells without empty cells (i.e: 1 to 7)
- For any cell such as A1, with the following settings about
Data Validation
Note observe the ignore blank checkbox, it is unmarked
And
I am able to create the Drop List and select any value from it. Until here all is ok.
- If in that cell I press the
backspacekey (deleting all the data) and thenenterkey is pressed I receive the expected error message
Until here all works how is expected
Problem
- I can select other value from the list, but if later the
deleteorsuprkey is used, deleting all the data, andenterkey is pressed the cell pass to be empty, thus the validation has failed. No error message arises. I can confirm through other cell and using thelenfunction it shows0, and in other cell using thecountblankshows1thus is empty.
Why the validation works how is expected with the cell without data throughbackspaceand not throughdelete/supr?
How can I fix this situation?
Note: just in case, this situation exists even if in-cell dropdown is unmarked
microsoft-excel microsoft-excel-2013
asked 6 hours ago
Manuel JordanManuel Jordan
101
New contributor
Manuel Jordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
- For a range of cells without empty cells (i.e: 1 to 7)
- For any cell such as A1, with the following settings about
Data Validation
Note observe the ignore blank checkbox, it is unmarked
And
I am able to create the Drop List and select any value from it. Until here all is ok.
- If in that cell I press the
backspacekey (deleting all the data) and thenenterkey is pressed I receive the expected error message
Until here all works how is expected
Problem
- I can select other value from the list, but if later the
deleteorsuprkey is used, deleting all the data, andenterkey is pressed the cell pass to be empty, thus the validation has failed. No error message arises. I can confirm through other cell and using thelenfunction it shows0, and in other cell using thecountblankshows1thus is empty.
Why the validation works how is expected with the cell without data throughbackspaceand not throughdelete/supr?
How can I fix this situation?
Note: just in case, this situation exists even if in-cell dropdown is unmarked
microsoft-excel microsoft-excel-2013
asked 6 hours ago
Manuel JordanManuel Jordan
101
New contributor
Manuel Jordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
- For a range of cells without empty cells (i.e: 1 to 7)
- For any cell such as A1, with the following settings about
Data Validation
Note observe the ignore blank checkbox, it is unmarked
And
I am able to create the Drop List and select any value from it. Until here all is ok.
- If in that cell I press the
backspacekey (deleting all the data) and thenenterkey is pressed I receive the expected error message
Until here all works how is expected
Problem
- I can select other value from the list, but if later the
deleteorsuprkey is used, deleting all the data, andenterkey is pressed the cell pass to be empty, thus the validation has failed. No error message arises. I can confirm through other cell and using thelenfunction it shows0, and in other cell using thecountblankshows1thus is empty.
Why the validation works how is expected with the cell without data throughbackspaceand not throughdelete/supr?
How can I fix this situation?
Note: just in case, this situation exists even if in-cell dropdown is unmarked
microsoft-excel microsoft-excel-2013
microsoft-excel microsoft-excel-2013
asked 6 hours ago
Manuel JordanManuel Jordan
101
New contributor
Manuel Jordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 6 hours ago
Manuel JordanManuel Jordan
101
New contributor
Manuel Jordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 6 hours ago
Manuel JordanManuel Jordan
101
New contributor
Manuel Jordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 6 hours ago
Manuel JordanManuel Jordan
101
asked 6 hours ago
Manuel JordanManuel Jordan
101
101
New contributor
Manuel Jordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Manuel Jordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Manuel Jordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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
});
}
});
Manuel Jordan is a new contributor. Be nice, and check out our Code of Conduct.
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%2fsuperuser.com%2fquestions%2f1427460%2fvalidation-about-ignore-blank-fails-with-delete-but-works-with-backspace%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Manuel Jordan is a new contributor. Be nice, and check out our Code of Conduct.
Manuel Jordan is a new contributor. Be nice, and check out our Code of Conduct.
Manuel Jordan is a new contributor. Be nice, and check out our Code of Conduct.
Manuel Jordan is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1427460%2fvalidation-about-ignore-blank-fails-with-delete-but-works-with-backspace%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
