Stats

  • Locked Locked
  • Replies 3
  • Subscribers 165
  • Views 15947
  • Members are here 0
More Content
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Creating a BOM with LibreOffice Calc versus MS Office Excel!!!

MandeepDraftor

I know one can create an Excel-like spreadsheet bill of materials (BOM) importing the tab or CSV delimited ASCII BOM file from Allegro Capture (OrCAD Capture) to a get your standard BOM document, but what if you use LibreOffice or OpenOffice type office applications, is there a way to get Allegro or OrCAD Capture to automatically open in LibreOffice Calc when one checks "open in Excel" check mark to create the BOM?  Assume SPB 17.20.060 and the latest LibreOffice (version 6.3.2).

  • RFinley

    (Sorry, forgot to circle back and expand on this.)   

    You will need a standalone Windows Excel license to export a BOM.  Scripting in Excel can do interesting things including SQL calls (shudder), so we're stuck with it.

    Standalone Excel can be obtained in the US for around $140. 

  • MurimGomes

    I know one can create an Excel-like spreadsheet bill of materials (BOM) importing thnba reddit e tab or CSV delimited ASCII BOM file from Allegro Capture (OrCAD Capture) to a get your standard BOM document, but what if you use LibreOffice or OpenOffice type office applications, is there a way to get Allegro or OrCAD Capture to automatically open in LibreOffice Calc when one checks "open in Excel" check mark to create the BOM?  Assume SPB 17.20.060 and the latest LibreOffice (version 6.3.2). reverse ph one lookup 

     
  • RFinley
    in reply to MurimGomes

    In short, the primary advantage to exporting to Excel:  CIS BOMs can include information that is not cached in the schematic and is obtained by SQL query.  I.E.  Not sure why you would cache the component description but it would be nice to include it on the BOM, live from the SQL data source.

    Love or Hate Microsoft, in the end, Standalone Excel is not wildly expensive.  And, the SAX scripting environment in office products could be useful someday.

    If it helps, I consider Project and Powerpoint as evil.

Cadence Guidelines

Community Guidelines

The Cadence Design Communities support Cadence users and technologists interacting to exchange ideas, news, technical information, and best practices to solve problems and get the most from Cadence technology. The community is open to everyone, and to provide the most value, we require participants to follow our Community Guidelines that facilitate a quality exchange of ideas and information. By accessing, contributing, using or downloading any materials from the site, you agree to be bound by the full Community Guidelines.