Bug 119810 - Base Reports: Ruler-Margin Landscape Mode Wrong
Summary: Base Reports: Ruler-Margin Landscape Mode Wrong
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.1.0.0.alpha0+
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-09-11 16:31 UTC by Edward Redondo
Modified: 2020-03-27 07:43 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Report builder screen after wizard is finished (85.51 KB, image/png)
2018-09-11 18:34 UTC, Drew Jensen
Details
Screenshot of Report Edit (106.57 KB, image/jpeg)
2018-10-08 20:11 UTC, Edward Redondo
Details
LO 6.1.3.2 Base Border Error (101.34 KB, image/jpeg)
2018-11-12 18:07 UTC, Edward Redondo
Details
Screenshot Report Format (128.96 KB, image/jpeg)
2019-05-16 17:36 UTC, Edward Redondo
Details
Screenshot of report writer with LO64alpha (5.97 KB, image/png)
2019-08-28 07:56 UTC, Alex Thurgood
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Edward Redondo 2018-09-11 16:31:51 UTC
RE: LO 6.1.0.3 Base Reports

When editing a Report in landscape (default) both the ruler and margins do not set for landscape mode.

When you edit a Report in portrait both the ruler and margins match portrait mode.

Need to fix both margins and ruler in landscape mode.
Comment 1 Drew Jensen 2018-09-11 18:34:03 UTC
Created attachment 144803 [details]
Report builder screen after wizard is finished

I used Ubuntu 18.04 and checked this in LibreOffice 6.0, 6.1.1 and 6.2.
Could not confirm the behavior, when editing an existing report the rulers expand and contract as expected changing page format from portrait to landscape and back.

There is an anomaly during the Report Wizard and when the wizard dialog is still open, on the Page 5. Layout, switching between page formats does not properly update the rulers, but that page area does change properly and the controls behave when it does as expected.

So you can get the report display on screen to be incorrect by following.

1. In Base report section select 'Use Wizard to Create Report'.

2. Add some fields and click next until Page. 5

3. Change the page format from landscape to portrait and back again

4. Click next, on page 6 select 'Modify Report Layout' and click 'Finish'

(see the screen shot attachment)

If you now change the page format using the menu item the rulers and page area are displayed correctly, or close report and reopen it for editing the rulers and the page area are correct.
Comment 2 Drew Jensen 2018-09-11 18:35:12 UTC
Setting the issue to new, and altering the summary line for what I found in testing.
Comment 3 Drew Jensen 2018-09-11 18:37:32 UTC
Actually, and sorry for the bouncing here, what I think is best here since the report is against Windows and I only test on Linux is to change the summary back to the original and set this back to unconfirmed, the display may be wrong in Windows IDK. It wasn't in Linux is all I really know.
Comment 4 Buovjaga 2018-10-05 10:37:53 UTC
tecknode: please attach a file so we do not have to create one to test.

Please attach an example document.
Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the document.
Comment 5 Edward Redondo 2018-10-05 18:38:41 UTC
This problem occurs for any Base Form. The margin & ruler stay at portrait even when the document is landscape (default for report forms).
Comment 6 Xisco Faulí 2018-10-08 15:21:52 UTC
Thank you for reporting the bug. 
Could you please create and attach a screencast showing the steps?
There are various free screencast software available for use, including Camstudio (Windows), Jing (Mac), Simple Screen Recorder (Linux) or screencast-o-matic.com (Web).
Comment 7 Edward Redondo 2018-10-08 20:11:45 UTC
Created attachment 145499 [details]
Screenshot of Report Edit
Comment 8 Buovjaga 2018-10-09 12:25:41 UTC
I dug out a random Base file and did a report, but could not see the problem on Win or Linux:

1. Open attachment 125595 [details]
2. Tables - Right-click the table - Report wizard
3. In the field selection, click the >> button and Finish
4. Back in Base, go to Reports, right-click TEXTTEST - Edit

tecknode: if you do these steps, do you see the problem?

Arch Linux 64-bit
Version: 6.2.0.0.alpha0+
Build ID: b7835c1d7465db6bea4cc80b6d0c2f71596938f1
CPU threads: 8; OS: Linux 4.18; UI render: default; VCL: gtk3_kde5; 
Locale: fi-FI (fi_FI.UTF-8); Calc: threaded
Built on 8 October 2018

