Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0051106Openbravo ERPA. Platformpublic2022-12-12 15:172022-12-19 15:53
Reporteraxelmercado 
Assigned ToTriage Platform Base 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50 
Target VersionFixed in VersionPR23Q1 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0051106: Unable to download some reports in "Excel Format" in Google Chrome browser for Chrome versions higher than 107
DescriptionWhen trying to download some manual reports in "Excel Format" in the new versions of Chrome, the report will hang and will not work.
Steps To ReproduceCan be tested on livebuilds.

1. Login and open the window named "Sales Invoice Dimensional Report"
2. Set the following in the parameters:
a) From Date: 01-11-2022
b) To Date: 30-11-2022
c) Organization: Paseo de la Cruz AGS
d) Select Dimention option as "Documento"
e) Currency: MXN
3. Click on button named "Excel Format" to run the report. The report will be loaded or the screen will go black (error).
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0051146PR22Q4.1 closed Triage Platform Base Unable to download any type of report in "Excel Format" in Google Chrome browser for Chrome versions higher than 107 
depends on backport 0051147PR22Q3.3 closed Triage Platform Base Unable to download any type of report in "Excel Format" in Google Chrome browser for Chrome versions higher than 107 
related to backport 00527473.0PR19Q3.3 closed Triage Platform Base Unable to download some reports in "Excel Format" in Google Chrome browser for Chrome versions higher than 107 
Attached Filespng Screenshot from 2022-12-12 16-44-28.png (100,822) 2022-12-12 16:49
https://issues.openbravo.com/file_download.php?file_id=17935&type=bug
png

png Screenshot from 2022-12-12 16-44-20.png (312,112) 2022-12-12 16:49
https://issues.openbravo.com/file_download.php?file_id=17936&type=bug
png Screenshot from 2022-12-12 16-50-35.png (271,533) 2022-12-12 16:50
https://issues.openbravo.com/file_download.php?file_id=17937&type=bug
png Screenshot from 2022-12-12 16-50-44.png (64,602) 2022-12-12 16:51
https://issues.openbravo.com/file_download.php?file_id=17938&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2022-12-12 15:17axelmercadoNew Issue
2022-12-12 15:17axelmercadoAssigned To => Triage Omni WMS
2022-12-12 15:59axelmercadoSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=25227#r25227
2022-12-12 16:49mtaalNote Added: 0144545
2022-12-12 16:49mtaalFile Added: Screenshot from 2022-12-12 16-44-28.png
2022-12-12 16:49mtaalFile Added: Screenshot from 2022-12-12 16-44-20.png
2022-12-12 16:50mtaalFile Added: Screenshot from 2022-12-12 16-50-35.png
2022-12-12 16:51mtaalFile Added: Screenshot from 2022-12-12 16-50-44.png
2022-12-12 16:51axelmercadoAssigned ToTriage Omni WMS => Triage Platform Base
2022-12-13 07:26alostaleSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=25232#r25232
2022-12-13 07:27alostaleStatusnew => acknowledged
2022-12-13 07:27alostalePriorityurgent => immediate
2022-12-13 07:28alostaleProjectModules => Openbravo ERP
2022-12-13 07:28alostaleModules => Core
2022-12-13 07:28alostaleTriggers an Emergency Pack => No
2022-12-13 07:28alostaleCategoryReporting => A. Platform
2022-12-13 10:14hgbotNote Added: 0144576
2022-12-13 16:58cbernerStatusacknowledged => scheduled
2022-12-14 07:31alostaleSummaryUnable to download any type of report in "Excel Format" in Google Chrome browser for Chrome versions higher than 107 => Unable to download some reports in "Excel Format" in Google Chrome browser for Chrome versions higher than 107
2022-12-14 07:31alostaleDescription Updatedbug_revision_view_page.php?rev_id=25245#r25245
2022-12-14 08:13hgbotResolutionopen => fixed
2022-12-14 08:13hgbotStatusscheduled => closed
2022-12-14 08:13hgbotFixed in Version => PR23Q1
2022-12-14 08:13hgbotNote Added: 0144614
2022-12-14 08:13hgbotNote Added: 0144615
2022-12-19 15:53cbernerNote Added: 0144823
2022-12-19 16:06cbernerNote Edited: 0144823bug_revision_view_page.php?bugnote_id=0144823#r25267
2023-06-15 04:07ivazquezRelationship addedrelated to 0052747

Notes
(0144545)
mtaal   
2022-12-12 16:49   
The error happens in very generic code. Reproducible on live builds, note the report/window name on live builds to try is: Sales Invoice Dimensional Report

The error happens in the javascript, the screenshots show where and what.
(0144576)
hgbot   
2022-12-13 10:14   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/786 [^]
(0144614)
hgbot   
2022-12-14 08:13   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 07ebe43657c563051cf159b2fb33596d21334797
Author: Asier Lostalé <asier.lostale@openbravo.com>
Date: 13-12-2022 17:38:44
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/07ebe43657c563051cf159b2fb33596d21334797 [^]

Fixes ISSUE-51106: cannot download Excel report in Chrome

Excel is exported by opening a new tab/popup with a set target to
_blank.

This worked before chrome version 107, but it does not work anymore. The
main reason is that target=_blank implies that the new window will not
be able to access window.opener object(it will be null). To avoid this
problem, we set target=null when target is _blank, this allows us to
keep the old behaviour.

---
M src/org/openbravo/erpCommon/security/Login.html
M web/js/utils.js
---
(0144615)
hgbot   
2022-12-14 08:13   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/786 [^]
(0144823)
cberner   
2022-12-19 15:53   
(edited on: 2022-12-19 16:06)
Issue was related with the following changes done in chrome: https://bugs.chromium.org/p/chromium/issues/detail?id=1168591#c3 [^] and https://chromium-review.googlesource.com/c/chromium/src/+/3754790 [^]

This changes were done due to the following change in the html spec: https://github.com/whatwg/html/issues/4078 [^]

https://bugs.chromium.org/p/chromium/issues/detail?id=898942 [^]