Bug 31894 - LibreOffice Base report does not format correctly
Summary: LibreOffice Base report does not format correctly
Status: RESOLVED FIXED
Alias: None
Product: Mageia
Classification: Unclassified
Component: RPM Packages (show other bugs)
Version: 9
Hardware: All Linux
Priority: Normal normal
Target Milestone: ---
Assignee: QA Team
QA Contact:
URL:
Whiteboard: M9-64-OK
Keywords: advisory, validated_update
Depends on:
Blocks:
 
Reported: 2023-05-07 15:44 CEST by Herman Viaene
Modified: 2026-04-24 17:23 CEST (History)
8 users (show)

See Also:
Source RPM: libformula,ant-contrib
CVE:
Status comment:
herman.viaene: test_passed_mga9_64+


Attachments
run of report on the emp.odb example file (106.51 KB, image/png)
2026-02-01 17:12 CET, Bruno Cornec
Details
correctly formatted report (36.56 KB, application/pdf)
2026-02-02 10:08 CET, Herman Viaene
Details
Demo database. (75.68 KB, application/vnd.oasis.opendocument.database)
2026-02-04 21:25 CET, Herman Viaene
Details

Description Herman Viaene 2023-05-07 15:44:44 CEST
Description of problem:
A report with a page break on a field in the header section shows up as a single page listing all itemsn not respecting the breaks that should be triggered by the different values in that field

Version-Release number of selected component (if applicable):
LO7.4.5.1

How reproducible:
Allways

Steps to Reproduce:
Take the test file from bug 31021 and run the report.

This bug does not apply for the moment to the LO versions in M9 as in these versions the report crashes completely.
Comment 1 Lewis Smith 2023-05-08 21:47:34 CEST
[The last remark discourages simply updating LibreOffice!]
Have you searched elsewhere to see whether others have found this problem?

Assigning anyway to tv who mostly deals with LO; CC'ing ns80 who does too.

Source RPM: (none) => libreoffice-7.4.5.1-1.mga8.src.rpm
Assignee: bugsquad => thierry.vignaud
CC: (none) => nicolas.salguero

Comment 2 Herman Viaene 2023-05-09 06:12:59 CEST
Thé problem does  not occur with the rpms from LO itself. I will not be able to do further research the next days as I am in hospital right now.
Comment 3 Martin Whitaker 2023-05-16 22:02:29 CEST
This doesn't seem to be a recent problem. I get the same result when running a Mageia 8 Live ISO (using LibreOffice 7.0.4.2) after installing just the updates that fixed bug 29556.

CC: (none) => mageia

Comment 4 Herman Viaene 2023-05-17 08:37:38 CEST
I won't comment on that since I use the LO-provided on my desktop PC where I do the development (out of frustration ...) and this problem does not occur there, nor on Win10 (the platform) of my customer, nor on PCLinuxOS (on real HW). I'm not sure about Mint (on VM).
Comment 5 Marja Van Waes 2024-08-22 23:02:31 CEST
We stopped supporting Mageia 8 almost 8 months ago 
https://blog.mageia.org/en/2023/12/30/mageia-8-end-of-life/

That means we also stopped fixing Mageia 8 bugs and that this bug report needs to be closed, regardless of whether it was fixed for Mageia 8 or not.

If this particular bug did not get fixed for Mageia 8, then we do regret that.

If this issue is still present in Mageia 9 or cauldron, then please reopen this report, write a comment and adjust the "Version:" field.

If you are not yet a member of one or our teams, then please consider becoming one. https://wiki.mageia.org/en/Contributing
Mageia is a community project, meaning that we, the users, make Mageia together.

The more active contributors we have, the more bug reports will get fixed.
Besides, being active in a team can be very rewarding. It was and is certainly rewarding to me :-D

Status: NEW => RESOLVED
Resolution: (none) => OLD

Comment 6 Herman Viaene 2024-08-23 09:01:52 CEST
Still valid for M9

Version: 8 => 9

