teleren/devto huggingface dataset:
Auto Resize Comment Boxes to Fit the Contents in Excel Office 365!!
Tags: autoresizecommentbox, kutoolsexceltutorial, kutools
Published: 2020-09-23 06:59:10

---
title: Auto Resize Comment Boxes to Fit the Contents in Excel Office 365!!
published: true
date: 2020-09-22 12:23:23 UTC
tags: AutoResizeCommentBox,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/auto-resize-comment-boxes-to-fit-the-contents-in-excel-office-365/
---

## Auto Resize Comment Boxes To Fit the Contents:

Here, we come up with the steps to **Auto Resize Comment Boxes to Fit the Contents** in **Excel**  **Office**  **365** using **Kutools**. Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## **Steps to Auto Resize Comment Boxes to Fit the Contents:**

Here are the steps to auto-resize comment boxes to fit the contents in Excel, do as below instructions.

- Refer to the below image, you can see the example comment.

![Example comment](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-90.png)<figcaption id="caption-attachment-14464">Example comment</figcaption>

- If you want to **auto-resize comment boxes in the current worksheet**.
- Go to the **Kutools**  **Tab** , **select** the **More** option in the **Editing**  **section** , **choose** the **AutoFit**  **Comment** option, then **select** the **Active**  **sheet** option.
- To **resize all comment boxes** in the **whole**  **workbook** , on the **Kutools** Tab,  **select** the **More** option in the **Editing**  **section** , **choose** the **AutoFit**  **Comment** option, then **select**  **All**  **sheets** option.

![Choose AutoFit Comment](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-81.png)<figcaption id="caption-attachment-14465">Choose AutoFit Comment</figcaption>

- Now all the comment boxes are automatically resized to fit into their content as shown in the below example.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Result-1.png)<figcaption id="caption-attachment-14466">Result</figcaption>

### Note:

- If you **add new comments** , you need to enable this **AutoFit Comment** feature again to resize the newly inserted comment boxes.

## **Summary:**

In this guide, we helped you to learn the steps to **Auto Resize Comment Boxes to Fit the Contents** in **Excel**  **Office**  **365** using **Kutools**. Give your **suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!
Go to Single Detail Product Information through match.params.id in redux with Contentful CMS API-Class Components
Tags: react, redux, javascript, html
Published: 2020-09-22 12:21:47

Previous blog on part-1:  https://rb.gy/mzbxws

Go to Single Detail Product Information through match.params.id in redux with Contentful CMS API using Class-Based Components


[Github Code](https://rb.gy/dm4i1u)


{% youtube cH9bwKDZICs %}
How to Use Excel DCOUNTA Function in Office 365? – {with Examples}
Tags: exceldcountafunction, excelfunctions
Published: 2020-09-23 06:58:21

---
title: How to Use Excel DCOUNTA Function in Office 365? – {with Examples}
published: true
date: 2020-09-22 12:15:40 UTC
tags: ExcelDCOUNTAFunction,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-dcounta-function-in-office-365-with-examples/
---

## Excel DCOUNTA Function:

![DCOUNTA Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/DCOUNTA-Function.png)<figcaption id="caption-attachment-14428">DCOUNTA Function</figcaption>

In this post, we are going to explore how to use the **Excel DCOUNTA Function in Office 365** with its syntax, explanation, and examples. Let’s step into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## **DCOUNTA Function – Explanation:**

- This function **counts the non-blank cells in a list or database**   **that matches certain conditions or criteria**.

## **Syntax:**

**=DCOUNTA(database, [field], criteria)**

### Arguments Description:

**Database – ** It is the database range including headers.

**Field – ** It is an optional one. This is the field name or index to count.

**Criteria – ** It is the criteria range including table headers.

### Note:

- You need to give the field argument as a name within the **double quotes** ( **” “** ) or a number representing the field index.
- The **database** and **criteria ** range must include the matching table headers.

## **Example:**

- In the below screenshot, you can see the input **database** range ( **B5** : **E13** ) and the **criteria** range ( **B2** : **E3** ).
- The given condition is “ **Product=Book, Price >10** “, the output is displayed in the **Cell G6**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-86.png)<figcaption id="caption-attachment-14426">Example</figcaption>

