Ubuntu
libreoffice package

libreoffice base zone liste choix impossible

Bug #1950094 reported by Forestier
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
LibreOffice
New
Medium
libreoffice (Ubuntu)
Triaged
Low
Unassigned

Bug Description

Bonjour,

Ce phénomène existait déjà sous UbuntuMate 20.04. J'ai donc chargé UbuntuMate 21.10 afin de voir si une modification avait été apporté à un éventuel bogue que je vous soumets.

Le souci est avec la zone de liste dans LibreOffice Base avec la macro ci-dessous sur Événement "A réception du focus".

Sub ActualiserListe(oEv as Object)
    oEv.Source.Model.Refresh
End Sub

pour mettre à jour la zone de liste après modification d'un élément.

La mise à jour fonctionne bien mais je ne peux pas choisir une nouvelle entrée dans la liste. Alors que si je choisis un autre événement, comme "souris déplacée alors qu'une touche est pressée" beaucoup moins pratique, je ne rencontre pas ce problème.

Après plusieurs recherches sur le forum OpenOffice il s'avère que la fonction marche bien mais que le problème pourrait venir de l'environnement Ubuntu.

Sauriez-vous m'aider pour débloquer ma situation ?

Dommage que je ne puisse pas joindre mon fichier pour des essais sur vos propres machines ce serait plus "parlant".

Merci.
Éric

Revision history for this message
In , Jeanmichel-coste (jeanmichel-coste) wrote :

Description:
On different versions of Linux. First found on Ubuntu MATE.
Use the attached RefreshForm.odb database.

The fmtBookType (List box) control is updated by the RefreshList macro, connected to the event "when receiving focus".

The list is well updated, Choice possible but not saved.

Description in the file : RefreshForm.odt

Steps to Reproduce:
1. Open the form fBooks
2. click on the "…" button to edit the support table from the drop-down list.
3. add a row in the table
4. close the form that allowed the addition ("close" button)
5. try to change the value of the field "BookType"

Actual Results:
The list is well updated, the choice is possible, but it is not taken into account.

Expected Results:
Choice saved saved

Reproducible: Always

User Profile Reset: Yes

Additional Info:
Version: 7.2.2.2 / LibreOffice Community
Build ID: 02b2acce88a210515b4a5bb2e46cbfb63fe97d56
CPU threads: 2; OS: Linux 5.11; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: en-US
Calc: threaded

Revision history for this message
In , Jeanmichel-coste (jeanmichel-coste) wrote :

Created attachment 176250
The LibreOffice Base to test

Revision history for this message
In , Jeanmichel-coste (jeanmichel-coste) wrote :

Found on several versions of LibreOffice

Revision history for this message
In , Jeanmichel-coste (jeanmichel-coste) wrote :

Created attachment 176251
Description of then problem and list of Linux versions affected

The first observation was made in Ubuntu MATE, but not in Windows. The following tests have shown malfunction on Debiian (XFCE), Ubuntu (XFCE), Fedora (XFCE) , Linux MINT, Linux MX.
Operation is correct on Ubuntu (LXQT), Ubuntu (KDE), Open Suse (KDE), Mageia (KDE)

Martin Wimpress  (flexiondotorg)
no longer affects: ubuntu-mate
Adolfo Jayme Barrientos (fitojb)
Changed in libreoffice (Ubuntu):
importance: Undecided → Low
Bug Watch Updater (bug-watch-updater)
Changed in df-libreoffice:
importance: Unknown → Medium
status: Unknown → New
Sebastien Bacher (seb128)
Changed in libreoffice (Ubuntu):
status: New → Triaged
Revision history for this message
In , Ilmari-lauhakangas (ilmari-lauhakangas) wrote :

(In reply to Jean-Michel COSTE from comment #0)
> Description:
> On different versions of Linux. First found on Ubuntu MATE.
> Use the attached RefreshForm.odb database.
>
> The fmtBookType (List box) control is updated by the RefreshList macro,
> connected to the event "when receiving focus".
>
> The list is well updated, Choice possible but not saved.
>
> Description in the file : RefreshForm.odt
>
> Steps to Reproduce:
> 1. Open the form fBooks
> 2. click on the "…" button to edit the support table from the drop-down list.
> 3. add a row in the table
> 4. close the form that allowed the addition ("close" button)
> 5. try to change the value of the field "BookType"
>
>
> Actual Results:
> The list is well updated, the choice is possible, but it is not taken into
> account.

Do you mean there would be an additional step 6 to click "Save record" from the bar below the form? Because if I do it, there is no problem.

Set to NEEDINFO.
Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED WORKSFORME, if the problem went away.

Arch Linux 64-bit
Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 70987cc656f0cded915be5aa148f265a257ec791
CPU threads: 8; OS: Linux 6.0; UI render: default; VCL: gtk3
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 22 November 2022

Bug Watch Updater (bug-watch-updater)
Changed in df-libreoffice:
status: New → Incomplete
Revision history for this message
In , Nv4y-robert (nv4y-robert) wrote :

Have tested this:
Opened "fbooks"
Entered new row with 'Informatik'.
Switched to previous row to save the data in table control.
Closed by button.
Switched to listbox.
'Informatik' will be shown.

So: No bug detected on
Version: 7.4.3.2 / LibreOffice Community
Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890
CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: en-US
Calc: threaded

Revision history for this message
In , Nv4y-robert (nv4y-robert) wrote :

No bug also in
Version: 7.1.5.2 / LibreOffice Community
Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5
CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5
Locale: de-DE (de_DE.UTF-8); UI: en-US
Calc: threaded

on OpenSUSE 15.3 64 bit rpm.

This is (nearly) one of the versions tested for the bug description.

Revision history for this message
In , Nv4y-robert (nv4y-robert) wrote :

… and new book types could also be saved in both versions of LO, tested with OpenSUSE 15.3 64bit rpm Linux.

Revision history for this message
In , Qa-admin-q (qa-admin-q) wrote :

Dear Jean-Michel COSTE,

This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED. Due to regular bug
tracker maintenance, if the bug is still in NEEDINFO status with
no change in 30 days the QA team will close the bug as INSUFFICIENTDATA
due to lack of needed information.

For more information about our NEEDINFO policy please read the
wiki located here:
https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO

If you have already provided the requested information, please
mark the bug as UNCONFIRMED so that the QA team knows that the
bug is ready to be confirmed.

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-NeedInfo-Ping

Revision history for this message
In , Jeanmichel-coste (jeanmichel-coste) wrote :

After re-examining the problem:
The form is closed using the "Close" button with the ".uno:closewin" statement in the URL property.
On interfaces with GTK3, closing the form is brutal.
On the others, I get the question "
------------------------
Do you want to save your changes?
The content of the current form has been modified.
------------------------
I think I should report another bug?

Bug Watch Updater (bug-watch-updater)
Changed in df-libreoffice:
status: Incomplete → New
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.