Bug 144745 - Copy/Paste into VARCHAR fields in tables and forms does not get written to bound field
Summary: Copy/Paste into VARCHAR fields in tables and forms does not get written to bo...
Status: RESOLVED DUPLICATE of bug 140992
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.1.6.2 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-09-27 03:47 UTC by bugReportLOm
Modified: 2021-09-28 15:19 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description bugReportLOm 2021-09-27 03:47:02 UTC
Description:
Base 
HSQLDB odb, Java Version 8 Update 301
Windows 10.0 Build 19043

Text [VARCHAR] fields:

The Text [VARCHAR] fields show the following problems in:
Version: 7.1.6.2 (x64) / LibreOffice Community
Build ID: 0e133318fcee89abacd6a7d077e292f1145735c3
CPU threads: 6; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL

but not in: 
Version: 7.0.6.2 (x64)
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 6; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL

If one copies and paste text into such a field, no new data set is saved. One must add an empty space at the end to save the new data set. This occurs in forms and tables.
If one moves the mouse over a field with changed format, the field is shown in the standard format.

Makro:

Robert Grosskopf provided this helpful Makro to directly open an internet link or LO file from a text field in a base form:

REM  *****  BASIC  *****

SUB Website_Aufruf(oEvent AS OBJECT)
	REM Aufruf einer Website oder des Mailprogramms mit einer vorgegebenen Mailadresse
	DIM oFeld AS OBJECT
	DIM oShell AS OBJECT
	DIM stFeld AS STRING
	oFeld = oEvent.Source
	REM Den Text aus der Dateiauswahl auslesen
	stFeld = oFeld.Text
	IF stFeld = "" THEN
		EXIT SUB
	END IF
	IF InStr(stFeld,"@") THEN
		stFeld = "mailto:"+stFeld
	ELSEIF InStr(stFeld,"http://") OR InStr(stFeld,"https://") THEN
		stFeld = convertToUrl(stFeld)	'convertToUrl erkennt, dass mit http:// bereits eine Verbindung vorgegeben ist. file:/// wird nicht gesetzt
	ELSE	
	END IF
	REM Start des Files mit der entsprechenden URL-Verbindung
	oShell = createUnoService("com.sun.star.system.SystemShellExecute")
	oShell.execute(stFeld,,0)
END SUB

This worked with:
Version: 7.0.6.2 (x64)
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 6; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL

With:
Version: 7.1.6.2 (x64) / LibreOffice Community
Build ID: 0e133318fcee89abacd6a7d077e292f1145735c3
CPU threads: 6; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL

it does not work.
Error message:
BASIC run time error
argument not optional

this line is marked:
oFeld = oEvent.Source

The makro is started by clicking on the text field containing a link. In the form Properties: Text box, events the makro is connected to "Mouse button pressed".

The links to be opened by the makro are in fields with Text [VARCHAR].

Actual Results:
no new data set
makro did not run

Expected Results:
new data set
makro starts


Reproducible: Always


User Profile Reset: Yes



Additional Info:
makro Error message:
BASIC run time error
argument not optional

this line is marked:
oFeld = oEvent.Source
Comment 1 Alex Thurgood 2021-09-27 09:18:54 UTC
@bugReportLOm 

You have described what appear to be at least 3 different issues here, please open a separate ones for each.

1) Copy/Paste into table grid view or form for VARCHAR field

2) Mouse over format display - please provide in the new bug report to be opened more details for this than what you have given here, for example, what do you meanby "over a field with changed format" ? Where/how did you change the format of the field ?

3) Basic Macro oEvent.Source execution
Comment 2 Alex Thurgood 2021-09-27 09:22:09 UTC
The copy/paste problem is known from bug 140992, therefore this problem is a duplicate.

As requested, please open separate bug reports for the other 2 issues.

*** This bug has been marked as a duplicate of bug 140992 ***
Comment 3 bugReportLOm 2021-09-28 15:19:12 UTC
@  Alex Thurgood 
Sorry for the confusion in my report.

I opened two more reports:

Basic Macro oEvent.Source execution in a form, started in a Text [VARCHAR] field
https://bugs.documentfoundation.org/show_bug.cgi?id=144772

Text [VARCHAR] fields problem in forms, modified font format changes with mouse action to standard
https://bugs.documentfoundation.org/show_bug.cgi?id=144773