microsoft excel – Detect cell format change

How can I detect a change in the fill colour of a cell in a column in a table, I have tried using OnChange like;

Worksheet_Change(ByVal Target As Range)
......
If Not Intersect(Target, Me.ListObjects("tbl_City").ListColumns(2).DataBodyRange) Is Nothing Then

but that does not seem to work for changes to formatting. Is there a way to detect a change in the cell value and/or its fill.

How to change only one javascript function in wordpress child theme?

I would like to change just one JavaScript function in the child theme but without having to insert all the JavaScript code of the parent theme.

How do I change only this function (I need change only count = Math.ceil(width / size) line):

function slickAutoResponsive(slider, max, size) {

  if (!max){
    max = 5;
  }
  if (!size){
    size = 380;
  }

  var width = slider.width(),
    count = Math.ceil(width / size);

  if (count < 1) count = 1;
  if (count > max) count = max;

  return count;
}

disable or change ribbon keytips shortcut on word 2016

When I am typing on word and I want to change the language of keyboard several times with ‘alt’+’shift’ keys. But it is very annoying because when I press ‘alt’ key It shows ribbon keytips.
I want to know is there any way to disable this or change the key for example to ‘ctrl’ key?
Thanks

google sheets – How to change cell format on ImportHTML Function

I’ve used the ImportHTML function to scrape play-by-play information from Basketball Reference.

I am using a Vlookup to create a rating system based on time, point different, and several other factors.

I realized the TIME vlookup isn’t reading correctly, but the formula is exactly how it should be (I’ve tested it, and it works fine when I type in the info manually). It only doesn’t work on the time that is coming from my ImportHTML.

I can’t get the format to match – I’ve tried every format option on both my vlookup & the data, and tried forcing it with the TEXT function (might of not done that correctly).

I’m at an absolute stand-still at this point — has anyone experienced anything similar?

Other ways to force a format change on imported data? or another way to correctly pull the values from a range of times? I’ve tried the Lookup function as well.

For Reference:

=VLOOKUP(H11,$J$2:$L$6,3,TRUE)

upper lower bounds

importfunction

charging – How do I change the Battery Percentage that corresponds to a Voltage in Android

My original Li-ion has 3000mAh capacity.

I’ve modded my device to have a total of 7000mAh capacity now.

The enhanced capacity means that my percentage is not displayed accurately anymore.

About 2000mAh charge displays 75% charge.

That means 5000mAh are located in the top 25% of my battery indicator.

(Charging times confirm: 1 Hour @1800mA goes from 25% to 75%, but 75 to 83 takes almost the same time and so on)

I know a lot is possible with a rooted android device but I’m not too much of a software person.

How can I change the percentages that display?

There has to be some kind of lookup table where the Vbatt->”%” conversion is done.

Edit: If no one can help me, I am going to add a bunch of tp4056 chips to enable actually charging.

The software seems to mess around quite abit.
Now my phone is charging the 2nd time, and (i assume because it is calculated that the battery should be “full” by now in terms of mAh) it has reached “100%” despite the Vbatt being 3.95 Volts. Actual charge is ~ 70%at max!

enter image description here

magento2 – Database schema realted change reverted

I have one of my Magento 2 projects running with version 2.3.3. There are so many simple products for one single configurable product sue to which the SKU length issue occurred. TO solve I have taken all possible steps

1) Override file : MagentoCatalogModelProductAttributeBackendSku and change const SKU_MAX_LENGTH = 255;

Check below code for this

<?php
namespace CustomSkusizeModelProductAttributeBackend;


class Sku extends MagentoCatalogModelProductAttributeBackendSku
{
    /**
     * Maximum SKU string length
     *
     * @var string
     */
    const SKU_MAX_LENGTH = 255;


