[libreoffice-users] SQL statement error when linking Main form to SubForm

2013-06-05 Thread Marion Noel Lodge
Hi, I have a Form with families info in the Main Form and family members info in a Sub Form. The Tables and relevant fields are - Main Form (Families) FamilyID BIGINT IDENTITY Info fields follow Sub Form (Roll) RollID BIGINT IDENTITY FamilyKey BIGINT Info fields follow I

Re: [libreoffice-users] LibreOffice 3.6 Base Handbook published

2013-06-05 Thread minhsien0330
Thanks to all who wrote this handbook! It's really useful! Best Regards, Minhsien0330 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more:

Re: [libreoffice-users] Re: LO 4.0.3 - Calc Hyperlink not functioning

2013-06-05 Thread Tom Davies
Hi :) The Ctrl Click message usually appears as a tool-tip when you hover the mouse arrow over the link.  Have you switched off tool-tips? Regards from Tom :)  From: Schoelje schoe...@solydxk.com To: users@global.libreoffice.org Sent: Wednesday, 5 June

Re: [libreoffice-users] Date problem in LO Calc 4.0.3.3

2013-06-05 Thread Tom Davies
Hi :) Is this something to do with the difference between how Excel calculates dates and how Calc does it?  There is something weird about the way Excel does it.  The question is should we do it the wrong way in order to be compatible with Excel or the right way in order to make sense to the

Re: [libreoffice-users] Re: Ubuntu Menu Bar Option for LibreOffice

2013-06-05 Thread Tom Davies
Hi :) Regressions are good to know about.  Any chance of posting a bug-report about it?  Perhaps others will be able to narrow it down further or it might be narrowed down enough already.  https://wiki.documentfoundation.org/BugReport The {sudo apt-get remove libreoffice*.*} looks good enough

[libreoffice-users] Re: LO 4.0.3 - Calc Hyperlink not functioning

2013-06-05 Thread Schoelje
That's what I thought as well, but tool tips are on in the LibreOffice general section, and in writer the tooltip shows when I hover a link, just not in calc. It's really odd. -- View this message in context:

Re: [libreoffice-users] SQL statement error when linking Main form to SubForm

2013-06-05 Thread Dan Lewis
Onn 06/05/2013 02:29 AM, Marion Noel Lodge wrote: Hi, I have a Form with families info in the Main Form and family members info in a Sub Form. The Tables and relevant fields are - Main Form (Families) FamilyID BIGINT IDENTITY Info fields follow Sub Form (Roll) RollID BIGINT

[libreoffice-users] Re: Ubuntu Menu Bar Option for LibreOffice

2013-06-05 Thread CVAlkan
KrackedPress - Actually, after realizing that I must not have been completely successful in removing the Ubuntu version of LO, I did in fact look in Synaptic Package Manager after doing the [sudo apt-get remove libreoffice*.*] (and your point about using * rather than *.* is well taken - too

[libreoffice-users] Re: Ubuntu Menu Bar Option for LibreOffice

2013-06-05 Thread CVAlkan
Tom: See my last response to KrackedPress - I suspect this may in fact be a bug, but since someone mentioned that a new release will be out this month, I'll wait and see how that works before posting a bug. -- View this message in context:

Re: [libreoffice-users] Re: Ubuntu Menu Bar Option for LibreOffice

2013-06-05 Thread Tom Davies
Hi :) It's probably best to just post the bug-report now.  This is around the time that the most devs will be focussing on the newer branch so it's a good time to try to get your favs sorted.  Waitsee gets nowhere especially if none of the devs knows there is a problem to fix.  If the bug

Re: [libreoffice-users] Re: Ubuntu Menu Bar Option for LibreOffice

2013-06-05 Thread Tom Davies
Hi :) I did the same until very very recently so i thought it worth pointing out! lqtm Regards from Tom :)  From: CVAlkan fobe...@enteract.com To: users@global.libreoffice.org Sent: Wednesday, 5 June 2013, 12:53 Subject: [libreoffice-users] Re: Ubuntu Menu

Re: [libreoffice-users] Date problem in LO Calc 4.0.3.3

2013-06-05 Thread Spencer Graves
On 6/4/2013 9:23 PM, Brian Barker wrote: At 16:41 04/06/2013 -0700, Spencer Graves wrote: When I copy a date from one LO spreadsheet to another, it changes. Much as you might be surprised by this, it is, I think, by design. Specifically, I have *.ods files DateProblem2add.ods and

Re: [libreoffice-users] Date problem in LO Calc 4.0.3.3

2013-06-05 Thread Brian Barker
At 09:02 05/06/2013 -0700, Spencer Graves wrote: On 6/4/2013 9:23 PM, Brian Barker wrote: At 16:41 04/06/2013 -0700, Spencer Graves wrote: When I copy a date from one LO spreadsheet to another, it changes. Much as you might be surprised by this, it is, I think, by design. Specifically, I

[libreoffice-users] calc - hours of work in a month

2013-06-05 Thread Adam
Hi, I have two list of times in format HH:MM , : TimeIn TimeOut 07:29 15:08 07:20 14:00 for each pair I can compute its difference = (TimeOut-TimeIn) It is also in HH:MM format so for firs pair it is 07:39 Then I want to sum all differences. It is not hard = SUM(D2:D33) It should be

[libreoffice-users] Paid devs and the companies they work for

2013-06-05 Thread Tom Davies
Hi :) I thought people might be interested in this list of developers that are paid by different organisations to work on LibreOffice.  http://www.documentfoundation.org/certification/developers/ I found it particularly as it shows how many devs each company pays.  So it kinda shows how

Re: [libreoffice-users] calc - hours of work in a month

2013-06-05 Thread Brian Barker
At 18:43 05/06/2013 +0200, Adam Noname wrote: I have two list of times in format HH:MM , : [...] Then I want to sum all differences. It is not hard = SUM(D2:D33) . It should be in [HH]:MM format to show good number of hours. My result is : 149:43 . I want to round it to full hours, which

[libreoffice-users] Re: calc - hours of work in a month

2013-06-05 Thread Adam
On 05.06.2013 19:19, Brian Barker wrote: At 18:43 05/06/2013 +0200, Adam Noname wrote: I have two list of times in format HH:MM , : [...] Then I want to sum all differences. It is not hard = SUM(D2:D33) . It should be in [HH]:MM format to show good number of hours. My result is : 149:43 . I

Re: [libreoffice-users] Re: calc - hours of work in a month

2013-06-05 Thread Brian Barker
At 19:39 05/06/2013 +0200, Adam Noname wrote: On 05.06.2013 19:19, Brian Barker wrote: At 18:43 05/06/2013 +0200, Adam Noname wrote: I have two list of times in format HH:MM , : [...] Then I want to sum all differences. It is not hard = SUM(D2:D33) . It should be in [HH]:MM format to show

Re: [libreoffice-users] Default Superscript and Subscript size

2013-06-05 Thread Tim Vivian-Griffiths
Hi all, Late reply, been finishing off something - but I can get back to thinking about superscripts again! Yes Virgil, I think we've got a similar problem... I can change the size of individual cases, but there is no way I have found that I can just set the new size once, and then all

Re: [libreoffice-users] SQL statement error when linking Main form to SubForm

2013-06-05 Thread Marion Noel Lodge
Hi Dan, Thank you for your prompt and detailed reply. I'm using the H2 database and I suspect that was the vital piece of information that I failed to mention in my first post. Sorry about that. I originally linked the two tables using the Wizard. Then later I used the Form properties dialog