KB: Filter Database 'value' Parameter in Components Panel

Solution Details

Although Excel can be used, it is recommended to use a true database such as Access for a Database Library.  With Excel, multi-user connections can be problematic, and there may be some unintended issues caused by formatting, such as this:  

The Components Panel below is showing results from a DbLib configured to use an Excel XLS database. Notice the voltage values


The solution would be to open the excel / access database and check for the format of the cells. If they are formatted as General, then need to be in defined as Number: 


After that save the file and recreate your data base library. Now the filter should work fine.



Here's documentation that may be of interest:
https://www.altium.com/documentation/altium-designer/working-with-database-libraries-ad