Skip to main content

Dear Community,

 

As you know, we’ve been working on Enhancing the Tabular Data Manipulation experience on WebUI epic, and made our first incremental release of Excel Upload/Download support in the last 4.86.1 release, also mentioned in my previous product update. 

We’ve made further progress on this epic and also have introduced a new Data Color Palette that is applied across widgets in the WebUI. The 4.87 release includes these features, here is a preview of them: 

  1. Increment on Enhancing the Tabular Data Manipulation experience: As part of enhancing user experience of data manipulation on the WebUI table widgets, we now have extended it with support for Block Editing and Copy/Paste:
  • Block Editing: We now can select a region of a table using your mouse, then type a value and press CTRL+ENTER to change all selected cells into the value you typed.                            You are not limited to selecting a rectangular region of cells. Holding down the CTRL key, you can select more than one region with your mouse. Such a region can also consist of a single cell.
  • Copy/Paste: The table now supports Copy/Paste functionality. Currently, this is limited to rectangular blocks of cells, which you can select as described in the Block Editing section above. When having selected a block of cells, press CTRL+C to copy the block. In order to paste it, select a single cell in the table and press CTRL+V. This will paste your selected block of cells into a region of the same size with the selected cell as its top-left cell.                            If the paste region contains read-only cells, no values will be pasted in those.                  Pasting is not limited to the same table as from which you copied the values. You can paste into different tables on the same WebUI page or on different WebUI pages, even in other WebUI apps. Furthermore, you can also paste to external programs, for example, like text editors or Excel.                                                                                                                    Please note that pasting from an external source to a WebUI table is not supported.

The Block Editing and the Copy/Paste features are available as Experimental Features. You can toggle the ‘Advanced Table Editing’ feature On or Off in the Experimental Features dialog in order to use it.

 

  1. Updated Data Color Palette used across WebUI: The WebUI has a new data color palette, consisting of 16 well discernible colors for most users. This was introduced to replace the current default 19-color palette.                                                                                                    It will affect all Widgets that derive the coloring of their nodes from ordinal annotations: all Charts and the Map. The new palette also works better when using the Transparency Index option to create additional color variations for the Combination Chart.                                          Please refer to the documentation to learn more about the new colors, about falling back to the previous 19, 11 or 7-color palettes and how this influences any custom data coloring that might be in place.

 

 Combination Chart with Colors from the New Palette
Combination Chart with Color and Transparency Index applied

 

We hope these features bring value to your applications and further enhance your user experience.

 

Please leave your feedback and suggestions in the comments.

 

Thanks.

Team WebUI.

 

Dear @Madhu Krishnappa,

 

Great to see that you are working on this and great to see the progress!

I have tested it out a bit (in AIMMS 4.87.3.3) and seems to work quite okay. I just noticed one thing when testing it. Sometimes the copying and pasting works well and sometimes it doesn’t. What happens is this:

I copy a selection of four cells and select four other cells to paste them in, when i hit CTRL+V, it pastes the selection of four directly into the first cell (which doesn’t work). This is what I see:

the four cells get pasted into the first cell, instead of over all four
the error i get

 

Hi @Guus Kattenbelt,

 

Thanks for the encouraging feedback.

About the buggy scenario described above. I assume you have double-clicked on the destination cell instead of just a single click. Double click on the cell, gets into edit mode, and the paste action later just pasted the entire (copied) data to that cell.

Inorder to paste the selection, you just need to select a cell, achieved through single click.

 

Do let me know if this information helped you.

Thanks,

Madhu Krishnappa

Hi Madhu,

 

Thanks for the answer. I’ve try to experiment a bit more. It was not the thing you mentioned with double clicking, I did not do that. I’m afraid I can’t get a great example for you, but what I notice is that it does work for me, but when I hit CTRL+V at the same time (instead of first holding CTRL down and then pressing V), I get the wrong action I mentioned above. There is no easy and quick way of importing a video here, but I think you get what I mean.

 

Regards,

Guus

Hi @Guus Kattenbelt,

 

I'm happy to share that the above issue with quick pasting action has been resolved in the most recent AIMMS 4.89.1 release.


I urge you to read this post and this release notes for more details on the many additional interesting improvements included in this AIMMS 4.89.1 release.

 

Thanks,

Madhu Krishnappa

Terms & Conditions

Didn't find what you were looking for? Try searching on our documentation pages:

AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator