How do I configure my sheet to go directly to a certain column when opening the document?

I have dates at the top of the document and I would like it to go to the date & # 39; of today & # 39; when I open the document instead of scrolling each time.

javascript: What are the benefits of using a web server instead of opening an HTML file directly through your browser?

I just started coding in Javascript. I am looking for an in-depth response that explains the features that I have available when I use a web server to serve my index.html file instead of simply opening it directly through my browser.

I found this question here, which could be considered a duplicate, however, I am looking for an in-depth answer that shows all the options / features / capabilities one gains when serving your page through a server. There was also this question that gave an answer about ajax.

The answers to both questions are vague.

Other than the obvious feature of making the web page available to end users, what do I earn when I use a server if I plan to simply use this web page that I am creating locally?

Finally, if I need data, the database requires a server to access that data … unless I am using something like SQLite and then here I am with a single .html file and a single .sqlite file … No servers needed. What am i missing?

slr – Do the opening blades move between each shot in burst mode?

I tried my cheap Canon EOS 2000D with a really slow burst mode, with continuous shooting and AF servo.

First, I selected the f / 5.6 aperture. Then, I started shooting. The viewfinder was bright between the shots.

Then, I selected the f / 22 aperture and started shooting. The viewfinder remained equally bright, unchanged from f / 5.6.

Therefore, I suppose this camera with its horrendously slow burst speed will actually move the aperture blades. However, this is an entry level DSLR, so there may be a difference to improve the DSLR. I am interested in answers for better digital SLR; I don't have a digital SLR.

My main camera today is an EOS RP without a mirror, and with it I really can't prove because I am not seeing the world through an optical viewfinder but through a digital screen integrated in the EVF. In any case, the camera is correcting the exposure in the EVF automatically.

5.0 lollipop – Android application – error opening WebRTC URL in WebView