Comment 7 katnatek 2024-08-24 05:34:04 CEST
Did this still happen in new user or if you delete ~/.config/libreoffice ?
Comment 8 Herman Viaene 2024-08-26 10:18:15 CEST
Deleted ~/.config/libreoffice
Started first menu screen ogf my application; of course all settings (firebird, macro settings, applicable database) are gone and I fill those in again.
Close screen and restart LO completely.
Problem still there.
Comment 9 Herman Viaene 2024-09-28 15:15:15 CEST
Problem still exists in Mageia's latest LO 24.2

Status: RESOLVED => REOPENED
Resolution: OLD => (none)

Comment 10 Herman Viaene 2025-08-03 10:13:17 CEST
And in 25.2
Comment 11 Herman Viaene 2025-08-03 10:47:55 CEST
And to answer on Comment 1: this error does not occur in Fedora 42. But Mageia is not alone struggling with LO Base Reports. In Mint22 and Kubuntu reports crash completely. But that does not help me.
Comment 12 Bruno Cornec 2026-02-01 17:11:05 CET
This bug doesn't occur on mga9 for me with LO 24.2.7.2 your .odb test file and that JRE 17.0.18 activated in the options menu of LO.

Result attached.

CC: (none) => bruno

Comment 13 Bruno Cornec 2026-02-01 17:12:03 CET
Created attachment 15376 [details]
run of report on the emp.odb example file
Comment 14 Herman Viaene 2026-02-01 17:16:28 CET
It does occur: this report should have page breaks.
Comment 15 Bruno Cornec 2026-02-01 19:32:51 CET
Could you attach a report of what you mean by it works with a LO which works for you, as I'm unsure what you try to get
Comment 16 Giuseppe Ghibò 2026-02-02 00:25:47 CET
How about listing the libreoffice packages installed when it occurs and when doesn't (rpm -qa | grep libreoffice)

As for alignment or not respecting page break how about comparing the font savailable in the system, maybe the LO site rpms provide its own set of extra fonts? What if you add the standard core web fonts to your system?

CC: (none) => ghibomgx

Comment 17 Herman Viaene 2026-02-02 10:08:20 CET
Created attachment 15378 [details]
correctly formatted report
Comment 18 Herman Viaene 2026-02-02 10:14:10 CET
list of rpm's installed from LO:

libobasis25.8-base-25.8.4.2-2.x86_64.rpm                                  libobasis25.8-images-25.8.4.2-2.x86_64.rpm                  
libobasis25.8-xsltfilter-25.8.4.2-2.x86_64.rpm
libobasis25.8-calc-25.8.4.2-2.x86_64.rpm                                  libobasis25.8-impress-25.8.4.2-2.x86_64.rpm                 libreoffice25.8-25.8.4.2-2.x86_64.rpm
libobasis25.8-core-25.8.4.2-2.x86_64.rpm                                  libobasis25.8-kde-integration-25.8.4.2-2.x86_64.rpm         
libreoffice25.8-base-25.8.4.2-2.x86_64.rpm
libobasis25.8-draw-25.8.4.2-2.x86_64.rpm                                  libobasis25.8-librelogo-25.8.4.2-2.x86_64.rpm               
libreoffice25.8-calc-25.8.4.2-2.x86_64.rpm
libobasis25.8-en-US-25.8.4.2-2.x86_64.rpm                                 libobasis25.8-libreofficekit-data-25.8.4.2-2.x86_64.rpm     
libreoffice25.8-dict-en-25.8.4.2-2.x86_64.rpm
libobasis25.8-extension-beanshell-script-provider-25.8.4.2-2.x86_64.rpm   libobasis25.8-math-25.8.4.2-2.x86_64.rpm                   0
 libreoffice25.8-dict-es-25.8.4.2-2.x86_64.rpm
