How to insert row and move down the oleobjects in the excel use POI HSSF

[Jiang Jian Feng (NCSI SZ)]

Hi All,

         I meet a problem, please help me.

         In my excel sheet there is an OLEObjects Forms.CommandButton.1,
when we create a new row, then shift it, the button did not move down.
When I manual insert a new row in the excel file, the button move down.
How to do for it to let the button move down?

         Please help me. Thanks

 

Jianfeng Jiang