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 2014/02/06 20:55:26 UTC

[Bug 124198] New: [CALC] Page Footer: (Bad) print Rresult differs heavily from (good) print preview

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

            Bug ID: 124198
        Issue Type: DEFECT
           Summary: [CALC] Page Footer: (Bad) print Rresult differs
                    heavily from (good) print preview
           Product: Calc
           Version: 4.0.0
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: printing
          Assignee: issues@openoffice.apache.org
          Reporter: kurt.pfeifle@gmail.com
                CC: issues@openoffice.apache.org

Created attachment 82516
  --> https://issues.apache.org/ooo/attachment.cgi?id=82516&action=edit
ODS file to demonstrate the bug

When printing a Calc sheet, the page footer print RESULT differs badly from the
(correctly looking) print PREVIEW. The same problem as with the printout result
can be seen with PDF export.

I found 2 major problems, both of which may be interdependent:

* The font does not really look like it does in the preview (it takes more 
  horizontal space).
* The footer runs gets cut off on the right side and is printed incompletely.

Attached are:

  1. One sample ODS file (which was used in an attempt to create a 
     letterhead template for myself).
  2. A screenshot showing the print preview of the footer area.
  3. Another showing the actual print result.


Further notes:
==============

  * This used to work with previous versions of OpenOffice.
  * After upgrading to OpenOffice 4.x, it stopped to work.
  * The same is true for LibreOffice, BTW: it used to work with 3.x, stopped
    working with 4.0.x.

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

[Bug 124198] [CALC] Page Footer: (Bad) print Rresult differs heavily from (good) print preview

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

--- Comment #1 from kurt.pfeifle@gmail.com ---
Created attachment 82517
  --> https://issues.apache.org/ooo/attachment.cgi?id=82517&action=edit
Screenshot of print preview (footer area)

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

[Bug 124198] [CALC] Page Footer: (Bad) print Rresult differs heavily from (good) print preview

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

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |CONFIRMED
             Latest|---                         |4.1-dev
    Confirmation on|                            |
     Ever confirmed|0                           |1

--- Comment #4 from Edwin Sharp <el...@apache.org> ---
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1562493
Rev.1562493
Win 7

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

[Bug 124198] [CALC] Page Footer: (Bad) print Rresult differs heavily from (good) print preview

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

--- Comment #2 from kurt.pfeifle@gmail.com ---
Created attachment 82518
  --> https://issues.apache.org/ooo/attachment.cgi?id=82518&action=edit
Screenshot of print result (footer area)

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

[Bug 124198] Page Footer: wrong font and truncated at the right

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

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|elish@apache.org            |

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

[Bug 124198] Page Footer: wrong font and truncated at the right

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

--- Comment #14 from kurt.pfeifle@gmail.com ---
I've now re-tested:

 - with the original ODS file attached to this bug
 - on a Windows 7 system 
 - running PortableApps-based AOO 3.2.0
 - while the Droid fonts where not installed on the system
 - using the native PDF-export capability of AOO.

The PDF which was created has (according to `pdfinfo`) all fonts embedded as a
subset:

 * LaoUI
 * LaoUI-Bold
 * Trebuchet-BoldItalic
 * ArialMT