libobasis25.8-extension-javascript-script-provider-25.8.4.2-2.x86_64.rpm  libobasis25.8-ogltrans-25.8.4.2-2.x86_64.rpm                
libreoffice25.8-dict-fr-25.8.4.2-2.x86_64.rpm
libobasis25.8-extension-mediawiki-publisher-25.8.4.2-2.x86_64.rpm         libobasis25.8-onlineupdate-25.8.4.2-2.x86_64.rpm            
libreoffice25.8-draw-25.8.4.2-2.x86_64.rpm
libobasis25.8-extension-nlpsolver-25.8.4.2-2.x86_64.rpm                   libobasis25.8-ooofonts-25.8.4.2-2.x86_64.rpm                
libreoffice25.8-en-US-25.8.4.2-2.x86_64.rpm
libobasis25.8-extension-pdf-import-25.8.4.2-2.x86_64.rpm                  libobasis25.8-ooolinguistic-25.8.4.2-2.x86_64.rpm           
libreoffice25.8-freedesktop-menus-25.8.4-2.noarch.rpm
libobasis25.8-extension-report-builder-25.8.4.2-2.x86_64.rpm              libobasis25.8-postgresql-sdbc-25.8.4.2-2.x86_64.rpm         
libreoffice25.8-impress-25.8.4.2-2.x86_64.rpm
libobasis25.8-firebird-25.8.4.2-2.x86_64.rpm                              libobasis25.8-python-script-provider-25.8.4.2-2.x86_64.rpm  
libreoffice25.8-math-25.8.4.2-2.x86_64.rpm
libobasis25.8-gnome-integration-25.8.4.2-2.x86_64.rpm                     libobasis25.8-pyuno-25.8.4.2-2.x86_64.rpm                   
libreoffice25.8-ure-25.8.4.2-2.x86_64.rpm
libobasis25.8-graphicfilter-25.8.4.2-2.x86_64.rpm                         libobasis25.8-writer-25.8.4.2-2.x86_64.rpm                  
libreoffice25.8-writer-25.8.4.2-2.x86_64.rpm
David GEIGER 2026-02-03 17:44:57 CET

CC: (none) => geiger.david68210

Comment 19 David GEIGER 2026-02-03 17:50:18 CET
So I found what is going wrong in our LO pkg, libformula is the culprit as it wasn't compiled with ant-contrib.

I fixed it and the other java pkgs that LO needs, LO patched some of these java dependencies and now I have sync like them.

Please test now to see if the LO report module is good, for me on my system it is fixed!

Same for mga9 I fixed libformula and also it should be fixed!
Comment 20 David GEIGER 2026-02-03 17:58:01 CET
For mga9 it is: libformula-1.1.6-14.1.mga9
katnatek 2026-02-03 18:51:37 CET

Assignee: thierry.vignaud => qa-bugs

Comment 21 katnatek 2026-02-03 18:55:36 CET
Not sure is valid test
Now that I understand the bug, I can reproduce with bdk's version

installing libformula-1.1.6-14.1.mga9.noarch.rpm from //home/katnatek/qa-testing/x86_64
Preparing...                     ###################################################################################################
      1/1: libformula            ###################################################################################################
      1/1: removing libformula-1.1.6-14.mga9.noarch
                                 ###################################################################################################

I see 2 pages in the report, one from Production and other from Finance

This looks good for me
katnatek 2026-02-03 19:03:57 CET

Source RPM: libreoffice-7.4.5.1-1.mga8.src.rpm => libformula-1.1.6-14.mga9

katnatek 2026-02-03 19:10:29 CET

Keywords: (none) => advisory

Comment 22 David GEIGER 2026-02-04 07:31:44 CET

Packages in 9/Core/Updates_testing:
======================
libformula-1.1.6-14.1.mga9.noarch.rpm
libformula-javadoc-1.1.6-14.1.mga9.noarch.rpm

ant-contrib-1.0-0.39.b3.1.mga9.noarch.rpm
ant-contrib-javadoc-1.0-0.39.b3.1.mga9.noarch.rpm


