Bug 145156 - Copy/Paste to Text editor/Spreadsheet does not work with Table Control of a Form, which is connected to data by a simple SQL command
Summary: Copy/Paste to Text editor/Spreadsheet does not work with Table Control of a F...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.4.7.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-10-15 16:44 UTC by intmail01
Modified: 2023-10-17 15:14 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
The configuration of the source of data (23.42 KB, image/png)
2021-10-15 21:11 UTC, intmail01
Details
Open the different forms of the database. Tablecontrols of forms connected through SQL couldnt be copied. (64.62 KB, application/vnd.oasis.opendocument.database)
2021-10-16 07:09 UTC, Robert Großkopf
Details

Note You need to log in before you can comment on or make changes to this bug.
Description intmail01 2021-10-15 16:44:30 UTC
Description:
Data in a Form inside a 'Table Control' array can not be copied then paste. The clipboard is empty. Does not work whether it is a spreadsheet or simple text editor. The source is postgresql, content type is an sql command.


Steps to Reproduce:
1.clic upper-left corner of the Table Control
2.right-clic "Copy"
3.Open an new spreadsheet or a Text editor
4.Do edit > Paste --> Nothing appears

Actual Results:
Nothing appears

Expected Results:
Data must be pasted with a columns label


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Version: 7.0.6.2
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3
Locale: fr-FR (en_US); UI: en-US
Calc: threaded
Comment 1 Robert Großkopf 2021-10-15 18:48:05 UTC
Have tested this one with a table control inside a form.
Copied the content.
Pasted the content to a new Calc document.

No Problem appears under OpenSUSE 15.2 64bit rpm Linux, LibreOffice
Version: 7.2.2.2 / LibreOffice Community
Build ID: 02b2acce88a210515b4a5bb2e46cbfb63fe97d56
CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded

Same with Version 7.0.5.2 on the same system.

Copied content could be pasted as table to the Calc sheet.
Comment 2 intmail01 2021-10-15 21:11:04 UTC
Created attachment 175771 [details]
The configuration of the source of data
Comment 3 intmail01 2021-10-15 21:12:43 UTC
(In reply to Robert Großkopf from comment #1)
> Have tested this one with a table control inside a form.
> Copied the content.
> Pasted the content to a new Calc document.
> 
> No Problem appears under OpenSUSE 15.2 64bit rpm Linux, LibreOffice
> Version: 7.2.2.2 / LibreOffice Community
> Build ID: 02b2acce88a210515b4a5bb2e46cbfb63fe97d56
> CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb)
> Locale: de-DE (de_DE.UTF-8); UI: de-DE
> Calc: threaded
> 
> Same with Version 7.0.5.2 on the same system.
> 
> Copied content could be pasted as table to the Calc sheet.


My setting is an sql code that is why it does not work.
The copy/paste works ONLY if the source is a table.
Please check the previous attached picture to see my configurations.
Comment 4 Robert Großkopf 2021-10-16 07:09:08 UTC
Created attachment 175774 [details]
Open the different forms of the database. Tablecontrols of forms connected through SQL couldnt be copied.

Open the attached database.
There are 3 forms.
Content off all forms is the same.
Forms are connected in different ways to the data.
One form is connected directly to the table, another connected to a query and the last connected to SQL.
Mark the content of the table control with left mouse button in the upper left corner of the control.
Right mouse button for the context menu and copy the content.
Open an empty Calc document.
Paste the content.

Pasting the content will work with the forms connected to the table and connected to the query, but won't work with form connected through SQL.

This buggy behavior appears here with all installed LO versions, for example LO 6.4.7.2, also LO 7.2.2.2 on OpenSUSE 15.2 64bit rpm Linux.
Comment 5 QA Administrators 2023-10-17 03:13:56 UTC Comment hidden (obsolete)
Comment 6 Robert Großkopf 2023-10-17 15:14:59 UTC
Bug is still the same in LO 7.6.2.1 on OpenSUSE 15.4 64bit rpm Linux.