Created attachment 190405 [details] Open the query "qry_Person_Grade_1to1". Write a value in Grade in first line. Move down with arrow key. Open the attached database. Open the query "qry_Person_Grade_1to1". Write something in "GradeMath" in first row. Go down with arrow key. Entry follows the cursor. Looks like the value will be copied, but isn't. Value is only shown in GUI, won't be saved by moving the cursor to anywhere. But: Irritates a lot! Tested here with Version: 7.6.2.1 (X86_64) / LibreOffice Community Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333 CPU threads: 6; OS: Linux 5.14; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded had the same bug with MariaDB and JDBC-Connection. Thought it was a special bug there, but it seems a buggy behavior when connecting 2 tables with 1:1-connection. Test "qry_Person_Grade_1toN". Works with out any problem.
*** Bug 157898 has been marked as a duplicate of this bug. ***
Confirmed with Version: 7.6.3.0.0+ (X86_64) / LibreOffice Community Build ID: 9395171aa8641341316f87e2537dcdfa3df4ef78 CPU threads: 8; OS: Mac OS X 14.0; UI render: Skia/Raster; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: en-US Calc: threaded Running that dev build in lldb debug session, and using query1to1 I see the following when moving from one cell to another: warn:legacy.tools:8366:62177:svtools/source/brwbox/editbrowsebox2.cxx:94: EditBrowseBox::CreateAccessibleControl: invalid index! warn:legacy.tools:8366:62177:svtools/source/brwbox/editbrowsebox2.cxx:68: EditBrowseBox::implCreateActiveAccessible: not to be called if we're not editing currently! warn:svx.fmcomp:8366:62177:svx/source/fmcomp/fmgridcl.cxx:1915: com.sun.star.beans.UnknownPropertyException message: "-1" However, I also see similar output when using query1toN: warn:legacy.tools:8366:62177:svtools/source/brwbox/editbrowsebox2.cxx:94: EditBrowseBox::CreateAccessibleControl: invalid index! warn:legacy.tools:8366:62177:svtools/source/brwbox/editbrowsebox2.cxx:68: EditBrowseBox::implCreateActiveAccessible: not to be called if we're not editing currently! warn:svx.fmcomp:8366:62177:svx/source/fmcomp/fmgridcl.cxx:1915: com.sun.star.beans.UnknownPropertyException message: "-1" warn:legacy.tools:8366:62177:svtools/source/brwbox/editbrowsebox2.cxx:94: EditBrowseBox::CreateAccessibleControl: invalid index! warn:legacy.tools:8366:62177:svtools/source/brwbox/editbrowsebox2.cxx:68: EditBrowseBox::implCreateActiveAccessible: not to be called if we're not editing currently! warn:svx.fmcomp:8366:62177:svx/source/fmcomp/fmgridcl.cxx:1915: com.sun.star.beans.UnknownPropertyException message: "-1" warn:legacy.osl:8366:62177:comphelper/source/misc/accessiblewrapper.cxx:457: OAccessibleContextWrapperHelper::disposing(): inner context is no broadcaster! warn:legacy.osl:8366:62177:comphelper/source/misc/accessiblewrapper.cxx:457: OAccessibleContextWrapperHelper::disposing(): inner context is no broadcaster! warn:legacy.osl:8366:62177:comphelper/source/misc/accessiblewrapper.cxx:457: OAccessibleContextWrapperHelper::disposing(): inner context is no broadcaster! warn:legacy.osl:8366:62177:comphelper/source/misc/accessiblewrapper.cxx:457: OAccessibleContextWrapperHelper::disposing(): inner context is no broadcaster!
Also in Version: 7.1.0.0.alpha0+ Build ID: 63bf8f042abe3c0f6989f6763d13f5389182b816 CPU threads: 16; OS: Linux 6.2; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded 7.1 is the oldest version I can test.
tested with MariaDB and direct connection in Version: 6.2.0.3 Build-ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62 CPU-Threads: 6; BS: Linux 5.14; UI-Render: Standard; VCL: kde5; Gebietsschema: de-DE (de_DE.UTF-8); UI-Sprache: de-DE Calc: threaded Same buggy behavior.
So maybe not a regression then, just never worked ?
(In reply to Alex Thurgood from comment #5) > So maybe not a regression then, just never worked ? Might be. But the person who reported this to me wrote: It runs well with AOO… Couldn't test this, because AOO won't run with the JRE I have installed. I will delete the keywords.