From SRPMS
libformula-1.1.6-14.1.mga9.src.rpm
ant-contrib-1.0-0.39.b3.1.mga9.src.rpm
Comment 23 Herman Viaene 2026-02-04 20:02:13 CET
(In reply to katnatek from comment #21)
> Not sure is valid test
> Now that I understand the bug, I can reproduce with bdk's version
> 
> installing libformula-1.1.6-14.1.mga9.noarch.rpm from
> //home/katnatek/qa-testing/x86_64
> Preparing...                    
> #############################################################################
> ######################
>       1/1: libformula           
> #############################################################################
> ######################
>       1/1: removing libformula-1.1.6-14.mga9.noarch
>                                 
> #############################################################################
> ######################
> 
> I see 2 pages in the report, one from Production and other from Finance
> 
> This looks good for me

No, you should see three pages: Engineering, Finance and Production.
Comment 24 katnatek 2026-02-04 20:42:38 CET
(In reply to Herman Viaene from comment #23)
> (In reply to katnatek from comment #21)
> > I see 2 pages in the report, one from Production and other from Finance
> > 
> > This looks good for me
> 
> No, you should see three pages: Engineering, Finance and Production.

The example db that I have in my system just have Production and Finance with one entry in each department

Don't know if I remove the other or have an old version
Comment 25 Herman Viaene 2026-02-04 21:25:19 CET
Created attachment 15385 [details]
Demo database.
Comment 26 katnatek 2026-02-04 21:54:30 CET
(In reply to Herman Viaene from comment #25)
> Created attachment 15385 [details]
> Demo database.

With this file I see 3 pages, Engineering, Finance and Production.

As ant-contrib is Build Time dependency I consider tested by build libformula, 
just test clean install

LC_ALL=C urpmi ant-contrib
urpmi database is locked, process 23211 is already using it (/usr/bin/perl /usr/libexec/urpmi.update --update)
[root@jgrey ~]# LC_ALL=C urpmi ant-contrib
To satisfy dependencies, the following packages are going to be installed:
  Package                        Version      Release       Arch    
(medium "QA Testing (64-bit)")
  ant-contrib                    1.0          0.39.b3.1.mg> noarch  
(medium "Core Release (distrib1)")
  ant                            1.10.12      10.mga9       noarch  
  ant-lib                        1.10.12      10.mga9       noarch  
  hamcrest                       2.2          3.mga9        noarch  
  junit                          4.13.1       9.mga9        noarch  
  xerces-j2                      2.12.2       1.mga9        noarch  
  xml-commons-resolver           1.2          38.mga9       noarch  
(medium "Core Updates (distrib3)")
  java-17-openjdk-devel          17.0.18.0.8  1.mga9        x86_64  (recommended)
14MB of additional disk space will be used.
8.8MB of packages will be retrieved.
Proceed with the installation of the 8 packages? (Y/n) y


    https://mirror.math.princeton.edu/pub/mageia/distrib/9/x86_64/media/core/release/junit-4.13.1-9.mga9.noarch.rpm
    https://mirror.math.princeton.edu/pub/mageia/distrib/9/x86_64/media/core/release/ant-1.10.12-10.mga9.noarch.rpm                  
    https://mirror.math.princeton.edu/pub/mageia/distrib/9/x86_64/media/core/release/ant-lib-1.10.12-10.mga9.noarch.rpm              
    https://mirror.math.princeton.edu/pub/mageia/distrib/9/x86_64/media/core/release/xerces-j2-2.12.2-1.mga9.noarch.rpm              
    https://mirror.math.princeton.edu/pub/mageia/distrib/9/x86_64/media/core/release/hamcrest-2.2-3.mga9.noarch.rpm                  
    https://mirror.math.princeton.edu/pub/mageia/distrib/9/x86_64/media/core/release/xml-commons-resolver-1.2-38.mga9.noarch.rpm     
    https://mirror.math.princeton.edu/pub/mageia/distrib/9/x86_64/media/core/updates/java-17-openjdk-devel-17.0.18.0.8-1.mga9.x86_64.rpm
installing /var/cache/urpmi/rpms/hamcrest-2.2-3.mga9.noarch.rpm                                                                      
/var/cache/urpmi/rpms/xml-commons-resolver-1.2-38.mga9.noarch.rpm
//home/katnatek/qa-testing/x86_64/ant-contrib-1.0-0.39.b3.1.mga9.noarch.rpm
/var/cache/urpmi/rpms/java-17-openjdk-devel-17.0.18.0.8-1.mga9.x86_64.rpm
/var/cache/urpmi/rpms/ant-lib-1.10.12-10.mga9.noarch.rpm
/var/cache/urpmi/rpms/junit-4.13.1-9.mga9.noarch.rpm
/var/cache/urpmi/rpms/ant-1.10.12-10.mga9.noarch.rpm
/var/cache/urpmi/rpms/xerces-j2-2.12.2-1.mga9.noarch.rpm
Preparing...                     ###################################################################################################
      1/8: ant-lib               ###################################################################################################
      2/8: java-17-openjdk-devel ###################################################################################################
      3/8: ant                   ###################################################################################################
      4/8: xml-commons-resolver  ###################################################################################################
      5/8: xerces-j2             ###################################################################################################
      6/8: hamcrest              ###################################################################################################
      7/8: junit                 ###################################################################################################
      8/8: ant-contrib           ###################################################################################################


Still looks good, if somebody test with mageia's version of libreoffice we can say this is fixed

Source RPM: libformula-1.1.6-14.mga9 => libformula,ant-contrib

Comment 27 Herman Viaene 2026-02-04 23:05:38 CET
Tested on M9 with the current 24.2.72 LO and this update, and on M10 with its current versions and the report displays OK. TX a lot and lets go.

Whiteboard: (none) => M9-64-OK
Flags: (none) => test_passed_mga9_64+

Comment 28 Morgan Leijström 2026-02-05 00:23:18 CET
Thank you David for fixing this, 
and thank you Herman for keeping naggin about it :-)

CC: (none) => fri, sysadmin-bugs
Keywords: (none) => validated_update

Comment 29 Mageia Robot 2026-02-05 07:06:14 CET
An update for this issue has been pushed to the Mageia Updates repository.

https://advisories.mageia.org/MGAA-2026-0010.html

Resolution: (none) => FIXED
Status: REOPENED => RESOLVED

Comment 30 katnatek 2026-02-05 22:39:49 CET
@sysadmin I remove a duplicated office word in the advisory
Please fix the published advisory when you can
Comment 31 Dan Fandrich 2026-02-06 06:19:16 CET
Advisory updates are automatically published on the next security fix push, so it's already live.

CC: (none) => dan

Comment 32 Herman Viaene 2026-04-22 14:47:22 CEST
Problem crops up again in M10 rc1 LO26.2.2

Status: RESOLVED => REOPENED
Resolution: FIXED => (none)

Comment 33 David GEIGER 2026-04-22 16:29:35 CEST
No problem here on my mga10! works as it should
Comment 34 David GEIGER 2026-04-22 16:47:18 CEST
Also tested on fresh vbox install, no problem too!
Comment 35 Herman Viaene 2026-04-22 17:50:00 CEST
I've installed two different instances of M10rc1:
on Compaq laptop used kernel-desktop 6.18.23 and here problem shows.
on HP Elitebook discarded the update of the kernel-desktop and installed the kernel-server 6.18.23, and there the report runs OK.
Comment 36 katnatek 2026-04-24 03:02:39 CEST
I can't reproduce with the sample db in comment 25
uname -r
6.18.23-desktop-1.mga10


rpm -qa|grep libreoffice
libreoffice-data-26.2.2.2-1.mga10
libreoffice-opensymbol-fonts-26.2.2.2-1.mga10
libreoffice-ure-common-26.2.2.2-1.mga10
libreoffice-ure-26.2.2.2-1.mga10
libreoffice-gtk3-26.2.2.2-1.mga10
libreoffice-langpack-es-26.2.2.2-1.mga10
libreoffice-core-26.2.2.2-1.mga10
libreoffice-pyuno-26.2.2.2-1.mga10
libreoffice-pdfimport-26.2.2.2-1.mga10
libreoffice-graphicfilter-26.2.2.2-1.mga10
libreoffice-ogltrans-26.2.2.2-1.mga10
libreoffice-writer-26.2.2.2-1.mga10
libreoffice-emailmerge-26.2.2.2-1.mga10
libreoffice-impress-26.2.2.2-1.mga10
libreoffice-draw-26.2.2.2-1.mga10
libreoffice-math-26.2.2.2-1.mga10
libreoffice-calc-26.2.2.2-1.mga10
libreoffice-base-26.2.2.2-1.mga10
libreoffice-26.2.2.2-1.mga10
libreoffice-help-es-26.2.2.2-1.mga10
libreoffice-xsltfilter-26.2.2.2-1.mga10

Please open new bug

Status: REOPENED => RESOLVED
Resolution: (none) => FIXED

Comment 37 Herman Viaene 2026-04-24 17:23:06 CEST
Sorry for the noise. But the users of my app made a rather drastic change in the data content, I wasn't awware off. That made me think the report was wrong, but not....

Note You need to log in before you can comment on or make changes to this bug.