Stats

  • Locked Locked
  • Replies 3
  • Subscribers 165
  • Views 15948
  • 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).

Parents
  • 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. 

Reply
  • 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. 

Children
No Data
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.