Lorthas's questions

This is a pretty simplified example of what I'm doing regarding the number of cells involved. In Excel I have a name "Cells1" which contains:

=(B1;B3;B4)

I want to loop through this array constant with VBA. I have tried the following:

Sub Vaciar_nombres()
    Dim R1() As Range

    REM En la siguiente linea me salta error.
    R1 = hoja_de_pruebas.Names("Celdas1").RefersTo

    Debug.Print (VarType(R1))
End Sub

I haven't worked with array constants let alone using them with VBA. How can I take an array constant to later go through the ranges that are in that array using VBA? (I already know the loops)

After manually installing a new version of Wordpress, more specifically 4.7.5 coming from 4.3.3, a plugin like Yaost SEO or the All In One SEO Pack causes the page not to load directly and remains blank. It does not even enter the administrator menu and I am forced to delete those plugins via FTP.

I have been removing and putting the rest of the plugins by hand and I have come to the conclusion that these two plugins (testing both separately) give problems.

I have followed the recommended update procedure and this afternoon the page was working fine and tonight I looked and it was already working strangely. One of the pages where I had a form made with Form Maker directly did not show the text or the form.

How delicate is this to update Wordpress? I wanted to include version 4.7.5 since I had plugins that didn't make it to the latest version 4.8 but I see that I may have to go back to the previous version.

Version data:

• PHP 5.3
• MYSQL 5.6
• Wordpress 4.3.11(Old) (4.7.5 new version fails)

After retesting I have verified that on a page where I have a form made with Form Maker, this is not displayed nor is the text when entering the page as a normal guest, but as an administrator the content of that page appears even if I have it in public. Yoast SEO plugins or All In One SEO Pack when installed makes the admin page look blank and I think the page in general too, but resetting to the previous version of Wordpress seems to work fine again. Does this have something to do with the version of PHP or mysql? Would you recommend updating wordpress?
Since my old version (4.3.11) seems a bit outdated and new versions could bring interesting things.

As saving variables globally is not recommended, how could I save values ​​in variables that are persistently maintained when loading the same page several times or when going to other pages and that the variable is not deleted?

For example, I store a private variable inside a module where I want to save or cache some values ​​to have them later available.

            const mod = (function() {

                let privada = "foo";

                return {
                    v: "hola",
                    f: () => {
                        console.log(mod.v);
                        console.log(privada);
                        v = "mundo";
                        privada = "bar";
                    }
                };

            }());

            mod.f();

It's a pretty simple example but when reloading the page the variable has been re-initialized.

What would be the best way to be able to save variables in a private and persistent way, if possible? If it can't be done privately at least let me save it persistently?

Good. She thought she understood it but I don't quite understand it. He wanted to more or less replicate a static Java variable or method, that without having to instantiate an object he could use static methods.

I have several problems:

If I do it like this:

const Obj = (function() {
     let _obj = function() {}           
     _obj.prototype.alertar = function(){
         alert("Hola mundo");
     }
     return _obj;
});

It is a method that is shared with all instances but you would have to instantiate the object to be able to use it as I have tested.

const o1 = new Obj();
o1.alertar();

If I do it another way:

const Obj = (function() {

    let _obj = function() {}
        _obj.alertar = function(){alert("Hola mundo");};
        return _obj;
})();

const o1 = new Obj();
Obj.alertar();
console.dir(Obj);

It would be the closest thing to Java, right? I don't need to create an instance and the method wouldn't be inherited to children, right?

Apart from being interested in a method or variable that cannot be overridden, without affecting other variables and methods, could I use Object.defineProperty() to make variables and methods static that cannot be overloaded without having to use Object.freeze( ), Object.seal() or Object.preventExtensions()?

I know Ecmascript6 is being used but I use the old syntax to create objects without "class" because it helps me better understand how the language works. In addition, according to what I read, the new syntax is nothing more than a mask that basically does the same thing as the old syntax and it does not seem that certain things can be done.

I am trying to learn to export and import modules in ES6 and it tells me in the console: SyntaxError: export declarations may only appear at top level of a module

I'm trying something simple. I have the code like this:

file.js

export default const modulo = function(){
    alert("Hola mundo");
};

Could I then in an html page within a script tag do the following to test? page.html

import modulo  from 'archivo.js';

According to MDN it should work but only the export already gives an error.

Why so much complication? Couldn't you use the revealing pattern instead? What advantages would ES6 modules offer over methods like Revealing with immediately executable functions that return an object (IIFE)? The use of these imports/exports prevents you from having to import the .js with the ?

Good. I'm trying to do something so that every 2 <br> in a row becomes a <p></p>

I managed to get it to convert from <br><br> to <p></p> only once. But when I try to put 2 <p> in a row no more paragraphs are created.

