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

            Bug ID: 174477
           Summary: Calc Letter Landscape page height limits actual
                    row/margin area to only 8 inches!
           Product: LibreOffice
           Version: unspecified
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Description:
LibreOffice Calc v: 24.2.7.2 Linux Mint 22.2 AND v: 26.8.3.2 (upgraded) Linux
Mint 22.3

US Letter paper Landscape:  11.0" by 8.5"

I am creating a 7 column 'days' by 6 row 'weeks' calendar page.

I set the Top and Bottom margins to 0.41" = 0.82" total
I set the Left and Right margins to 0.41" = 0.82" total

I calculated the Row Height at 1.28" to fill the page = 7.68"

6 Rows + Top/Bottom Margins = 7.68 + 0.82 = 8.48", which SHOULD fit within the
8.50 page height ... But it DOESN'T !!!  On the sheet it shows the page ending
between rows 5 and 6 ... way less than 8.5".

I had to adjust the Row Height down to 1.18 and the T/B margins down to 0.41"
to get the 'end of page' marker to include all 6 rows.

Margins total = 0.82"
6 Rows total  = 7.08"
  Sum Total   = 7.90"  <--  Fits on Landscape Page

If I increase one T/B margin to 0.82" it stays the same ...
If I increase BOTH T/B margins to 0.82 (or increase ANYTHING else) the page
divider line jumps up between rows 5 and 6

Margins total = 0.84"
6 Rows total  = 7.08"
  Sum total   = 7.92"  <--  Does NOT FIT on Landscape Page ???

DOES NOT FIT on the 8.5" Page Height ???

This doesn't make any sense for Letter (nor A4 Paper).  It seems like 0.5" of
paper is NOT accessible to the sheet???

Thank you for your gracious and prompt assistance with this issue.

Art in Carlisle PA USA

Steps to Reproduce:
1.Format > Page Style > Page: Letter, Landscape, Top Marg .42, Bot Marg .42
2.Sheet: Select rows 1-6: Set Row Height to 1.18 for all 6 rows
3.Dashed Page end indicator is between rows 5 and 6 - Should be below row 6

Actual Results:
Dashed Page end indicator is between rows 5 and 6

Expected Results:
Top Margin = 40, Bottom Margin = 40, Row Height (1-6) = 1.28"
Sum Total Height = 8.48" (LESS THAN 8.50" actual paper height)
Dashed Page end indicator should be below Row 6


Reproducible: Always


User Profile Reset: No

Additional Info:
I don't care if I loose a little of the page, but losing a half inch strip of
the page is unreasonable.

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

Reply via email to