Skip to Content

Requirement

User wants to  copy some part from spreadsheet ,and paste them on the table which is in the C4C  system.

This is easy clipboard, the only thing user need to do is to copy the data from spreadsheet , then select the first cell of the part they want to paste in and paste it.

i.e.

spreadsheet:

C4C Sales Quotes →Product ( Before paste):

Please note that the cursor should be in the first cell of the part which is you want to edit.

C4C Sales Quotes →Product(After paste):

Solution

Since user want to do part paste like what is already implemented in the SAP GUI, we choose the simplest implement way as below flow chart.

Flow Chart

1.User copy data from spreadsheet.

2.User select the first cell of the part which is they want to edit.

3.User paste data in it.

4.When user paste some data from clipboard , we will capture this event and replace it with our own logic.

a.Get data from clipboard.

b.Separate data by separator such as ‘tab’ ‘\n’.

c.Get data from table which is editing by user, the editing table is defined by the cursor in which table.

d.Change the data to the table based on cursor and clipboard data.

i.e.

–→ 

e.Do special handle for special scenarios such as currency & unit or checkbox , select list….

5.User need to handle some exception scenarios which cannot be handled by program.

implement

1.Attach an event ‘paste’ to the table(UI5 component) after table rendered.

2.Write handler to do logic which is mentioned above.

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. Vignesh Dharmaraj

    Thanks Joey for the images.

    Now I am not clear on where to add this Java Script codes for the C4C Standard or custom screens.

    As a C4C Developer we have only access to edit the screens in UI Designer of SAP Cloud Application Studio.

    Can you please let me know exactly where this can be done in C4C UI Designer?

     

    Regards,

    Vignesh

    (0) 
    1. Joey Yang Post author

      Hi  Vignesh,

       

      Actually these changes should be done on product level,which means this is for standard development, there is no way to add these codes via SAP Cloud Application Studio.

      Thanks,

      Joey

       

      (0) 

Leave a Reply