Bug 82097 - REPORTBUILDER: Group Header keeps the values of the first group
Summary: REPORTBUILDER: Group Header keeps the values of the first group
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Database (show other bugs)
Version: 4.2.0.0.alpha0+ Master
Hardware: Other All
: high critical
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard: BSA bibisected
Keywords: bisected, regression
Depends on:
Blocks:
 
Reported: 2014-08-03 16:53 UTC by ClDc
Modified: 2015-01-03 17:39 UTC (History)
5 users (show)

See Also:
i915 platform:
i915 features:


Attachments
Configuring group header (158.27 KB, image/jpeg)
2014-08-03 16:53 UTC, ClDc
Details
test_entete.odb the Data base (13.53 KB, application/vnd.sun.xml.base)
2014-08-03 16:55 UTC, ClDc
Details
origine_Aoo410.odt the expected result (13.06 KB, application/vnd.oasis.opendocument.text)
2014-08-03 16:57 UTC, ClDc
Details
origine_Loo425.odt Wrong result from LOO 4.2.5 (15.53 KB, application/vnd.oasis.opendocument.text)
2014-08-03 17:00 UTC, ClDc
Details
workaround_Loo425.odt when header is not repeated (15.62 KB, application/vnd.oasis.opendocument.text)
2014-08-03 17:01 UTC, ClDc
Details

Description ClDc 2014-08-03 16:53:10 UTC
Created attachment 103928 [details]
Configuring group header

Hi,

LibreOffice 4.2.5.2 and 4.3.0.4: 
In some cases, the group header is not updated in a report defined with ReportBuilder. 
The values ​​shown are those in the first group. 

The attached files : 

- test_entete.odb  database which contains an "origin" report showing the problem and a "workaround" report, copy of the previous showing the parameter causing the problem. 
- State [b] origine_Aoo410.odt [/ b] showing the expected generated successfully with Apache OpenOffice 4.1.0 from the report "original" result 
- Output origine_Loo425.odt showing the wrong result generated by LibreOffice 4.2.5.2 and 4.3.0.4 
- Output workaround_Loo425.odt  highlighting a workaround with LibeOffice 4.2.5.2 but not 100% satisfactory 

- Data Base test_entete.odb contains the table "liste", with 2 columns "document" and "detail" 

The purpose of the report "origin" is to print documents with a new page for each document, the header will contain the document number. If a document is printed on multiple pages each of them will contain the header of the document, so it involves the settings you can see in attached file  maj.jpg .

- As explained above, this report will generate origine_Loo425.odt, we see that the header for all the documents contains: 2014-01 
- The expected result is origine_Aoo410.odt (ApacheOpenOffice) header takes the values​​: 2014-01, 2014-02, 2014-03 
   documents 2014-01 and 2014-03 held on 2 pages, their header is repeated on every page .
- The "workaround" report is a copy of "origin" with the exception of the parameter "Repeat Section" becomes "no" 
workaround_Loo425.odt is the result: the header takes the values​​: 2014-01, 2014-02, 2014-03, the documents 2014-01 , 2014-03 held on 2 pages, but the header is not repeated on each page, it is not suitable. 
It worked for years in the inherited OOO versions until the 4.1.5.3 version of LibreOffice versions. 
The only solution for now is to use ApacheOpenOffice 4.0.1 and 4.1.0 versions giving the exected result. 

