CSV p and p file

Mar 30, 2021 Last reply: 5 years ago 3 Replies

Figured out myJLCPCB files. Using Libre calc and it imported my text files nicely.



I have one file that will be a real pain to add the designation of mil after the x and y numbers. (many parts) Will they figure it out themselves? Can I just add a comment that everything is in mils?



Tried to find a way to maybe generate a mil suffix in Calc but don't see a way to do it.



,,,,,,,, No,Name,Value,Layer,Mid X,Mid Y,Rot,Package,Comment ,,,,,,,,



1,R1,10000,Top,3181.15,2412.5,90,0805 (do I have to 3181.15mil) ?
2,R2,10000,Top,1993.65,2412.5,90,0805
3,R3,10000,Top,1993.65,2312.5,90,0805
4,R4,10000,Top,1993.65,2212.5,90,0805

If all of the fields are constant width, perhaps a simple keystroke macro to return cursor to start of (next) line, move right N places until just past the Mix X value, insert " mil", move right until just past the Mid Y value, insert " mil", end (which will be followed by "return cursor to start of next line" when you reinvoke the macro.

[Dunno, I don't use LibreOffice but I'd do something like this in Brief]

If the eventual result is to make PCB with gerber files, then yes, just a couple of unit and scaling lines.

You can add the mil label as a format. It will show in the spread sheet cells and if someone manually copies those cells it is included in the text. Since I don't know exactly how they will use a spread sheet, I can't say this will work for them.

To do this select a cell or cells and right click to get the popup menu and select "Format Cells". Under category select Numbers and select an appropriate format under Format. Near the bottom of the dialog box put the text cursor in the Format Code line and type "mil" with the quotes. If you want the numbers to be fixed width fields you can use zeros to force the number length with leading and trailing zeros. For example 0000.00"mil" results in the fifth field in the first line being "3181.15mil" while 00000.00"mil" would give "03181.15mil".

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required