EDUCAÇÃO E TECNOLOGIA

SAC Analytics Designer – change color in the table dynamically for notifying which cell is editable

Recently one of my colleague asked to me how we can change “color fill for editable cells” to red for read mode and green for input mode?

so I made a quick prototype for doing it.

It can be done using custom CSS.  For detail, please read this blog

https://blogs.sap.com/2020/09/28/css-in-analytic-application-sac/

Here is my prototype.

There are two button for turning on and off.  Key Performance Indicators are locked so only Operating Income can be editable.

so I defined two custom CSS sets.  .Edit_On and .Edit_Off

.Edit_On .sap-custom-table-editable-cell{

background-color: green;

color:white

}

.Edit_Off .sap-custom-table-editable-cell{

background-color:orange

}

Then in the code of button, We can use below code.

// for button on

Table_1.setEnabled(true);

Table_1.setCssClass(“Edit_On”);

//for button off

Table_1.setEnabled(false);

Table_1.setCssClass(“Edit_Off”);

When you run the app, then click On button, then only editable cell will be changed the color as below and you can edit.

When you click off button, then it will change the color and you can’t edit it.

It is quite simple trick to do 🙂

Thanks!