How to make a negative number in excel as a number. Here is my code MagentoFrameworkAppResponseHttpFileFactory $fileFactory, $content[] = [ 'qty' => __("QTY"), 'part_number' => __("PART NUMBER"), 'invoice' => __("INVOICE #"), 'date' => __("DATE"), 'description' => __("Description"), 'retail' => __("RETAIL"), 'd_discount' => __("DEALER DISCOUNT"), 'a_discount' => __("ADDITIONAL DISCOUNT"), 'total' => […]
Yearly Archives: 2023
This is the original path – vendor/magento/module-cms/Helper/Wysiwyg/Images.php I want to put a plugin for this function getImageHtmlDeclaration() I want to pass different HTML tag if (!$renderAsTag) { $src = $this->isUsingStaticUrlsAllowed() ? $fileUrl : $this->escaper->escapeHtml($directive); $html = sprintf('<img class="hello" src="%s" alt="" />', $src); }
We use the following code, to get the category name of a specific product. This works fine, but we face the issue with the store views. It only works well if the specific store view does have a unique value for the category name. See this part $cond[] = $items->getSelect()->getConnection()->quoteInto("category_name.store_id=?", […]
I want to put an around plugin. This is the core file vendor/magento/module-cms/Controller/Adminhtml/Wysiwyg/Images/Thumbnail.php The main purpose is on the execute function I want to upload a custom icon for WYSIWYG. $image = $this->_objectManager->get(MagentoFrameworkImageAdapterFactory::class)->create(); $image->open('media/wysiwyg/test_icon.png'); $resultRaw->setHeader('Content-Type', $image->getMimeType()); $resultRaw->setContents($image->getImage());
I managed to install awscli on WSL1. I can query my s3 bucket, copy and move data to/from my buckets just fine. However, when I convert to WSL2, awscli doesnt seem to work. If I issue aws s3 ls I would get Could not connect to the endpoint URL: "https://s3.us-west-2.amazonaws.com/" […]
Context: My team hosts multiple applications on a Windows Server 2016 box. For planning purposes, I’m interested in profiling CPU and RAM usage per application over time. Most of these apps are .NET via IIS, while a few are .NET and scheduled through Task Scheduler, and some are Python scripts […]
I’ll try to make this mystery as simple as possible in the following way: My components: Motherboard: Asus P8Z77-V SSD: Kingston 120GB (ssdNOW 300) HDD: Seagate BarraCuda 1TB CPU: Intel® Core™ i7-3770 RAM: Kingston 16GB (8×2) 1600MHZ DDR3 OS: Linux Mint 21.1 Recently bought: 870 EVO SATA 2.5″ SSD 250GB […]
I am trying to come up with a way to calculate the hours on Excel automatically for my rota. The issue I’m running into is that we do not list “off times” on the schedule, so the shifts are input as “12-cls” or “5-LB”. I am trying to find a […]
I have a conditional format in place to highlight text in columns A – I as information is entered in column L. I would like to now delete or change the information in adjacent cells to be blank or 0. For example, when amag is entered in L1, B2 is […]