Excel Formula Not Working Unless Double Click Cell

Sometimes you may face issues like any formula of excel does not work until you double on each cell. This is a very command issue and I also faced this while working on one of the websites. When excel has too much data then it’s not possible to click each cell one by one to fix the formula issue. We found one solution to mass click each cell of excel to fix the formula issue in the excel or CSV file.

Continue reading “Excel Formula Not Working Unless Double Click Cell”

Magento 2 Get URL Without Trailing Slash in CMS Page and Block

The trailing slash at the end of the URL creates an issue of duplicate content on your website. URLs with and without trailing slash are considered as different pages by the Google search engine. Google consider these pages as 2 separate pages with the same content. In Magento 2 when you call any page in your CMS block using store URL it automatically adds a trailing slash at the end of URL. This blog post by Dhairvi Solutions helps you to know how to add URL without trailing slash in the Magento 2

Continue reading “Magento 2 Get URL Without Trailing Slash in CMS Page and Block”

Magento 2 Display Product Based on Store View

in Magento 2, products are always based on the website, not on the store. We can update product attribute values at the store level but the products itself is global for all the stores. You may have business requirements like hiding and showing products for a specific store. This blog post by Dhairvi Solutions show you how to display product on the store level. Before we go ahead if you are unaware of how Magento Product Scope works then you should review it over Magento doc.

Continue reading “Magento 2 Display Product Based on Store View”