[libreoffice-users] SQL-Operators in LO 4.3.3.1-Base

2014-08-12 Thread Rainermusik (Office)
Hello, I notice that the filter-operators <= (less than) and >= (greater than) are missing in the latest version of Base. Is this intentional? Regards H. Stoellinger -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/h

Re: [libreoffice-users] SQL-Operators in LO 4.3.3.1-Base

2014-08-12 Thread Tom Davies
Hi :) !!! I think file a bug-report about it asap! Is there a work-around such as using < and then = as separate keystrokes instead of clicking on the single button when making a formula? If not then it's probably worth marking the bug-report as extremely urgent or something like that. Regards fr

Re: [libreoffice-users] Question about Calc and hiding rows

2014-08-12 Thread Tom Davies
Hi :) +1 Also ... Errr, how are the cells being hidden?!?? Of course it is possible to hide an entire row or column by clicking on the row/column header (1, 2, 3 etc or A, B, C etc) and then right-click to hide the entire row/column. To hide individual cells it might be easier to grab a graphic,

Re: [libreoffice-users] Question about Calc and hiding rows

2014-08-12 Thread Tom Davies
Hi :) Also the 4.1.0 was VERY early in that branch's cycle. There have been numerous updates to fix lots of bugs and make it more stable. So instead of the 4.1.0 it would be better to try the 4.1.6. Similarly with the 4.0.1. That 3rd digit shows it had only 1 update (to fix bugs) since the begi

Re: [libreoffice-users] Question about Calc and hiding rows

2014-08-12 Thread Alex McMurchy
Perhaps you can change the text colour to be the same as the background colour - effectively hiding it. Then protect the sheet/cells as per this in the help https://help.libreoffice.org/Calc/Protecting_Cells_from_Changes On Tuesday 12 Aug 2014 09:16:15 Tom Davies wrote: > Hi :) > +1 > Also ..

[libreoffice-users] UNSUBSCRIBE

2014-08-12 Thread Gabriele Azzaro
-- 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: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messa

Re: [libreoffice-users] Question about Calc and hiding rows

2014-08-12 Thread Brian Barker
At 09:16 12/08/2014 +0100, Tom Davies wrote: At 19:34 11/08/2014 -0700, Tom Williams wrote: My dad is a long time OpenOffice user and today he called me about a problem he's having with one of his spreadsheets. Apparently, he hides rows to reduce the amount of information he sees when he's loo

Re: [libreoffice-users] Question about Calc and hiding rows

2014-08-12 Thread Brian Barker
At 11:30 12/08/2014 +0100, Alex McMurchy wrote: At 19:34 11/08/2014 -0700, Tom Williams wrote: My dad is a long time OpenOffice user and today he called me about a problem he's having with one of his spreadsheets. Apparently, he hides rows to reduce the amount of information he sees when he's

Re: [libreoffice-users] shortcut keys for LibreOffice under Linux

2014-08-12 Thread Cley Faye
2014-08-12 4:55 GMT+02:00 Thomas : > Then I do have the choice between learning all the different shortcuts, > or else switching to Ubuntu (this "unity" thing, which I do not like at > all). > ​Unity and XFCE are not the only desktop ​environments. If you have issues with one, and dislike the oth

Re: [libreoffice-users] Question about Calc and hiding rows

2014-08-12 Thread Alex McMurchy
No, I can't believe that Calc is magically converting cells contents to images. Is the cell subject to a formula somewhere else on the sheet? What happens when you try and delete the object that is symbolised by the anchor and green squares along the perimeter? On Tuesday 12 Aug 2014 13:05:48

Re: [libreoffice-users] shortcut keys for LibreOffice under Linux

2014-08-12 Thread T. R. Valentine
>> On 10 August 2014 21:13, Thomas wrote: > Yes, you are right! > Under Xubuntu using XCFE the shortcut keys are different from the usual > Ubuntu. > I did not know and realize that. Bad form, IMO. But I suppose the developers of XCFE have their reasons. ??? But I'm glad the puzzle was resolve

Re: [libreoffice-users] shortcut keys for LibreOffice under Linux

2014-08-12 Thread Brian A. Colucci
Linux Mint, is another nice choice for those looking for a classic Ubuntu feel. *Brian Colucci* *Information Technology Manager* MedWork_Logo_CMYK.jpg *MedWork Occupational Health Care* *1435 Cincinnati Street* *Suite 100* *Dayton, Ohio 45417* On 08/12/2014 08:51 AM, Cley Faye wrote: 20

Re: [libreoffice-users] shortcut keys for LibreOffice under Linux

2014-08-12 Thread Tom Davies
Hi :) Weirdly under Unity both Ctrl shift z and Ctrl y both redo I've been using Unity for a couple of years. I didn't like it at first but it's made huge improvements. It feels like Gnome is going backwards and Mate&Cinamon are getting heavier. KDE is awesome imo. Mint seems nice but it too s

Re: [libreoffice-users] Question about Calc and hiding rows

2014-08-12 Thread Tom Davies
Hi :) +1 I think it's more likely that the user has found ingenious and unexpected ways to hide cells, such deliberately using images. Regards from Tom :) On 12 August 2014 14:24, Alex McMurchy wrote: > No, I can't believe that Calc is magically converting cells contents to > images. > > Is t

[libreoffice-users] Re: Question about Calc and hiding rows

2014-08-12 Thread Pedro
If the document has been going back and forth between LibreOffice and Apache OpenOffice (or old OpenOffice.org) it is quite possible that it was corrupted at some stage (I have a document where this happened...) If your father has been using OpenOffice only, can he pinpoint a version where it wor

Re: [libreoffice-users] Re: Question about Calc and hiding rows

2014-08-12 Thread Tom Davies
Hi :) Ahhh, so the hidden columns/rows might well be the only ones corrupted? That would make it less annoying! Regards from Tom :) On 12 August 2014 16:44, Pedro wrote: > If the document has been going back and forth between LibreOffice and > Apache > OpenOffice (or old OpenOffice.org) it is

Re: [libreoffice-users] UNSUBSCRIBE

2014-08-12 Thread Luuk
On 12-8-2014 12:56, Gabriele Azzaro wrote: To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org -- 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: http://

Re: [libreoffice-users] Currently Using Spreadsheet for Personal Project - Thinking About Database

2014-08-12 Thread Mark Bourne
Paul wrote: So I was interested, and did a little more digging. I figured I would share the info. On Sun, 10 Aug 2014 22:48:43 +0100 Mark Bourne wrote: I don't know to be honest, not having a lot of experience in database design. I've only ever really used MySQL, which does support enums, bu

[libreoffice-users] Error

2014-08-12 Thread skiper skippers
blockquote {padding-left: 1ex; margin: 0px 0px 0px 0.8ex; border-left: #cc 1px solid;} p {margin: 0px;padding: 0px;} Check =2^53 it shows 9007199254740990 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-

[libreoffice-users] Re: Base questions

2014-08-12 Thread Jarosław Staniek
Wolfgang Keller wrote: >> This is one way Base is more powerful than Access. > > That's the whole point. > > By not focusing on promoting Base as *the* generic client-side FOSS tool > for access to client-server RDBMs, they're missing a *HUGE* opportunity. > > And since Rekall has vanished (des

Re: [libreoffice-users] Currently Using Spreadsheet for Personal Project - Thinking About Database

2014-08-12 Thread Paul
Hi Mark, On Tue, 12 Aug 2014 22:37:18 +0100 Mark Bourne wrote: [snip] > > Also, then you can localize your status names if you ever want to > > make your program support other languages. > > Something else I haven't had to worry about, but if I did I'd have > done the localisation in the appl

Re: [libreoffice-users] Error

2014-08-12 Thread Brian Barker
At 22:46 12/08/2014 +0200, Skiper Skippers wrote: Error Check =2^53 it shows 9007199254740990 This is not an error! You are using a finite computing machine - one in which each number in a cell is stored in a memory location of finite length. So there is always a limit to how large an intege

[libreoffice-users] Re: Error

2014-08-12 Thread Pedro
skiper skippers wrote > blockquote {padding-left: 1ex; margin: 0px 0px 0px 0.8ex; border-left: > #cc 1px solid;} p {margin: 0px;padding: 0px;} > Check =2^53 it shows 9007199254740990 FYI MS Excel returns the same value. If you need accuracy then use Gnumeric or R For those who can't spot the

[libreoffice-users] Re: Currently Using Spreadsheet for Personal Project - Thinking About Database

2014-08-12 Thread Werner
Hi, On 8/13/2014 1:18, Paul wrote: Hi Mark, ... Normally, localization is done by having a plain text file with all the application strings in it, and this file is simply copied and each string translated for each different language. Then at run time the application knows which locale it is

Re: [libreoffice-users] Error

2014-08-12 Thread Keith Bates
Hi Brian, While I agree with most of your post, a slight typo or something crept in here, where you confuse 10^53 with 2^53 > > 2^53 is one followed by fifty-three zeroes, of course - so is just > too long to be stored accurately. > Brian Barker > -- God bless you Keith Bates Jesus is t