This article will show you how to add/create a dropdown list control in Excel so that the user can select only predefined value from custom list. What we want to accomplish We want a user to select a color in cell B1 from the predefined list of colors as shown on the picture. Typical scenario when describing items… Read More »
This article will show you in 5 steps how to change proxy server settings for particular Wi-Fi connection in Android without root needed. This will work for most of apps. You also can specify credentials – password and username for proxy server. If you want to change a proxy for a mobile data please refer to Set proxy… Read More »
This article will show you in 4 steps how to set a proxy server for mobile data 3g connection in Android with No Root needed. This will work for connection for most of apps. You also can specify credentials – password and username for proxy server. If you want to change a proxy for a Wi-Fi network please… Read More »
This article will quickly introduce you to the 4K Ultra HD world. You will get to know what is it, how it fits into current HD formats. To get to know which video cables support 4K and what needs to be considered please see related article Check if your Video Cable Supports 4K Ultra HD. What is 4K… Read More »
This article will show you how to easily add a watermark to any image using Paint.NET 4.0.3 – a recommended free graphical editing tool. Well, basically you can use any of your favorite tool that supports layers. We are going from this: to this: or this: Step 1 Make sure that you have all needed windows in paint.net… Read More »
#VALUE! The formula has the wrong type of argument Excel found type of data which was not expected there. The most common cause is when you use a function or create a formula with a cell that has text instead of numbers. Other might be that single value is expected but a whole range is returned. #NAME? Name… Read More »
Since KitKat Google has decided to hide the Developer Options so only advanced users who know what they do can access it. This can affect phones like: HTC One, LG G2, Motorola Droid, Nexus (5,7,10), Galaxy Note (10,3), Galaxy S4, Galaxy S5 etc. Good thing is that it is not hard to get it back. This article will… Read More »
There is a new option in SharePoint 2013 that allows you to re-index list or document library. You can find more about this on those blogs: http://blogs.msdn.com/b/armenk/archive/2013/02/12/how-to-force-whole-list-or-library-to-be-re-crawled-by-search.aspx http://www.learningsharepoint.com/2012/12/17/the-new-reindex-list-and-reindex-document-library-option-in-sharepoint-2013 Important:It does not work in SharePoint 2010! It is also possible to do it for whole web. Thanks to this all items in all lists will be re-crawled. I would… Read More »
If you get below exception in custom application, when you try to open Site to which you have rights, check “Project Properties/Build/Platform target”. Change it from: “x86” to “Any CPU” or “x64”.
<pre class="inline:true decode:1 " >System.IO.FileNotFoundException was unhandled
Message=The Web application at http://devbox1.com/could not be found.
Verify that you have typed the URL correctly.
If the URL should be serving existing content,
the system administrator may need to add a new request URL mapping to
the intended application.
at Microsoft.SharePoint.SPSite..ctor(SPFarm farm, Uri requestUri,
Boolean contextSite, SPUserToken userToken)
at Microsoft.SharePoint.SPSite..ctor(String requestUrl)
When you get:
<pre class="inline:true class:txt decode:1 " >Invalid URI: The Uri string is too long
on XmlDocument while loading xml from string make sure you use: XmlDocument.LoadXml(string) Loads the XML document from the specified string. and not XmlDocument.Load(string) Loads the XML document from the specified URL.