Thanks for your help
Operating System: Windows 7
Version: 4.2.5.2 release
Comment 1 ClDc 2014-08-03 16:55:55 UTC
Created attachment 103929 [details]
test_entete.odb the Data base
Comment 2 ClDc 2014-08-03 16:57:33 UTC
Created attachment 103930 [details]
origine_Aoo410.odt  the expected result
Comment 3 ClDc 2014-08-03 17:00:05 UTC
Created attachment 103931 [details]
origine_Loo425.odt  Wrong result  from LOO 4.2.5
Comment 4 ClDc 2014-08-03 17:01:31 UTC
Created attachment 103932 [details]
workaround_Loo425.odt when header is not repeated
Comment 5 ClDc 2014-08-03 17:09:06 UTC
(In reply to comment #0)

instead of :

"State [b] origine_Aoo410.odt [/ b]"

read:

output origine_Aoo410.odt
Comment 6 robert 2014-08-12 05:36:25 UTC
You are right. The value for document in the group-header doesn't change for the next group.
Have tested it with different versions of LO. Works in LO 4.1.6.2 (OpenSUSE 12.3, 64bit rpm Linux), doesn't work first with LO 4.2.0.0alpha0. So it's a regression.
Comment 7 Matthew Francis 2014-12-21 16:25:45 UTC
Bibisect results from 43all:
Two issues in reproducing this. Firstly, the "expected result" document only shows the expected result when opened in AOO. Secondly, in a lot of versions around the commit, Base corrupts the database when generating the report.


There are only 'skip'ped commits left to test.
The first bad commit could be any of:
0e54cced22ee8d216a783202cf26384317db0959
2e349599ef946cf01cfe40929509254c596fdca3
7d3d1a6f00503d8d402f5069e746ec5eb492a096
7d63b17e3d3fe488e34de32ffa042559dbad3cfd
5bac99c03c8d9c687c11c53285a65e79af6c8ef5
We cannot bisect more!
asbel@ramiel:~/Development/LibreOffice/bibisect-43all$ git bisect log
# bad: [c2069a369d738078124812312d51f21ea1ce2421] source-hash-f160e4935c474a5293b3d3c11b3d538efb4767a0
# good: [782be4193770a332476f99538efa5967d79af5c3] source-hash-8757c9c462ba690de60602404ef2e9e99702f0b4
git bisect start 'last41onmaster' '782be4193770a332476f99538efa5967d79af5c3'
# bad: [ca34486a7bc19acb3ddfa7b4fc27ce8bae42c66a] source-hash-bec62421a45da89d2812bdff30fbbab73291cf91
git bisect bad ca34486a7bc19acb3ddfa7b4fc27ce8bae42c66a
# skip: [ad874a5319e9f68e6b3a974e44de838b8a0a82e1] source-hash-4b4ca8030285bd66526ff5bb2b6ea5a75a6c6bc7
git bisect skip ad874a5319e9f68e6b3a974e44de838b8a0a82e1
# skip: [7be7cf83087144563a18000acdae82c8fd6f4872] source-hash-d59024b652ccfaf7247da113ec36788fe260de74
git bisect skip 7be7cf83087144563a18000acdae82c8fd6f4872
# skip: [56e0b2e447c2ff52af50c3469dc5e565d86c14df] source-hash-fcda0878e99d5792e150705f63f3ba25b5d8d14c
git bisect skip 56e0b2e447c2ff52af50c3469dc5e565d86c14df
# bad: [37d651b903e8d0d704f746e27165e92c3333750b] source-hash-9351d0e4181924c3f72be24081fc7af027aa41f7
git bisect bad 37d651b903e8d0d704f746e27165e92c3333750b
# skip: [69497016bae6f296c763f76670153dbe6a2f265d] source-hash-bed3049c4c04a202ff288189d225ca6e5941d69b
git bisect skip 69497016bae6f296c763f76670153dbe6a2f265d
# skip: [638cb54cb50a2b1269009db83f70792cf5076abc] source-hash-877c96a601e6e50d0c7a8f704d57baec22f089c5
git bisect skip 638cb54cb50a2b1269009db83f70792cf5076abc
# skip: [cefa3613b0ac72135d68a3b4fa1ff5dcd47ca6e0] source-hash-fdda178d888127c4b4dafd4b53800989929e9b6b
git bisect skip cefa3613b0ac72135d68a3b4fa1ff5dcd47ca6e0
# good: [e4c742a9e244bd7ebeabc50c90182df28ac3daaf] source-hash-c52ba433491afbca70aa1977a624c795bdd5b9ef
git bisect good e4c742a9e244bd7ebeabc50c90182df28ac3daaf
# good: [9324d2db2ab5b11184d1280c914fb7d49e57ab55] source-hash-51065497ea83e90764860784dc6e193faaf0d673
git bisect good 9324d2db2ab5b11184d1280c914fb7d49e57ab55
# bad: [241d451e09694446622f9767fb76db50481c9e32] source-hash-c3aa1cefdc6521d34a2a32c20bae1593e1edb5ba
git bisect bad 241d451e09694446622f9767fb76db50481c9e32
# bad: [5bac99c03c8d9c687c11c53285a65e79af6c8ef5] source-hash-20d4cd5e08c1400fcc5ae5eb45861f429b914969
git bisect bad 5bac99c03c8d9c687c11c53285a65e79af6c8ef5
# good: [18518588d8414f446ece5591944766f5082ebef5] source-hash-82c25249e624cb54ca6d3293d1c3d0d8ebc208e0
git bisect good 18518588d8414f446ece5591944766f5082ebef5
# skip: [0e54cced22ee8d216a783202cf26384317db0959] source-hash-2815396a1813cb3956c5aba066de49a7f34bc657
git bisect skip 0e54cced22ee8d216a783202cf26384317db0959
# skip: [7d63b17e3d3fe488e34de32ffa042559dbad3cfd] source-hash-83837d6514217c82ebe8d56dddf89fa34f4b5435
git bisect skip 7d63b17e3d3fe488e34de32ffa042559dbad3cfd
# skip: [2e349599ef946cf01cfe40929509254c596fdca3] source-hash-cf2bdd65945d2a02af44db535cf1964d4d09ae20
git bisect skip 2e349599ef946cf01cfe40929509254c596fdca3
# skip: [7d3d1a6f00503d8d402f5069e746ec5eb492a096] source-hash-f9a453fb01908e16032abdbf1f895666e1d260a6
git bisect skip 7d3d1a6f00503d8d402f5069e746ec5eb492a096
# good: [a035fba5e34dc12e2b1796af6ec46f04647a3576] source-hash-df9b0d2e930eb1f60e429301e5386f742a1676ff
git bisect good a035fba5e34dc12e2b1796af6ec46f04647a3576
# only skipped commits left to test
# possible first bad commit: [5bac99c03c8d9c687c11c53285a65e79af6c8ef5] source-hash-20d4cd5e08c1400fcc5ae5eb45861f429b914969
# possible first bad commit: [7d3d1a6f00503d8d402f5069e746ec5eb492a096] source-hash-f9a453fb01908e16032abdbf1f895666e1d260a6
# possible first bad commit: [2e349599ef946cf01cfe40929509254c596fdca3] source-hash-cf2bdd65945d2a02af44db535cf1964d4d09ae20
# possible first bad commit: [0e54cced22ee8d216a783202cf26384317db0959] source-hash-2815396a1813cb3956c5aba066de49a7f34bc657
# possible first bad commit: [7d63b17e3d3fe488e34de32ffa042559dbad3cfd] source-hash-83837d6514217c82ebe8d56dddf89fa34f4b5435
Comment 8 Matthew Francis 2014-12-22 13:20:36 UTC
The below appears to be the commit that introduced the bug

(Note regarding building the original bug:
50cf7caee5bc6d8e066580d13c72b40926fcb69a introduced another bug which prevents reproduction of this bug. Manually apply 6868efe203cffda0ab60db2abc4637433e6caf90 in order to be able to test in the region of the bug)

(Note 2: The methods patched by the below now reside in sw/source/core/doc/DocumentFieldsManager.cxx)


Adding Cc: mstahl@redhat.com


commit 2815396a1813cb3956c5aba066de49a7f34bc657
Author: Michael Stahl <mstahl@redhat.com>
Date:   Tue Jul 31 17:25:44 2012 +0200

    _SetGetExpFlds: this looks simpler with upper_bound
    
    Change-Id: I37dd291aaa229493141fbb8b426488e8e4427185
Comment 9 Alex Thurgood 2015-01-03 17:39:45 UTC
Adding self to CC if not already on


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.