XToolset
XToolset copied to clipboard
[BUG] #! DUMP_COLS should shift columns
I expect DUMP_COLS
to shift the columns to the right, so that you can write templates after the DUMP_COLS
statement.
Here is a small reproduction of what I mean:
issue.xlsx dump-cols-issue-template.xlsx
mode.json
{
"targets": [
"1",
"2",
"3",
"4"
],
"arr": [
{
"targets": [
22,
44,
33,
66
],
"number": 69
},
{
"targets": [
75467,
7,
7456,
66
],
"number": 1337
},
{
"targets": [
452,
44,
735,
66
],
"number": 420
}
]
}
Further to initial report, is it possible to also maintain excel filter on the duplicated Dumped columns?
report-template.xlsx expenses_report_1655193948182.xlsx
{
"name": "Driver Expenses Report",
"date": "14/06/2022, 09:10:22",
"items": [
{
"job_number": "26",
"transship": "NO",
"driver_name": "Driver 3",
"status": "Complete - Confirmed",
"reg_number": "",
"chassis_number": "",
"job_mileage": 215,
"expenses_submitted": "26/05/2022",
"date_delivered": "20/05/2022",
"total": "30.00",
"driver_pay": "70.30",
"expenses": [
"40.00",
"0.00",
"0.00",
"0.00",
"0.00",
"0.00",
"0.00",
"0.00"
]
},
{
"job_number": "27",
"transship": "NO",
"driver_name": "Driver 1",
"status": "Complete - Confirmed",
"reg_number": "EA66OTT",
"chassis_number": "1",
"job_mileage": 52.7,
"expenses_submitted": "24/05/2022",
"date_delivered": "19/05/2022",
"total": "16.60",
"driver_pay": "57.79",
"expenses": [
"0.00",
"0.00",
"0.00",
"6.00",
"0.00",
"0.00",
"27.20",
"0.00"
]
},
{
"job_number": "28",
"transship": "NO",
"driver_name": "Driver 1",
"status": "Complete - Confirmed",
"reg_number": "EA66OTT",
"chassis_number": "1",
"job_mileage": 207.9,
"expenses_submitted": "24/05/2022",
"date_delivered": "19/05/2022",
"total": "2.40",
"driver_pay": "61.14",
"expenses": [
"0.00",
"0.00",
"0.00",
"2.40",
"0.00",
"0.00",
"0.00",
"0.00"
]
},
{
"job_number": "32A",
"transship": "YES",
"driver_name": "Driver 3",
"status": "Complete - In dispute",
"reg_number": "",
"chassis_number": "",
"job_mileage": 22.3,
"expenses_submitted": "20/05/2022",
"date_delivered": "20/05/2022",
"total": "5.00",
"driver_pay": "41.00",
"expenses": [
"0.00",
"0.00",
"0.00",
"5.00",
"0.00",
"0.00",
"0.00",
"0.00"
]
},
{
"job_number": "32B",
"transship": "YES",
"driver_name": "Driver 2",
"status": "Complete",
"reg_number": "",
"chassis_number": "",
"job_mileage": 62.3,
"expenses_submitted": "20/05/2022",
"date_delivered": "20/05/2022",
"total": "5.00",
"driver_pay": "31.71",
"expenses": [
"0.00",
"0.00",
"0.00",
"5.00",
"0.00",
"0.00",
"0.00",
"0.00"
]
},
{
"job_number": "33",
"transship": "NO",
"driver_name": "Driver 2",
"status": "Complete",
"reg_number": "AB12ABC",
"chassis_number": "555555",
"job_mileage": 11.9,
"expenses_submitted": "20/05/2022",
"date_delivered": "20/05/2022",
"total": "30.00",
"driver_pay": "54.00",
"expenses": [
"0.00",
"25.00",
"0.00",
"5.00",
"0.00",
"0.00",
"0.00",
"0.00"
]
}
],
"expenses": [
"Fuel Card",
"Fuel",
"Car Wash",
"Bus",
"Taxi",
"Tolls",
"Train",
"Other"
]
}
Sorry for no progress with this bug, I'm totally busy in 2022. Hope to be better in this matter soon.