Bug 164147 - CALC page preview anticipation not matching with page setting portrait/landscape or A4 vs. Letter at first opening
Summary: CALC page preview anticipation not matching with page setting portrait/landsc...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.3.2 release
Hardware: All Windows (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-12-03 13:58 UTC by HTK300
Modified: 2025-06-20 08:28 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
page setup (41.23 KB, image/jpeg)
2024-12-03 13:59 UTC, HTK300
Details
paper borders at opening file (194.80 KB, image/jpeg)
2024-12-03 13:59 UTC, HTK300
Details
preview (146.84 KB, image/jpeg)
2024-12-03 14:00 UTC, HTK300
Details
correct paper borders indicated (197.40 KB, image/jpeg)
2024-12-03 14:01 UTC, HTK300
Details
CALC file (27.24 KB, application/octet-stream)
2025-05-27 16:53 UTC, HTK300
Details
screenshot (66.66 KB, image/jpeg)
2025-05-27 16:55 UTC, HTK300
Details
screenshot (155.15 KB, image/jpeg)
2025-05-27 16:56 UTC, HTK300
Details
screenshot fist page (154.37 KB, image/jpeg)
2025-05-27 16:57 UTC, HTK300
Details

Note You need to log in before you can comment on or make changes to this bug.
Description HTK300 2024-12-03 13:58:12 UTC
Description:
at the first time when opening a CALC spreadsheet, the anticipated page borders are shown in dashed lines in the final column or across the last row that would match on the first paper page that had been set in the menu: [Format] > [Page Style]. What I experienced is, that the shown dash lines will be correct only once you initiate a page preview and come back. 
I cannot guess where the lines after the opening of a file had been set, nor portrait or landscape had been misinterpreted, nor A4, A3, Letter seems to be a hint to this.

Steps to Reproduce:
1. create a spreadsheet in CALC that exceeds ONE page of contents (no matter to the right or down to next paper of current setting
2. close the file
3. open the file and remind yourself of the anticipated paper borders indicated with horizontal and vertical dashed lines
4. initiate a page preview and close that again
5. compare the previous paper borders with the new page borders indicated

Actual Results:
at the beginning when opening a spreadsheet, the paper border (size) does not displays the correct information about the page sizes

Expected Results:
The paper size and the anticipated page borders of the displayed file are not consistent


Reproducible: Always


User Profile Reset: No

Additional Info:
see attachments
Comment 1 HTK300 2024-12-03 13:59:13 UTC
Created attachment 197916 [details]
page setup

screenshot
Comment 2 HTK300 2024-12-03 13:59:55 UTC
Created attachment 197917 [details]
paper borders at opening file

screenshot
Comment 3 HTK300 2024-12-03 14:00:27 UTC
Created attachment 197918 [details]
preview

screenshot
Comment 4 HTK300 2024-12-03 14:01:02 UTC
Created attachment 197919 [details]
correct paper borders indicated

screenshot
Comment 5 Buovjaga 2025-05-27 15:31:58 UTC
I don't reproduce this. If you still see this with version 25.2, attach an example file.

Version: 25.2.3.2 (X86_64) / LibreOffice Community
Build ID: bbb074479178df812d175f709636b368952c2ce3
CPU threads: 2; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

Arch Linux 64-bit
Version: 25.2.3.2 (X86_64) / LibreOffice Community
Build ID: 520(Build:2)
CPU threads: 8; OS: Linux 6.14; UI render: default; VCL: kf6 (cairo+wayland)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
25.2.3-1
Calc: threaded
Comment 6 HTK300 2025-05-27 16:50:37 UTC
Hi,
having read your comment, for you could not reproduce the behavior, I took time to mess with paper sizes, zoom levels, portrait and landscape sheets, activated the preview and within that print preview I modified zoom levels back and forth. Then this is the moment when the dashed lines get wrong in the normal page and editing view. 
It may also be relevant, to have more than one page content on the A4 sheet.

anyway here are the screenshot and a calc file. 
Important to mention is that the dashed lines which I suppose were created for the editor to help indicate the end of the pages to the right (across( and to the bottom (below) for the next page.
Comment 7 HTK300 2025-05-27 16:53:16 UTC
Created attachment 200979 [details]
CALC file
Comment 8 HTK300 2025-05-27 16:55:57 UTC
Created attachment 200980 [details]
screenshot

here you see the help line that should indicate the sheet's edges, but they are not correctly shown, because DIN A4 was the setup
Comment 9 HTK300 2025-05-27 16:56:40 UTC
Created attachment 200981 [details]
screenshot

settings for CALC view
Comment 10 HTK300 2025-05-27 16:57:37 UTC
Created attachment 200982 [details]
screenshot fist page

this helping lines are not correctly positioned as setup with DIN A4
Comment 11 Buovjaga 2025-05-27 17:05:46 UTC
(In reply to HTK300 from comment #7)
> Created attachment 200979 [details]
> CALC file

What I see is that there are *no* print area dashes visible upon opening. I bibisected the change with linux-64-7.0 to c4281cb41e6b76cabd5fe42fc707877e864dfb82
tdf#130640: Revert "tdf#124983 In calc make printable page...

...borders also initially visible"

So it seems to be a deliberate change.

I don't reproduce the area dashes being in an incorrect location.
Comment 12 HTK300 2025-06-20 08:28:34 UTC
the dashed lines which seem to anticipate the border of the paper sheet appears only on the most left tab. Once a preview has been initiated, the borders appear and are good