You cannot change which items will be installed along with Office 365 when you are running a regular installation file. But you can use Office Deployment Tool along with customized configuration file to install only these components that you really need.
This article is a copy of this guide updated for Office 356 Home Premium.
Read More “Install selected Office 365 components”This is just a memo for future self of what steps must be undertaken in order to:
If you’re familiar with the above then you won’t find anything valuable in this article, sorry.
Read More “Adding custom action to yii\rest\ActiveController”PuTTY stores all sessions in Windows Registry, not in a file, so if you want to export these and import on some other computer or account then follow these steps (source):
regedit /E "C:\Trash\PuTTY Settings.reg" HKEY_CURRENT_USER\Software\SimonTatham
Adjust path after /E switch to match your expectations.
Execute the following (instead of above):
regedit /E "C:\Trash\PuTTY Sessions.reg" HKEY_CURRENT_USER\Software\SimonTatham\PuTTY\Sessions
if you wish to export just sessions, not the entire configuration of PuTTY.
Double click exported .reg file in order to import sessions or settings on a new computer.
Source: How to Export and Import Putty Settings (by TechEarl -May 27, 2018)
After writing the previous article I have realized that I solved the problem quite wrong. I added the example RESTful app controller to the frontend application in the multi-application Yii 2 Advanced Project Template environment.
I have also realized that the corresponding Yii 2 Guide is very, very poor and limited. It only tells you that you can have many applications (like backend, fronted and console) in the multi-application Yii 2 Advanced Project Template environment. But it leaves you completely guessing on how to actually add new application.
This quick article is my memo to remember steps that must be undertaken in order to achieve this.
Read More “Adding new application to Yii 2 Advanced Project Template”As explained in the previous article, the example given in Yii 2 Guide about turning regular MVC apps into RESTful one is of a low quality, as it mixes certain things (refer to the previous article for details).
This article deals with this problem and show how to enable REST in Yii 2 Advanced Project Template by adding REST UserController directly to frontend application in that template and thus allowing to server User model through RESTful approach.
Read More “The quickest way to add RestAPI to your Yii 2 app. Part 2”Since Microsoft is Microsoft and the software produced by this company may surprise you in many ways, it may happen that the ideas given in the previous article turn out to be not enough. And file size of your PowerPoint presentation will still be too big.
In this case a more brutal method is needed.
Since every Microsoft Office document is in fact a .zip archive, we will try to reduce file size by direct modification or manipulation of the content of this file.
Read More “Reducing PowerPoint presentation’s file size using brute-force method”The example given in Yii 2 Guide is of a low quality, because it It requires User model based on database, not a file. And the guide mixes two things together:
As an effect, people who just starts their journey with Yii 2 and REST are often confused and finds official example not working in their side.
This article deals with this problem and show how to enable REST in Yii 2 Basic Project Template by using some model (database-based) other than User model.
Read More “The quickest way to add RestAPI to your Yii 2 app. Part 1”To not make our lives too easy, Microsoft decided to distribute offline installers for Windows 11 in well known .iso format while shipping Office 365 offline installation images as .img.
I don’t like the other format and I don’t have any software to work with it, so I needed to find a way for converting .img disk image format into .iso image.
Various methods and issues around this are discussed in this article.
Read More “Convert IMG ↔ ISO and other disk image types”In these days we want to have our PowerPoint presentations “rich and beautiful”. Cool fonts, soft backgrounds and a serie of animations or transitions that pisses-off everyone except presentation’s author are just not enough. We want to have many beautiful images do depict our presentations. Maybe we even want every slide to have different fully photographic background etc.
This is especially true given the fact that there are many services like pixabay.com which offers you hundreds of thousands of beautiful photos completely royalty-free.
However, there’s a well known problem with PowerPoint. If you add any filter or modification to the image placed on some slide, it will be internally saved as PNG format irrespective of the actual format that source image has!
For example, I had a tiny, 9-slides presentation, where each slide had a different full-page photo as a background. Because images were too bright (overlying slide’s text was hard to read), I applied a -40% brightness filter to each image. All my nine source images were saved as JPEGs and took only 1.50 MB on disk. But PowerPoint presentation using them had… 18,1 MB! Over ten times more. And I had to implement a serie of steps to prevent that.
Read More “Reduce PowerPoint presentation’s file size in easy steps”You can have customized document (Word), workbook and worksheet (Excel) or presentation (PowerPoint) opened up as default whenever you start corresponding Microsoft Office application.
In this article I’ll be talking a little bit about file name, content and location for each of three key Microsoft Office components. That is, what to store, where to store and how to name a file.
Read More “Customize how Office starts or default Office templates”I think I’ve been playing this game for over 10 years now. But for the first time I scored 5 million points…
…and built four Lightning Castles, as you may see! :]
Most of you probably know this for years, I have discovered this today:
Tested in Microsoft Edge. Probably works in Chrome and maybe in others.
Works for URL currently entered to the omnibar, not on current page’s URL. Meaning that you can hit F4 then change current page’s URL a little bit and then hit one of those above and get modified URL opened in either new window or tab.
Useful for quickly duplication current tab: F4 + Alt+Enter.
I know that there’s Ctrl+Alt+K, but it seems less natural to be remembered and doesn’t allow to duplicate current tab with modified URL, because it works on current page’s URL.
On freshly installed PowerPoint when you start typing any content in any slide, your language will be automatically changed to your keyboard language layout. If you have your presentation in any other language they you’ll start seeing (nearly) every word underlined as not correct, which is very annoying.
Both solutions that I found in the Internet (this one and this one) turned out to be wrong or not enough, so I had to come with my own.
Read More “Prevent PowerPoint from auto-changing typing language”When developing web applications in PHP based on Yii 2’s Advanced Project Template you have a clear separation between two applications:
There’s also a separate console application but it isn’t important from web applications perspective as it is not accessed remotely via URL, but rather locally in console.
In local development environment you can separate access to these two applications using various methods:
This article deals with all three scenarios, but using XAMPP/Apache for Windows only. You must adjust provided examples, if you’re running Apache on different operating system.
Read More “Configure virtual hosts for separated apps in Advanced Project Template”If you need a typical primary key then use $this->primaryKey() in your migration file. You can also use something like $this->primaryKey(2), if you need a bigger (here int(2)) primary key.
But, what when you need a non-standard primary key, i.e. you want to turn following example SQL code:
CREATE TABLE `country` ( `code` CHAR(2) NOT NULL PRIMARY KEY, `name` CHAR(52) NOT NULL, `population` INT(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
into Yii 2 migration?
Calling:
'code' => $this->primaryKey()->char(2)->notNull()
will fail with error:
Exception: Calling unknown method: yii\db\mysql\ColumnSchemaBuilder::char()
Now, what Qiang?
Read More “Create a non-standard primary key in Yii 2 migration”There’s a handy Safe Mode for all Office 365 offline apps (and probably for older version of Office as well) that you can use to start any Office app without any add-ins and many other things (like themes, animations, etc.) turned off or disabled. Very handy for diagnosing possible problems with some Office app.
To enable it, simply hold Ctrl key when launching any of Office app. When you see app’s button in the taskbar, release the Ctrl key, click that button and answer Yes in the dialog window that appears:
That would be pretty much all.
Whether you want to say “no!” to Putin’s war or you just want to block Russian hackers from attacking your website, the solution is as easy as:
Sure, this is not the ultimate solution. Use of proxy servers, Tor networks, botnets and other techniques for spoofing actual IP address will get them through your “so called firewall”. Also, IP address assigmnets changes often, so Country IP Blocks database might already be out-dated (if fact, it is). But, hey!, it’s always something. As good for the start as anything else. And surely better than doing nothing.
Read More “Block all traffic from Russia to coming your site”Excel is still often used for simple time tracking or roadmap planning in small IT projects. It is good to know that with a simple steps you can create a basic data validation for certain fields in your sheets.
Kind of validation, as discussed here, focuses on forcing user to select or enter only values that are found in some reference list (dictionary). A classing enum / enumerator field well known in databases. If user provided an incorrect (out of scope) value then an error is displayed:
Unfortunately, due to nature of Microsoft Excel, this fails completely when data is pasted.
Read More “Simple data validation or enum fields in Excel”Here’s a quick batch file for DOS / Windows that deletes selected folder and then deletes itself:
@echo off :try rmdir "C:\Trash\Temp" /S /Q if exist "C:\Trash\Temp" goto try del %0
Creating an endless loop for deleting a folder stinks like a hell, but I haven’t figured out anything better so far.
Anyone out there still using a non-SSD disks or hard disks at all? :) While I do believe in cloud data storage, I am an old dinosaur that wishes to have some off-line copy of my most important data. For this reason, I am using (for past 12+ years) a NAS and a number of 4-5 TB disks (I have a lot of important data).
Two days ago one of my disks started to get wako with me being unable to copy certain files. My diagnosis was quick and only confirmed by designated software — surface error, years ago known as “bac blocks”.
Since the disk was one month after five years long warranty, I had to try to fix it myself. For this reason I used two free pieces of software — HDD Low Level Format Tool 4.40 and HD Tune 2.55 Free to confirm.
Read More “Fix small HDD surface errors using low-level format”Microsoft loves to “enrich” our lives with a wonderful (in their opinion) yet totally useless and pissing off (in our opinions) features. The “Pick up where you left off” is one of them.
This tiny little thing wouldn’t be so irritating and could be easily ignored, if it wouldn’t be for a single fact. It blocks keyboard shortcuts completely, until it hides itself (so for approx. 3-5 seconds)! Preventing you from pressing Ctrl+F to do an ultra-fast-searching-millisecond-after-opening-a-document (my beloved feature).
There’s a fairly easy solution to this problem (my own article) that requires you to do some dirty tricks in the Windows Registry. One and a half month after writing that article it turned out that a method described there simply isn’t working at all on one of my computers. So I came out with the following post.
Read More “Get rid of “Pick up where you left off” from Word — three methods”How many favicons you must prepare for your website? The answer is simple — many! Here is the exact list. And here you’ll find answer why there is so many of them?
And here is a real gem and a true magic! A Favicon Generator!
Read More “The Favicon Generator — One Favicon to Rule Them All”Suppose that you have a landing page (or just a cool background) and you have some many versions of it, and all so beautiful, that you can’t decide which one to show. Some kind of weird solution is to show them all in a random manner.
If you wish to achieve something similar to this then all you need is a really short piece of HTML, JavaScript and CSS. All can be put to a single file.
Since I like a clean and easy solution, this one use pure-JavaScript. No jQuery stuff etc. included.
Read More “Randomize background of a webpage”For obvious security reasons, Google will do anything that is in their power to stop you from sending .exe, .apk and other executable files as email messages’ attachments. But, sometimes it is very needed to send such file (in a completely legitimate scenarios). And doing so in Gmail becomes a serious task.
This is, because simple encrypting (password-protecting) such files isn’t enough right now. Since password-protected files encrypts their content only and thus list of attached files is available. Gmail can scan such file and learn that you’re trying to send an executable file even without knowing the password.
Simple extension rename: .exe –> .nothing also doesn’t work today. Google is somehow able to check mime-type of files attached in encrypted archives and doesn’t rely on file extensions anymore.
Read More “Sending executable file through Gmail in Windows”Office 365 off-line apps brings new start-up behavior of showing a summary screen instead of starting with an empty document open. If you like the “old” behavior then there’s a very easy way to achieve this:
Restart app to see the effect.