Bug 139300 - Button OK isn't active when you try load content from external source
Summary: Button OK isn't active when you try load content from external source
Status: RESOLVED DUPLICATE of bug 114994
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: ARM macOS (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2020-12-29 08:11 UTC by Matthias Pförtner
Modified: 2021-11-23 18:49 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Matthias Pförtner 2020-12-29 08:11:47 UTC
LibreOffice Vanilla on macOS Big Sur 11.1, Mac mini M1, 2020.

Since a few days access to GDRIVE is gone. I have used in LibreOffice Calc for many years the access to an external data source to import current share prices provided by Google Sheet. This access is not possible anymore although I didn't change my Calc spreadsheet to import this data.

When I try to define a new access in a blank LO Calc sheet by using table -> Link to external data -> URL of the external data source, I cannot press OK button to load the contents of my GOOGLE sheet.

Steps to Reproduce:
1.Create GOOGLE sheet on GDRIVE and share URL via clipboard
2.Go to LO Calc and define access to external data source. Copy URL to dialog box
3.OK button is not active to load contents in LO Calc

Actual Results:
OK button of dialog box is inactive

Expected Results:
OK button should be active and allow import of external data from GDRIVE into LO Calc.

Reproducible: Always

User Profile Reset: No

Additional Info:
LibroOffice Vanilla
Build: 86854cc6f33e285facadff0644b2db752e193d8c
Environment: CPU-threads: 8; OS: MacOS X 10.16
Regional scheme: de-DE; UI: de-DE
Misc: Calc: threaded
Comment 1 Roman Kuznetsov 2021-07-30 14:22:04 UTC
after inserting the link into the dialog you should press Enter key on your keyboard. Please try it
Comment 2 Matthias Pförtner 2021-08-02 08:59:09 UTC
This is working on LibreOffice for Windows only. I have created under Windows the Calc file with the access to the external data source on GDRIVE and it is working as explained. When I try to open this file on a shared drive under LO Vanilla on M1 MacOS, it is said the the "link couldn't be updated". I am using presently LO Vanilla on MacOS and LO Windows.
Comment 3 Denys Prokhorov 2021-08-03 08:33:41 UTC
no repro

The OK button is really inactive.

My steps:
1.Create a new LibreOffice Calc document.
2.Click on a cell in the table (A1 for example)
3.Go to Sheet ▸ Link to external data.
4.The External Data dialog opens. 
- In the field ▸ URL of external data source - inserted my URL Google Sheet.
5. Tap Enter (OK button is not active).
- A dialog box will open (Select the Language to Use for Import).
6.Choose language.
7. Tap the button OK

Additional Info:
Version: / LibreOffice Community
Build ID: 246f24ebc8227345f13784d9e2f055d813f3d24f
CPU threads: 12; OS: Mac OS X 10.15.7; UI render: default; VCL: osx
Locale: ru-RU (ru_UA.UTF-8); UI: en-US
Calc: threaded

Version: / LibreOffice Community
Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5
CPU threads: 12; OS: Mac OS X 10.15.7; UI render: default; VCL: osx
Locale: ru-RU (ru_UA.UTF-8); UI: en-US
Calc: threaded
Comment 4 Denys Prokhorov 2021-08-03 09:23:44 UTC
Although the OK button is inactive, the import function works.
Comment 5 Roman Kuznetsov 2021-11-23 18:49:52 UTC
I think it's a dupe of the bug 114994

*** This bug has been marked as a duplicate of bug 114994 ***