https://bugs.documentfoundation.org/show_bug.cgi?id=172959

            Bug ID: 172959
           Summary: shrink-to-fit cell causes extra blank page when
                    printed
           Product: LibreOffice
           Version: 26.8.0.0 alpha0+ master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 207952
  --> https://bugs.documentfoundation.org/attachment.cgi?id=207952&action=edit
x1.ods demo spreadsheet

The attached spreadsheet (x1.ods) has shrink-to-fit in all cells.  There are
only two columns, one 4" wide and the other 0.5" wide.

However the text "abcdefg" in the 0.5" column causes the cell to overflow, i.e.
it is not shrunk sufficiently.  With View->Page Break a phantom cell is visible
in Column C.   

If the font size is manually set to 9 pt then it fits.  But with the font set
to 10 pt, shrink-to-fit is ineffective.

This is derived from a larger sheet.  In the real application, the problem
causes blank pages to be printed because a "phantom" column is created which
has no visible content, but which won't fit in the page width.

STEPS TO REPRODUCE:

1. Load the attached x1.ods
2. View->Page Break
3. Verify that Alighment-> Shrink to fit cell size is checked in cell B1
   (Rightclick->Format Cells->Alignment->Shrink to fit cell size checked)

4. File->Print Preview

RESULTS: A "phantom" cell in column C appears which can not be deleted. When
printed, it appears on an extraneous empty page.  (I've set a page-format
background color so you can see the empty cell when printed on the extra page)

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

Reply via email to