Forums Ultimate UI for WPF
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Nicolas Subotovsky
195
Excel-like functionality manipulating cells
posted

I was checking xamSpreadsheet control, and though very useful, found some expected functionality missing (when compared to Excel).

My question would be, is there a way to 'activate' these features, or a way to easily implement them?

Feature 1) Copying cell content by dragging the lower right corner of the cell.

I noticed the selected cell has the lower right of the cell bound marked the same way Excel does; which in Excel it's used for dragging and copying the cell contents. However, on the xamspreadsheet control, when I drag from this corner of the cell I just select all the cells (like if I were just dragging it from the middle of the cell)

Feature 2) When Inputting formulas, select source formulas with the mouse

In Excel, when you type the '=' symbol on a cell, if you then click on another cell you get the cell 'address' pasted into the current cell that's being edited. On the xamspreadsheet, it switches instead to the other cell instead.

Feature 3) Copying/Pasting cells

I noticed there's copy/paste functionality implemented either by right-clicking or using crtl+c/v. However, the copied cell is not 'highlighted' to indicate which content has been copied.

Also, can the copy/paste featuer be binded to the crtl + ins and shift+ins as well?

Thanks,

   - Nicolas

  • 1530
    Verified Answer
    posted

    Hello Nicolas,

     

    Thank for your post.  I have been researching the functionalities that you are trying to achieve and regarding the last one(copy/paste using the ctr + ins and shift + ins) you can achieve that by handling the KeyDown event of the spreadsheet and executing the Copy/Paste command when ctr+ins / shift+ ins is detected like this:

    private void xamSpreadSheet1_KeyDown(object sender, KeyEventArgs e)
    {             
    if (e.Key == Key.Insert && (Keyboard.Modifiers & ModifierKeys.Control) == ModifierKeys.Control) 
    {                 
    SpreadsheetCommand cmd = new SpreadsheetCommand(SpreadsheetCommandType.Copy);
    cmd.Execute(xamSpreadSheet1);
    }             
    else if (e.Key == Key.Insert && (Keyboard.Modifiers & ModifierKeys.Shift) == ModifierKeys.Shift)             
    {                 
    SpreadsheetCommand cmd = new SpreadsheetCommand(SpreadsheetCommandType.Paste);                 
    cmd.Execute(xamSpreadSheet1);             
    }         
    }

    I have attached a sample which demonstrate this behavior. Regarding the first three features they have been determined as new Product Ideas. You can suggest new Product Ideas for future versions (or vote for existing ones) at http://ideas.infragistics.com.

     

    Steps to create your idea:

                   

    1. Log into the Infragistics Product Ideas site at http://ideas.infragistics.com (creating a new login if needed).

    2. Navigate to the product / platform channel of your choice (e.g. WPF, Windows Forms, ASP.NET, HTML5 / Ignite UI, iOS / NucliOS, etc.)

    3. Add your product idea and be sure to be specific and provide as much detail as possible. Explain the context in which a feature would be used, why it is needed, why it can’t be accomplished today, and who would benefit from it. You can even add screenshots to build a stronger case. Remember that for your suggestion to be successful, you need other members of the community to vote for it. Be convincing!

     

    The benefits of submitting the product idea yourself include:

    • Direct communication with our product management team regarding your product idea.

    • Notifications whenever new information regarding your idea becomes available.

     

    Additional benefits of the Product Idea system include:

     

    • Ability to vote on your favorite product ideas to let us know which ones are the most important to you.  You will have ten votes for this and can change which ideas you are voting for at any time.

    • Allow you to shape the future of our products by requesting new controls and products altogether.

    • You and other developers can discuss existing product ideas with members of our Product Management team.

     

    The product ideas site allows you to track the progress of your ideas at any time, see how many votes it got, read comments from other developers in the community, and see if someone from the product team has additional questions for you.

     

    Thank you for contacting Infragistics.

     

    Sincerely,
    Teodor
    Software Developer
    Infragistics
    www.infragistics.com/support

    XamSpreadSheetFeatures.zip