Bug 167967 - External link to Google Sheets imports only first 100 rows
Summary: External link to Google Sheets imports only first 100 rows
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.2.5.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-08-15 17:17 UTC by tktf50-libreoffice
Modified: 2025-08-15 22:39 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Spreadsheet with external link demonstrating 100 row limitation (36.69 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-08-15 17:17 UTC, tktf50-libreoffice
Details

Note You need to log in before you can comment on or make changes to this bug.
Description tktf50-libreoffice 2025-08-15 17:17:33 UTC
Created attachment 202337 [details]
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.
Comment 1 m_a_riosv 2025-08-15 22:39:14 UTC
Reproducible
Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 7f4868348c14b305fcd75744e1e3544d0d3a5d61
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded

Doing the link to the download file as ODT, works just fine.
But on the web it is seen by LO as a web page.