You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/11/27 11:31:53 UTC

[Bug 121415] New: Cell content overlaps when exporting to PDF

https://issues.apache.org/ooo/show_bug.cgi?id=121415

            Bug ID: 121415
        Issue Type: DEFECT
           Summary: Cell content overlaps when exporting to PDF
    Classification: Application
           Product: spreadsheet
           Version: AOO 3.4.1
          Hardware: PC
                OS: Windows XP
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: save-export
          Assignee: issues@openoffice.apache.org
          Reporter: rc.openfeel@yahoo.com.sg
                CC: issues@openoffice.apache.org

Created attachment 79958
  --> https://issues.apache.org/ooo/attachment.cgi?id=79958&action=edit
The spreadsheet file that gets wrong when exported to PDF

When a cell content which is word-wrapped gets exported to PDF, the text inside
the cells may overlap with the next row.

I have looked at similar bug report, and it was advised to use printer metric
to solve this (http://wiki.openoffice.org/wiki/Calc/CellWrapping). However, I
tried using printer metric and the result still overlaps.

I attached the ods file.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 121415] Cell content overlaps when exporting to PDF

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121415

elish <el...@mail-page.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |CONFIRMED
                 CC|                            |elish@mail-page.com
     Ever confirmed|0                           |1

--- Comment #3 from elish <el...@mail-page.com> ---
The file that Robin attached is indeed printed overlapping.
However, a fresh spreadsheet made with Rev. 1400866 printed OK.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 121415] Cell content overlaps when exporting to PDF

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121415

--- Comment #2 from rc <rc...@yahoo.com.sg> ---
Created attachment 79960
  --> https://issues.apache.org/ooo/attachment.cgi?id=79960&action=edit
Exported PDF file (with print metric)

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 121415] Cell content overlaps when exporting to PDF

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121415

--- Comment #1 from rc <rc...@yahoo.com.sg> ---
Created attachment 79959
  --> https://issues.apache.org/ooo/attachment.cgi?id=79959&action=edit
Exported PDF file (without print metric)

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Issue 121415] Cell content overlaps when exporting to PDF

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121415

--- Comment #6 from rra <rr...@blue-elephant-systems.com> ---
Experiencing this issue also with the current 4.1.1 version (rev. 1617669).

Interestingly, the problem can be solved by simply copying and pasting the
complete contents of the problematic sheet to a new spreadsheet document,
specifically the steps are: 

1. Open the attached brokenPrintPreview.ods
2. Click cell A1 so it has the focus
3. Press CTRL-A, then CTRL-C to copy the complete sheet contents
4. Create a new spreadsheet document
5. Click cell A1 so it has the focus
6. Press Shift-Insert to paste

Even more interesting: Doing the same but pasting into a new sheet of the same
document will not solve the problem.

A visible difference between the cells in the original and the new document is
that in the new document, the text inside the affected cells spans 3 text rows,
where in the original sheet, the same text spanned only 2 rows (screenshot
attached, "Comparison of copy & pasted sheet contents.jpg").

Besides the PDF feature, the print preview has the same problem.

-- 
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.
You are watching all issue changes.

[Issue 121415] Cell content overlaps when exporting to PDF

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121415

--- Comment #7 from rra <rr...@blue-elephant-systems.com> ---
Created attachment 84308
  --> https://issues.apache.org/ooo/attachment.cgi?id=84308&action=edit
Comparison of copy & pasted sheet contents (2 vs. 3 text rows)

-- 
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.
You are watching all issue changes.

[Issue 121415] Cell content overlaps when exporting to PDF

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121415

--- Comment #5 from rra@blue-elephant-systems.com ---
Created attachment 84307
  --> https://issues.apache.org/ooo/attachment.cgi?id=84307&action=edit
New document with sheet content copied from the original one, no longer
overlapping text

-- 
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.
You are watching all issue changes.

[Issue 121415] Cell content overlaps when exporting to PDF

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121415

rra@blue-elephant-systems.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |rra@blue-elephant-systems.c
                   |                            |om

--- Comment #4 from rra@blue-elephant-systems.com ---
Created attachment 84306
  --> https://issues.apache.org/ooo/attachment.cgi?id=84306&action=edit
Original spreadsheet with overlapping text in PDF / print preview / ...

-- 
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.
You are watching all issue changes.