[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

2018-08-20 Thread toodr
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 http://document-foundation-mail-archive

[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

2018-08-19 Thread toodr
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-6.

[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

2018-08-19 Thread toodr
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

2014-02-23 Thread toodr
file a bug report too, if this is a bug... 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.

[libreoffice-users] Re: Visible currency rounding

2013-07-23 Thread toodr
return it as it is Rounded=NumD End if End Function You can call it for each line (item) in an invoice. It will take the number you through at it and will return it rounded to the second diggit after the comma or point separator. Then when you sum the invoice up - the numbers will al

[libreoffice-users] Re: Visible currency rounding

2013-07-21 Thread toodr
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

2013-07-20 Thread toodr
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 in

[libreoffice-users] Re: Visible currency rounding

2013-07-20 Thread toodr
57 , this is the intended result as described 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 N

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

2012-06-14 Thread toodr
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 Sen

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

2012-06-12 Thread toodr
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,

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

2012-06-10 Thread toodr
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 al

[libreoffice-users] reportbuilder_1.2.1 doesnot draw horizontal or vertical lines in libreoffice3.3.1, but draws them in nopenoffice3.2

2011-03-13 Thread toodr
I have problems with the report builder, such as when I insert any vert. or horiz. lines in no matter what section of the report (be it header, footer or detail) it doesnot get drawn in libreoffice 3.3.1 but gets drawn in openoffice 3.2. I don't know if it will be drawn in openoffice 3.3.1, since