[libreoffice-users] Re: Help with LO Base

2014-05-16 Thread frofa
What is the reason you need to split your data into multiple tables? You will make life a lot easier for yourself if you are able to consolidate your data into one table. The rules of data 'normalization' (see link below) may require your data to be divided into more than a single table, but this

[libreoffice-users] Report Builder font problems bug report

2013-04-07 Thread frofa
Looks like it's a bug/regression and has been reported HERE https://bugs.freedesktop.org/show_bug.cgi?id=62147 . Maybe you might add your findings to the bug report. Hope it's fixed soon, because I reckon it will be a blocker for a lot of users. -- View this message in context:

[libreoffice-users] Re: MySQL-Connector - Mac OS LO 4

2013-02-20 Thread frofa
However, the differences in code trees between LO and AOO now mean that the connector for AOO no longer works in LO4, or at least, that is what Heinrich has reported (and Robert too, I believe). - Alex Just a note to say the AOO native MySQL connector here

[libreoffice-users] RE-NAMING database (Base) tables is broken in LO v.4?

2013-02-07 Thread frofa
I have just installed the newly-released LO Version 4.0.0.3 (Build ID: 53fd80e80f44edd735c18dbc5b6cde811e0a15c) and testing with some of my 'split' databases (using HSQLDB v.2.2.8 in 'file mode'). I notice when I right-click on a TABLE NAME (in the table listing) there now seems to be NO option to

[libreoffice-users] Re: Base Query Sort and Reports

2013-01-23 Thread frofa
There was a bug in LO 3.5.x versions discussed at the end of this post http://nabble.documentfoundation.org/Base-and-new-Report-Builder-in-3-5-td3817159i20.html#a3961330 which might be relevant to you. I seem to recall any query you use in a report is not automatically updated when you

[libreoffice-users] Problem with exporting BASE query result to CALC sheet

2012-07-17 Thread frofa
I'm trying out the latest LibO 3.5.5.3 (on Mac OS X.6) and I think I've found a bug with exporting a BASE query result set to a CALC sheet. I used to be able to just drag the query icon from the QUERIES pane of the BASE window into a cell of a new CAL sheet (alongside), and, voila, the query

[libreoffice-users] Folders for QUERIES in the DATABASE window?

2012-06-24 Thread frofa
Is it possible to create virtual FOLDERS in the QUERIES pane of the BASE database window - as one can in the FORMS and REPORTS panes? -- View this message in context: http://nabble.documentfoundation.org/Folders-for-QUERIES-in-the-DATABASE-window-tp3992040.html Sent from the Users mailing list

[libreoffice-users] Re: Legacy Base reports won't open in LibreOffice 3.5

2012-06-02 Thread frofa
These problems still persist with LO 3.5.4, but at least there are the work-arounds above, and also see here for my summary of the work-arounds: http://nabble.documentfoundation.org/Workarounds-for-multiple-problems-with-the-legacy-Report-Designer-Wizard-under-LO-3-5-td3964175.html Hoping these

[libreoffice-users] Re: Repeating Display of BASE Table entries in LO 3.5

2012-05-30 Thread frofa
The TABLE GRID display problem reported above is still present in LO 3.5.4 (Mac OS). Can anyone else confirm this problem? There was a bug report about it a few weeks ago, but it seems to have 'disappeared'. I reckon it's a fairly serious problem (for BASE users) and should be fixed asap. It's a

[libreoffice-users] Display of Table entries - one record repeated many times

2012-05-07 Thread frofa
This is a potentially serious problem I hadn't seen before and was pointed out here recently... http://en.libreofficeforum.org/node/1267 The problem manifests in at least TWO situations (at least on my setup): 1. When using the SEARCH function (button with 'binoculars' icon) - click on TABLE to

[libreoffice-users] Workarounds for multiple problems with the legacy Report Designer-Wizard under LO 3.5

2012-05-05 Thread frofa
After doing a bit more investigation recently, this is a summary of what I've found (so far) regarding the multiple problems with the legacy Report Designer-Wizard (RDW) under LO 3.5. For convenience and succinctness, I thought it might be worth SUMMARIZING the situation in this new message. It

[libreoffice-users] Re: Base and new Report Builder in 3.5

2012-05-04 Thread frofa
Hi Andreas... I know it's been a while since you posted - I'm not sure if you have solved this problem yet. Anyway, this is what I found works for me using the LRD (legacy 'old' report designer/wizard) in LO 3.5.3 to create the report: STEPS 1. Create your primary SQL query showing all the

[libreoffice-users] Re: Legacy Base reports won't open in LibreOffice 3.5

2012-05-02 Thread frofa
Also, see these links for more reports about the problem on different platforms: https://bugs.freedesktop.org/show_bug.cgi?id=47325 https://bugs.freedesktop.org/show_bug.cgi?id=49279 http://en.libreofficeforum.org/node/2589 -- View this message in context:

[libreoffice-users] Re: Legacy Base reports won't open in LibreOffice 3.5

2012-04-19 Thread frofa
Thanks for your comments, Alex and others. One thing I didn't say is that when I edit my original reports in OO, their hidden controls do NOT show a 'Sorting' control listed at all, and yet they run perfectly in OO apparently without such a control. Since there is ALSO no 'Sorting' control listed