[Libreoffice-bugs] [Bug 144826] Conditional formatting works in Base table, not in forms
https://bugs.documentfoundation.org/show_bug.cgi?id=144826 --- Comment #16 from robinwalte...@gmail.com --- Robert Großkopf - that DOES work, thank you! Nice to know that it was as simple as setting the font colour to automatic. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144826] Conditional formatting works in Base table, not in forms
https://bugs.documentfoundation.org/show_bug.cgi?id=144826 Robert Großkopf changed: What|Removed |Added Resolution|--- |WORKSFORME Status|UNCONFIRMED |RESOLVED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144826] Conditional formatting works in Base table, not in forms
https://bugs.documentfoundation.org/show_bug.cgi?id=144826 --- Comment #15 from Robert Großkopf --- Created attachment 175789 --> https://bugs.documentfoundation.org/attachment.cgi?id=175789=edit Same database - now with conditional formatted content in a form field Uploaded the database. The field will now show the font in a conditional formatted way, because the font isn't directly set to a font color. Have switched the color to automatic. I will set this bug to worksforme. Feel free to reopen, if it doesn't solve your problem. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144826] Conditional formatting works in Base table, not in forms
https://bugs.documentfoundation.org/show_bug.cgi?id=144826 Robert Großkopf changed: What|Removed |Added CC||rob...@familiegrosskopf.de --- Comment #14 from Robert Großkopf --- Formatting of the font overwrites the conditional formatting: Go to Control properties of the formatted field. General → Font → Button … Character → Font Effects → Font color Change the value from "black" to "automatic" The wizards for forms will set font color to black instead of "automatic". If you create a form directly without a wizard it will be "automatic". -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144826] Conditional formatting works in Base table, not in forms
https://bugs.documentfoundation.org/show_bug.cgi?id=144826 QA Administrators changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144826] Conditional formatting works in Base table, not in forms
https://bugs.documentfoundation.org/show_bug.cgi?id=144826 --- Comment #13 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144826] Conditional formatting works in Base table, not in forms
https://bugs.documentfoundation.org/show_bug.cgi?id=144826 --- Comment #12 from robinwalte...@gmail.com --- The attached DB is a 10 day old WIP from a rank newbie trying to learn about DBs and SQL from scratch - likely to cause horror and laughter for seasoned DB pros. Sorry! -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144826] Conditional formatting works in Base table, not in forms
https://bugs.documentfoundation.org/show_bug.cgi?id=144826 --- Comment #11 from robinwalte...@gmail.com --- Created attachment 175435 --> https://bugs.documentfoundation.org/attachment.cgi?id=175435=edit The Db I'm trying to put conditionally formatted form fields in -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144826] Conditional formatting works in Base table, not in forms
https://bugs.documentfoundation.org/show_bug.cgi?id=144826 --- Comment #10 from robinwalte...@gmail.com --- First of all, can I just say that I am stunned by the response to this bug. Thank you all. It's barely even a bug really since it's only a minor cosmetic detail Regarding the suggestion to use a formatted field control, I believe that the control in question is a formatted field, at least if I understand the attached screenshot correctly. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144826] Conditional formatting works in Base table, not in forms
https://bugs.documentfoundation.org/show_bug.cgi?id=144826 --- Comment #9 from robinwalte...@gmail.com --- Created attachment 175434 --> https://bugs.documentfoundation.org/attachment.cgi?id=175434=edit comtrol properties dialog box -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144826] Conditional formatting works in Base table, not in forms
https://bugs.documentfoundation.org/show_bug.cgi?id=144826 Alex Thurgood changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #8 from Alex Thurgood --- @Robin : please provide a sample ODB file with which we can try and confirm/infirm your findings, along with instructions on how to reproduce. If you can get this to work with a Formatted Field Control, then please report back. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144826] Conditional formatting works in Base table, not in forms
https://bugs.documentfoundation.org/show_bug.cgi?id=144826 --- Comment #7 from Alex Thurgood --- @Robin : Perhaps you should be using a "Formatted Field Control" instead ? See, for example the Base Guide, page 145 : https://nextcloud.documentfoundation.org/s/Rt67sEsWtg4TQJR -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144826] Conditional formatting works in Base table, not in forms
https://bugs.documentfoundation.org/show_bug.cgi?id=144826 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #6 from m.a.riosv --- (In reply to robinwalter31 from comment #0) > ... > Following the instructions at > https://help.libreoffice.org/7.2/en-US/text/shared/01/05020301. > html?=CALC > The link it's about calc not base. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144826] Conditional formatting works in Base table, not in forms
https://bugs.documentfoundation.org/show_bug.cgi?id=144826 --- Comment #5 from Alex Thurgood --- @Robin : Please see also this discussion : https://forum.openoffice.org/en/forum/viewtopic.php?f=39=84111 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144826] Conditional formatting works in Base table, not in forms
https://bugs.documentfoundation.org/show_bug.cgi?id=144826 --- Comment #4 from Alex Thurgood --- @Robin : it is interesting though, that the datasource grid (as illustrated in your screenshot) is NumberFormatter aware, but not the Form controls. ConditionalFormatting is also possible in the ReportBuilder. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144826] Conditional formatting works in Base table, not in forms
https://bugs.documentfoundation.org/show_bug.cgi?id=144826 --- Comment #3 from Alex Thurgood --- (In reply to Alex Thurgood from comment #2) > My understanding is that this is not possible in Base, other than through > macro coding of the condition and corresponding format. Oh, and this question too from the Ask website : https://ask.libreoffice.org/t/conditional-formatting-in-table-controls/227 which basically confirms that conditional formatting isn't available in forms, at least not for grid controls. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144826] Conditional formatting works in Base table, not in forms
https://bugs.documentfoundation.org/show_bug.cgi?id=144826 Alex Thurgood changed: What|Removed |Added OS|Windows (All) |All -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144826] Conditional formatting works in Base table, not in forms
https://bugs.documentfoundation.org/show_bug.cgi?id=144826 --- Comment #2 from Alex Thurgood --- My understanding is that this is not possible in Base, other than through macro coding of the condition and corresponding format. See for example: https://ask.libreoffice.org/t/base-query-conditional-formatting/26559 The help page you have linked to relates to Calc, not Base. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144826] Conditional formatting works in Base table, not in forms
https://bugs.documentfoundation.org/show_bug.cgi?id=144826 --- Comment #1 from robinwalte...@gmail.com --- Version: 7.2.1.2 (x64) / LibreOffice Community Build ID: 87b77fad49947c1441b67c559c339af8f3517e22 CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: en-NZ (en_NZ); UI: en-GB Calc: CL -- You are receiving this mail because: You are the assignee for the bug.
