Version: 7.5.3.2 (X86_64) / LibreOffice Community Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3 CPU threads: 4; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded Hello, Libreoffice fail when i want create a function (accumulation, minimum,maximum) field in ReportBuilder. This problem not appear in precedent version. Have you an idea ? Thanks
Could you please attach an example with a report, which calculates right in earlier versions?
Created attachment 188242 [details] Open the report for editing. Try to create accumulation for field [ecrdebit] in group footer. Have found the example here: https://ask.libreoffice.org/t/lo-7-5-3-2-reports-impossible-de-creer-un-champ-fonction-accumulation/93352 Could confirm LO hangs when trying to create a function in Report Builder. Note: LO will hang, no respond when trying to create the function. Has nothing to do with footer of the group. Function will be created if there has been added an alias to the field in the query.
This bug appears in LO 7.5.5.1 and also in older versions. Could test it with different versions of LO 7, also could reproduce it with LO 6.4.7.2 on OpenSUSE 15.4 64bit rpm Linux.
Created attachment 188254 [details] My base test : test accumulate on field "debit"
I have tested in 7.3.7.2 (ubuntu package) 7.4.0.3 7.4.4.2 7.4.7.2 7.5.0.3 All are wrong, LO failed Before all test i "sudo apt remove libreoffice*"
Excuse me I found ...; In reality with or without alias the problem is "solved" at my place, but it is necessary to wait between 2 and 3 minutes that the creation is made by responding to wait for each message from Cratch! Problem of memory.... ?
Is really a big bug Please give hight priority Thanks
In Page Header, Report Header, Page Footer, Report Footer NO PROBLEM ! In Group Header and Group Footer even creation, modification, moving a field cause problem!
I have found ! I think The base field name (grouping)having a underscore (evt_Libel)! If i rename without underscore the problem disepears ! Yessss ! Perhaps a incompatibility whith Wayland ? I read somewhere that Libreoffice and Wayland are problems. Thanks for your read
Hi Pierre, but is really a bug. Now a developer could look why Report Builder gets confused by a undersored name.
Created attachment 188270 [details] Report will work without problem when group isn't underscored. Open the report of this example. Group isn't underscored. You could create an accumulation without any problem here.
Could also reproduce in: Version: 6.1.0.3 Build ID: efb621ed25068d70781dc026f7e9c5187a4decd1 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk2; Locale: en-AU (en_AU.UTF-8); Calc: CL Also hangs on macOS (I tested 7.5.4), so unrelated to Wayland. Robert and Pierre, could you please check if the following reports are at all related? - bug 77897 - bug 152170 - bug 152782 Thank you!
I noticed that it eventually works, it's "just" having serious performance issues (both macOS and Linux). Using these steps: 1. Open attachment 188242 [details] 2. Reports > edit report rptSoldeEvenement 3. Click the =ecrdebit field in the Detail section 4. In the right panel, got the Data tab 5. Select "Function" in Data Field Type 6. Select "ecrdebit" for Data 7. Select "Accumulation" for Function Results: Hangs for ages, long enough to make the user want to force quit. Eventually resumes and populates the fields with: - Data field type = Function - Data field = [Accumulationecrdebitevt_Libel] After that, clicking away and then back on the modified field again hangs LO. So not just a one-off thing: happens every time the information is displayed. After that, the fields contain: - Data field type = User defined function - Function = [Accumulationecrdebitevt_Libel] Tested with: Version: 7.5.4.2 (X86_64) / LibreOffice Community Build ID: 36ccfdc35048b057fd9854c757a8b67ec53977b6 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded
(In reply to Stéphane Guillou (stragu) from comment #12) > > Robert and Pierre, could you please check if the following reports are at > all related? > - bug 77897 Isn't related to this bug, because it isn't about functions in Report Builder > - bug 152170 Might be related, but there is missing an example file to reproduce. > - bug 152782 Might also be related, but there is also missing an example file. Reason for the buggy behavior is the name of the group. Might be it is more than only underscore. Could also be a space ore something else …
FWIW, I ran a recent version of 7.6alpha daily build from one of the buildbots, and reproduced in a LLDB session. After several back and forth, selecting the field, setting Function, then Accumulation, and clicking elsewhere on the report, each time getting a slowdown as described, when it came to saving the report, I got a SIGSEGV. The backtrace of the stack, including everything up to the point of the crash, is enclosed.
Created attachment 188290 [details] LLDB backtrace on macOS Arm
I confirm it's still here in 7.6.4.1 running on Linux (Mint 21.3)
Created attachment 195216 [details] CPU Profile taken during hang using Xcode's Instruments application
(In reply to Patrick Luby (volunteer) from comment #18) > Created attachment 195216 [details] > CPU Profile taken during hang using Xcode's Instruments application Using the steps in comment #13, I obtained the CPU Profile in ttachment #195216 during the hang. From what can see, most of the CPU time is spent doing text search. The "ecrdebit" field is a decimal field so my guess is that the text search is being performed on one of the other columns. Maybe the report is searching for and/or sorting a non-indexed text field?