Bug 148233 - Editing - Form - Listbox: Direct SQL-code with breaks will be destroyed if edited in text mode
Summary: Editing - Form - Listbox: Direct SQL-code with breaks will be destroyed if ed...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.3.1.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, regression
Depends on:
Blocks: Database-Forms Database-Queries
  Show dependency treegraph
 
Reported: 2022-03-28 10:49 UTC by Robert Großkopf
Modified: 2024-12-21 15:24 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Testdatabase - open the form and have a look at the code for data in listbox. (12.30 KB, application/vnd.oasis.opendocument.database)
2022-03-28 10:49 UTC, Robert Großkopf
Details
Description with screenshots (124.25 KB, application/pdf)
2022-03-28 10:49 UTC, Robert Großkopf
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2022-03-28 10:49:21 UTC
Created attachment 179163 [details]
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].
Comment 1 Robert Großkopf 2022-03-28 10:49:55 UTC
Created attachment 179164 [details]
Description with screenshots
Comment 2 Alex Thurgood 2022-04-01 07:52:39 UTC
Confirming with

Version: 7.3.1.3 / LibreOffice Community
Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951
CPU threads: 8; OS: Mac OS X 12.2.1; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded

regression
Comment 3 QA Administrators 2024-04-02 03:12:06 UTC Comment hidden (obsolete)
Comment 4 Robert Großkopf 2024-04-02 06:12:11 UTC
Same buggy behavior with LO 24.2.2.2 on OpenSUSE 15.4 64bit rpm Linux