Bug 152229 - Form Control: Read only doesn't work for special characters. (MacOS only)
Summary: Form Control: Read only doesn't work for special characters. (MacOS only)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.4.1.2 release
Hardware: All macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-11-26 07:58 UTC by Robert Großkopf
Modified: 2022-12-15 06:00 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Open the form. Try to input special characters into field "Name", which is set to "Read only" → 'yes' (12.13 KB, application/vnd.oasis.opendocument.database)
2022-11-26 07:58 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-11-26 07:58:17 UTC
Created attachment 183796 [details]
Open the form. Try to input special characters into field "Name", which is set to "Read only" → 'yes'

Open the attached Base file.
Open the form.
Try to input new content to the field "Name".
Reported for Mac (https://www.libreoffice-forum.de/viewtopic.php?f=10&t=38384): Special characters like "ß ´ § ` ü Ü ö Ö ä Ä" will ignore "Read only" → 'yes'. You could input this characters and save the changed content.

Couldn't find any second person for testing this with a Mac. Don't have Mac here. Bug doesn't appear on Linux systems or on Windows.
Comment 1 Mike Little 2022-12-12 06:14:21 UTC
(In reply to Robert Großkopf from comment #0)
> Created attachment 183796 [details]
> Open the form. Try to input special characters into field "Name", which is
> set to "Read only" → 'yes'
> 
> Open the attached Base file.
> Open the form.
> Try to input new content to the field "Name".
> Reported for Mac
> (https://www.libreoffice-forum.de/viewtopic.php?f=10&t=38384): Special
> characters like "ß ´ § ` ü Ü ö Ö ä Ä" will ignore "Read only" → 'yes'. You
> could input this characters and save the changed content.
> 
> Couldn't find any second person for testing this with a Mac. Don't have Mac
> here. Bug doesn't appear on Linux systems or on Windows.

Hello Robert, thank you for the information. I am on a Mac, but a slight challenge is I am based in Australia and so I have an Australian keyboard, but we will work around that... but in your www.libreoffice-forum.de discussion you made mention to the user manual. To expite things, can you provide me with a link to the relevant topic in the german user manual? [i suspect the UK/Australian manual may not have the same topic]
Comment 2 Robert Großkopf 2022-12-12 07:26:43 UTC
(In reply to Mike Little from comment #1)
> in your www.libreoffice-forum.de
> discussion you made mention to the user manual. To expite things, can you
> provide me with a link to the relevant topic in the german user manual? [i
> suspect the UK/Australian manual may not have the same topic]

German user manual (Base Handbuch) you will get here
https://de.libreoffice.org/get-help/documentation/
direct link to *.pdf is https://wiki.documentfoundation.org/images/9/9d/Base_Gesamtband_einseitig_V74.pdf
… and all updates including this versions you could get at
https://www.familiegrosskopf.de/robert/

Think you are looking for Control.EnableVisible or Control.ReadOnly. This appears on page 470 in Base Handbuch V 7.4

For different questions about Base Handbuch you could mail directly to me.

But this all has nothing to do with the bug. The buggy behavior seems to appear without any macro.
Comment 3 Alex Thurgood 2022-12-12 14:08:39 UTC
Hi Robert,

Confirming with 

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

macOS Ventura 13.0.1 M1 Arm Silicon

I can enter a number of umlauted characters, e.g. ö, ü, ä, and the accented characters é, à, è, and §, etc, in fact pretty much any character that also uses the Shift-Option-Letter key combination.

For example, pressing Shift-Option-T inserts a superscript "TM" into the form and is saved to the table.
Comment 4 Mike Little 2022-12-15 04:52:46 UTC
(In reply to Alex Thurgood from comment #3)
> Hi Robert,
> 
> Confirming with 
> 
> Version: 7.4.1.2 / LibreOffice Community
> Build ID: 3c58a8f3a960df8bc8fd77b461821e42c061c5f0
> CPU threads: 8; OS: Mac OS X 13.0.1; UI render: default; VCL: osx
> Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
> Calc: threaded
> 
> macOS Ventura 13.0.1 M1 Arm Silicon
> 
> I can enter a number of umlauted characters, e.g. ö, ü, ä, and the accented
> characters é, à, è, and §, etc, in fact pretty much any character that also
> uses the Shift-Option-Letter key combination.
> 
> For example, pressing Shift-Option-T inserts a superscript "TM" into the
> form and is saved to the table.

Hello Alex, how are you entering the special characters, from the Insert > Special Characters? 
I can confirm that I am able to copy and paste the special character as defined by Robert Großkopf 2022-11-26 07:58:17 UTC into a document, and I can save the document.
Comment 5 Mike Little 2022-12-15 04:55:29 UTC
(In reply to Robert Großkopf from comment #2)
> (In reply to Mike Little from comment #1)
> > in your www.libreoffice-forum.de
> > discussion you made mention to the user manual. To expite things, can you
> > provide me with a link to the relevant topic in the german user manual? [i
> > suspect the UK/Australian manual may not have the same topic]
> 
> German user manual (Base Handbuch) you will get here
> https://de.libreoffice.org/get-help/documentation/
> direct link to *.pdf is
> https://wiki.documentfoundation.org/images/9/9d/
> Base_Gesamtband_einseitig_V74.pdf
> … and all updates including this versions you could get at
> https://www.familiegrosskopf.de/robert/
> 
> Think you are looking for Control.EnableVisible or Control.ReadOnly. This
> appears on page 470 in Base Handbuch V 7.4
> 
> For different questions about Base Handbuch you could mail directly to me.
> 
> But this all has nothing to do with the bug. The buggy behavior seems to
> appear without any macro.



Robert, can you document your procedure and capture screen shots associated with each procedural step?
Comment 6 Alex Thurgood 2022-12-15 06:00:15 UTC
(In reply to Mike Little from comment #4)
> (In reply to Alex Thurgood from comment #3)
> >


> Hello Alex, how are you entering the special characters, from the Insert >
> Special Characters? 
> I can confirm that I am able to copy and paste the special character as
> defined by Robert Großkopf 2022-11-26 07:58:17 UTC into a document, and I
> can save the document.

@Mike: they're not special characters for someone with a European keyboard layout. I just type them in via my French Azerty keyboard on my MacBook Pro.
Some of the umlauted characters require typing the tréma first, followed by the vowel, whereas the most common ones have predefined keys.