Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG] #! DUMP_COLS should shift columns #210

Open
TheNoim opened this issue Mar 15, 2022 · 2 comments
Open

[BUG] #! DUMP_COLS should shift columns #210

TheNoim opened this issue Mar 15, 2022 · 2 comments
Assignees
Labels
BUG Something isn't working

Comments

@TheNoim
Copy link

TheNoim commented Mar 15, 2022

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
                }
        ]
}
@Siemienik Siemienik self-assigned this Mar 23, 2022
@Siemienik Siemienik added the BUG Something isn't working label Mar 23, 2022
@talktomedia-rob
Copy link

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

@Siemienik
Copy link
Owner

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
BUG Something isn't working
Projects
Status: Important
Development

No branches or pull requests

3 participants