[libreoffice-users] Re: SOLVED:Re: LibreOffice Base now does not apply named parameter substitution after upgrade from LO 6.0 to LO 6.1 and this breaks subforms based on mysql/mariadb tables

Thanks for pointing me to this bug description. I wasn't aware of it. Quite a few .odb files I'll have to edit by hand. Some of them dating back to 2010! It seems that for the sqllight .odb files there is an option under Edit → Database → Advanced Settings

[libreoffice-users] SOLVED:Re: LibreOffice Base now does not apply named parameter substitution after upgrade from LO 6.0 to LO 6.1 and this breaks subforms based on mysql/mariadb tables

More precisely, This happens only within odb files created with LibreOffice-6.0.6 and older. And it is due to a setting of the driver , which is present in the content.xml file, within the .odb file. But if one alters the above setting like this: OLD SETTING: NEW SETTING: Then in

[libreoffice-users] LibreOffice Base now does not apply named parameter substitution after upgrade from LO 6.0 to LO 6.1 and this breaks subforms based on mysql/mariadb tables

I have two simle mysql tables with no relationships set between them. The database containing those tables is MariaDb and the JDBC driver I use to connect is mariadb-java-client-2.2.6. Both have a field named "num_vin" among various other fields. And I created a simple form containing a subform.

[libreoffice-users] regresion in calc 4.2.1

... So, I beg for an excuse posting here , if this is not the place ... Regards, toodr -- View this message in context: http://nabble.documentfoundation.org/regresion-in-calc-4-2-1-tp4098699.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users

[libreoffice-users] Re: Visible currency rounding

free to modify and use it as you please. Cheers, toodr -- View this message in context: http://nabble.documentfoundation.org/Visible-currency-rounding-tp4065342p4066292.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr

[libreoffice-users] Re: Visible currency rounding

participants in this discussion. Regards, toodr -- View this message in context: http://nabble.documentfoundation.org/Visible-currency-rounding-tp4065342p4066516.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

[libreoffice-users] Re: Visible currency rounding

above. Thanks again for the clarification you've given in your post. Regards, toodr -- View this message in context: http://nabble.documentfoundation.org/Visible-currency-rounding-tp4065342p4066383.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users

[libreoffice-users] Re: Visible currency rounding

of them - we shall be risking to get an incorrect result. The correct way to round the number will be to start at the rightmost available digit and drop one digit at a time, untill we reach the desired digit position. At least this is correct in my oppinion. Regards, toodr -- View this message

[libreoffice-users] Re: Base, Use wizard to create tables

I use LibreOffice 3.5.3.2 and the samples are present. Perhaps it is a problem with the installation or the package? What is your environment Linux/Windows ? tooodr -- View this message in context: http://nabble.documentfoundation.org/Base-Use-wizard-to-create-tables-tp3989732p3990222.html

[libreoffice-users] Re: cannot save an .html type document, opened in calc as .ods file (libreoffice 3.5.3)

insert-names-manage menu. What baffles me though is that on right click open - we get the file imported OK, but if we are inside calc and we try to open the same file from within the calc program - the same file gets opened into a writer/web program. Why is this inconsistency ? Best regards, Toodr

[libreoffice-users] Re: cannot save an .html type document, opened in calc as .ods file (libreoffice 3.5.3)

Some clarification on the matter. The file in question has xml content, tags and all. It used to be imported into a calc sheet if one opens it as a html calc document. The calc sheet looked like a normal sheet in an .ods file. Now it opens in something remotely resembling a text table in writer