## **Wind-Up:**

From the above article, you can clearly understand the usage of **Excel DCOUNTA Function in Office 365** with its syntax, explanation, and examples. Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Read Ahead:

- [How to Use Excel QUARTILE.INC Function in Office 365?](https://geekexcel.com/how-to-use-excel-quartile-inc-function-in-office-365/)
- [How to Use Excel RANK Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-rank-function-in-office-365-with-examples/)
how to use react hook form
Published: 2020-09-22 12:13:56

<h1>how to install react hook form using npm</h>

npm i react-hook-form

<h2>how to use React hook form on submit</h2>


<code>
```javascript
import React from "react";
import { useForm } from "react-hook-form";
import "bootstrap/dist/css/bootstrap.min.css";

export default function App() {
  const { register, handleSubmit, errors } = useForm();
  const onSubmit = (data) => console.log(data);
  console.log(errors);

  return (
    <section class="login-block">
      <div className="container-fluid auth-box card">
        <form onSubmit={handleSubmit(onSubmit)}>
          <div className="row">
            <div className="md-col-6 offset-4 mt-3">
              <input
                type="text"
                className="form-control"
                placeholder="First name"
                name="First name"
                ref={register({ required: true, maxLength: 80 })}
              />
            </div>
          </div>

          <div className="row">
            <div className="md-col-6 offset-4 mt-3">
              <input
                className="form-control"
                type="text"
                placeholder="Last name"
                name="Last name"
                ref={register({ required: true, maxLength: 100 })}
              />
            </div>
          </div>

          <div className="row">
            <div className="md-col-6 offset-4 mt-3">
              <input
                className="form-control"
                type="text"
                placeholder="Email"
                name="Email"
                ref={register({ required: true, pattern: /^\S+@\S+$/i })}
              />
            </div>
          </div>

          <div className="row">
            <div className="md-col-6 offset-4 mt-3 mb-3">
              <input type="submit" />
            </div>
          </div>
        </form>
      </div>
      <div className="row">
        <div className="md-col-6 offset-4 mt-3">
          <a href="https://askavy.com/react-hooks-forms/">React-hooks-forms</a>{" "}
          , -<a href="https://askavy.com/">React</a>
        </div>
      </div>
    </section>
  );
}

```
</code>

Code example on codesandbox.io

https://codesandbox.io/s/react-hook-form-askavy-0erju

Source : <a href="https://askavy.com/react-hooks-forms">react hooks forms</a>
How to Use Excel DCOUNT Function in Office 365? – {with Examples}
Tags: exceldcountfunctioni, excelfunctions
Published: 2020-09-23 06:58:05

---
title: How to Use Excel DCOUNT Function in Office 365? – {with Examples}
published: true
date: 2020-09-22 12:13:05 UTC
tags: ExcelDCOUNTFunctioni,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-dcount-function-in-office-365-with-examples/
---

## Excel DCOUNT Function:

![DCOUNT Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/DCOUNT-Function.png)<figcaption id="caption-attachment-14423">DCOUNT Function</figcaption>

In this tutorial, we will guide you to learn the usage of the **Excel DCOUNT Function in Office 365 ** with its syntax, explanation, and examples. Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## **DCOUNT Function – Explanation:**

- This function **counts the cells that contain only numbers in a list or database that matches certain conditions or criteria**.

## **Syntax:**

**=DCOUNT(database, [field], criteria)**

### Arguments Description:

**Database – ** It is the database range including headers.

**Field – ** It is an optional one. This is the field name or index to count.

**Criteria – ** It is the criteria range including headers.

### Note:

- You need to give the field argument as a name within the **double quotes** ( **” “** ) or a number representing the field index.
- The **database** and **criteria ** range must include the matching table headers.
- If you want to **count numbers or text values** from the given field, use **DCOUNTA**  **Function**.

## **Example:**

- In the below image, you can see the  **database** **range (B5:E13) **and the **criteria range (B2:E3).**
- The given condition is “ **product=pencil, price= >10** ” and the output is displayed in the **Cell G6**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-85.png)<figcaption id="caption-attachment-14422">Example</figcaption>

