https://bugs.documentfoundation.org/show_bug.cgi?id=148233
Bug ID: 148233
Summary: Editing - Form - Listbox: Direct SQL-code with breaks
will be destroyed if edited in text mode
Product: LibreOffice
Version: 7.3.1.3 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 179163
--> https://bugs.documentfoundation.org/attachment.cgi?id=179163&action=edit
Testdatabase - open the form and have a look at the code for data in listbox.
Open the attached database.
Open the form for editing, not for input data.
Right click on the listbox and open the control properties.
Change to folder "data".
List content has been created as direct SQL in the query editor. It contains
some breaks.
Press the "Down" arrow to edit the content in text mode.
Add a space after the first comma.
Press OK.
Now the code has been changed. Every return has been set as a semicolon.
This is the normal behavior of such a textbox, but it destroys the code of the
query.
Open the query editor by the three buttons and you will see only the first row
up to the break. Other content has been lost.
Solution: Disable the text editor if list content is SQL [Native].
--
You are receiving this mail because:
You are the assignee for the bug.
