Importing a file with Data validation causes rows to be hidden

Posted by: adisa.craig on 6 April 2020, 3:35 am EST

  • Posted 6 April 2020, 3:35 am EST

    I 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).
  • Replied 6 April 2020, 3:36 am EST

    seems the file was not attached in original post
    IssueTracker.xlsx.zip
  • Replied 6 April 2020, 11:57 pm EST

    Hi 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.

    Regards
    Sharad
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels