CSV p and p file

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
Reply to
mkr5000
Loading thread data ...

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]
Reply to
Don Y

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

Reply to
Ed Lee

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".

Reply to
Rick C

ElectronDepot website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.