Link to Google Sheet imports only first 100 rows

[sdickerson]

Hi,

I’ve been using LibreOffice Calc for some time to track some stock holdings. In order to update the stock prices automatically, I created a Google Sheet and linked it into one sheet in my spreadsheet. Up until a week ago, this worked fine. But now, without any changes to that spreadsheet, the sheet with the external link only shows the first 100 rows of the Google Sheet (there are actually 145 rows).

I see that someone else raised (the same?) issue about a year ago but never provided the information required to resolve the problem.

Here is my LibreOffice Calc version information:
Version: 25.2.5.2 (X86_64) / LibreOffice Community
Build ID: 03d19516eb2e1dd5d4ccd751a0d6f35f35e08022
CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: en-CA (en_CA); UI: en-US
Calc: threaded

Here is a link to the Google Sheet I’m using (it is public):
Stock Prices

And here is a spreadsheet demonstrating the problem. It contains only an external link to the Google Sheet:
LimitedTo100Rows.ods (38.4 KB)

I selected the “HTML_all” range in the link, so I expect to see all rows of the Google Sheet. Is there a bug in the latest release(s) of Calc or am I doing something wrong (maybe a change in the way these links work that I missed)?

Thanks.

[EarnestAl]

When I open your .ods then cell A1 starts with “This browser version is no longer supported. Please upgrade to a supported browser…” . I think I just see a cached copy of the sheet.

This question at Google seems very similar, Sharing link no longer works with LIBREOffice - Google Docs Editors Community I guess that google has made some changes, again.


Maybe this question helps, Google Finance work in Libreoffice - #2 by Wanderer

Otherwise, I suggest you post a bug report, How to Report Bugs in LibreOffice - The Document Foundation Wiki

[Wanderer]

@EarnestAl

Maybe this question helps

It seems there were recent changes, too:

Google Shared Links no longer work?!

I have multiple calc spreadsheets that rely on an external link to a google sheet for information to process that has been not working any longer. Has Google or Libreoffice changed something and why? Is there a way to get the same results or work around? This issue leaves my calc sheets useless.

[sdickerson]

Thanks EarnestAI.

It looks like others have seen the same problem. I’ll look into creating a bug report.

[sdickerson]

Thanks Wanderer. It looks like I need to create a bug report.