Another thing is that I am putting the text that I get from the substitutions directly in element.innerHTML. What happens is that even if I write elements directly in the TEXTAREA these are added. Is there also a way to encode this HTML after receiving the text? What would be the best way to do all this that I want to do?

The example code would be the following. If I have the following HTML code:

<p>
  Esto es un texto
  <br><br>Parrafo 1
  <br><br>Parrafo 2
  <br><br>Parrafo3
</p>

Become:

<p>
  <p>Parrafo 1</p>
  <p>Parrafo 2</p>
  <p>Parrafo 3</p>
</p>

And starting from the previous code I would like to be able to do that within each paragraph when I do the following:

<p>
  <p>Parrafo 1 <br><br>Nuevo parrafo</p>
  <p>Parrafo 2</p>
  <p>Parrafo 3<br><br>Subparrafo de 3</p>
</p>

Become:

<p>
  <p>Parrafo 1</p>
  <p>Nuevo parrafo</p>
  <p>Parrafo 2</p>
  <p>Parrafo 3</p>
  <p>Subparrafo de 3</p>
</p>

Or that those 2 paragraphs go at the end instead of going right after the paragraph where his

As I said, I have managed to create 2 consecutive paragraphs with their internal text, but when creating the third one, 2 BR are created with a text inside one of those 2 paragraphs. Then I changed the regular expression and now I only get 1 paragraph to be created in a row.

Anyway, I can't find the regular expression, if it is possible. Here the HTML and the javascript

HTML

<div>
    <h4>Escribe un texto cualquiera</h4>
    <textarea cols="60" rows="10">Lorem ipsum dolor sit amet, consectetur adipisicing elit. In, id, quidem ex quaerat dignissimos saepe molestias vero praesentium nostrum iste libero voluptatem quam maxime quos quod obcaecati quae dolor pariatur!</textarea>

    <p id="p1">Lorem ipsum dolor sit amet, consectetur adipisicing elit. In, id, quidem ex quaerat dignissimos saepe molestias vero praesentium nostrum iste libero voluptatem quam maxime quos quod obcaecati quae dolor pariatur!</p>
</div>

JavaScript

window.onload = function(){
  const p1 = document.querySelector("#p1");
  const textarea = document.querySelector("textarea");

  textarea.addEventListener("input", function(){
    let texto = this.value.replace(/\n/gi, "<br>");
    texto = texto.replace(/(.*<p>.*)*(?:<br(?:\s\/)?>){2}(.*)(<\/p>)*/gi, "$1$3<p>$2</p>");

    texto = texto.replace(/-{4,8}/g, "<hr>");

    p1.innerHTML = texto;

  });
}

Good. I would like to know how I could, if possible, change settings like windows theme, resolution, dpi, mouse and anything else I can change from control panel in Windows 10 or Windows 7 using a batch. Is it possible or is it not worth it?

My idea was to automate various changes, I know that for example in Windows 7 you can save themes and settings but I'm not sure how to do several procedures in a batch.

I'm also not sure if saving a theme's settings will also save the resolution, dpi and other settings such as accessibility so if I activate another theme and switch back to the custom theme I had saved I'll reset those changes.

I have searched and I have not found anything about batch so I suspect that this being able to be done will not be the best way, but is there code to do what I say?

There are configurations that when saving a theme may be saved, but if I export the theme and take it to another PC, some of those configurations may not have been saved because they would be separate.

My idea was that if I have to transfer some configurations, I can execute a batch and make the changes comfortably by executing that batch file.

I hope the question is not open. I think I'm asking something quite specific:

Adjust by batch the following:

