This bug was filed from the crash reporting server and is br-7412a6b2-8f92-4a61-891f-2ba9b8a7dc26. ========================================= REPORT BUILDER When trying to insert (apparently any) function in report control (text box) via Function Wizard, LO crashes.
Ok, I did Insert - Report controls - Text box, what do I do next?
Created attachment 140706 [details] Selecting desired function
Created attachment 140707 [details] On trying insert formula Base crashes
Try inserting (apparently any) function from thw wizard -- e.g. into a conditional formatting. When Next pressed Base crashes.
(In reply to c18florentino from comment #2) > Created attachment 140706 [details] > Selecting desired function How do I get this?
Say you have field1 and desires to have report line (detail section) of field2 printed only IF field1 IS NOT NULL. How do you do it in Report Builder?
CONDITIONAL FORMATTING > =NOT(IS BLANK(field1)) But note that apparently this happens with any function in the expression builder. And only in 6.x I've never noted this in previous versios of LO Base.
Created attachment 140709 [details] BEFORE selecting desired function BEFORE trying to insert
Created attachment 140710 [details] AFTER When try to insert the formula LO crashes immediately
Another example from ANOTHER MACHINE with W-10 1709 32bits 6.0.2.1 ANOTHER DATABASE Same crash
(In reply to c18florentino from comment #8) > Created attachment 140709 [details] > BEFORE > > selecting desired function BEFORE trying to insert Please tell me exactly what I have to do to get this dialog.
Thank you for reporting the bug. Unfortunately without clear steps to reproduce it, we cannot track down the origin of the problem. Please provide a clearer set of step-by-step instructions on how to reproduce the problem. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the steps are provided
Build a query (I think it could be just 1 field); build a report on the query; try to add a function (e.g. as I've exemplified above) in the field's datasource ("formula or field" property). Best yet: check the report error and o you should be able to check the log. I am not (able to do so)...
SELECT field1, field2 FROM your_table; REPORT DESIGNER ADD >> field1 filed2 Let's say you want a conditional formatting so to field2 just gets printed (in report's detail) if field1 IS NOT NULL But take notice that this is just an example. It appears that the proplem is with ANY function in the wizard. So, I think best is not to fous on a particular example but to look into the log as it shows that the problem happened and where in the code.
Ok, I can repro. Steps: 1. Open any database, for example attachment 140158 [details] 2. Click Reports - Create report in design view 3. Insert - Report controls - Text box 4. In the Data deck of the sidebar, click the "..." next to "Data field" 5. Double-click any function Bisected to https://cgit.freedesktop.org/libreoffice/core/commit/?id=bf1ffc64128f5b96d7c2fcc7adc81cbc25e232fd FormulaDlg_Impl::UpdateValues: evaluate in force-array context if present Arch Linux 64-bit Version: 6.1.0.0.alpha0+ Build ID: c70471a0f984f1c5be7cb5eeaf88e71b17c903ee CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on March 19th 2018
Adding Cc: to Eike Rathke
Created attachment 140721 [details] before crash in example DB
Created attachment 140722 [details] crash with no recovery
In the example DB let's say want to conditional format field txt on ISEVEN(ID) txt > Properties > CF > 1. Select ISEVEN conditional [before crash in example DB] 2. Next (to insert the function) [crash with no recovery] Absolute crash with no immediate recovery. Needed to call Task Manager > End Task LO before recovery of .odb
Taking.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=3a3a61bce913b564c7b7a98c56b55cbc11ea273a Resolves: tdf#116468 do not check array/matrix context for reportdesign It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/51642 for 6-0 https://gerrit.libreoffice.org/51643 for 6-0-3
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-6-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=e722779351bb83af4ca368c143ab9561f1864bcf&h=libreoffice-6-0 Resolves: tdf#116468 do not check array/matrix context for reportdesign It will be available in 6.0.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-6-0-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=084e02969dad50e6a5e636bb6391f52113dec096&h=libreoffice-6-0-3 Resolves: tdf#116468 do not check array/matrix context for reportdesign It will be available in 6.0.3. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.