Posted 26 July 2024, 12:29 am EST - Updated 26 July 2024, 12:34 am EST
Hi, we are using Farpoint.Win.Spread (version 12.45.20191.0) control in our windows application. In our application, we have a feature to import an excel file with data which can be opened in spread through our application to input some data and create dynamic reports. We also have a feature to display the rows based on the filter logic in spread. With default filter, we display all the rows which are visible in spread and we use GetRowVisible method to check the visibility of the row.
Suppose we have rows from 1st to 25th in excel and grouping with collapse mode is applied on 25th row (which contains rows from 4th to 24th as hidden) and other rows (1,2,3) are visible in the sheet. For more info, please check the attached excel file as well.
Currently, we are facing an issue of showing the rows from (4th to 24th) when grouping is collapsed in excel because in excel grouping is applied in collapsed mode and our logic (GetRowVisible mehod) returns the result false for collapsed rows (row 4 to 24th).
Is there any way to find the rows which are under the collapsed grouping but not hidden in the spread so that we can display them even when grouping is in collapsed mode in excel? Please help.
As a workaround, this works when we import excel with all grouping in expanded mode.
