Personal Experiences ...

Thursday, August 6, 2020

Excel lot of buttons greyed out

For example, pretty much all in data tab is disabled and is non-clickable

Example:

Possible solution

See the file name on top. If you see Shared, this may give a clue on whats wrong

In this case,

Check Review tab, Protect Section and see if Unshare Workbook button is enabled. If yes, click on this, and voila, all editing is back allowed!

Monday, July 20, 2020

Jenkins: Disable default readonly dashboard for anonymous users

Jenkins =>

Configure Global Security =>
Authorization
Logged-in users can do anything

Allow anonymous read access ==> Uncheck this option

Thursday, July 2, 2020

Plain Javascript show hide section using plus and minus

Here is the code

<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1">
<style>
#myDIV {
  width: 100%;
  padding: 50px 0;
  text-align: center;
  background-color: lightblue;
  margin-top: 20px;
}
</style>
</head>
<body>


<span onclick="myFunction(this)">[-]</span>

<div id="myDIV">
This is my DIV element.
</div>

<p><b>Note:</b> The element will not take up any space when the display property set to "none".</p>

<script>
function myFunction(src) {
  var x = document.getElementById("myDIV");
  if (x.style.display === "none") {
    x.style.display = "block";
    src.innerText  = "[-]";
  } else {
    x.style.display = "none";
    src.innerText  = "[+]";
  }
}
</script>

</body>
</html>