• Resolution
• dpi or (dpi?)
• Visual theme of any type: Normal, Architectural, Characters, high contrast accessibility
• Activate or change accessibility section settings (such as on-screen keyboard, screen reader, etc.
• Change mouse, speed, extra mouse options etc...
• change sounds

In short, things of the style that would be changed from the customize menu or from the control panel. I hope the question has been understood.

Good. I am trying to draw the trace that follows this recursive fibonacci code in Java to see how exactly the recursion works in this case. I do not quite understand the exact operation in this specific case since in the return it is supposed to return and exit the function in which it is, but in the return it recursively enters 2 methods that in turn if it is not 0 or one returns again 2 recursive methods exiting that method in question.

The code is the following:

public int fibonacci(int n) {

  if ((n == 0) || (n == 1)) // base cases
      return n;
    else
      // recursion step
      return fibonacci(n - 1) + fibonacci(n - 2);
}

Could someone explain to me the trace that the program follows and in each pass the result of n at the end of each function for each time it is called?

The return really does not have a stack leaving the function and calling in turn 2 functions as a tail recursion?

I'm trying to emulate the JSON.stringify function by doing a bit of "reverse engineering" by seeing the result of serializing an object or array to json. Next I put a jsfiddle of the emulation of a proper method.

"use strict"

const obj = {
  "hello": "object",
  "im_an_array": ["pos 0", "pos 1"],
  22.4: [1, "Hola", null, undefined, false, 0],
  "object": {
    description: "im an object"
  },
  "date": new Date(),
  "function": function(arg = "") {
  	alert("Hello "+arg+"!");
  }
}
const arr = ["Hello", "array", 2, 2.1245, ["0", 1], null, new Date(), [false, [undefined, true, {param1: true, empty_obj: {}}, {empty_arr: []}, ""]]];


/****************** START OF FUNCION *************************/

JSON.cerealize = function(obj = {}) {
    if (typeof obj !== "object") {
      throw new TypeError("The parameter passed is not an object");
    }

    let str2 = "";
    let openTag = "{";
    let closeTag = "}";
    let obj_type = "object";
    let str3 = ""; //For setting keys and ':' for only when the value is not a function.

    //KNOW IF IT IS AN ARRAY OR OBJECT FOR OPEN AND END TAGS
    if (Array.isArray(obj)) { //If the passed object is an array, susbstitute the open and close tags and set the cached obj_type as array instead of object.
      openTag = "[";
      closeTag = "]";
      obj_type = "array";
    }

    str2 += openTag;
    //If object is a Function do nothing
    for (const k in obj) {
      //Cache the obj
      const _obj = obj[k];

      //Print the key of the object if it is not an array
      str3 = "";
      if (obj_type !== "array") {
        typeof k === "string" ? str3 += ("\"" + k + "\"") : str3 += k;
        str3 += ":";
      }

      if (typeof _obj !== "function") {
        
        str2 += str3;
       
        if (typeof _obj === "object") {

          if (_obj === null) {
            str2 += null;
          } else if (_obj instanceof Date) {
            str2 += "\"" + _obj.toJSON() + "\"";
          } else {
            str2 += JSON.cerealize(_obj);
          }
          
        }
        else if(typeof _obj === "string") {
          	str2 += "\"" + _obj + "\"";
        } 
        else if(typeof _obj === "undefined") {
						str2 += null;
        }
        else {
          str2 += _obj;
        }
        str2 += ",";
      }
      
    }
  
    str2 += closeTag;
    return str2.replace(/,(]|})/, "$1");
  }

  /**************************** END OF FUNCTION *************************/

window.onload = function() {
  console.time('json_stringify_obj');
  JSON.stringify(obj);
  console.timeEnd('json_stringify_obj');
  
  const p_obj = document.querySelector("#info_obj");
  p_obj.textContent = JSON.cerealize(obj);

const p_arr = document.querySelector("#info_arr");
  p_arr.textContent = JSON.cerealize(arr);

}

console.time('json_stringify_arr');
  JSON.stringify(arr);
  console.timeEnd('json_stringify_arr');
 console.time('serial_obj');
  JSON.cerealize(obj);
  console.timeEnd('serial_obj');
 console.time('serial_arr');
  JSON.cerealize(arr);
  console.timeEnd('serial_arr');
 

  font-family: Lucida Console, Monospace, Arial, Sans-Serif;

<h2>
Recursion practice | Serializing objects
</h2>

<h3>serializing an object</h3>
<p id="info_obj">
  <!-- obj info -->
</p>
<hr />
<h3>
<h3>Serializing an array</h3>
<p id="info_arr">
  <!-- Array info -->
</p>

I have noticed that while in my case it appears undefined, in the original method doing JSON.stringify, the value is serialized as null.

Why? If undefined is a definable value why can't it be serialized as such? Couldn't you save an object entirely with inner methods? Since I have seen that JSON.stringify does not serialize the methods.

I am trying to override a custom css file called responsive.css with child themes in wordpress.

If I edit the responsive.css of the parent there is no problem but if I do it in the responsive.css child it does not work

The rest of the files (style.css) do work in the child theme but responsive.css does not.

I'm trying to do the following command in CMD to save %PATH% with newlines to a text file.

"@echo. %PATH:;= & @echo.%" > path.txt

With this I try to do it with line breaks so that I can then do a findstr from that file. But it gives me error The line written is too long. And the same if I try to pipe it to another command like findstr instead of the file. I am doing something wrong? I thought that to group commands they were the quotes but not anyway.

If I do in CMD something forlike this:

for /F "tokens=1,2* delims=: " %%g in (test.txt) do (
    echo %%g es el label y %%h es el valor
)

With those delimiters what happens to me is that it separates me by a colon OR by a space. But how can I make it always separate by a colon AND by a space?