#15379: Open workbook action should first instantiate a dummy workbook

SachinPrakash reported 2017-07-12T21:36:13Z · last modified 2018-02-08T16:29:20Z

Open workbook action should first instantiate a dummy workbook

Dev	kunalkalbande
QA	nhilam

Priority	Low
Complexity	Unknown

Component	Visual Analytics
Version	18.5

Open a VA workbook. With this workbook having focus, choose to open another workbook. Lets say this 2nd workbook takes 30 seconds to open due to query execution time being very long. A modal dialog is presented saying "opening workbook..." and I'm unable to interact w/ the first workbook during this time.

Explanation:

The query execution happens asynchronously. It is the File > Open workbook process which requires a modal window. You can do the following as a workaround:

Open a New VA workbook (File > New). Any time you want to load a workbook, switch to this empty workbook & then open an existing workbook. This will prevent you from accessing the empty workbook but all other open workbooks can still be used.

Enhancement: We should first create a new "dummy" empty workbook & then show the modal "opening workbook..." on top of this "dummy" workbook. This way, you wouldn't need to perform the workaround I suggested above.

1 attachment

v19.vizx

2017-10-05T01:23:46Z

634 KB

All Comments (5) Change History

nhilam 2017-09-07T01:21:16Z

The following queries against SQL Server will cause a long execution:

WAITFOR DELAY '00:00:20'
select * from Sales.Customer

The following queries against SQL Server will cause a long execution:

WAITFOR DELAY '00:00:20'
select * from Sales.Customer

supriyasarade 2017-10-04T13:25:22Z

This issue is verified on Build no.: ads-windows-x64-18.5.0-dev-8.

nhilam 2017-10-05T03:57:17Z · (edited)

The code changes look good. However the follow scenario fails:

From ADS, open the attached v19.vizx workbook.
A "Newer Version Workbook" confirmation dialog box is displayed because the workbook is of a newer version than the current release.
Click the No button.

Result: The workbook is not opened, which is correct. However the "dummy" VA window remains open, which is incorrect.

Expected: When I select not to open the workbook, the dummy window should be closed.

Note: Going forward, please enter the SVN revision number for each issue in a comment so that it is clear what code changes are being reviewed.

supriyasarade 2017-10-06T08:43:20Z

This issue is verified on Build no.: ads-windows-x64-18.5.0-dev-11.

sagarzond 2017-10-10T06:05:50Z

Nhi,

The code changes look good. However the follow scenario fails:

From ADS, open the attached v19.vizx workbook.
A "Newer Version Workbook" confirmation dialog box is displayed because the workbook is of a newer version than the current release.
Click the No button.

Result: The workbook is not opened, which is correct. However the "dummy" VA window remains open, which is incorrect.

Expected: When I select not to open the workbook, the dummy window should be closed.

[SZ] : Solved

Search Tips

Aqua Data Studio / nhilam

Open workbook action should first instantiate a dummy workbook

1 attachment

Issue #15379

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Open workbook action should first instantiate a dummy workbook

1 attachment

Issue #15379

Completion