I am working on the development of an Android application, in which I want to open a URL in WebView. Now, if I open a simple URL in WebView (like it works fine. But I want to open a URL that uses WebRTC (Web Real-Time Communication) that says: "It seems that you are using an unsupported browser version." I searched and discovered that WebRTC begins to be compatible with Android 5.0 (API level 21) and higher.

My version of Webview is:

using webView.getSettings (). getUserAgentString () I get the details of my web view.

 apply plugin: ''
        apply plugin: ''

        android {
            compileSdkVersion 28
            defaultConfig {
                applicationId "com.cbtech.learningpod"
                minSdkVersion 21
                targetSdkVersion 28
                versionCode 1
                versionName "1.0"

        buildTypes {
            release {
                minifyEnabled false
                proguardFiles getDefaultProguardFile('proguard-android-optimize.txt'), ''

        dataBinding {
            enabled = true

    configurations.all {
        resolutionStrategy.eachDependency { details ->
            def requested = details.requested
            if ( == "") {
                if (!"multidex")) {
                    details.useVersion "26.+"

    dependencies {
        implementation fileTree(dir: 'libs', include: ('*.jar'))
        implementation ''
        implementation ''
        implementation ''
        implementation ''
        implementation ''
        testImplementation 'junit:junit:4.12'
        androidTestImplementation ''
        androidTestImplementation ''
        implementation 'android.arch.lifecycle:extensions:1.1.1'
        implementation ''
        implementation ''
        implementation ''
        implementation ''
        implementation 'com.squareup.picasso:picasso:2.5.2'
        implementation 'com.github.bumptech.glide:glide:3.7.0'
        implementation ''
        implementation 'com.squareup.okhttp3:okhttp:3.10.0'
        implementation 'org.apache.commons:commons-lang3:3.6'
        implementation('com.paytm:pgplussdk:1.3.3') {
            transitive = true;

The AndroidManifest.xml file is as follows:









The file is as follows:

 public class MyFragment extends Fragment {
        String url;
        private WebView webView;
        private ProgressDialog progressDialog;
        final String CUSTOM_TAB_PACKAGE_NAME = "";
        CustomTabsClient mCustomTabsClient;
        CustomTabsSession mCustomTabsSession;
        CustomTabsServiceConnection mCustomTabsServiceConnection;
        CustomTabsIntent mCustomTabsIntent;

        public static MyFragment newInstance(String url) {
            BBBFragment fragment = new BBBFragment();
            Bundle args = new Bundle();
            args.putString("URL", url);
            return fragment;

        public void onCreate(Bundle savedInstanceState) {
            if (getArguments() != null) {
                url = getArguments().getString("URL");

        @RequiresApi(api = Build.VERSION_CODES.O)
        public View onCreateView(LayoutInflater inflater, ViewGroup container,
                                 Bundle savedInstanceState) {
            // Inflate the layout for this fragment
            View view = inflater.inflate(R.layout.fragment_myfragment, container, false);
            webView = view.findViewById(;
            try {
                Log.d("BBB URL is ", url);

                Log.d("WebView Version", "=======>" + webView.getSettings().getUserAgentString());
                //   webView = (WebView) view.findViewById(;
                webView.setWebChromeClient(new MyWebClient());
                webView.setWebViewClient(new WebViewClient());
                webView.getSettings().setUserAgentString("Mozilla/5.0 (Linux; Android 5.1.1; Nexus 5 Build/LMY48B; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/43.0.2357.65 Mobile Safari/537.36");

                // AppRTC requires third party cookies to work
                CookieManager cookieManager = CookieManager.getInstance();
                cookieManager.setAcceptThirdPartyCookies(webView, true);
                //webView.setWebViewClient(new MyBrowser());

             /*   CustomTabsIntent.Builder builder = new CustomTabsIntent.Builder();
                CustomTabsIntent customTabsIntent =;
                customTabsIntent.launchUrl(getActivity(), Uri.parse(url));*/

            } catch (Exception e) {
            return view;

        private class MyBrowser extends WebViewClient {
            public boolean shouldOverrideUrlLoading(WebView view, String url) {
                return true;

            public void onPageStarted(
                    WebView view, String url, Bitmap favicon) {
                Log.i("Tag", "page started:" + url);
                super.onPageStarted(view, url, favicon);

            public void onPageFinished(WebView view, final String url) {
                Log.i("Tag", "page finished:" + url);

            //Show loader on url load
            public void onLoadResource(final WebView view, String url) {
                Uri uri = Uri.parse(url);
                CustomTabsIntent.Builder intentBuilder = new CustomTabsIntent.Builder();
                //Open the Custom Tab
      , uri);

            public void onReceivedSslError(WebView view, SslErrorHandler handler, SslError er) {


        private class MyWebClient extends WebChromeClient {

            @RequiresApi(api = Build.VERSION_CODES.LOLLIPOP)
            public void onPermissionRequest(PermissionRequest request) {


         * Convenience method to set some generic defaults for a
         * given WebView
         * @param webView
        @RequiresApi(api = Build.VERSION_CODES.LOLLIPOP)
        private void setUpWebViewDefaults(WebView webView) {
            WebSettings settings = webView.getSettings();

            // Enable Javascript

            // Use WideViewport and Zoom out if there is no viewport defined

            // Enable pinch to zoom without the zoom buttons

            // Allow use of Local Storage

            if (Build.VERSION.SDK_INT >= Build.VERSION_CODES.LOLLIPOP) {
                // Hide the zoom controls for HONEYCOMB+

            // Enable remote debugging via chrome://inspect
            if (Build.VERSION.SDK_INT >= Build.VERSION_CODES.LOLLIPOP) {

            webView.setWebViewClient(new WebViewClient());

            webView.getSettings().setUserAgentString("Mozilla/5.0 (Linux; Android 5.1.1; Nexus 5 Build/LMY48B; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/43.0.2357.65 Mobile Safari/537.36");

            // AppRTC requires third party cookies to work
            CookieManager cookieManager = CookieManager.getInstance();
            cookieManager.setAcceptThirdPartyCookies(webView, true);

The image link is as follows:

Opening my own earnings blog

Hello everyone! ;)

terminal – Opening ports on MacOS X High Serra

Ok, I'm having some time trying to make this work.
I have a program that needs to pass to another program on port 8080. However, I can't seem to make that port respond.

I checked my router (RBS50) to make sure nothing is blocking. I even put the computer in the DMZ to make sure everything works on that side. However, even in the DMZ, I cannot make the programs respond to each other. I imagine it must be something local with my computer. If I try to access the port from another machine on the same network, I still cannot access the open port.

I have tried several commands through the terminal to see if I can make it work and none has worked so far.

Running lsof -Pn -i4 | grep :8080
It gives me the result of Program Name 580 Username 9u IPv4 0xb2e9d1619d08cbdf 0t0 TCP (LISTEN)

When I run nc -l 8080
I get the results GET / HTTP/1.1
Host: computer.local:8080
Upgrade-Insecure-Requests: 1
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.1 Safari/605.1.15
Accept-Language: en-us
Accept-Encoding: gzip, deflate
Connection: keep-alive

When trying to reach the open port from a different computer.

I don't have a firewall activated through System Preferences.

I am at my final wit here. Any help or suggestions would be greatly appreciated.

opening: is there any reason to change the ISO manually?

Contrary to the beliefs of many people (and against how the film works), with everything else the same, a higher ISO does not mean more noise but amplified exposure. This amplification will also occur to the content of the scene, as well as to an underlying background noise.

So, if everything else is the same, there is a point in Auto ISO, that is, correct an underexposed image. But most of the time, other forms of correction are a better option: longer exposure (assuming you can keep the movement under control), greater aperture (assuming you can organize the scene properly), flash exposure (assuming this does not will alter the balance of light)

The camera cannot make such assumptions safely. Some of them the user can make and tell the camera explicitly (particularly in the most manual shooting modes). If you place your camera on a tripod to stabilize it (note that long exposures also add own noise), you can safely expose static scenes for a longer time.

For such cases, setting ISO to its lowest value will tend to offer the best images, assuming that the content of the scene supports it. Yes really to wish Prolonged exposures (such as wanting to capture light trails or moving dancers or lightning bolts or whatever), canceling the camera's ISO selection will also help to achieve the exposure times it points to without the camera trying to change its choices.

lightning network daemon – Opening channel with full wallet balance in LND

I was looking at the help exit of lncli openchannel and I was wondering if there is a way to open the channel using the current balance of the wallet, so that the balance of the wallet minus the opening transaction fee is committed to the channel. In c-lightning I can use all as a value for satoshi argument of lightning-cli fundchannel To do that.

8 – Show form errors before opening AJAX modal

I have a form that adds a product to the cart.

The form uses AJAX to open a modal when the form is submitted.

I want to show form errors (if any) before the modal is opened and avoid opening it if there are errors.

Here is my form submission element:

$form('submit') = (
  '#type' => 'submit',
  '#value' => $this->t('Submit'),
  '#ajax' => (
    'callback' => '::submitAjaxForm'
  '#attached' => (
    'library' => ('core/drupal.dialog.ajax'),

My submitAjaxForm:

public function submitAjaxForm(array $form, FormStateInterface $form_state) {
  $response = new AjaxResponse();
  $response->addCommand(new OpenModalDialogCommand(
    $this->t('Product added to cart!'),
      '#theme' => 'some_theme',

  return $response;

And my submitForm:

public function submitForm(array &$form, FormStateInterface $form_state) {
  // Add product to cart.

How can I show errors of validateForm and avoid opening the modal?

editors: prevent VS Code from opening Unity scripts twice

Is it possible to prevent VS Code from opening Unity scripts twice?

E.g. I opened the Unity project, double-clicked on a script and opened my project (Assets folder) in VS Code, now I go to Unity to make some changes and open another script file. The script file opens another instance of the VS Code. I would like to have the file open in the currently open instance instead of opening a new one. It's possible?

enter the description of the image here

enter the description of the image here

Thank you.