https://bugs.documentfoundation.org/show_bug.cgi?id=167967
Bug ID: 167967
Summary: External link to Google Sheets imports only first 100
rows
Product: LibreOffice
Version: 25.2.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 202337
--> https://bugs.documentfoundation.org/attachment.cgi?id=202337&action=edit
Spreadsheet with external link demonstrating 100 row limitation
I've been using a Google Sheet to track stock prices and importing that sheet
into Calc using an External Link for several years now. After the last update
of LibreOffice the link stopped working. I'm not sure if that is just a
coincidence because it seems that Google has changed how these external links
work.
Here is the original link URL that I used (which was working in a prior release
of Calc):
https://docs.google.com/spreadsheets/d/e/2PACX-1vTJ2FIXojgCbH1tg-L3dTAyYY8S2Ho7AEADyOtqofYXRh0tv_14BposZdE1R5b1iiWU3kZfgi2MXo-q/pubhtml
This link now produces no data in Calc.
I tried to fix this by copying the (new) link from Google Sheets and updating
the External Link in Calc. Here is the new URL:
https://docs.google.com/spreadsheets/d/111dYsDIMOhjkjSaJgrZ22-koATQNzLW-KaRDXAFZrYU/edit?usp=sharing
Note that this Sheet link is public so you can use it to reproduce the problem.
I am also attaching a simple spreadsheet to demonstrate the problem
(LimitedTo100Rows.ods).
Thanks for taking a look.
--
You are receiving this mail because:
You are the assignee for the bug.
