Monday, February 26, 2018

M$ Excel Apply Data Validation Using Custom Formula

If you wanted a whole number between known limits, easy... What if it has a fractional part? Why can't the *ds at M$ provide for this case as well?

How are you supposed to know you need an "=" at the beginning? Good q! *ds!


Thursday, February 22, 2018

Quincy Larson > Mario Hoyos : Super Time Saver - If Only I Had Known..

https://medium.freecodecamp.org/tools-i-wish-i-had-known-about-when-i-started-coding-57849efd9248

Chrome extensions : WhatFont, Pesticide, Colorzilla, CSS Peeper, Wappalyzer, React Dev, Redux Dev, JSON Formatter, Vimeo Repeat and Speed (speed up Vimeo videos).

Visual Studio Code extension : Auto Rename Tag, HTML CSS Support, HTML Snippets (use with Emmet), Babel ES6/ES7, Bracket Pair Colorizer, ESLint, Guides, JS Console Utils, Code Spell Checker, Git Lens, Path Intellisense, Prettier (automatic code formatter), VSCode-Icons

The classic line : as a self-proclaimed Web Dev, I practically live in my Chrome Console :)

Monday, February 19, 2018

The Uselessness of Microsoft Excel

How can such a simple feature be missing from such a key product?

I want to search for "form" and not find "information". That is, I want to "match entire word".

Why? Why? Why?

Please, developer, developer, developer, developer, developer,.... *ds!

Saturday, February 03, 2018

Beating a Bad Web Page

As in a page whose user experience could be better :

https://www.thefreedictionary.com/words-that-start-with-wit

What, specifically? Scroll down, and you now have to scroll back up to get back to the text field. Wouldn't it be nice if that entry field was always within view no matter where in the page you went?

Enter frames - the poor man's solution :)

I want to have one frame with a text box where I can enter the prefix, and hit Go and load the result in the frame on the right. Doesn't work! Why? What's special about this website? The page sort of loads up - partially... They tell you, something's wrong..

Fortunately, I have a solution that works okay if I say open in new tab. Other, less useful pages work fine, but thefreedictionary does not.. Go figure..

I feel like I've arrived as a webeloper with that hack that selects the text in the field when you click on it :)

For your index.html :

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<frameset cols="20%,80%">
<frame name="left" src="input.html" />
<frame id="right" name="right" src="http://www.wordfind.com/starts-with/tru/" />
</frameset>
</html>

And for the input.html :

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<script type="text/javascript">
function process()
{
  var seturl="https://www.thefreedictionary.com/words-that-start-with-" + document.getElementById("url").value;
  window.open( seturl, '_blank');
  return false;
}
</script>
  <form  onSubmit="return process();" >
Prefix: <input onClick="this.select();" type="text" name="url" id="url"> <input type="submit" value="go">
  </form>
</body>
</html>


And, you guessed it. With my OCD, I want more - the text input field is way too small - you want to be able to click anywhere - a bigger target boosts productivity :) So, :

<input onClick="this.select();" type="text" style="height:200px; font-size:30px;" name="url" id="url">

Helps big time!!

At the end - the frames part didn't really help - in fact, it only hurts  - coz we're not using it at all..
Meaning? Use just the input.html and you'll be fine - use that for your bookmark. Now, if you have OCD like me, you want to get the focus in the input field, with the text selected when you activate the tab that this page is in.. For starters, when the page loads, you want the cursor in the text field :) And then, anytime you "return" to this tab, you want to focus in the text field, and you want all the text selected so you can replace it..

<html>
<head>
 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<script type="text/javascript">
function process()
{
  var seturl="https://www.thefreedictionary.com/words-that-start-with-" + document.getElementById("url").value;
  window.open( seturl, '_blank');
  return false;
}

function onFocus(){
 document.getElementById("url").select();
};
// http://www.thefutureoftheweb.com/demo/2007-05-16-detect-browser-window-focus/
window.onfocus = onFocus;

</script>
  <form  id="wform" onSubmit="return process();" >
Prefix: <input onClick="this.select();" type="text" autofocus="autofocus" style="height:200px; font-size:30px;" name="url" id="url">
  </form>
</body>
</html>

Still Pulling it Off Though Age Piles Up

once in a while :)