Version: 6.2.0.0.alpha0+ (x64)
Build ID: d9ad59da50c1172fe98f94370221c9c1b688200a
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2018-10-09_01:03:44
Locale: fi-FI (fi_FI); Calc: threaded
Comment 9 Edward Redondo 2018-10-09 14:52:36 UTC
(In reply to Buovjaga from comment #8)
> I dug out a random Base file and did a report, but could not see the problem
> on Win or Linux:
> 
> 1. Open attachment 125595 [details]
> 2. Tables - Right-click the table - Report wizard
> 3. In the field selection, click the >> button and Finish
> 4. Back in Base, go to Reports, right-click TEXTTEST - Edit
> 
> tecknode: if you do these steps, do you see the problem?
> 
> Arch Linux 64-bit
> Version: 6.2.0.0.alpha0+
> Build ID: b7835c1d7465db6bea4cc80b6d0c2f71596938f1
> CPU threads: 8; OS: Linux 4.18; UI render: default; VCL: gtk3_kde5; 
> Locale: fi-FI (fi_FI.UTF-8); Calc: threaded
> Built on 8 October 2018
> 
> Version: 6.2.0.0.alpha0+ (x64)
> Build ID: d9ad59da50c1172fe98f94370221c9c1b688200a
> CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
> TinderBox: Win-x86_64@42, Branch:master, Time: 2018-10-09_01:03:44
> Locale: fi-FI (fi_FI); Calc: threaded

Your Base file has the same problem. Created a Landscape report but the ruler and margin were set Portrait.
Comment 10 Alex Thurgood 2018-10-10 08:56:35 UTC
I can't reproduce either with

Version: 6.1.2.1
Build ID: 65905a128db06ba48db947242809d14d3f9a93fe
Threads CPU : 4; OS : Mac OS X 10.13.6; UI Render : par défaut; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group threaded

@tecknode: in your original submission, you talk about Reports, but in comment 5 you mention Forms - which is it ?
Comment 11 Alex Thurgood 2018-10-10 08:59:31 UTC
@teckode : looking at the screenshot you posted, can you tell us which system locale you are using and which UI-language / lang defaults for LO ? That might help us isolate a problem linked to a particular configuration on your system.
Comment 12 Edward Redondo 2018-10-11 16:51:44 UTC
(In reply to Alex Thurgood from comment #11)
> @teckode : looking at the screenshot you posted, can you tell us which
> system locale you are using and which UI-language / lang defaults for LO ?
> That might help us isolate a problem linked to a particular configuration on
> your system.

English (U.S.) default

Last test confirming issue done using LO Version: 6.1.0.3 (x64) on my Win7 Pro 64bit desktop rig.
Comment 13 Buovjaga 2018-10-12 05:57:26 UTC
(In reply to Alex Thurgood from comment #10)
> @tecknode: in your original submission, you talk about Reports, but in
> comment 5 you mention Forms - which is it ?

Still curious about this, so keeping as needinfo.

Please also copy and paste here the text contents of your Help - About.
Comment 14 Edward Redondo 2018-10-12 15:24:59 UTC
(In reply to Buovjaga from comment #13)
> (In reply to Alex Thurgood from comment #10)
> > @tecknode: in your original submission, you talk about Reports, but in
> > comment 5 you mention Forms - which is it ?
> 
> Still curious about this, so keeping as needinfo.
> 
> Please also copy and paste here the text contents of your Help - About.

The problem is with Reports.  Sorry I mentioned Forms.

Note that this problem has been confirmed using a Base file sent to me by someone here, so it is not just my Base files.
Comment 15 Alex Thurgood 2018-10-12 16:00:36 UTC
Could be linked to the default US page style - wouldn't be the first time we've had such issues.
Comment 16 Xisco Faulí 2018-11-12 12:13:44 UTC
I can't reproduce it in

Versión: 6.1.3.2
Id. de compilación: 86daf60bf00efa86ad547e59e09d6bb77c699acb
Subprocs. CPU: 1; SO: Windows 6.1; Repres. IU: predet.; 
Configuración regional: es-ES (es_ES); Calc: group threaded

Could you please try to reproduce it with the latest version of LibreOffice
from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' if the bug is still present in the latest version.
Comment 17 Edward Redondo 2018-11-12 18:04:58 UTC
(In reply to Xisco Faulí from comment #16)
> I can't reproduce it in
> 
> Versión: 6.1.3.2
> Id. de compilación: 86daf60bf00efa86ad547e59e09d6bb77c699acb
> Subprocs. CPU: 1; SO: Windows 6.1; Repres. IU: predet.; 
> Configuración regional: es-ES (es_ES); Calc: group threaded
> 
> Could you please try to reproduce it with the latest version of LibreOffice
> from https://www.libreoffice.org/download/libreoffice-fresh/ ?
> I have set the bug's status to 'NEEDINFO'. Please change it back to
> 'UNCONFIRMED' if the bug is still present in the latest version.

LO 6.1.3.2 Base Report borders still wrong for Landscape.
Sending new screenshot.
Comment 18 Edward Redondo 2018-11-12 18:07:40 UTC
Created attachment 146574 [details]
LO 6.1.3.2 Base Border Error
Comment 19 Xisco Faulí 2019-05-16 11:50:21 UTC
Dear tecknode,
A new major release of LibreOffice is available since this bug was reported.
Could you please try to reproduce it with the latest version of LibreOffice
from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' if the bug is still present in the latest version.
Comment 20 Edward Redondo 2019-05-16 17:36:55 UTC
Created attachment 151466 [details]
Screenshot Report Format
Comment 21 Edward Redondo 2019-05-16 17:42:29 UTC
(In reply to Xisco Faulí from comment #19)
> Dear tecknode,
> A new major release of LibreOffice is available since this bug was reported.
> Could you please try to reproduce it with the latest version of LibreOffice
> from https://www.libreoffice.org/download/libreoffice-fresh/ ?
> I have set the bug's status to 'NEEDINFO'. Please change it back to
> 'UNCONFIRMED' if the bug is still present in the latest version.

Just updated to LO 6.2.3.2 64bit on my Win7 Pro 64bit desktop rig.

The report DOES print correctly.

But the Report Format grid still shows Margin Indicator at 8" when it should be at 11" in landscape.

(see latest screenshot)
Comment 22 Alex Thurgood 2019-08-28 07:52:23 UTC
I appear to be able to reproduce this in 

Version: 6.4.0.0.alpha0+
Build ID: c3c0826b9c300d84d10dcca90b22ae662211316a
CPU threads: 4; OS: Mac OS X 10.14.6; UI render: default; VCL: osx; 
Locale: en-US (fr_FR.UTF-8); UI-Language: en-US
Calc: threaded

under the following conditions :

1) Default LO UI lang : en_US
2) Set default measurements in Writer preferences to inches
3) Set default day/date and language of documents to en-US
4) Open a ODB file, click on Reports, create a report in design view
5) Menu Format > Page > choose Letter in dropdown for page format if not preselected, then select Landscape.

Notice how the ruler sets the page limit at just over 9 inches and 3/8 inch (cf. attached screenshot).
Comment 23 Alex Thurgood 2019-08-28 07:56:00 UTC
Created attachment 153697 [details]
Screenshot of report writer with LO64alpha
Comment 24 Alex Thurgood 2019-08-28 08:06:00 UTC
(In reply to Alex Thurgood from comment #22)


> 
> Notice how the ruler sets the page limit at just over 9 inches and 3/8 inch
> (cf. attached screenshot).

Note however, that the default US page style has page margins of 0.79 inches, so what I see is consistent with that.

If I remove the page margins, and ignore my printer page default warning about the page size exceeding the size at which the printer can print the page, then I get a UI margin boundary set at 11 inches. So this would actually not be a bug in that case, but WFM.



@teckode : under the Format menu of the report writer, what are the page margins set ?
Comment 25 QA Administrators 2020-02-25 02:49:05 UTC Comment hidden (obsolete)
Comment 26 QA Administrators 2020-03-27 07:43:26 UTC
Dear Edward Redondo,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp