[libreoffice-users]

2014-09-26 Thread Nicola Dell'Uomo
Hi everybody, Since libreoffice versions 4.2.x for mac os X, I noticed I can't switch anymore between multiple windows by pressing cmd+' . Does anybody know how to workaround this issue? Thanks -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Base Reports - Getting Monthly YTD Averages

2014-09-26 Thread Tom Davies
Hi :) I don't know and i'm not an expert. There are people on this mailing list who are. So, i'm just exploring some thoughts ... Would it be sensible to average the whole time-interval rather than averaging the averages? Probably not but if it is then a Query could do it easily. Can't a

Re: [libreoffice-users]

2014-09-26 Thread Tom Davies
Hi :) Have you tried renaming your User Profile to see if that fixes it? https://wiki.documentfoundation.org/UserProfile It gets back to factory defaults and often solves weird problems that just suddenly start. If it doesn't help then just rename you old profile back over the top of the new one

[libreoffice-users] Re: Base Reports - Getting Monthly YTD Averages

2014-09-26 Thread Alex Thurgood
Le 25/09/2014 23:59, Don Parris a écrit : Hi Don, shown, and that works great. I used the Accumulation function to do this. But when I try to get an overall average, I wind up getting the average for the first month (in the report), not for the year-to-date. What expression are you

Re: [libreoffice-users] Re: Base Reports - Getting Monthly YTD Averages

2014-09-26 Thread Don Parris
Thanks Alex. The underlying query gets the month from the date, as well as the total, average, max and min for each month. The results are, of course, already grouped calculated by month. I was able to get the overall total, but also wanted to see the overall average, max and min. I somehow

Re: [libreoffice-users] Re: Base Reports - Getting Monthly YTD Averages

2014-09-26 Thread Tom Davies
Hi :) I was thinking about a 2nd Query to get the average/month rather than using the 1st Query. Alex has a better idea i think. As for using Calc i thought the idea was to use something like; Insert - Data Source but i could only find linking to External data. I didn't think that just dragging

[libreoffice-users] To open a second Sheet with one mouse click from the first Sheet in same document?

2014-09-26 Thread csanyipal
Hello, I'm using LibreOffice 4.2.6.3 Build: 4.2.6.3 Arch Linux build-4 Is it possible to create a hyperlink in a cell ( text or button ) in one Calc Document on one Sheet so if one click on that hyperlink then get focused another Sheet in the same Document? The purpose of this would be that

Re: [libreoffice-users] To open a second Sheet with one mouse click from the first Sheet in same document?

2014-09-26 Thread Brian Barker
At 05:12 26/09/2014 -0700, Csányi Pál wrote: Is it possible to create a hyperlink in a cell ( text or button ) in one Calc Document on one Sheet so if one click on that hyperlink then get focused another Sheet in the same Document? The purpose of this would be that one should not searching a

Re: [libreoffice-users] To open a second Sheet with one mouse click from the first Sheet in same document?

2014-09-26 Thread Mark Bourne
csanyipal wrote: Hello, I'm using LibreOffice 4.2.6.3 Build: 4.2.6.3 Arch Linux build-4 Is it possible to create a hyperlink in a cell ( text or button ) in one Calc Document on one Sheet so if one click on that hyperlink then get focused another Sheet in the same Document? The purpose of

[libreoffice-users] Ctrl+F4 Close document

2014-09-26 Thread Thomas Blasejewicz
Good evening I just noticed something. I have LibreOffice 4.2.4.2 on some Windows machines and recently also on two Linux (xubuntu 14.04) machines. Usually on the Windows machines the KB shortcut Ctrl+F4 closes the current document. Under Linux it does not do that (I copied the user profile from

Re: [libreoffice-users] Ctrl+F4 Close document

2014-09-26 Thread Cley Faye
The close document behavior you're noticing on windows is not linked to LibreOffice, but is a feature of the system. It just mean close the window, not the app and work everywhere. You can try it in most tabbed browser too :) The reason to have this greyed on Linux might be to avoid a clash with

[libreoffice-users] Re: To open a second Sheet with one mouse click from the first Sheet in same document?

2014-09-26 Thread csanyipal
Mark Bourne wrote I assume you are using Insert Hyperlink Document, then leaving the document path blank and either entering the sheet name in the Target field or using the button next to that field to select a sheet? Indeed. Mark Bourne wrote It doesn't seem to work with sheet names

[libreoffice-users] Re: Ctrl+F4 Close document

2014-09-26 Thread V Stuart Foote
@Cley, *, Cley Faye wrote The close document behavior you're noticing on windows is not linked to LibreOffice, but is a feature of the system. It just mean close the window, not the app and work everywhere. You can try it in most tabbed browser too :) Sorry but that is not quite correct.