I've noticed that whan I have a form with a table control with two listboxes column I'm not able to read the item text but I can read only the value of the field of the query records.
It regullary works when I've use only one listbox column.
Thanks for your help
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug.
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it.
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 136583 [details]
odb file and db source
If you try to modify the form esempi/qa_preventivi_da_approvare_professionista when you change between edit and execute (in italian I use the "modo struttura" button) the listbox is displayed sometimes correctly and other times it shows only the value of the field of the query record.
I've noticed a similar behaviour with the form "pagina_iniziale" in the table "tabellaPreventiviDaApprovare" of the subform "formPreventiviDaApprovare"
Thanks a lot
it's an odbc database, could you provide connection parameters?
The forms couldn't be opened for editing or input without any connection to the database.
Please try to reproduce the explained buggy behavior with a small example with internal HSQLDB and without macro code.
If it is a special problem with macro code please add only this code to the example database.
Created attachment 137227 [details]
DB file, dlls and models
the odbc parameter are:
database: [path of DB file]\CONTABILITA_FB3.FDB
client DLL: [path of DB file]\fbclient.dll
the other parameters are the default
(In reply to robert from comment #4)
> The forms couldn't be opened for editing or input without any connection to
> the database.
> Please try to reproduce the explained buggy behavior with a small example
> with internal HSQLDB and without macro code.
> If it is a special problem with macro code please add only this code to the
> example database.
I'll try to reproduce the bug also with internal dB, but I fear it will take me a lot of time.
Changed title to reflect findings with information given so far
@Alberto : please also indicate :
- bit type of your Windows OS (32 or 64);
- bit type, name and version number of your ODBC driver ;
- bit type of LibreOffice version (32 or 64bit)
(In reply to Alex Thurgood from comment #8)
> @Alberto : please also indicate :
> - bit type of your Windows OS (32 or 64);
> - bit type, name and version number of your ODBC driver ;
> - bit type of LibreOffice version (32 or 64bit)
WINDOWS 10 64bit
I installed database CONTABILITA_FB3.FDB on my Firebird3 server and I created the ODBC connection. Connection is OK, I can connect database conti_sviluppo.odb to CONTABILITA_FB3.FDB.
BUT I don't understand where is the problem :-)
Give us, please, the detailed steps to reproduce.
(In reply to ribotb from comment #10)
> I installed database CONTABILITA_FB3.FDB on my Firebird3 server and I
> created the ODBC connection. Connection is OK, I can connect database
> conti_sviluppo.odb to CONTABILITA_FB3.FDB.
(In reply to Alberto from comment #6)
> I'll try to reproduce the bug also with internal dB, but I fear it will take
> me a lot of time.
@Alberto Hopefully you are not still having the problem.
Reading what you have commented on the issue seems all about listboxes and ODBC isn't really a factor, so I took some time to look at the database with a slightly different setup. OS here is Ubuntu 18.04 and using LibreOffice 6.2Alpha1 then I switched the connection type in your ODB file to sdbc:Firebird_file connected (in single user mode) to the datafile CONTABILITA_FB3.FDB.
Everything (most things, there is a couple of basic errors I hit) seem to work as I would expect including at the listbox behavior as far as I can tell. Looking at a few of the forms you referenced I had a hard time funding data grids with multiple listboxes (but I don't think I understand fully how to work those forms, so they are likely in the grid which seems to need questions answered to activate)
I did find multiple listboxes on form CLIENTI_FORNITORI_REFERENTI and did then with another added a couple here.
As I say, in those cases the controls are acting as I would expect.
I do have one question, just though, when you said in the first comment 'I'm not able to read the item text' do you possibly mean from within a macro. I didn't dig into it, but one of the errors the basic routines looked like it was trying to do that - so if that is it I'll take time to test that.
Changing status to needs info for the moment.
Thank you Drew Jensen,
thank you Ribotb,
I'm sorry I'm replying so late, but I haven't read the mail until today.
It was a bit I wasn't working with the db and today I've tried to use it with the last release of libreoffice (6.1.3): now the listboxes in the table work fine.
Thank you for your work and helpfulness
(In reply to Alberto from comment #12)
> Thank you Drew Jensen,
> thank you Ribotb,
> I'm sorry I'm replying so late, but I haven't read the mail until today.
> It was a bit I wasn't working with the db and today I've tried to use it
> with the last release of libreoffice (6.1.3): now the listboxes in the table
> work fine.
> Thank you for your work and helpfulness
Thanks for getting back in touch.
Change the status then.