Semut's References

I have read a numerous tutorials in the web on techniques to reduce file size. Some of it work okay but not to my satisfactory. I will show those that work first and then I will show my own simple way that works better. Method I found in the web that works but not very well and comes with cons.  - Save your excel file in binary format. Click save as, select Excel Binary Workbook. This however means it will change the format of your file and binary file format is not amendable unless you save as another file format again. Method I found that works better  - Highlight the last row and drag until the very far bottom row of the sheet. Then, select "Delete". The further you go the better. - Highlight the last column and drag until the very far bottom column of the sheet. Then, select "Delete". The further you go the better. Once it is done. Click Save. You should able to reclaim your file size back to small one.

In the PMBOK project management process groups and knowledge areas. For what ever projects that you are about to embark on planning process group, you will need to create the WBS under project scope management. However, when you think you are already using the industry most commonly used project management software - Ms Project. You simply can't find a way to start working on it using the software. You are like, WTF.... In fact, if you do a bit of Google here and there, you will end up getting search result suggesting you to buy another software that sits on top of Ms Project. The software is not bad but shouldn't WBS a fundamental of project planning? How could Microsoft miss out on this. I am not going to elaborate about the purpose of WBS, what are the details of it and how is it going to be applied. For that, you can refer to PMBOK or any project management web sites for details. What I am going to discuss about is the way to do WBS using Ms Project. And the items th...

I often times want to do certain things in Microsoft Project that is supposed to be trivial but I always end up I could not find that particular command or function based on my current habit of looking up for things. Even I tried to google for answer but it just returns irrelevant stuff. I suppose these are consider too trivial or too shy for people to ask this sort of questions. So, this article is meant for anyone who shares the same trait like me. Bumping into simple stuff in Microsoft Project that need a quick answer without having to attend formal Microsoft Project training. 1. How to rename the resource in the project? Resource is the usually the team member of the project, it could also be machine or what ever that are required for the tasks to be carried out. The default view of Microsoft Project is Gantt Chart, so, whenever someone wants to rename assigned resource for the task, usually you will just double click on the task and go to "Resources" of the tas...

I use sticky notes for one reason is that it will stay sticking on my screen until I have decided to remove it. The Microsoft Outlook the moment you create the sticky note, it will stay on top of the screen. However, when you have switch off your machine or close your Outllook application. The sticky notes will go disappear itself. You have to reopen one by one in the Outlook again to make it sticky on top again. Imagine if you have tons of sticky notes in your notes folder.  Of course for the case of Microsoft Outlook, if you want to quickly check back what you have put into the note is that you can change the view of the Sticky Note folder to list. But then again, that defeat the purpose of me using sticky note. That is not the reason why I use a sticky note, I might as well use task or something else in Outlook for that purpose. So, here goes my solution which is to make use of Office VBA macros. It is not a daunted task as you may think, just a little bit of google se...

There are a lot of ways to clean your storage so then to get more storage for new app installation. If you search in market, you get a array of these kind of apps. Before we talk about cleaning storage. Lets talk about why we need to house keeping sometimes. It is good to have extra system storage, not just for you to install more apps or place personal data. In fact, by having more extra system storage will prevent running into hanging issue for your Android phone. The reason being that some apps will generate temporary files when it performs some tasks in the phone, depending on how good is the developer of the app. If they do not do a proper exception handling in their code, if the phone run into cases that the system storage has run out, the app might cause the entire phone to hang. So, it is important to ensure there are ample amount of system storage available in your Android phone. OK, here goes the real topic of how to get more system storage for your phone. My appr...

I was running into situation to pick either OneNote or Evernote for my exam preparation. Version that I am using to compare are - Evernote 5.3 Windows version and  Evernote for Android Mobile. - OneNote 2013 and OneNote2010. I synchronize across few version of OneNote for the same stuff. And then, OneNote for Android recently launched. Experience on the software wise, I have used both OneNote and Evernote for years. Although I have to be frank that, due to heavy duty of notes that I am taking and I am using Windows on my PC. I used OneNote more often. Evernote I came across this because of its popularity in Android community. My feeling towards both of the software are,  features wise, Onenote wins Evernote hands down. Evernote I would say currently it only carries a subset of features what Onenote has. Ranging from tagging, Onenote has ways more in term of doing a tagging like it allows tagging by a selected text in a paragraph. Not just by page. Evernote however ...

