I have tables containing ID (Integer) and d.o.b (date-integer) and text. using 4.2.7 in Linux Fedora 20 no problem, nor in Windows 7 with 4.1.1 . Changing from Fedora 20 to openSuse 13.2 came with an upgrade to LibreOffice 4.3.3 . Now: the numerical fields in the tables all show 0 (zero) the SQL statements of the queries are unchanged some queries still work, but only when ID is not involved in the query the forms are unchanged but remain empty the reports based on working queries are OK, the others not the macros needed for opening a tree of forms work OK the macro determining the path to the database works OK Upon closing the not-working database in openSuse (without storing any changes) and transferring the database to a machine with Windows 7 - libreoffice 4.1.1 -, the new path is found correctly and all works perfectly again.
I couldn't confirm this for the original packages of LO and OpenSUSE 12.3, 64bit. Using LO 4.3.3.2 and Base without any problems here. If I understand right you ara using the packages of OpenSUSE. The first I have done when I installed a new OpenSUSE-version: I deinstalled the packages of OpenSUSE, created a folder for the packages of LO and downloaded the packages from this page: http://downloadarchive.documentfoundation.org/libreoffice/old/4.3.3.2/rpm/ For packages from OpenSUSE please report the bug to OpenSUSE also.
Lionel/Robert: dup of fdo#84315? (put in See Also)
(In reply to robert from comment #1) > I couldn't confirm this for the original packages of LO and OpenSUSE 12.3, > 64bit. > Using LO 4.3.3.2 and Base without any problems here. > > If I understand right you ara using the packages of OpenSUSE. The first I > have done when I installed a new OpenSUSE-version: I deinstalled the > packages of OpenSUSE, created a folder for the packages of LO and downloaded > the packages from this page: > http://downloadarchive.documentfoundation.org/libreoffice/old/4.3.3.2/rpm/ > > For packages from OpenSUSE please report the bug to OpenSUSE also. Correct, I have LO straight from the openSuse DVD. Will do what you suggest and make a separate installation of LO. I Will come back after I have done this. For what it is worth: I installed on another machine the latest version of OpenOffice and there everything worked fine.
dh_holsboer: could you take a look to https://bugs.freedesktop.org/show_bug.cgi?id=84315 to know if it's a dup or not?
(In reply to dh_holsboer from comment #3) > (In reply to robert from comment #1) > > I couldn't confirm this for the original packages of LO and OpenSUSE 12.3, > > 64bit. > > Using LO 4.3.3.2 and Base without any problems here. > > > > If I understand right you ara using the packages of OpenSUSE. The first I > > have done when I installed a new OpenSUSE-version: I deinstalled the > > packages of OpenSUSE, created a folder for the packages of LO and downloaded > > the packages from this page: > > http://downloadarchive.documentfoundation.org/libreoffice/old/4.3.3.2/rpm/ > > > > For packages from OpenSUSE please report the bug to OpenSUSE also. > > Correct, I have LO straight from the openSuse DVD. Will do what you suggest > and make a separate installation of LO. > I Will come back after I have done this. > For what it is worth: I installed on another machine the latest version of > OpenOffice and there everything worked fine. Followed your suggestion with a "clean" install straight from LO. The problem has disappeared. I will write to openSuse about the distribution bug. Thank you very much for helping out.
(In reply to Julien Nabet from comment #4) > dh_holsboer: could you take a look to > https://bugs.freedesktop.org/show_bug.cgi?id=84315 to know if it's a dup or > not? After looking at that bug, it seems a duplicate. I have not looked at it in depth, however, as using the LO installation instead of the openSuse installation solved the problem.
Thank you for your feedback, I put it as dup. *** This bug has been marked as a duplicate of bug 84315 ***