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.

Sign up for GitHub

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

Jump to bottom

Reports: xlsx-report causes 'Index out of bounds' exception #1500

Closed
Gavrilov-Ivan opened this issue Mar 13, 2023 · 2 comments
Closed

Reports: xlsx-report causes 'Index out of bounds' exception #1500

Gavrilov-Ivan opened this issue Mar 13, 2023 · 2 comments
Assignees
@Gavrilov-Ivan @konyashkina
Labels
in: reports type: bug Something isn't working
Projects
Release 1.5
Milestone
1.5.1

Comments

@Gavrilov-Ivan
Copy link
Contributor

Gavrilov-Ivan commented Mar 13, 2023 •
edited
Loading

Report based on xlsx-template failed with 'Index out of bounds' exception if template has named range for band with empty cells and non-rendered rows before this band.

  1. Create xlsx-template with one named range for band started not from the begining of document (e.g. from B2). Last row(s) of this range should be empty.
  2. Create simple report with horizontal band refered to this named range.
  3. Run report.

Error occurs in XlsxFormatter#copyCells(BandData band, Range templateRange, List<Row> resultSheetRows, Row firstRow, Worksheet resultSheet) because of mismatch of row indexes between template and result sheet.

https://forum.jmix.io/t/xlsx-report-ranged-names-not-working/2650
@Gavrilov-Ivan Gavrilov-Ivan self-assigned this Mar 13, 2023
@Gavrilov-Ivan Gavrilov-Ivan changed the title Reports: xlsx-report causes 'Index out of bound' exception Reports: xlsx-report causes 'Index out of bounds' exception Mar 13, 2023
@Gavrilov-Ivan Gavrilov-Ivan mentioned this issue Mar 15, 2023
Closed
@Gavrilov-Ivan Gavrilov-Ivan added the type: bug Something isn't working label Mar 15, 2023
@Gavrilov-Ivan Gavrilov-Ivan added this to Backlog in Release 1.5 via automation Mar 22, 2023
@Gavrilov-Ivan Gavrilov-Ivan moved this from Backlog to Review in Release 1.5 Mar 22, 2023
@Gavrilov-Ivan Gavrilov-Ivan moved this from Review to In progress in Release 1.5 Mar 22, 2023
Gavrilov-Ivan added a commit that referenced this issue Mar 27, 2023
@Gavrilov-Ivan
Reports: xlsx-report causes 'Index out of bounds' exception. Update Y…
6491dd5 
…ARG version #1500
Gavrilov-Ivan added a commit that referenced this issue Mar 27, 2023
@Gavrilov-Ivan
Reports: xlsx-report causes 'Index out of bounds' exception. Update Y…
904a889 
…ARG version (Release 1.5) #1500
@Gavrilov-Ivan
Copy link
Contributor Author

Updated dependency: YARG 2.2.21

@Gavrilov-Ivan Gavrilov-Ivan moved this from In progress to QA in Release 1.5 Mar 27, 2023
@konyashkina
Copy link

Tested on
Jmix version: 1.5.999-SNAPSHOT
Jmix Studio plugin version: 1.5.1-231
IntelliJ version: IntelliJ IDEA 2023.1 (Ultimate Edition)

Release 1.5 automation moved this from QA to Done Apr 3, 2023
@gorbunkov gorbunkov added this to the 1.5.1 milestone Apr 5, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Gavrilov-Ivan Gavrilov-Ivan

@konyashkina konyashkina

Labels
in: reports type: bug Something isn't working
Projects
Release 1.5
  
Done
Milestone
1.5.1
Development

No branches or pull requests
3 participants
@gorbunkov @Gavrilov-Ivan @konyashkina