Posted 6 April 2020, 3:35 am ESTI have imported this file into the Inspector sample of spreadjs v12. There is a formula list data validation applied to columns B, C and D. When I import there are certain rows that are being hidden or height set to 0(Row 20-289).
Importing a file with Data validation causes rows to be hidden
Posted by: adisa.craig on 6 April 2020, 3:35 am EST
Replied 6 April 2020, 11:57 pm ESTHi Adisa,
During our investigation, we found that the issue is related to the filter. Rows(20-289) are not visible because of the filter applied to the 'Assigne' column. The filter is set to display only rows where assigne=SOMEWHERE.
Could you please let us know how the file is generated because, in Excel too, rows(20-289) should be hidden, reapplying the filter in MS Excel hides the rows correctly.