Bug 162810 - Opening .xlsx file in calc and it's scrolled to the 31st row, when exporting to PDF with "Whole sheet export" all rows above the 31st are not visible
Summary: Opening .xlsx file in calc and it's scrolled to the 31st row, when exporting ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: ARM macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: PDF-Export
  Show dependency tree / graph
 
Reported: 2024-09-05 13:56 UTC by Caleb Meredith
Modified: 2024-12-07 11:51 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
input.xlsx (7.19 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-09-05 13:56 UTC, Caleb Meredith 		Details
actual.pdf (25.26 KB, application/pdf)
2024-09-05 13:57 UTC, Caleb Meredith 		Details
View All 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 Caleb Meredith 2024-09-05 13:56:16 UTC 
Description:
When opening the attached .xlsx file in LibreOffice it's scrolled to the 31st row (Carla Trumbull) and the cursor is at K46. Consistently every time. When exporting this file to PDF with "Whole sheet export" enabled, half the PDF is blank white (all rows above the 31st).

(PRINTING, FILEOPEN)

Steps to Reproduce:
1. Open the attached .xlsx file
2. Select File > Export as PDF
3. Make sure "Whole sheet export" is selected

Actual Results:
The exported .pdf file is half blank (see attached .pdf file) and when the .xlsx file was opened we were automatically scrolled to the 31st row.

Expected Results:
All rows are visible in the exported .pdf


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Version: 24.8.0.3 (AARCH64) / LibreOffice Community
Build ID: 0bdf1299c94fe897b119f97f3c613e9dca6be583
CPU threads: 10; OS: macOS 14.2.1; UI render: Skia/Metal; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 1 Caleb Meredith 2024-09-05 13:56:49 UTC 
Created attachment 196254 [details]
input.xlsx
Comment 2 Caleb Meredith 2024-09-05 13:57:29 UTC 
Created attachment 196255 [details]
actual.pdf

The .pdf I get when exporting with "Whole sheet export" enabled.
Comment 3 viktoriia.strekalovskaia 2024-12-04 13:30:03 UTC 
Thank you for reporting the bug. I can confirm that the bug is present in

Version: 24.8.3.2 (AARCH64) / LibreOffice Community
Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92
CPU threads: 8; OS: macOS 14.5; UI render: Skia/Metal; VCL: osx


Version: 25.2.0.0.alpha0+ (AARCH64) / LibreOffice Community
Build ID: 7713d916e06a8388f849a758f928cbcfded6c0ae
CPU threads: 8; OS: macOS 14.5; UI render: Skia/Metal; VCL: osx
Comment 4 viktoriia.strekalovskaia 2024-12-04 14:08:53 UTC 
when I copied all the table data into a new .ods file, such a bug did not occur.