Bug 160663 - libreoffice calc suppose to support 1 million rows, 2023 version and 2024 ver. deletes rows beyond 65,000 rows when saved
Summary: libreoffice calc suppose to support 1 million rows, 2023 version and 2024 ver...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.2.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-04-14 22:45 UTC by frank48k
Modified: 2024-04-14 23:41 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description frank48k 2024-04-14 22:45:04 UTC 
Description:
libreoffice calc suppose to support 1 million rows, 2023 version and 2024 ver. deletes rows beyond 65,000 rows when saved

for pc windows ver., 2024 ver 24. downloaded today
previous ver. from 2023 had same problem

Steps to Reproduce:
1.I have a text file that's 7 megabytes, about 70,000 lines
2.paste in text file and it fills in 70,000 rows
3. save file as .xls (excel 97-2003 worksheet)

Actual Results:
all lines exceeding 65,500 lines deleted

Expected Results:
calc claims to support 1 million lines/rows.


Reproducible: Always


User Profile Reset: No

Additional Info:
not delete rows beyond 65,000
Comment 1 ady 2024-04-14 23:41:36 UTC 
LO 7.4 (and newer) supports up to 2^20 (1048576) rows.

XLSX and ODS file formats, when saved with LO 7.4 (and newer), can save that amount of rows.

But the XLS file format supports up to 2^16 (65536) rows, no matter which spreadsheet tool you would use.


This is not a bug.