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

[14.0] excel_import_export - Having multiple cells with the same value makes the exported file have a duplicated amount of rows #3040

Open
NathanQj opened this issue Sep 30, 2024 · 0 comments
Labels

Comments

@NathanQj
Copy link

Module

excel_import_export

Describe the bug

When creating an Export model with "Easy Reporting", if multiple Cells in the export mapping share the same value, then the generated Excel file will have duplicated rows (multiplication factor being the number of time a value is repeated in the mapping).

For example :
If I have an Easy Report for product.template with 9 records and the following mapping:
A1 -> default_code -> ${value or ""}
B1 -> default_code -> ${value or ""}
C1 -> default_code -> ${value or ""}
D1 -> name -> ${value or ""}

Then the generated file will have:
27 rows with A, B and C filled with the value of default_code
9 rows with D correctly filled with the value of name

To Reproduce

14.0:

Steps to reproduce the behavior:

  1. Create a new XLSX Template
  2. Check "Easy Reporting"
  3. Add a Report Model (e.g "product.template")
  4. Fill the Export tab (export_ids field) with the example given above (X columns with the same value, X greater than 1)

Expected behavior
The number of rows should remain consistent with the number of records exported.
Capture d'écran 2024-09-30 164306
Capture d'écran 2024-09-30 164110

@NathanQj NathanQj added the bug label Sep 30, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant