Issue 124198 - Page Footer: wrong font and truncated at the right
Summary: Page Footer: wrong font and truncated at the right
Alias: None
Product: Calc
Classification: Application
Component: printing (show other issues)
Version: 4.0.0
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needmoreinfo
Depends on:
Reported: 2014-02-06 19:55 UTC by kurt.pfeifle
Modified: 2014-02-20 16:37 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

ODS file to demonstrate the bug (25.19 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-02-06 19:55 UTC, kurt.pfeifle
no flags Details
Screenshot of print preview (footer area) (25.86 KB, image/png)
2014-02-06 19:56 UTC, kurt.pfeifle
no flags Details
Screenshot of print result (footer area) (25.58 KB, image/png)
2014-02-06 19:56 UTC, kurt.pfeifle
no flags Details
footer comparison (28.24 KB, image/jpeg)
2014-02-06 20:20 UTC, Edwin Sharp
no flags Details
footer comparison (29.12 KB, image/jpeg)
2014-02-06 20:27 UTC, Edwin Sharp
no flags Details
Screenshot of print dialog with print preview (complete page) (141.25 KB, image/png)
2014-02-07 02:50 UTC, kurt.pfeifle
no flags Details
Screenshot Comparison with/without Droid Font installed (135.19 KB, application/
2014-02-07 08:58 UTC, Rainer Bielefeld
no flags Details
Screenshot No. 1 showing footer settings with Droid font (71.39 KB, image/png)
2014-02-07 12:55 UTC, kurt.pfeifle
no flags Details
Screenshot No. 2 showing footer settings with Droid font (56.39 KB, image/png)
2014-02-07 12:56 UTC, kurt.pfeifle
no flags Details
Screenshot No. 3 showing footer settings with Droid font (52.21 KB, image/png)
2014-02-07 12:57 UTC, kurt.pfeifle
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description kurt.pfeifle 2014-02-06 19:55:26 UTC
Created attachment 82516 [details]
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.
Comment 1 kurt.pfeifle 2014-02-06 19:56:13 UTC
Created attachment 82517 [details]
Screenshot of print preview (footer area)
Comment 2 kurt.pfeifle 2014-02-06 19:56:56 UTC
Created attachment 82518 [details]
Screenshot of print result (footer area)
Comment 3 Edwin Sharp 2014-02-06 20:20:56 UTC
Created attachment 82519 [details]
footer comparison

top: page preview at 100% zoom
bottom: SumatraPDF 2.3.2 at 100% zoom
Comment 4 Edwin Sharp 2014-02-06 20:21:42 UTC
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1562493
Win 7
Comment 5 Edwin Sharp 2014-02-06 20:27:36 UTC
Created attachment 82520 [details]
footer comparison

Like previous but with 3.0.1
Comment 6 Rainer Bielefeld 2014-02-06 21:51:11 UTC
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

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?
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
Comment 7 kurt.pfeifle 2014-02-07 02:50:25 UTC
Created attachment 82523 [details]
Screenshot of print dialog with print preview (complete page)
Comment 8 Rainer Bielefeld 2014-02-07 04:46:44 UTC
Also worked fine for me on a different WIN XP PC with AOO 4.0.1 an HP 895C. Strange!
Comment 9 Rainer Bielefeld 2014-02-07 06:29:45 UTC
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?
Comment 10 kurt.pfeifle 2014-02-07 07:12:04 UTC
@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?
Comment 11 Rainer Bielefeld 2014-02-07 07:45:41 UTC
(In reply to kurt.pfeifle from comment #10)
I use that phrase due to old Bugzilla But status <>

Works for me means "no problems here, I can not reproduce the bug"
Comment 12 kurt.pfeifle 2014-02-07 07:56:06 UTC
@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`...)
Comment 13 Rainer Bielefeld 2014-02-07 08:58:05 UTC
Created attachment 82524 [details]
Screenshot Comparison with/without Droid Font installed

Hm, currently Droid Sans from <> for me does not produce the problem for me, PDF print and ral printer print also looks fine after having installed Droid.

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," 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.
Comment 14 kurt.pfeifle 2014-02-07 09:59:56 UTC
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.
Comment 15 kurt.pfeifle 2014-02-07 12:55:54 UTC
Created attachment 82527 [details]
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 (as well as with LibreOffice) for more than 2 years (I started to use this template in July 2011).


   *  ...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.
Comment 16 kurt.pfeifle 2014-02-07 12:56:43 UTC
Created attachment 82528 [details]
Screenshot No. 2 showing footer settings with Droid font
Comment 17 kurt.pfeifle 2014-02-07 12:57:56 UTC
Created attachment 82529 [details]
Screenshot No. 3 showing footer settings with Droid font
Comment 18 kurt.pfeifle 2014-02-07 13:34:41 UTC

Talking about "preview thoughts leading to nowhere ... being too subjective"... your attachment #82524 [details] 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...
Comment 19 Rainer Bielefeld 2014-02-20 16:37:05 UTC
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.