## **Closure:**

In this tutorial, we guided you to learn the usage of **Excel DCOUNT Function in Office 365 ** with its syntax, explanation, and examples. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Keep Reading:

- [How to Use Excel PERCENTILE.INC Function in Office 365? – (with Examples)](https://geekexcel.com/how-to-use-excel-percentile-inc-function-in-office-365-with-examples/)
- [How to Use Excel ASIN Function in Office 365? – (with Examples)](https://geekexcel.com/how-to-use-excel-asin-function-in-office-365-with-examples/)
How to Use Excel DAVERAGE Function in Office 365? – [with Examples]
Tags: exceldaveragefunctio, excelfunctions
Published: 2020-09-23 06:57:49

---
title: How to Use Excel DAVERAGE Function in Office 365? – [with Examples]
published: true
date: 2020-09-22 12:10:02 UTC
tags: ExcelDAVERAGEFunctio,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-daverage-function-in-office-365-with-examples/
---

## Excel DAVERAGE Function:

![DAVERAGE Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/DAVERAGE-Function.png)<figcaption id="caption-attachment-14418">DAVERAGE Function</figcaption>

In this article, we are going to see how to use the **Excel DAVERAGE Function in Office 365** with its syntax, explanation, and examples. Let’s get into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## **DAVERAGE Function – Description:**

- This function **returns the average of records in a list or database that matches certain criteria**.

## Syntax:

**=DAVERAGE(database, field, criteria)**

### Parameter Description:

**Database – ** It is the database range including headers.

**Field – ** This is the field name or index to count.

**Criteria – ** It is the criteria range including table headers.

### Note:

- You need to give the field argument as a name within the **double quotes** ( **” “** ) or a number representing the field index.
- The **database** and **criteria ** range must include the matching headers.

## Example:

Let’s see some examples to understand how this function works.

### Example:

- In the below screenshot, you can see the **database**  **range** ( **B5** : **E13** ) and the **criteria**  **range** ( **B2** : **E3** ).
- We have shown the average of the field “ **Price** ” using the **DAVERAGE** function in **Cell G6**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-84.png)<figcaption id="caption-attachment-14416">Example</figcaption>

### Multi-row Criteria

- Multi-row criteria have one or more rows below the headers. These are joined by using **OR** logic.
- The expressions in a given criteria row are joined with **AND** logic.

## Verdict:

In the above article, you can clearly understand how to use the **Excel DAVERAGE Function in Office 365** with its syntax, explanation, and examples. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### See Also:

- [How to Use Excel PERCENTRANK.EXC Function in Office 365?](https://geekexcel.com/how-to-use-excel-percentrank-exc-function-in-office-365/)
- [How to Use DELTA Function in Microsoft Excel 365? – (With Examples)](https://geekexcel.com/how-to-use-delta-function-in-microsoft-excel-365-with-examples/)
Insert Multiple Rows Using Macros (VBA) in Excel Office 365!!
Tags: insertmultiplerowsus, vbamacros
Published: 2020-09-23 06:57:30

---
title: Insert Multiple Rows Using Macros (VBA) in Excel Office 365!!
published: true
date: 2020-09-22 12:07:29 UTC
tags: InsertMultipleRowsUs,VBAMacros
canonical_url: https://geekexcel.com/insert-multiple-rows-using-macros-vba-in-excel-office-365/
---

## Insert Multiple Rows Using Macros (VBA) in Excel:

In this article, we are going to learn the steps to **Insert Multiple Rows Using Macros in Excel Office 365**. Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## **Steps to**  **Insert Multiple Rows Using Macros:**

To insert multiple rows in Excel using Macros, follow the below steps.

- On the **Developer**  **Tab** , **select** the **Visual**  **Basic** option under the code section.

![Select Visual Basic option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/11-3.png)<figcaption id="caption-attachment-14406">Select Visual Basic option</figcaption>

- Now, you need to make sure that the sheet1 is selected. Then, enter the below code.

VBA code for inserting multiple rows

Sub InsertMultipleRows()

Dim numRows As Integer

Dim counter As Integer

‘you need to select the current row

ActiveCell.EntireRow.Select

On Error GoTo Last

numRows = InputBox(“Enter number of rows to insert”,  “Insert Rows”)

‘You need to keep on inserting the rows until we reached the specified number

For counter = 1 To numRows

Selection.Insert Shift:=xIToDown, CopyOrgin:=xIFormatFromRightorAbove

Next counter

Last:Exit Sub

End Sub

- You need to save the code by selecting it. Then close the window.

![Enter the Source Code](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-78.png)<figcaption id="caption-attachment-14407">Enter the Source Code</figcaption>

- You need to select any cell where you want to insert rows. Then, go to the **Developer**  **Tab** , **choose** the **Macros** option.

![Macro Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-39.png)<figcaption id="caption-attachment-14408">Macro Dialog Box</figcaption>

- You have to make sure that your Macro is selected and **click** the **Run** button.
- It will open the **Insert**  **Rows**  **dialog**  **box** , you have to **enter the number of rows** that you need to add in the text box. Then, hit the **OK** button.

![Insert Rows Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/4-17.png)<figcaption id="caption-attachment-14409">Insert Rows Dialog Box</figcaption>

- Now, the specified number of rows will be added to the spreadsheet.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/EXCEL_LYLkoMHjdU.png)<figcaption id="caption-attachment-14410">Result</figcaption>

## **Wrap-Up:**

In the above article, you can understand the steps to **Insert Multiple Rows Using Macros in Excel Office 365**. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!
Creating GitHub build for JavaScript projects
Tags: rollup, javascript
Published: 2020-09-22 12:03:35

---
title: Creating GitHub build for JavaScript projects
published: true
description: Shows how to set up a JavaScript project with a build system using rollup.js
tags: rollup, javascript
series: my javascript frontend
cover_image: https://dev-to-uploads.s3.amazonaws.com/i/to4m2li5pdh46m8oz8xv.PNG
---

In this article I am showing what I have done to get an automated build running in GitHub to build a JavaScript library.  The project uses rollup.js to perform the build and to build a bundled javascript file based on the contents of a src folder.  

I have used the GitHub Actions feature to create a new build.  This is done by creating a GitHub project and then once the JavaScript files are in the project on the server clicking the Actions tab which takes me to this screen:

![actions](https://dev-to-uploads.s3.amazonaws.com/i/rygxiynodqevjiyt030u.PNG)

The next step is very simple, I click on Setup workflow under Node.js which results in GitHub creating a .yml file for the build for me.  I then make a small change to the yaml file to support running the build using rollup. The change is to add **rollup.config.js** to the run: task as follows:

```
    - run: npm run build rollup.config.js --if-present
```

Once this is done if you wait about 2-3 minutes you can then click on the Actions tab again to review the results of the build.  If all is good you should see something similar to the following:

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/to4m2li5pdh46m8oz8xv.PNG)

Finally the project can be found here if you are interested in viewing the code:

{% github https://github.com/muncey/MyJavascriptCMS %}
Cron-job.org - Free Cron service
Tags: saas, webdev, todayisearched, productivity
Published: 2020-09-22 12:01:35

Cron-job.org is the free service which allows executing any URL regularly and automatically. Every second or once in a year.

> 🇨🇿 V češtině si lze článek přečíst na [kutac.cz](https://www.kutac.cz/weby-a-vse-okolo/planovane-spousteni-webovych-skriptu)


---

Regular and automatic executing of scripts or functions is required in almost every information system. Sending email notifications, managing expired entities or just backup databases. Those are just examples of what cron is useful for.

Some alternative to cron is available in every shared web hosting. But it is often limited to the maximum amount of cron jobs or execution interval. If you run for example [Laravel Queue](https://github.com/orobogenius/sansdaemon) in cron *(without daemon)*, which is responsible for sending emails, running cron every hour is not enough.

![Creation of job](https://dev-to-uploads.s3.amazonaws.com/i/1h2l0vl7p8xt2dbzim0y.png)

# Cron-job.org can do it for free

If web hosting cannot run cron more often, the only solution is its own server or service like [Cron-Job.org](https://cron-job.org/). Which allows creating an **unlimited amount** of cron jobs, and the execution can be set to **every minute** or just once in a year.

When creating a cron job, the developer can choose from almost all HTTP methods, name and password when HTTP Basic Auth is used, or add custom HTTP Headers.

If the service cannot reach the target URL, it can notify the owner about this issue. If there are 15 subsequent failures, the job is disabled and the owner will be notified as well. The Dashboard, which is completely redesigned since the end of August, contains some **history of execution** with nice charts.

![Executions of cron job](https://dev-to-uploads.s3.amazonaws.com/i/thjske8ko1jsbudg40ux.png)

## Must keep in mind some limitations

There are some limitations, but just minor. In the Dashboard, the user can see only the last **25 execution details** or execution details in the last 2 days. If the target script is running more than **30 seconds**, it is considered failed. The same happens when the script returns more than **1024 bytes** of data. In both cases, the **connection is closed**. The best is just to return `"OK"` and logs everything in the server.

If you are using PHP and there is a chance script will run more than 30 s, add this line before the expensive operation starts. When the connection is closed, the PHP script will be terminated.

```php
// This will prevent terminating script when connection is closed
ignore_user_abort(true);
```
Daily Developer Jokes - Tuesday, Sep 22, 2020
Tags: jokes, dailydeveloperjokes
Published: 2020-09-22 12:00:13

---
title: "Daily Developer Jokes - Tuesday, Sep 22, 2020"
description: "Check out today's daily developer joke! (a project by Fred Adams at xtrp.io)"
series: "Daily Developer Jokes"
cover_image: "https://private.xtrp.io/projects/DailyDeveloperJokes/thumbnail_generator/?date=Tuesday%2C%20Sep%2022%2C%202020"
published: true
tags: #jokes, #dailydeveloperjokes
---

Generated by Daily Developer Jokes, a project by [Fred Adams](https://xtrp.io/) ([@xtrp](https://dev.to/xtrp) on DEV)

___Read about Daily Developer Jokes on [this blog post](https://xtrp.io/blog/2020/01/12/daily-jokes-bot-release/), and check out the [Daily Developer Jokes Website](https://dailydeveloperjokes.github.io/).___
### Today's Joke is...
![Joke Image](https://private.xtrp.io/projects/DailyDeveloperJokes/public_image_server/images/5e12593b1b51e.png)

---
*Have a joke idea for a future post? Email ___[xtrp@xtrp.io](mailto:xtrp@xtrp.io)___ with your suggestions!*

*This joke comes from [Dad-Jokes GitHub Repo by Wes Bos](https://github.com/wesbos/dad-jokes) (thank you!), whose owner has given me permission to use this joke with credit.*

<!-- 
Joke text:
A programmer was arrested for writing unreadable code. They refused to comment.
 -->
Git vs. GitHub: What’s the Difference?
Published: 2020-09-22 11:55:53

imply put, Git is a version control system that lets you manage and keep track of your source code history. GitHub is a cloud-based hosting service that lets you manage Git repositories. If you have open-source projects that use Git, then GitHub is designed to help you better manage them. Visit https://blog.devmountain.com/git-vs-github-whats-the-difference/#:~:text=GitHub%E2%80%A6-,what's%20the%20difference%3F,help%20you%20better%20manage%20them. for more details
qxresearch
Tags: github, codenewbie, python, beginners
Published: 2020-09-22 11:55:40

QX Research is an online Developer | Research club in collaboration with Mozilla Campus Club. We focus on the application of Programming with AI ML Cloud Computing Computer Vision IOT etc. Our Research Sessions will take place remotely over video chat, so you can be anywhere in the world.

#qxresearch enhance the knowledge you've to create something cool 🚀


Events:

Event-1 : 10 Projects - 10 Lines of Code
Link: https://www.youtube.com/watch?v=B0_0gK_CUpM&list=PLK_zxbpEUfmVPsXnl1wx1s6BD8eBUjuOM


Become Official Member
Join Mozilla Group @qxresearch
Join Telegram Group @qxresearch
email(qxresearch20@gmail.com) me your GitHub id (subject: GitHub id @qxresearch)