Description: LibreOffice Vanilla 7.0.4.2 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 Version: 7.0.4.2 Build: 86854cc6f33e285facadff0644b2db752e193d8c Environment: CPU-threads: 8; OS: MacOS X 10.16 Regional scheme: de-DE; UI: de-DE Misc: Calc: threaded
after inserting the link into the dialog you should press Enter key on your keyboard. Please try it
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 7.1.4.2 on MacOS and LO 7.1.4.2 Windows.
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: 7.3.0.0.alpha0+ / 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: 7.1.5.2 / 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
Although the OK button is inactive, the import function works.
I think it's a dupe of the bug 114994 *** This bug has been marked as a duplicate of bug 114994 ***