search

hildogjr / KiCost

Build cost spreadsheet for a KiCad project.
MIT License
493 stars 97 forks source link

KiCost "bulk orders" not working in LibreOffice Calc, does work in MS Excel with Digikey and Mouser #564

Open craigarno opened 2 months ago

craigarno commented 2 months ago 
Edition Windows 11 Pro
Version 23H2
Installed on    ‎10/‎11/‎2022
OS build    22631.3296
Serial number   03073...
Experience  Windows Feature Experience Pack 1000.22687.1000.0

kicad>kicost --version KiCost v1.1.18

I have a KiCost 1.1.18 Spreadsheet, and I am trying to order parts in bulk after filling in the "Purch" field.

Copy/Paste to DigiKey and Mouser works in MS-Excel but doesn't work in LibreOffice Calc.

When I copy the contents of the Bulk parts field, I get something different in Excel than I get from Calc:

Excel "10,BAT-HLD-001-ND,B1 20,399-T521D685M050ATE070CT-ND,C1;C2 200,399-C1210C476M4PAC7800CT-ND,C3;C15;C16;C24-C40 80,455-BM04B-SRSS-TBCT-ND,J27-J34 30,RMCF1206JG1K50CT-ND,R21-R23 10,732-13663-1-ND,SW1 30,36-5002-ND,TP1;TP5;TP6 10,175-MAXM15067AMB+TCT-ND,U1 20,742-SIC967ED-T1-GE3CT-ND,U2;U3 "

Calc 10,BAT-HLD-001-ND,B1 20,399-T521D685M050ATE070CT-ND,C1;C2 200,399-C1210C476M4PAC7800CT-ND,C3;C15;C16;C24-C40 80,455-BM04B-SRSS-TBCT-ND,J27-J34 30,RMCF1206JG1K50CT-ND,R21-R23 10,732-13663-1-ND,SW1 30,36-5002-ND,TP1;TP5;TP6 10,175-MAXM15067AMB+TCT-ND,U1 20,742-SIC967ED-T1-GE3CT-ND,U2;U3

The Bulk Order Entry works in Excel only.

LibreOffice Calc looks like the issue might be Linux line endings [lf] endings vs Windows [cr][lf]. When I correct line endings by hand, then bulk entry works again. In a parts list with 65 different parts, this hand editing of line endings becomes tedious.