Bug 134229 - Rows above viewport in scrolled down XLSX not included in PDF when using "whole sheet export"
Summary: Rows above viewport in scrolled down XLSX not included in PDF when using "who...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Printing and PDF export (show other bugs)
Version:
(earliest affected)
6.4.0.0.alpha0+
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx, implementationError
Depends on:
Blocks: PDF-Export
  Show dependency treegraph
 
Reported: 2020-06-22 13:16 UTC by tadas
Modified: 2024-03-07 02:12 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
File necessary to reproduce the bug (5.49 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-06-22 13:17 UTC, tadas
Details
PDF output of the converted xlsx file (7.22 KB, application/pdf)
2020-06-22 13:17 UTC, tadas
Details

Note You need to log in before you can comment on or make changes to this bug.
Description tadas 2020-06-22 13:16:46 UTC
Description:
I have a .xlsx document with ~60 lines. I scroll down for line 25 to be at the top, save the file, export the file to PDF using the 'full sheet preview' option. The result PDF file only contains content from lines 25 and down, no content on top of line 25 is visible, you can only see blank space.

Steps to Reproduce:
1. Open up the .xlsx file I attached to the bug
2. Scroll down so that line 25 would be at the top of the page if it's not already there
3. Ctrl+s to save the document (not sure if necessary)
4. Click file->export as pdf
5. Check 'Whole sheet export'
6. Click Export
7. Open up the PDF (I attached my own exported pdf to the bug)

Actual Results:
Lines 1-24 are not visible in the PDF

Expected Results:
All lines are visible in the PDF


Reproducible: Sometimes


User Profile Reset: Yes



Additional Info:
Version: 6.4.2.2
Build ID: 4e471d8c02c9c90f512f7f9ead8875b57fcb1ec3
CPU threads: 12; OS: Linux 5.4; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 1 tadas 2020-06-22 13:17:15 UTC
Created attachment 162305 [details]
File necessary to reproduce the bug
Comment 2 tadas 2020-06-22 13:17:34 UTC
Created attachment 162306 [details]
PDF output of the converted xlsx file
Comment 3 Buovjaga 2020-10-30 14:08:09 UTC
I tested with Linux 6.4 bibisect repo and the problem was there already. The feature was implemented in 6.4. Also seen on Windows.

It doesn't help, if you scroll up. It still leaves rows 1-24 as blank. I don't reproduce with a fresh file.

Arch Linux 64-bit
Version: 7.1.0.0.alpha1+
Build ID: 1a4ae360d06ae300a8fd5482b3b3a86dc021750d
CPU threads: 8; OS: Linux 5.9; UI render: default; VCL: kf5
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 30 October 2020
Comment 4 QA Administrators 2022-10-31 03:33:29 UTC Comment hidden (obsolete)
Comment 5 Stéphane Guillou (stragu) 2024-03-07 02:12:11 UTC
Does not happen with file saved as ODS.

To reproduce on any row:
1. scroll to whatever position that hides rows above viewport
2. save file
3. _reload_
4. export as whole sheet

Still the case in recent trunk build:

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 9574a62add8e4901405e12117e75c86c2d2c2f21
CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: CL threaded