Created attachment 194325 [details] Open the database, execute the report. Then open the report for editing… Open the attached database. Execute the report "ConditionalFormattingTown". There will be shown a field with towns and different colors for different rows of data. Open the report for editing. Click on the field [=Town]. Format → Conditional Formatting Note: There is no background color visible in the dialog, but it is chosen in this dialog and will be shown when executing the report. This bug appears in current LO 24.2.3.2. Bug also appears in Version: 7.4.7.2 / LibreOffice Community Build ID: 723314e595e8007d3cf785c16538505a1c878ca5 CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: en-US Calc: threaded and also older versions. This bug also appears when starting LO with SAL_USE_VCLPLUGIN=gen ./soffice This bug didn't appear in older versions. I have made screenshots for Base Handbook and this screenshots will show the background. But I couldn't get the background working with any version since LO 7.2.5.2 I will set this one as a regression.
Confirmed with: Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 92815f3a464b447898ecf52492247335228e4a72 CPU threads: 4; OS: Linux 6.6; UI render: default; VCL: gtk3 Locale: he-IL (en_IL); UI: en-US Calc: threaded
@Robert: Unfortunately, with: Version: 7.6.7.2 (AARCH64) / LibreOffice Community Build ID: dd47e4b30cb7dab30588d6c79c651f218165e3c5 CPU threads: 8; OS: Mac OS X 14.5; UI render: Skia/Raster; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded I get the following error when trying to open the report: org.libreoffice.report.ReportExecutionException: La table « tbl_Town » n'existe pas. org.libreoffice.report.ReportExecutionException: La table « tbl_Town » n'existe pas. at org.libreoffice.report.pentaho.PentahoReportJob.execute(PentahoReportJob.java:348) at org.libreoffice.report.pentaho.SOReportJobFactory$_SOReportJobFactory.execute(SOReportJobFactory.java:237) Caused by: org.jfree.report.ReportDataFactoryException: La table « tbl_Town » n'existe pas. at org.libreoffice.report.pentaho.StarReportDataFactory.queryData(StarReportDataFactory.java:68) at org.jfree.report.data.CachingReportDataFactory.queryData(Unknown Source) at org.jfree.report.data.ReportDataRow.createDataRow(Unknown Source) at org.jfree.report.flow.DefaultFlowController.performQuery(Unknown Source) at org.jfree.report.flow.layoutprocessor.ReportLayoutController.startData(Unknown Source) at org.jfree.report.flow.layoutprocessor.ElementLayoutController.startElement(Unknown Source) at org.jfree.report.flow.layoutprocessor.ElementLayoutController.advance(Unknown Source) at org.jfree.report.flow.AbstractReportProcessor.processReportRun(Unknown Source) at org.jfree.report.flow.SinglePassReportProcessor.processReport(Unknown Source) at org.libreoffice.report.pentaho.PentahoReportJob.execute(PentahoReportJob.java:336) ... 1 more Indeed the file doesn't appear to contain any tables when I look in the Tables part of the main ODB window.
(In reply to Alex Thurgood from comment #2) > @Robert: Unfortunately, with: > > Version: 7.6.7.2 (AARCH64) / LibreOffice Community > Build ID: dd47e4b30cb7dab30588d6c79c651f218165e3c5 > CPU threads: 8; OS: Mac OS X 14.5; UI render: Skia/Raster; VCL: osx > Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR > Calc: threaded > > I get the following error when trying to open the report: > > Forget this comment, I had the JDBCOOo/SQLite driver extensions installed, and this f*$ks up embedded hsqldb files...had to remove those extensions and redownload the test file. @Robert: when I display the Properties of the Town field in the report, I don't see a Format > Conditional Formatting entry I see "Conditional Print Expression" or "Formatting", but neither of these leads me to "Conditional Formatting". The "Background Colour" control is greyed out, and unselectable. Am I missing something ?
(In reply to Alex Thurgood from comment #3) > > @Robert: when I display the Properties of the Town field in the report, I > don't see a Format > Conditional Formatting entry > > I see "Conditional Print Expression" or "Formatting", but neither of these > leads me to "Conditional Formatting". The "Background Colour" control is > greyed out, and unselectable. > > Am I missing something ? I open the report for editing. Then I click on a field I want to format. In menue (not in properties on the right) I open "Format" → "Conditional Formatting…" Seems you are looking for the properties of the element on the right. Comment 1 confirmed the bug, so I set this one to NEW.
(In reply to Robert Großkopf from comment #4) > > I open the report for editing. > Then I click on a field I want to format. > In menue (not in properties on the right) I open "Format" → "Conditional > Formatting…" > Seems you are looking for the properties of the element on the right. > > Comment 1 confirmed the bug, so I set this one to NEW. Ah, thanks very much for the explanation, I can reproduce the behaviour. Additionally, I can also reproduce the behaviour in LO7181, so for me the problem goes even further back than 7.2.5.2.
This seems to have begun at the below commit in bibisect repository/OS linux-64-7.1. Adding Cc: to Heiko Tietze ; Could you possibly take a look at this one? Thanks c256732ac1456b609477b088ee27d9d354065523 is the first bad commit commit c256732ac1456b609477b088ee27d9d354065523 Author: Jenkins Build User <tdf@pollux.tdf> Date: Tue Nov 3 22:14:58 2020 +0100 source 6f3899b27156591e65f62649a92c727eb6f5dd03 https://git.libreoffice.org/core/+/6f3899b27156591e65f62649a92c727eb6f5dd03 Resolves tdf#137059 - Use application colors for font preview
Run into the error (Report > Edit...) "The document "ConditionalFormattingTown" could not be opened. at /usr/src/debug/libreoffice-fresh/libreoffice-24.2.3.2/connectivity/source/commontools/dbexception.cxx:179". You may also share a screenshot.
(In reply to Heiko Tietze from comment #7) > Run into the error (Report > Edit...) > > "The document "ConditionalFormattingTown" could not be opened. at > /usr/src/debug/libreoffice-fresh/libreoffice-24.2.3.2/connectivity/source/ > commontools/dbexception.cxx:179". > > You may also share a screenshot. Let me guess: You are using a LibreOffice-version, which is part of a Linux distribution. Very much distributions (here: OpenSUSE) will throw this error since a long time for every report. Original packages from LO won't throw this error. I will add a screenshot with executed report and dialog for conditional formatting.
Created attachment 194379 [details] Shows result of the report and dialog "Conditional Formatting" for the field "Town".
(In reply to Robert Großkopf from comment #8) > You are using a LibreOffice-version, which is part of a Linux distribution. Correct, and it works with self-build master. (In reply to raal from comment #6) > This seems to have begun at the below commit... Hard to imagine what my fiddling around with application colors has an impact on Base. The alternating color still work yet not for the defined field.