Tweaking AutoCorrect Options

I’m not a fan of AutoCorrect in my Excel or Calc program. As such, there are some tweaks that should be done. Disable Recognition of URLS: Libre Calc source ( Turn off URL Recognition Load a document of the type for which you want to modify the URL recognition. If you want to modify the URL recognition for text documents, open a text document. Choose Tools – AutoCorrect – AutoCorrect Options. In the AutoCorrect dialog, select the Options tab. If you unmark URL Recognition, words will no longer be automatically replaced Continue reading →

Saving your CSV files with Formulas

Whenever you are working with Formulas within Libre Calc or Excel, you will often want to save the formulas for reuse on other data sets. You can do this by going to File, Save As…, then saving the file as a ODS (OpenDocumentSpreadSheet) which is a universal file. You can also save as an XLSX file, but that with have some glitches between Excel and Cacl. LibreOffice Calc Microsoft Excel

Finding non-ASCII characters

Sourced from ( thanks to Alix Axel This will match a single non-ASCII character: [^\x00-\x7F] This is a valid PCRE (Perl-Compatible Regular Expression). You can also use the POSIX shorthands: [[:ascii:]] - matches a single ASCII char [^[:ascii:]] - matches a single non-ASCII char For Libre Calc or Libre Write do a Find & Replace (Ctrl + H) to get this menu:

A Lesson on Monitors

People frequently ask me what monitor I suggest. So, I’ve decided to keep a little blog post going that describes a few good options. First off, you may need to understand the difference between 4K vs 1440P and 1080P resolutions. If you take a look at this image, you will notice that a 4k screen is exactly the equal of 4 1080p screens. A comfortable size 1080p monitor is between 23″ and 27″ depending on your preferences. I like all of the fonts and icons Continue reading →

Create Hyperlinks in Magento Product Description

Creating a hyperlink in a Magento product description is pretty straight forward. It works like any plain HTML link anywhere on the web. You can simply use this syntax:  <a href=”address-you-want-to-link” title=”The Name of the Link”>The Text that is viewable</a> In case of a category: “” you want this part after the domain, including the slash

Turning Your Love Into Money, Without Loving Money

Here are 4 of my top links and why I think they are genius Blippi – He acts like a silly Muppet character, lives in the middle of no-where in Washington state, and has figured out a way to make money having fun while doing something productive. On top of all that, he gives parents an EASY way to download the video content to their own devicies to save on bandwidth which could be a huge benefit if you are going on an airplane Continue reading →

Mad Dash for the Cyber Monday – By SpringBot

Last week at the Magento Meetup for the Southeast here in Atlanta, I had the honor to hear Joe’s presentation on how to prepare for the mad dash from Nov 1 through Cyber Monday and into the New Year. It was a refreshing, concise set of action items that any merchant can implement. Of course, the tools allow you to implement certain of these action items in an easy way. Checkout the details and download the white paper at:

Magento 1.9x RWD – Showing Color Swatches in Layered Navigation

There are a few steps to get Magento 1.9x default RWD Color Swatches to show in the layered navigation. Go to your attribute and make sure it is set to global Ensure that you know the exact name of your color that is listed in the Admin column and save your images with this file name Save your image as a PNG file. If your Admin Label in step 2 contains any spaces or special characters, be sure to replace those with hyphens and replace Continue reading →

Benefits of our hosting – Revised

The time has come, where hosting is out pacing my ability to keep up! With virtualization and now containerization, I see the hosting landscape changing dramatically over the next few years. No doubt, people will always need a good server to host a basic website using cPanel. But I think that software architects will begin to write their code in such a way that containers are the future of the internet. Until then, I have two AWESOME hosting companies that I like to work with. Continue reading →