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

Cross Tab report generates corrupted xlsx file #239

Closed
longirun opened this issue Jan 14, 2020 · 0 comments
Closed

Cross Tab report generates corrupted xlsx file #239

longirun opened this issue Jan 14, 2020 · 0 comments
Assignees
Labels
state: fixed Fixed by the developer type: bug Something isn't working ver: 7.1.4 Fixed in version ver: 7.2.0 Fixed in version ver: 7.3.0 Fixed in version
Milestone

Comments

@longirun
Copy link

Important

Before this issue, the following one should be fixed: 238.

Environment

com.haulmont.reports: 7.1.0

Description of the bug

Run report GridExportReport.zip

Generated file Шахматка (22).xlsx is corrupted:

Now and then, workbooks get damaged. In this case, we made some temporary repairs so that you can open it in Reading View.
Hide technical details

Repaired Part: /xl/worksheets/sheet1.xml part with XML error.  Catastrophic failure Line 18, column 27.

Datasets for Band apartments, apartments_dynamic_header and apartments_master_data are empty.

To reproduce the issue, do following:

Edit -> Root -> apartments -> Bands
Replace Band apartments returning value

return AppBeans.get('tgrealestate_GridExportReportService')
               .getApartmentsRowData(realtyObject, manager, developer, contractor)

with
return []

Replace Band apartments_dynamic_header returning value

return AppBeans.get('tgrealestate_GridExportReportService')
               .getApartmentsDynamicHeaderRowData(realtyObject, manager, developer, contractor)

with
return [['roomNum': '']]
Replace Band apartments_master_data returning value

return AppBeans.get('tgrealestate_GridExportReportService')
               .getFloorNumbers(realtyObject, manager, developer, contractor)

with
return [['floorNum': '']]
3. Run report.

AR: Microsoft Office reports corrupted file (LibreOffice does not report any issues)
ER: File is ok.

Possible fix (actually bad solution, a better one should be found) attached in file TgCrossTabExtractionController.zip.

@knstvk knstvk added the type: bug Something isn't working label Jan 20, 2020
@andreysubbotin andreysubbotin added this to the Release 7.1 milestone Jan 20, 2020
NikitaShchienko added a commit to cuba-platform/yarg that referenced this issue Jan 29, 2020
@natfirst natfirst added ver: 7.1.4 Fixed in version ver: 7.2.0 Fixed in version ver: 7.3.0 Fixed in version state: fixed Fixed by the developer labels Jan 30, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
state: fixed Fixed by the developer type: bug Something isn't working ver: 7.1.4 Fixed in version ver: 7.2.0 Fixed in version ver: 7.3.0 Fixed in version
Projects
None yet
Development

No branches or pull requests

6 participants