Contact Us
Contact our corporate or local offices directly.
Created: March 28, 2021 | Updated: August 12, 2021
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.0Up 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:
https://www.altium.com/documentation/altium-designer/working-with-database-libraries-ad
Was this article helpful?