XToolset icon indicating copy to clipboard operation
XToolset copied to clipboard

[BUG] #! DUMP_COLS should shift columns

Open TheNoim opened this issue 2 years ago • 2 comments

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
                }
        ]
}

TheNoim avatar Mar 15 '22 11:03 TheNoim

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"
  ]
}

talktomedia-rob avatar Jun 14 '22 08:06 talktomedia-rob

Sorry for no progress with this bug, I'm totally busy in 2022. Hope to be better in this matter soon.

Siemienik avatar Jun 21 '22 08:06 Siemienik