You may not be aware, but there is a free application called OpenOffice that is largely equivalent to Microsoft Office. It can be downloaded at http://download.openoffice.fm/free/ . One note of caution; there are a few extra applications that get installed with OpenOffice that are marketing data gathering software. You are supposed to be able to opt-in at install time, but the opt-in process is so obscure that most people will miss it. However, you can remove these application after installation if you miss the opt-in process.

OpenOffice Text Import Dialog BoxI have downloaded Open Office and gave it a test drive with CutList Bridge 2.0. It works with one very minor problem. First, when exporting from SketchUp use the File/Export to Microsoft Excel command. Next, when importing to OpenOffice Spreadsheet use the File/Open command with All files (*.*) selected for Files of type:, and then a dialog box will appear. See the image on the left (click to enlarge). Clear any single quote or double quote (‘ or "") in the Text delimiter drop down box. You don’t have a choice of blank in the drop down, but just select any character(s) in that box and delete them. Make sure you have the Comma check box selected and none other. Hit OK and you will get a cut list similar to that shown in the image at right.

CutList Bridge 2.1 Cut List Imported To OpenOfficeThe double quotes in the left hand column should not be there. They are a result of a bug I have in my script which Excel overlooks, hence I have never seen it. I will fix it in the next bug fix release. This bug does not affect either CutList Plus or Excel. Simply select these cells and delete their content.

So far I am quite impressed with Open Office. I don’t know why I haven’t tried it before today. If you are looking for a complete free solution from 3D modeling of woodworking projects to shop cut lists then the combination of SketchUp, CutList Bridge 2.0 and OpenOffice is your answer.

Leave a Reply

2 Responses to “CutList Bridge 2.0 Works With OpenOffice Spreadsheet”


  1. Marc says:

    Thanks for all you have here. I have been going through your sketchup tutorials and learned many tricks I haven’t seen before. I wanted to share another open source software. Libre Office, It was developed by people from the Open Office team. A group of developers broke off of Open Office after it was aquired by Oracle in fear that the policies would change. I am happy with Libre Office.

    Thank you for sharing.

    Marc


  2. Joe says:

    Hi Marc,

    First, your are welcome. I am glad you find the site and tutorials useful. I took a quick look at Libre Office. It looks quite good. I will see if I can add it to the collection of applications CutList Bridge will work with, perhaps as early as my next release in a few weeks. Thanks for the heads up.

    Joe…..