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

[craigarno]

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.