The code hide row through conditional formatting in the Websheet.

[abcthing]

1. demo
This test rule is hide the third row when A1=1.

hiderow2.gif (416.68 KiB) Viewed 2196 times

2.method
(1) Modify the SheetRow class in the tm1webcore.jar.

Code: Select all

    public boolean isVisible() {
        //------add-----------
        for(SheetCell cell: m_Cells) {
             ConditionalStyle style =  cell.getConditionalStyle();
             if(style!=null) {
                  if(style.getStyle("backgroundColor").equals("transparent")) {
                        return false;
	          }
             }
        }
        //-------------------

        return this.m_Visible;
    }

(2) Modify your excel file, set background Color to no color for conditional formatting.

NEWTM1P0.jpg (211.32 KiB) Viewed 2284 times

[tomok]

An interesting idea. I just wish your examples were not in Chinese.

[abcthing]

I modified these pictures.