/*
         * Demonstrate using the WorkbookView.LocationToRange method to convert
         * from mouse coordinates to an instance of SpreadsheetGear.IRange.
         */
        private void workbookView_MouseDown(object sender, MouseEventArgs e)
        {
            // Acquire a lock on the workbook set.
            workbookView.GetLock();
            try
            {
                // Get the range associated with the mouse location.
                SpreadsheetGear.IRange range =
                    workbookView.LocationToRange(e.Location);
 
                // If this location contains a range, set the interior to blue.
                if (range != null)
                    range.EntireMergeArea.Interior.Color = Color.Blue;
            }
            finally
            {
                // Release the lock on the workbook set.
                workbookView.ReleaseLock();
            }
        }