Bug 121151 - I get a line in print and pdf export that is not visible in my table FORMATTING, PRINTING
Summary: I get a line in print and pdf export that is not visible in my table FORMATTI...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.2.1 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-11-03 23:08 UTC by florin.arjocu
Modified: 2018-11-05 22:06 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
my table that once exported as pdf, gets one more page with an invisible line (22.21 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-11-03 23:09 UTC, florin.arjocu
Details
exported pdf with 2 pages instead of one (75.34 KB, application/pdf)
2018-11-03 23:10 UTC, florin.arjocu
Details

Note You need to log in before you can comment on or make changes to this bug.
Description florin.arjocu 2018-11-03 23:08:24 UTC
Description:
I have a table with my schedule. I have copied the text from a .doc file and arranged it in this table to be much better visible. I have days which correspond to even/odd week number and the subjects are split with a diagonal line. Should be simple, but when I export it to pdf, I get a 2-page layout instead of one, in the second I get an oblique line (like my odd/even week separator) which I have no idea where it comes from. In my file in Libre Office Calc is not visible, so I cannot fix it.

I use:
Version: 6.1.2.1
Build ID: 1:6.1.2-0ubuntu1

FORMATTING, PRINTING

Steps to Reproduce:
1. Open my file
2. Export pdf
3. See page 2, there is that line

Actual Results:
I get 2 pages instead of one and the second one has only an oblique line.

Expected Results:
Should only have a table, one-page table.


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
Comment 1 florin.arjocu 2018-11-03 23:09:44 UTC
Created attachment 146275 [details]
my table that once exported as pdf, gets one more page with an invisible line

my table that once exported as pdf, gets one more page with an invisible line
Comment 2 florin.arjocu 2018-11-03 23:10:35 UTC
Created attachment 146276 [details]
exported pdf with 2 pages instead of one

exported pdf with 2 pages instead of one
Comment 3 m_a_riosv 2018-11-04 00:47:42 UTC
There are cells on column D with spaces to the right, see cell D13. I think the source of the issue.

Even without deleting those space (better deleting them), adapt the column 'D' with by right click on the column head and selecting 'Optimal with'

Also page format it's defined to print at 100% scale, so reduce it, or on Menu/Format/Page [Sheet] change the scale to print to one different than 'Reduce/enlarge printout' to print 1 or 1x1 page.
Comment 4 florin.arjocu 2018-11-05 22:06:39 UTC
(In reply to m.a.riosv from comment #3)
> There are cells on column D with spaces to the right, see cell D13. I think
> the source of the issue.
> 
> Even without deleting those space (better deleting them), adapt the column
> 'D' with by right click on the column head and selecting 'Optimal with'
> 
> Also page format it's defined to print at 100% scale, so reduce it, or on
> Menu/Format/Page [Sheet] change the scale to print to one different than
> 'Reduce/enlarge printout' to print 1 or 1x1 page.

You are right, it was because of some space in D13, thank you. I was searching for that P character to see the spaces and blank lines, as I suspected it might be something like that, but I have no idea in which toolbar to find it, my screen does not show it.


But.. This still is only the local/individual fix. The problem is that what I see on screen does not fit the print, so I did not know what to edit. I should see that line or it should not be in the print.