Bug 51203 - Hyperlink Field Type in Base
Summary: Hyperlink Field Type in Base
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected)
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
: 97565 (view as bug list)
Depends on:
Blocks: Hyperlink Base-UX
  Show dependency treegraph
Reported: 2012-06-18 05:40 UTC by Peter Jones
Modified: 2017-08-21 11:42 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:
Regression By:

Open any file in Base with the program, which is connected to the filetype (36.54 KB, application/vnd.sun.xml.base)
2012-07-07 13:02 UTC, Robert Großkopf
Try form "Mail_Websiteaufruf_direkt" - behaviour like hyperlink (58.75 KB, application/vnd.sun.xml.base)
2012-07-08 12:15 UTC, Robert Großkopf

Note You need to log in before you can comment on or make changes to this bug.
Description Peter Jones 2012-06-18 05:40:44 UTC

I tried logging this on Nabble, but was told that was the wrong place and should report it as an issue.

Please can a hyperlink field type be added onto Base?


Peter Jones
Comment 1 Robert Großkopf 2012-07-07 13:02:39 UTC
Created attachment 63950 [details]
Open any file in Base with the program, which is connected to the filetype
Comment 2 Robert Großkopf 2012-07-07 13:03:36 UTC
Have added a database (without any table) to show who it works now:
You could use a normal textfield or a field with a mask. The hyperlink must be placed in this field. You could press the button "Anzeigen" and the page will be shown with your browser. Works also with all other formats in your system, which are linked to the extension of the file.
For this funktion you have to enable the makro-functionality in LO.
Have changed the importance to "enhancement".

Comment 3 Robert Großkopf 2012-07-07 23:40:41 UTC
Changed the Importance to "enhancement" and Status to "needinfo".
Comment 4 Robert Großkopf 2012-07-08 12:15:56 UTC
Created attachment 63980 [details]
Try form "Mail_Websiteaufruf_direkt" - behaviour like hyperlink

Little database for more functions. I remembered, that I had created a textfield with blue underlining and hand-cursor. When there is noting inside the textfield you can klick it with the mouse - nothing happens. When you write an adress without "http://" it opens the webbrowser and starts this address.
Activate macros for these functions.
Comment 5 Jochen 2012-07-27 16:24:08 UTC
(In reply to comment #3)
> Changed the Importance to "enhancement" and Status to "needinfo".

Hi Robert,

What information is needed?
Comment 6 Peter Jones 2012-07-27 16:34:04 UTC
I agree, I can not understand what extra info is needed.  I made the original post, and whilst I appreciate the work around, I would just like a field type of 'Hyperlink' which works in the same fashion as MS Access.

Best wishes

Comment 7 Robert Großkopf 2012-07-27 16:59:59 UTC
Did you have tested the attachment "Mail Websiteaufruf direkt"? Is this the function you need?
I don't know anything about field-types in MS Access. But the field in my attachment looks like a link and works like a link. Certainly it isn't a original field-type of Base, because it works with a macro.
You must know there are many people who don't work with MS Access and many databases, which haven't a field-type "hyperlink". They only work with a text-field. Could be MS Access works with a database, which also saves it only in a text-field and works with it like my attachment, programmed original in the GUI.

Comment 8 Peter Jones 2012-07-27 19:50:24 UTC
Thanks for the update.  This does work, but it is a workaround rather that a solution.

If you search on Google for OpenOffice  / LibreOffice Base Hyperlink Fields you will see lots of people have wanted this for many years as an additional field type.  I enclose a request which goes back as far as 2008:


People want to move their databases and get rid of Microsoft software on their machines, but modern day databases need an easy way of handling hyperlinks as field types.

For example, I have a database for my online banking in access, and for each institution I have:

Bank Name
Bank Address
Website Address

It just makes life easier.  Please see below for the Access field types.


Sorry if this sounds like a rant (It is not supposed to), I just spend much of my time trying to convert people to Open Source, and regardless of if we like it or not, we have to compete with Microsoft Office.  It seems that Base is always the last product to get the updates.

Best wishes and I really do appreciate the work the Libre Office team are doing.

Peter Jones
Comment 9 Robert Großkopf 2012-07-27 20:19:54 UTC
I have changed it to NEW, because it hasn't been closed. I have set this to NEEDINFO, because I wanted to be informed if the attachment https://bugs.freedesktop.org/attachment.cgi?id=63980 shows the right behaviour. So we will hope there is someone, who could change the fields in the forms of Base for this behaviour. A field like a hyperlinkfield doesn't exist in the internal HSQLDB. But when it works in forms it will be the best solution for all databases, to which Base would be linked.

Comment 10 Lothar Kallweit 2012-08-21 18:01:46 UTC
I wish to add my support to Peter Jones's request.

This is an important enhancement that would make Base so much more user friendly. I personally would like to see the functionality to mimic that of LO Writer. The user adds a large text field to his table in Base, perhaps called "comments", and in the form he can then add some text and also insert hyperlinks by pressing Insert > Hyperlink, the exact same dialog box as in Writer. The result would be a hyperlink in blue and underlined in the "comments" field of his form that can be opened with ctrl and right click.
No macros, no Python, all designed with the user interface.
Comment 11 Owen Genat (retired) 2014-07-15 08:55:33 UTC
(In reply to comment #6)
> I would just like a field type of 'Hyperlink' which works in the 
> same fashion as MS Access.

This is just for information. The Microsoft Access Hyperlink data type is based on the Microsoft Jet Memo data type i.e., it is a proprietary / non-standard modification. Jet is the database engine used in Access. 

SQL Server has no equivalent of this data type. HSQLDB (v1.8 or v2.3) and Firebird do not have a Hyperlink data type either. The reason why these databases do not have this type is likely because they rely on an SQL specification (e.g., ISO/IEC 9075-2:2008) to determine valid data types. Examining the Final Committee Draft (FCD) for the 2011 version of the SQL specification, indicates this updated version still does not define a Hyperlink data type.

Similarly, ODF v1.2, Part 1, §19.42 (p. 344) defines the db:data-type attribute as being defined by ISO/IEC 9075-2:2008 and gives this example:

> The values of the db:data-type attribute are bit, boolean, tinyint, smallint,
> integer, bigint, float, real, double, numeric, decimal, char, varchar,
> longvarchar, date, time, timestmp, binary, varbinary, longvarbinary, sqlnull,
> other, object, distinct, struct, array, blob, clob or ref.

While I can see the value of having a Hyperlink data type, it would appear to depend on one of these options:

1. Changing ISO/IEC 9075-2 (unlikely).
2. Changing ODF to support a non-standard data type (also unlikely).
3. Changing ODF to include a further data attribute indicating special treatment of a VARCHAR data type (possible, but requiring an OASIS issue to be raised).
4. Some sort of hard-coded implementation in Base for special treatment of a VARCHAR data type (possible, but maybe undesirable).

Option (3) would seem most likely IMO.
Comment 12 Alex Thurgood 2015-01-03 17:40:52 UTC Comment hidden (no-value)
Comment 13 Adolfo Jayme Barrientos 2017-04-10 06:28:32 UTC
*** Bug 97565 has been marked as a duplicate of this bug. ***