    /**
     * Validate SKU
     *
     * @param Product $object
     * @return bool
     * @throws MagentoFrameworkExceptionLocalizedException
     * @throws MagentoFrameworkExceptionLocalizedException
     */
    public function validate($object)
    {
        $attrCode = $this->getAttribute()->getAttributeCode();
        $value = $object->getData($attrCode);
        if ($this->getAttribute()->getIsRequired() && strlen($value) === 0) {
            throw new MagentoFrameworkExceptionLocalizedException(
                __('The "%1" attribute value is empty. Set the attribute and try again.', $attrCode)
            );
        }

        if ($this->string->strlen($object->getSku()) > self::SKU_MAX_LENGTH) {
            throw new MagentoFrameworkExceptionLocalizedException(
                __('SKU length should be %1 characters maximum.', self::SKU_MAX_LENGTH)
            );
        }
        return true;
    }

    /**
     * Generate and set unique SKU to product
     *
     * @param Product $object
     * @return void
     */
    protected function _generateUniqueSku($object)
    {
        $attribute = $this->getAttribute();
        $entity = $attribute->getEntity();
        $attributeValue = $object->getData($attribute->getAttributeCode());
        $increment = null;
        while (!$entity->checkAttributeUniqueValue($attribute, $object)) {
            if ($increment === null) {
                $increment = $this->_getLastSimilarAttributeValueIncrement($attribute, $object);
            }
            $sku = trim($attributeValue);
            if (strlen($sku . '-' . ++$increment) > self::SKU_MAX_LENGTH) {
                $sku = substr($sku, 0, -strlen($increment) - 1);
            }
            $sku = $sku . '-' . $increment;
            $object->setData($attribute->getAttributeCode(), $sku);
        }
    }

2) Change eav_attribute table , find sku in attribute_code and change frontend_class

3) Change different tables column’s length to 255 containing sku like catalog_product_entity , inventory_low_stock_notification_configuration , inventory_reservation , inventory_source_item

Above 2 steps are working fine. But for last steps whenever I run “setup:upgrade” , its again revert to 64 length (For all tables)

So that I have created Installation schema also for same

namespace CustomSkusizeSetup;
use MagentoFrameworkSetupInstallSchemaInterface;
use MagentoFrameworkSetupModuleContextInterface;
use MagentoFrameworkSetupSchemaSetupInterface;
class InstallSchema implements InstallSchemaInterface
{
  public function install(SchemaSetupInterface $setup, ModuleContextInterface $context)
  {
            $setup->startSetup();

            $setup->getConnection()->changeColumn(
                            $setup->getTable('catalog_product_entity'),
                            'sku',
                            'sku',
                            (
                                            'type' => MagentoFrameworkDBDdlTable::TYPE_TEXT,
                                            'length' => 225
                            )
            );

            $setup->getConnection()->changeColumn(
                            $setup->getTable('inventory_low_stock_notification_configuration'),
                            'sku',
                            'sku',
                            (
                                            'type' => MagentoFrameworkDBDdlTable::TYPE_TEXT,
                                            'length' => 225
                            )
            );

            $setup->getConnection()->changeColumn(
                            $setup->getTable('inventory_reservation'),
                            'sku',
                            'sku',
                            (
                                            'type' => MagentoFrameworkDBDdlTable::TYPE_TEXT,
                                            'length' => 225
                            )
            );

            $setup->getConnection()->changeColumn(
                            $setup->getTable('inventory_source_item'),
                            'sku',
                            'sku',
                            (
                                            'type' => MagentoFrameworkDBDdlTable::TYPE_TEXT,
                                            'length' => 225
                            )
            );






  }
}

After this when I run “setup:upgrade” first time, its working fine and above all table’s sku column remain with 255 length

But if I execute same command again then its again reverted to 64

I also tried schema patch

<?php
/**
* Copyright © 2019 Magenest. All rights reserved.
* See COPYING.txt for license details.
*/
namespace CustomSkusizeSetupPatchSchema;


use MagentoFrameworkDBDdlTable;
use MagentoFrameworkSetupPatchSchemaPatchInterface;
use MagentoFrameworkSetupModuleDataSetupInterface;


