☝️Small business or a startup? See if you qualify for our special offer.
+

Question about paste values from a spreadsheet directly in grid

Answered
Gilberto Nishioka asked 3 days ago

My name is Gilberto, and I’m working in an Angular project where pivot table functionality is essential.

So, we are analyzing several components, and after navigating in FlexMonster’s website, your component meets almost all the demands of our users.

But one specific requirement remains:

  • Does FlexMonster allow a user to copy some data from a spreadsheet and batch update existing data in a grid?

Following is an example to illustrate this situation:

----------------------------------------------------------

  1. The application shows a grid with some data:

Column A    Column B

1                             10

2                             10

3                             10

4                             10

 

  1. Then the user copy and paste this data into a spreadsheet and alter the values:

(Spreadsheet)

Column A    Column B

1                             10

2                             20

3                             30

4                             40

 

  1. And finally, the user copies the spreadsheet column B's data and paste in the application (column B of the grid):

(Application)

Column A    Column B

1                                             10

2                                             20

3                                             30

4                                             40

----------------------------------------------------------

 Thanks in advance!

1 answer

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster 3 days ago

Hello, Gilberto!

Thank you for reaching out to us.

Kindly note that Flexmonster is mainly designed to visualize the data from the specified data source, and has limited functionality to perform CRUD operations with flat data on the run.
Our team recommends the following approach for the described use case:

  • paste data from Flexmonster to the spreadsheet
  • modify the data on the spreadsheet and save the CSV file to the local system
  • using Connect Toolbar tab, open the CSV file, and all results will be reflected on the grid with no need for further customizations.

Alternatively, it is possible to add custom controls for user input outside of Flexmonster and use the updateData() API call to refresh the data on the grid.

If you need to update a few values ​​point by point without changing the entire column on the flat table, you can enable editing, as discussed in the following thread: https://www.flexmonster.com/question/when-calling-flexmonster-save/.

Do not hesitate to ask if you have any further questions.
Looking forward to hearing from you.

Best regards,
Solomiia

Please login or Register to Submit Answer