Author Archives: Vishal Monpara

About Vishal Monpara

Vishal Monpara is a full stack Solution Developer/Architect with 12 years of experience primarily using Microsoft stack. He is currently working in Retail industry and moving 1's and 0's from geographically dispersed hard disks to geographically dispersed user's mind leveraging geographically dispersed team members.

Range.Sort throws an error even though cells are not merged

Recently, we encountered an issue in our production environment where so-far-nicely-working complex spreadsheet threw an exception on Range.Sort. The error description was “to do this all merged cells should be of same size”. Unfortunately there was no merged cell and Excel was still complaining about merged cell. Finally I figured out that the range contained… Read More »

Why TabCtrl_GetCurSel always returns 0?

TabCtrl_GetCurSel returns 0 when the handler passed as a parameter is “invalid”. Here is the fix. If you are using a dialog box, you need to get the tab handler using GetDlgItem(dialog_hwnd, MY_TAB_ID); and pass that handler to TabCtrl_GetCurSel. Make sure you are using the correct variable. I faced the issue when I had two… Read More »

PramukhIME CKEditor Plugin 4.0.0 released

I am very pleased to announce that today on the day of Maha Shivratri, I have released PramukhIME CKEditor Plugin 4.0.0 which supports CKEditor 4.x. Using this plugin user can type in 23 Indian languages (Assamese, Bengali, Bodo, Dogri, Gujarati, Hindi, Kannada, Kashmiri, Konkani, Maithili, Malayalam, Meitei, Manipuri, Marathi (Devnagari and Modi), Nepali, Oriya, Punjabi,… Read More »

SSIS – How to create a new line character (CRLF) column as Derived Column

Use the following expression in order to create a derived column (DT_STR,2,1252)"\r\n" By default Data Type of string “\r\n” is DT_WSTR so here I am casting the data type to DT_STR Vishal Monpara Vishal Monpara is a full stack Solution Developer/Architect with 12 years of experience primarily using Microsoft stack. He is currently working in… Read More »