Components Panel Filter not Correctly Filtering on Database 'value' Parameter

Created: March 28, 2021 | Updated: May 19, 2023

Using a Database Library with Microsoft Excel, formatting in the Excel file can cause the filter to not work correctly when read by Altium Designer. For example, setting the filter to "greater than or equal to #" does not filter correctly. We will look at how to format the column in the Excel database so it can be processed correctly.

Starting in Version: 18.0
Up to Version: Current

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:
Was this article helpful?
Found an issue with this document? Highlight the area, then use Ctrl+Enter to report it.

Contact Us

Contact our corporate or local offices directly.

We're sorry to hear the article wasn't helpful to you.
Could you take a moment to tell us why?
200 characters remaining
You are reporting an issue with the following selected text
and/or image within the active document: