Bug 120268 - [PDF] Export selection to PDF - wrong range
Summary: [PDF] Export selection to PDF - wrong range
Status: RESOLVED DUPLICATE of bug 120161
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.1.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2018-10-02 12:40 UTC by Wojtek
Modified: 2018-10-03 07:27 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
spreadsheet with example data (6.88 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-10-02 16:05 UTC, Wojtek 		Details
pdf with wrong output/range (7.53 KB, application/pdf)
2018-10-02 16:06 UTC, Wojtek 		Details
screenshot of what's been selected and what ranges Calc used (49.28 KB, image/png)
2018-10-02 16:07 UTC, Wojtek 		Details
selection export (138.26 KB, image/jpeg)
2018-10-02 17:30 UTC, Oliver Brinzing 		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 Wojtek 2018-10-02 12:40:27 UTC 
Description:
This started with LO Calc around 6.1.x release.

Exporting selection to PDF doesn't work as it uses wrong range (one starting from the beginning of the document)

Steps to Reproduce:
1. Create new spreadsheet
2. Type something into cels below default printing range block (in my case this falls between G/H columns and 53/54 rows)
3. Select those cells (for example range from E48:J60)
4. File -> Export to PDF, choose "Selection", confirm

Actual Results:
Output PDF doesn't have our selection but rather jest range starting from A1:G53

Expected Results:
Selected range should be included


Reproducible: Always


User Profile Reset: No



Additional Info:
Format -> Print Range -> Define seems to mark desired cells and export works correctly.

I would argue that exporting selection to PDF should not mark selected cells (i.e. leave dashed line in the spreadsheet)
Comment 1 Timur 2018-10-02 15:57:24 UTC 
Please attach sample document. Sounds like a duplicate of bug 119189.
Comment 2 Wojtek 2018-10-02 16:05:20 UTC 
Created attachment 145328 [details]
spreadsheet with example data
Comment 3 Wojtek 2018-10-02 16:06:06 UTC 
Created attachment 145329 [details]
pdf with wrong output/range
Comment 4 Wojtek 2018-10-02 16:07:11 UTC 
Created attachment 145330 [details]
screenshot of what's been selected and what ranges Calc used
Comment 5 Wojtek 2018-10-02 16:08:20 UTC 
It does look like it's related.

I attached example sheet, resulting PDF with wrong output and screenshot of the selection which I made and range that Calc used. I hope it sheds more light on the issue.
Comment 6 Oliver Brinzing 2018-10-02 17:30:54 UTC 
Created attachment 145333 [details]
selection export

i can confirm this.

only the first quadrant is exported.
printing the selection to pdf has same result.

please have a look at the attached picture.

Version: 6.1.2.1 (x64)
Build-ID: 65905a128db06ba48db947242809d14d3f9a93fe
CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; 
Gebietsschema: de-DE (de_DE); Calc:
Comment 7 Oliver Brinzing 2018-10-02 17:39:30 UTC 
export and pdf print was ok in LO 6.0.6.1
Comment 8 BogdanB 2018-10-02 18:16:53 UTC 
Isn't this a duplicate of this https://bugs.documentfoundation.org/show_bug.cgi?id=120161 but this have suplimentary printing to PDF?
Comment 9 Oliver Brinzing 2018-10-03 07:27:57 UTC 
(In reply to BogdanB from comment #8)
> Isn't this a duplicate of this
> https://bugs.documentfoundation.org/show_bug.cgi?id=120161 but this have
> suplimentary printing to PDF?

yes, looks like both issues have same root cause

*** This bug has been marked as a duplicate of bug 120161 ***