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
@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
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 ***
@ 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