class ChangeColumn implements SchemaPatchInterface
{
   private $moduleDataSetup;


   public function __construct(
       ModuleDataSetupInterface $moduleDataSetup
   ) {
       $this->moduleDataSetup = $moduleDataSetup;
   }


   public static function getDependencies()
   {
       return ();
   }


   public function getAliases()
   {
       return ();
   }


   public function apply()
   {
       $this->moduleDataSetup->startSetup();


       $this->moduleDataSetup->getConnection()->changeColumn(
         $this->moduleDataSetup->getTable('catalog_product_entity'),
         'sku',
         'sku',
         (
             'type' => MagentoFrameworkDBDdlTable::TYPE_TEXT,
             'length' => 225,             
             'comment' => 'Product sku lenght is 225'
         )
     );


       $this->moduleDataSetup->getConnection()->changeColumn(
         $this->moduleDataSetup->getTable('inventory_low_stock_notification_configuration'),
         'sku',
         'sku',
         (
             'type' => MagentoFrameworkDBDdlTable::TYPE_TEXT,
             'length' => 225,             
             'comment' => 'Product sku lenght is 225'
         )
     );

       $this->moduleDataSetup->getConnection()->changeColumn(
         $this->moduleDataSetup->getTable('inventory_reservation'),
         'sku',
         'sku',
         (
             'type' => MagentoFrameworkDBDdlTable::TYPE_TEXT,
             'length' => 225,             
             'comment' => 'Product sku lenght is 225'
         )
     );

       $this->moduleDataSetup->getConnection()->changeColumn(
         $this->moduleDataSetup->getTable('inventory_source_item'),
         'sku',
         'sku',
         (
             'type' => MagentoFrameworkDBDdlTable::TYPE_TEXT,
             'length' => 225,             
             'comment' => 'Product sku lenght is 225'
         )
     );


       $this->moduleDataSetup->endSetup();
   }
}

Still same issue. How can I achieve this please help.

unity – Change item rotation axis in inventory item visualization

I’m learning unity and i’m trying now make an inventory, i made a simple interface, and now i’m trying to make a item visualization. I look for some codes from web and i found this one:

using UnityEngine;

public class TurnObject : MonoBehaviour
{
    protected Vector3 posLastFame;
    public Camera UICam;

    // Update is called once per frame
    void Update()
    {
        if(Input.GetMouseButtonDown(0)) {
            posLastFame = Input.mousePosition;
        }    

        if (Input.GetMouseButton(0)) {
            var delta = Input.mousePosition - posLastFame;
            posLastFame = Input.mousePosition;

            var axis = Quaternion.AngleAxis(-90f, Vector3.forward) * delta;
            transform.rotation = Quaternion.AngleAxis(delta.magnitude * 0.1f, axis) * transform.rotation;
        }
    }
}

I know some code, but I’m not good with geometrics. In this code when I move my mouse horizontal way, my object turn in the Y axis. And that’s good. But when I move my mouse vertical the object move in the X axis instead of Z axis.

Is there a way in this code for change this? I really have difficulty to understanding geometrics in Unity.

Google Page Experience: Upcoming Search Ranking Change

Google is planning a search ranking change incorporating Core Web Vitals, and planning for the new algorithm.

posts – How can I change the product layout in the store page in WooCommerce?

I am a beginner at WordPress and PHP, (coming from mostly java and c#) and I was wondering how can I change the store page in woocommerce, I have knowledge of HTML + CSS and I want to implement my product design to the store page… I am using OceanWP theme.

I am looking for help with overriding the theme somehow,
I also need examples if possible (see code below) please

<div class= "main-body">
<?PHP foreach: product>
<div class ="title">
<?PHP echo product title>
</div>
<img src=<?PHP echo product image>

etc (ignore my bad syntax)

front end – Change colours of Code

I want to change the colour of some important variables in my code. My code is quite long and sometimes I have to change these specific variables, but it is quite annoying to search them, beacause their is no contrast and it is hard to find them. Is their a possibility to change their colour?