[Libreoffice-bugs] [Bug 133143] [WRITER] - ListBox disabled when the file is opened or until saved.
https://bugs.documentfoundation.org/show_bug.cgi?id=133143 Justin L changed: What|Removed |Added Resolution|--- |NOTABUG Status|NEW |RESOLVED --- Comment #13 from Justin L --- I think I'll close this as NOTABUG - comment 11, since that seems to match OP's reported problem. I'm don't know if Robert's "The second might be related: When creating the SQL for list boxes there isn't shown any content when testing the query" is still a concern - but that should be reported separately if so, because it is not at all clear what needs to happen with that. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133143] [WRITER] - ListBox disabled when the file is opened or until saved.
https://bugs.documentfoundation.org/show_bug.cgi?id=133143 Justin L changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=13 ||9298 --- Comment #12 from Justin L --- (In reply to Robert Großkopf from comment #8) > there is a third bug: It seems to be impossible to edit the SQL-code > when it has been created. The button with the 3 points has been gone in LO > 7.1.0.1. This seems to have been reported as bug 139298, which is fixed in 7.1. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133143] [WRITER] - ListBox disabled when the file is opened or until saved.
https://bugs.documentfoundation.org/show_bug.cgi?id=133143 Justin L changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=12 ||6731 --- Comment #11 from Justin L --- (In reply to Pierre Marty from comment #5) > However, this field becomes clickable when the document is saved, with or > without modifications. This sounds like bug 126731, which I marked as NOTABUG. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133143] [WRITER] - ListBox disabled when the file is opened or until saved.
https://bugs.documentfoundation.org/show_bug.cgi?id=133143 --- Comment #10 from Robert Großkopf --- Could be the reason for this bug is https://bugs.documentfoundation.org/show_bug.cgi?id=139267. The connection to the database will be lost. Seems LO 7.1 tries to save the connection at a new place (doesn't read the information from older versions from LO) and couldn't read any saved information for the database connection. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133143] [WRITER] - ListBox disabled when the file is opened or until saved.
https://bugs.documentfoundation.org/show_bug.cgi?id=133143 QA Administrators changed: What|Removed |Added Keywords||bibisectRequest -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133143] [WRITER] - ListBox disabled when the file is opened or until saved.
https://bugs.documentfoundation.org/show_bug.cgi?id=133143 Robert Großkopf changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=13 ||9267 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133143] [WRITER] - ListBox disabled when the file is opened or until saved.
https://bugs.documentfoundation.org/show_bug.cgi?id=133143 Robert Großkopf changed: What|Removed |Added Keywords||regression -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133143] [WRITER] - ListBox disabled when the file is opened or until saved.
https://bugs.documentfoundation.org/show_bug.cgi?id=133143 --- Comment #9 from Robert Großkopf --- Created attachment 168523 --> https://bugs.documentfoundation.org/attachment.cgi?id=168523=edit Example with internal HSQLDB - connect database and open odt-file in LO All this I tested with OpenSUSE 15.2 64bit rpm Linux and different LO-versions. Works up to LO 7.0.4.2, fails with LO 7.1.0.1. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133143] [WRITER] - ListBox disabled when the file is opened or until saved.
https://bugs.documentfoundation.org/show_bug.cgi?id=133143 Robert Großkopf changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEW --- Comment #8 from Robert Großkopf --- The examples are very special: The database is a text-database. You can't input values in the table. And the only table in the database is the table for the values, which should be shown (and changed) through the list box - and could never be changed. If I try it with a "normal" internal HSQLDB and an external Writer form I get a different result: Open the attached *.zip Connect the database inside this *.zip with LO by Tools → Options → LibreOffice Base ... Open the *.odt-file. Both list boxes are filled with data in LO 7.0.4.2 an all earlier versions of LO. Both list boxes aren't filled with data in LO 7.1.0.1 This is one of the different bugs I detected with LO 7.1.0.1 when testing this. The second might be related: When creating the SQL for list boxes there isn't shown any content when testing the query. You can't test this again, because there is a third bug: It seems to be impossible to edit the SQL-code when it has been created. The button with the 3 points has been gone in LO 7.1.0.1. I could confirm the list boxes don't show any content when opening an external form with LO 7.1.0.1 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133143] [WRITER] - ListBox disabled when the file is opened or until saved.
https://bugs.documentfoundation.org/show_bug.cgi?id=133143 Dieter changed: What|Removed |Added CC||rob...@familiegrosskopf.de --- Comment #7 from Dieter --- Robert can you (In reply to Dieter from comment #6) > I can confirm the observed behaviour with steps from comment 5, but I'm not > familiar enough with that topic (list boxes with a link to odb-file) to > assess, if this is a bug or a result of a wrong setting (help content is > missing). Sorry. Robert, can you help here? cc: rob...@familiegrosskopf.de -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133143] [WRITER] - ListBox disabled when the file is opened or until saved.
https://bugs.documentfoundation.org/show_bug.cgi?id=133143 Dieter changed: What|Removed |Added CC||dgp-m...@gmx.de Blocks||107742 --- Comment #6 from Dieter --- I can confirm the observed behaviour with steps from comment 5, but I'm not familiar enough with that topic (list boxes with a link to odb-file) to assess, if this is a bug or a result of a wrong setting (help content is missing). Sorry. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=107742 [Bug 107742] [META] Form control bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133143] [WRITER] - ListBox disabled when the file is opened or until saved.
https://bugs.documentfoundation.org/show_bug.cgi?id=133143 Pierre Marty changed: What|Removed |Added Whiteboard| QA:needsComment| -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133143] [WRITER] - ListBox disabled when the file is opened or until saved.
https://bugs.documentfoundation.org/show_bug.cgi?id=133143 Pierre Marty changed: What|Removed |Added Version|7.0.0.0.alpha1+ |7.1.0.0.alpha0+ Master --- Comment #5 from Pierre Marty --- Hi ! Here are more details about this bug. Description: A ListBox field, which obtains its content through an SQL query to an external database stored in a .odb file, is not clickable at document opening. It is visible but grayed out as a "disabled" field, yet it is noted as "enabled" if inspecting "Control Properties" in "Design Mode". Bypass: However, this field becomes clickable when the document is saved, with or without modifications. See attached video for a demo. Steps to Reproduce: 1. Download the "test.odt", "test.csv" and the "test.odb" files attached 2. Open "test.odt" 3. Enter in Design mode 4. Right-click on the second field (might be empty) and go to the "Form properties" 5. In the "Data" tab, click on "..." to match "Data source" with the "test.odb" file 6. In the same tab set the "Content" to "test" 7. Close the "Form properties" and access to "Control properties" 8. Verify the field is "Enable", "Visible" and not in "Read-Only" in the "General" tab 9. In the "Data" tab set "Data Field" to "Service" 10. In the same tab set "List Content" to " SELECT "Service", "Service" FROM "test" " 11. Close the "Control properties" and exit the "Design Mode" Actual Results: 12. The ListBox is not clickable but well set as "Enable" 13. Save the document 14. The list is now clickable Expected Results: 12. The ListBox is clickable Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.1.0.0.alpha0+ Build ID: f9fb86408e6e06c262332be26674305ae5c05bb7 CPU threads: 12; OS: Linux 4.4; UI render: default; VCL: x11 Locale: en-US (C.UTF-8); UI: en-US Calc: threaded Version: 7.1.0.0.alpha0+ (x64) Build ID: 75eeb423196c1e94a0189b7eccff37aed5765853 Threads CPU : 12; OS : Windows 10.0 Build 18363; UI Render : Skia/Vulkan; VCL: win Locale: fr-FR (fr_FR); Langue IHM : fr-FR Calc: CL Version: 7.0.0.0.alpha1+ Build ID: ef1b75a60466dda61a9d28b03262f6db357142a5 CPU threads: 12; OS: Linux 4.4; UI render: default; VCL: x11; Locale: en-US (C.UTF-8); UI: en-US Calc: threaded Version : 6.4.3.2 (x64) Build ID : 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8 Threads CPU : 12; OS : Windows 10.0 Build 18363; UI Render : GL; VCL: win; Locale : fr-FR (fr_FR); Langue IHM : fr-FR Calc: CL Version: 6.4.0.1 (x64) Build ID: 1b6477b31f0334bd8620a96f0aeeb449b587be9f Threads CPU : 12; OS : Windows 10.0 Build 18363; UI Render : GL; VCL: win; Locale : fr-FR (fr_FR); Langue IHM : fr-FR Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133143] [WRITER] - ListBox disabled when the file is opened or until saved.
https://bugs.documentfoundation.org/show_bug.cgi?id=133143 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133143] [WRITER] - ListBox disabled when the file is opened or until saved.
https://bugs.documentfoundation.org/show_bug.cgi?id=133143 --- Comment #4 from Pierre Marty --- Created attachment 160971 --> https://bugs.documentfoundation.org/attachment.cgi?id=160971=edit odb file to link to the odt -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133143] [WRITER] - ListBox disabled when the file is opened or until saved.
https://bugs.documentfoundation.org/show_bug.cgi?id=133143 --- Comment #3 from Pierre Marty --- Created attachment 160970 --> https://bugs.documentfoundation.org/attachment.cgi?id=160970=edit csv datas for the odb file -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133143] [WRITER] - ListBox disabled when the file is opened or until saved.
https://bugs.documentfoundation.org/show_bug.cgi?id=133143 --- Comment #2 from Pierre Marty --- Created attachment 160969 --> https://bugs.documentfoundation.org/attachment.cgi?id=160969=edit odt file with the list box -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133143] [WRITER] - ListBox disabled when the file is opened or until saved.
https://bugs.documentfoundation.org/show_bug.cgi?id=133143 --- Comment #1 from Pierre Marty --- Created attachment 160968 --> https://bugs.documentfoundation.org/attachment.cgi?id=160968=edit Demonstration of the bug -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs