When copying FROM Aspose.Grid.Web TO Excel, sometimes the hidden cells are also copied.
My first two columns are hidden (A & B).
If I try to select some cells starting from the first visible (C1) to any other cell (i.e. F9), and paste it into Excel, it will also copy the hidden cells (A1 -> F9) (wrong).
If I try to select some cells starting from the 2nd row (C2) to any other cell (i.e. F9), it will copy only the selected data (correct).
If I select any entire row (by clicking on the row header), it will copy all the hidden data from this row (or rows) (wrong).
I even set the IsProtected property to TRUE and set the hidden cell's property IsLocked to TRUE, and set the visible cells property IsLocked to FALSE, but it has no effect in this scenario.
Please, I need urgently for you to solve this bug.
Thanks in advance,
Thanks for the test cases,
Yes we noticed and we will figure out the issue related hidden columns soon.