search

dhatim / fastexcel

Generate and read big Excel files quickly
Other
651 stars 118 forks source link

If there is no cell with a value on the row, then hiding the row has no effect, neither does hiding the column #261

Closed meiMingle closed 1 year ago

meiMingle commented 1 year ago

In the following code only the row with index 1 is hidden but the row with index 2 is not

       ws.value(1,1,"hided cell");
       ws.hideRow(1);
       ws.hideRow(2);

In the following code, only the row with index 1 is hidden, but the row with index 2 is not. Also oddly, the following code only hides the row with index 1, but not the column with index 1

      ws.value(1,1,"hidden cell");
      ws.hideRow(1);
      ws.hideColumn(1);