Printout/PDF-export and page preview look identical (though not too similar to
the original file -- but that's to be expected). More important, the
printout/PDF-export does not show a truncated footer.

For comparison, here are the original fonts used on the system that created the
ODS:

  * DroidSans
  * DroidSans-Bold

Later tonight I'll re-test with the DroidSans font installed on the same Win7
system.

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

[Bug 124198] Page Footer: wrong font and truncated at the right

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

--- Comment #8 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
Also worked fine for me on a different WIN XP PC with AOO 4.0.1 an HP 895C.
Strange!

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

[Bug 124198] Page Footer: wrong font and truncated at the right

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

--- Comment #19 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
kurt.pfeifle:
Any new knowledge here? Of course there is no need that we clarify all details
here, but we should be able to know how to make the problem reproducible. May
be Edwin can help, he at least saw a notable effect in his footer.

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

[Bug 124198] [CALC] Page Footer: (Bad) print Rresult differs heavily from (good) print preview

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

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |elish@apache.org

--- Comment #3 from Edwin Sharp <el...@apache.org> ---
Created attachment 82519
  --> https://issues.apache.org/ooo/attachment.cgi?id=82519&action=edit
footer comparison

top: page preview at 100% zoom
bottom: SumatraPDF 2.3.2 at 100% zoom

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

[Bug 124198] Page Footer: wrong font and truncated at the right

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

--- Comment #17 from kurt.pfeifle@gmail.com ---
Created attachment 82529
  --> https://issues.apache.org/ooo/attachment.cgi?id=82529&action=edit
Screenshot No. 3 showing footer settings with Droid font

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

[Bug 124198] Page Footer: wrong font and truncated at the right

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

--- Comment #11 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
(In reply to kurt.pfeifle from comment #10)
I use that phrase due to old Bugzilla But status
<https://issues.apache.org/ooo/page.cgi?id=fields.html#bug_status>

Works for me means "no problems here, I can not reproduce the bug"

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

[Bug 124198] Page Footer: wrong font and truncated at the right

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

--- Comment #18 from kurt.pfeifle@gmail.com ---
@Rainer:

Talking about "preview thoughts leading to nowhere ... being too subjective"...
your attachment #82524 is nice, thanks for the effort!

Both shots look similar enough, but that is "subjective" too (and valuable at
that!) -- but please complement it with some "hard facts":

 * After all, you created 2 PDFs in 2 different environments -- one with Droid
   Sans installed, one without; so you have the PDF files.

 * Can you please post the results of `pdffonts name.pdf` for both? In case the
   file from the situation without DroidSans installed gets reported as using
   a non-embedded font, please also run `pdffonts -subst name.pdf` on it. (I 
   asked for that before, maybe you overlooked this request.) This may help me
   determine a setup of my workflow where I can substitute my footer with that
   font without sacrificing all my other document looks to this bug...

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

[Bug 124198] Page Footer: wrong font and truncated at the right

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

--- Comment #13 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
Created attachment 82524
  --> https://issues.apache.org/ooo/attachment.cgi?id=82524&action=edit
Screenshot Comparison with/without Droid Font installed

Hm, currently Droid Sans from
<http://www.schriftarten-fonts.de/d/12824/droid_sans.zip> for me does not
produce the problem for me, PDF print and ral printer print also looks fine
after having installed Droid.

@Kurt:
I think the page preview thoughts currently lead to nowhere, results of
investigation are too subjective. But at least I can see in your picture
"2014-02-06 20:56 CET, kurt.pfeifle@gmail.com" that font looks like some
"Extreme Droid Sans Mono"

Do you reproduce the problem with a free PDF-Creator or even better with AOO
PDF export? Comparison of the resulting PDF documents should lead to
discoveries more easy.

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

[Bug 124198] Page Footer: wrong font and truncated at the right

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

--- Comment #9 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
The remarkable font Edwin observed when he prints the document seems to be the
most promising indication to find out the roots of the problem and to make the
problem reproducible more reliable. Any idea what might happen there?
Unfortunately the problem also an a third WIN7 PC is not reproducible for me. 

Or may be it's reproducible for me on all PC, but in a way that it does not
cause any problem because the font in page footer is very similar to the
expected one?

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

[Bug 124198] Page Footer: wrong font and truncated at the right

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

--- Comment #15 from kurt.pfeifle@gmail.com ---
Created attachment 82527
  --> https://issues.apache.org/ooo/attachment.cgi?id=82527&action=edit
Screenshot No. 1 showing footer settings with Droid font

Here are 3 screenshots showing the exact font setup used by my footer. 

Yes, there were some non-standard setting enabled. This setting worked on this
very system with previous versions of AOO and OO.org (as well as with
LibreOffice) for more than 2 years (I started to use this template in July
2011).

After...

   *  ...trying to remove the specific font scaling settings ("Breite
skalieren"), 
         putting it at 100%,
   *  ...trying to remove the specific font spacing settings ("Laufweite
schmal"),
         setting it to "Standard",
   *  ...trying to disable the "Pair kerning" feature.

...I still see truncation on the right side of the printed /PDF-exported footer
(though the effect is not as heavy as it used to be with the previous setting).

What was interesting is this: for the right part of the footer (right pane in
'screenshot 2') I could remove my custom setting without a problem. Any changes
were displayed instantly in the preview. Removing the custom settings from my
left footer part (left pane in 'screenshot 2') turned out to be impossible: the
UI seemed to have accepted all the changes, but the preview remained the old
one (condensed look of the Droid font). 

With the new settings for the footer font in the printouts...

  ...the condensed look of the left footer part remains,
  ...the right footer part looks now like standard Droid Sans,
  ...but the right footer part is still truncated, but not so heavily.

After all, this may be a bug not directly rooted in AOO or in LO -- it may be
caused by some change in FreeType and may affects only certain fonts.

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

[Bug 124198] Page Footer: wrong font and truncated at the right

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

--- Comment #10 from kurt.pfeifle@gmail.com ---
@Rainer: when you say "works for me" that means -- you can create a PDF which
uses a font looking very similar to the ones seen in my screenshots, and there
is no truncation on the right side of the footer, right? Can you please employ
`pdffonts` and `pdffonts -subst` (recent Poppler versions) to get and report
the font name(s) you see?

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

[Bug 124198] Page Footer: wrong font and truncated at the right

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

Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |needmoreinfo
             Status|CONFIRMED                   |UNCONFIRMED
                 CC|                            |rainerbielefeld_ooo_qa@biel
                   |                            |efeldundbuss.de
            Summary|[CALC] Page Footer: (Bad)   |Page Footer: wrong font and
                   |print Rresult differs       |truncated at the right
                   |heavily from (good) print   |
                   |preview                     |
     Ever confirmed|1                           |0

--- Comment #6 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
This report is not in state CONFIRMED, for example because of 
* no meaningful Summary, I corrected that

Still to be done
* Limited to footer or also a problem with Header, normal cells?
* This might be caused by different "not existing font replacement" or what
ever
  else, we need some more research

Wee need to be careful with AOO's limited Developer resources and do the QA
research as careful as possible.

Additional info:
(a) Edwin's footer comparison shows a much bigger difference in Printout than
  reporters, we should try to find out reasons
(b) NOT reproducible with "AOO 4.0.1 – German UI / German locale 
   [Rev. 1524958 2013-09-20 11:40:29]" on German WIN7 Home Premium (64bit)", 
   “historic” 4.0 User Profile used for all predecessor versions
   Print via FreePDF looks fine, also Print with Samsung CLX-3185 looks fine,
   no truncation.
(c) Might be font / Font replacement related. Contents and footer are with font
    Droid Sans, what is not available on my PC
(d) But I would expect that such problems should also be visible 
    in page and print preview
(e) this might be a regression, but we need to know ore concerning the roots
    of the problem

@Edwin:
If I understand your comment 5 correctly you also reproduce the problem with
3.0.1? That would differ from reporter's result "worked with older versions"
and might show a setting relation.
Do you have Droid Sans available on you Computer? If not, can you find out with
what it will be replaced for Printout in cells and in footer?


@kurt.pfeifle@gmail.com
What's your printer?
Your secreenshot shows Page preview, not Print preview. What's your result in
print preview (in print dialog)?
What's your operating system?
3.x is too imprecise, what versions did you test? AOO 3.4.1

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

[Bug 124198] Page Footer: wrong font and truncated at the right

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

kurt.pfeifle@gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #82517|0                           |1
        is obsolete|                            |

--- Comment #7 from kurt.pfeifle@gmail.com ---
Created attachment 82523
  --> https://issues.apache.org/ooo/attachment.cgi?id=82523&action=edit
Screenshot of print dialog with print preview (complete page)

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

[Bug 124198] Page Footer: wrong font and truncated at the right

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

--- Comment #12 from kurt.pfeifle@gmail.com ---
@Rainer: I understand. But that's not what I asked.  :-)

I didn't express myself clearly enough, so let me re-state: *of course* you are
not able to reproduce the bug as I see it, because you are not testing the file
under the same condition(s): having installed the Droid font(s) on your system
will create a *different* environment.

Please re-consider my questions (I myself want to understand what's going on):

 * You Page Preview shows a font *similiar* to my Droid? (Can you identify 
   which one?)

 * Your printout or PDF shows a font *identical* to your preview? (You should
   be able to identify the PDF font with `pdffonts -subst the.pdf`...)

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

[Bug 124198] Page Footer: wrong font and truncated at the right

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

--- Comment #16 from kurt.pfeifle@gmail.com ---
Created attachment 82528
  --> https://issues.apache.org/ooo/attachment.cgi?id=82528&action=edit
Screenshot No. 2 showing footer settings with Droid font

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

[Bug 124198] [CALC] Page Footer: (Bad) print Rresult differs heavily from (good) print preview

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

--- Comment #5 from Edwin Sharp <el...@apache.org> ---
Created attachment 82520
  --> https://issues.apache.org/ooo/attachment.cgi?id=82520&action=edit
footer comparison

Like previous but with OpenOffice.org 3.0.1

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