I read numerous posts or discussions in the internet forums or android/Samsung support site about how to fix the android phone problems (software related that could cause hardware to fail) . Most of the solutions coming back are like rooting, reset to factory default settings and etc. I am not sure about others but to me, the stuff most important in a phone are below.  - Settings I have spent time putting into the phone itself, not just apps(that includes icons in the home screen, folder that stores apps, short cuts/customization that fit my style of using the phone and etc) - Apps that I have already installed and comes with my data in it.  Apps that i have spent time configuring, store personal stuff in it. Not to mention those I have spent $$ on it.   (If you have purchased the app from Google Play, chances are you get to re-download the app for free but if you purchased it from else where, then, good luck to you. ) - Phone data (like contacts, calendar, notes,...

My team members were asking me about how come their files can't be modified and etc even if it is a duplicated local copy. I tried it out and realized it is indeed not working as told. My finding was that the TFS has a tight control on the versioning of the file, even if the files are offline or those files are duplicate copies of the original files, the TFS control still present in every aspects of the actions you want to do onto those files. So, it seems like there need to have an official declaration to inform Visual Studio that the project files are out of the TFS radar. After some internet searches and trials, it seems like to "permanently" detach project file from TFS are not so straightforward and not properly documented too. It requires some kind of hacking seems. Below are the steps required after the files get copied out from the TFS. 1. Change all the files from readonly to non-readonly. 2. Remove your local workspace from the Visual Studio. Go to me...

Many people are using their mobile devices to communicate nowadays. Messenger, facebook, SMS and etc in one device. And to serve the users needs, most mobile devices will come equip with multi-protocol messenger built in or free to download and install. However, because these free multi-procotol messenger software are not the de facto owner of these messenging protocol like GTalk or MSN messenger. They lack of proper update in term of protocol support and vulnerability fixe that big corp like Microsoft can offer. Because of that, spammer and malware are taking advantages of this and exploiting these loopholes. Thus, many mobile devices user are getting scam, junk messages from their mobile devices messengers. Recently, i have just removed a long time MSN messenger spam+bot contact of mine that has Artifical Inteligent that can prevent typical messenger contact removal from mobile phone. Logon to latest version of PC Microsoft Windows Live. Then click - Tools - Options - Privacy - Bl...

I have a phone that runs on Symbian S60v5. The phone is a cool phone as I can use it for GPS navigation, decent camera, ergonomic (no awkward function/design like some other phones i have used before that put me off. Design and function make sense to me, no impractical but just down to earth.), sturdy , stable signal reception and good call quality. However, like any phone OSes, there are always bugs in it and Symbian makes no exception. And of all bugs in Symbian S60v5, there is one particular bug in the Symbian that really annoys me. It is this Java Suite Setting that sits inside the Installed App menu (Symbian Application Manager). The Installed Applications has a memory constraint bug that it cannot load up if there are too many applications/games installed into your phone. Especially if you have upgraded your memory card. When the Installed App could not load up. There is no way that you can change the Java Suite Settings of your Java application/game. What is in the Java Suite...

All I want to do is to get a set of binaries from projects in solution file (.NET win application) in the debug/release folder and put into one target folder so then I can quickly deploy into staging environment for testing. I do not want to create the setup packages because I want to retain the pdb files in it (for debug version). I know this can be done using the package setup too and also some well build automation script to include debug database but too much of hassle and I want to do it across many projects. Also, I do not want to purchase another tool for simple stuff like this. All I want is a generic script for all kind of the projects. So, here, I come out with a batch file There are some approach in batch programming where a batch will read from another text file (the locations of the project). But i like to put all the location setting to the batch file. Easy to keep track and feel like in control all the time. Too many files to maintain not my preference that all. Here g...

I need to delay the print job as there is no printer available for me to print. Therefore, I decided to save it as XPS for the print job and print it later when I am hook up to a printer in the network. XPS is the format supported in Win 7. It is part of the windows installation. So, i suppose, no issue would follow even though this would be my first time using the XPS. Next day, I open the file using the Ms XPS viewer. Yes, it does the job nicely, i can see the print out clearly and it looks exactly like the actual print out. (what am i talking, it "is" the print out.) Then, ok, it is time to print since i am hooked up to printer. Click print, says successful. Then, go to the printer, nothing comes out. Try few more times, same thing. I thought something is wrong with my printer. Try to print other thing. No issue. Only XPS viewer can't print. So, I figured out that it is XPS viewer printing issue. I then, try to convert to other format like PDF using Paperport or pagina...

If you are coming from SSRS 2005 background. You would be accustomed to the fact that SSRS is part of SQL server and at the same time, it is a web application in IIS. So, when you want to configure the report server, you would tinker the IIS and SQL server management studio. However, once you have upgraded the SSRS to be 2008. You would feel lost at first that all these familiar ways of doing things have changed. So, now, it is no longer depending on IIS seems. It has it's own http.sys. These are all good as in term of technology improvement and progress but at developer end, it is nothing pleasant but confusion and frustration when trying to troubleshoot the problem developers encounter, especially for experienced SSRS developers. They suddenly have turned into rookies. Ok, to help those experienced developers out there. This is my take to experienced guys as this is what i have been through too. First thing first, you have to accept the fact that technology advance quicker tha...

This is a continuation of the previous post. (http://anthony-yio.blogspot.com/2010/03/roadblocks-utilizing-aspnet-35-and.html) ASP.NET Dropdownlist with tooltip Problem: Although it might occur to everyone that dropdownlist when the text in it is too lengthy, there should have some tooltip to show the text in the dropdownlist like "any" combobox in Windows. But to your surprise, this feature does not come for free on ASP.NET 1.1, 2.0, 3.0, 3.5 or may be even 4.0. Resolution: (quote from - http://forums.asp.net/p/903935/994720.aspx) I have search many solutions, some used JQuery, some use CSS and etc. But i do not like to mess around too much with the CSS and Javascript/JQuery for this sort of thing since i am doing MVP+Controller model. A little or non scripting is preferred. Therefore, it is to add the title attribute to the item Add a ondatabound="ApplyOptionTitles" event to your DropDownList control. Then implement in code-behind (C#) as follows: protected voi...

I am sure anyone who have developed/run web application project before know how crucial the application compatible with the mainstream browser in the market. If you search in the google and look for the most rant about browser. It would be no surprise that IE is on top of the list. Ok. this is not a IE bash thread and never intended to be. Because the relation of IE to the development team or business is actually a love and hate sentiment. Why? thanks to IE, development team can focus only compatibility test on IE and ensure if it works there. The rest (not mainstream browser) on the other hand can be ignored (unfortunately, that would mean sayonara to my favorite Mozilla Firefox). To cut the story short, let just explain based on my experience (it could vary on your experience, just my exposure) why people would rant about IE. They said, it is bad, but how bad is bad? Most people would start off "trying" to make the application at least compatible with IE6. Because the older...

This is something that definitely continuous integration able to identify. Something to do with ASP.NET web page running well in development but not in the live environment or pre-screen - continuous integration environment. Server Error in '/' Application. -------------------------------------------------------------------------------- Parser Error Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately. Parser Error Message: The file '/XXX/XXXX.aspx.cs' does not exist. Source Error: Line 1: Line 2: For seasoned developers, if they have started development since .NET 1.1. This is something definitely they familiar with. Because, in the past, all this are not so automated in older version of Visual Studio.NET.So, in this case, it is the CodeFile directive that asking compiler to look for csharp code specify in the aspx file. Th...

The Ms Excel is a different animal when it comes to printing. Because of the nature of the format, you could be selecting only a fraction of page/sheet or workbook to print. For a casual excel user like me, this give inconvenient when all i care is to be able to print what i see on that particular page (or call sheet in excel). Often time, you would see some fraction of the content is being crop out in the print out. Because of exceeded range, you need to resize the columns one by one so then to be able to see the print out in one page. This is time consuming and frustrating. So, after some digging, I found my all time favorite Fit to Page printing function. It is located in "Page Layout" segment.And then, there is a "Scale to Fit" band next to page setup band. (that is another frustration of using newer version of office , all the menu items have been revamped, need time to search for what you want like in the past version). However, this would not wor...

I do not hook up to internet that often after office hours, only once in a blue moon for research purposes. (after all, i get to connect to internet all day long in the office.) It makes no sense for me to commit to the monthly flat rate plan , and thus I choose prepaid broadband for my non-office hours internet surfing. Ok, I have done quite a bit of survey (that is just me, surveying even on these kind of menial stuff) - (comparison of packages as of today - 3 April 2010) Oh, by the way, I have bought a D-Link WCDMA/HSDPA USB modem to test most of these packages. (No need to lock in to any packages just to get the bundled modem by any operator, it is the same standard HSDPA modem. It would work the same way. In fact, my D-Link modem has additional MicroSD card slot (for storage) and I can use the bundled software to send SMS. So, no need to top-up using my handphone, just the modem will do. ) Digi Limited Edition Prepaid Internet ------------------------------------- RM10 5 days unli...

Below is a listing of known bugs of the ASP.NET 3.5 and ASP.NET AJAX and the resolution. Calendar control extender http://forums.asp.net/p/1110311/2780472.aspx#2780472 Problem: Calendar extender would show random transparent weird popup upon clicking. (unbelievable that this can pass QA in the first place) Resolution: Add a dummy CalendarExtender outside of updatepanel. The calendarextender might need to associate with a dummy invisible textbox and invisble image button too. ----------------------------------------------------------- ASP.NET AJAX CalenderExtender again, this time on the days cells being blocked. Problem: If you have a couple of CalenderExtender in your page and asking UI designer to design the CSS separately. You would be very likely getting this. The problem is the td, tr and div tag being overridden by the CSS . Resolution: Have a more specific CSS for your calendarextender. The rule of CSS is the most specific one prevail.Use this (MyCalendar) in the CssClass attrib...

I can't find any example on the web for this, so i guess it could be helpful. This is a simple example to show a way to read the system.serviceModel configuration section in application/web configuration file. Something like for ConnectionString, there is a straightforward class for that, ConfigurationManager.ConnectionStrings["keyname"].ConnectionString Codes snippet below ServiceModelSectionGroup group = ServiceModelSectionGroup.GetSectionGroup(ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None)); //suppose if there is only one endpoint if(group.Client.Endpoints.Count < 0) { uri = group.Client.Endpoints[0].Address.AbsoluteUri; }