GnuLinux help-systems and a couple direct answers, was: Fw: [libreoffice-users] Re: Linux hyphenation
Hi :) Jump-drive or usb-stick or whatever is a great way of doing it. It is slower than an install on an internal hard-drive but it's not hugely noticeable unless you use it as your main system. It's just a really neat way of experimenting and playing around with it. Sometimes uninstalling the Wubi meant you had to 'fix' the Windows boot-loader again to remove the *buntu option from the boot-menu. With the Wubi i think the initial default for the boot-loader is to boot into Windows. With the proper dual-boot menu the initial default is usually to boot into *buntu/Mint/whichever. It's not difficult to change but only if you have a cheat-sheet to copypaste from. I tend to move Windows to the top of the menu and then set the default to whichever one i need most often. Anyone that wants a quick post on how to do that just start a new thread here or email me off-list. I imagine most people here have their own how-to or cheat-sheet/quick-reference. Mounting the Windows side is now a lot easier in most GnuLinux systems but wasn't obvious until fairly recently (a year or 2 ago). Again if you can find the right how-to then it is easy and you can even do a quick edit to make that happen automatically (although it's not recommended because, again, it creates problems if there was a problem on the Windows system so it's better to try to mount the Windows side AFTER booting up your system and it only takes 2 clicks). Again if people want a quick guide then you could probably get a few different answers on this list, any one of which would probably be fine or email me off-list if you are shy about going off-topic on this mailing list. If you uninstall a proper dual-boot system then the general advice is to 'fix' your Windows boot-loader first and then consider removing the GnuLinux partitions. 'Obviously ' if you delete the drive a program is installed on then it's going to be tough to try to run that program. So, it's better to use the boot-menu to boot into Windows 1st and then fix the Windows boot-menu from there BEFORE wiping the partitions that your boot-loader is on. It is kinda contra-intuitive and people that only know Windows systems generally give bad advice about this sort of thing. If anyone else is trying out GnuLinux then please do ask us questions if you run into problems, however small they might seem or however complicated. Most people on this list can probably point you to half a dozen how to or documentation pages or simply tell you how to fix it or point you to the proper forums for whichever distro. Trying to find answers yourself runs the risk of finding ridiculous Windows-based forums that are clueless. It is tough to ask for help with something and then have enough patience to wait for replies. Telephone support is sometimes better because at least you know when you have reached a live human being even if they do generally turn out to be a moron or working in a moronic system that favours closing tickets fast rather than really solving cases. On this list i have usually tried to make sure people get some sort of response within a couple of hours even if i haven't been able to help. I know what it's like to be a noob and ask a question and then sit there staring at the screen, hitting refresh and not even really knowing if my question arrived anywhere at all while my boss goes berserk behind me demanding an instant fix. So i try to get a response out there as quickly as possible just to let people know their message has arrived. However, that has got me into a lot of trouble with the BoD and various individuals here who would rather see people left hanging rather than give them any kind of moral support. A lot of other support forums and mailing list are worryingly silent in comparison to this one because they are waiting for someone to come up with the exact right answer. They don't see any value in making a guess and sometimes fear doing so in case they appear to be an idiot in front of their colleagues. On this list we fearlessly make guesses about what we think the person was really asking and build on each others answers until it becomes clearer what the person really needs to solve. So the person sees activity and then has to work out how to steer us rather than just getting a blank screen. Sorry this is rambling without really going anywhere. Also i'm even more sorry to hear someone had such problems and didn't feel comfortable enough to ask off-topic questions here. Now that i know it was a Wubi install and that they kinda liked Mint we could easily solve most of Virgil's problems by just saying to install Mint properly. It's a bit like renaming the user-profile in that 1. all sorts of weird little odd behaviours suddenly vanish but 2. it's fairly rare to encounter those weirdnesses in the first place. Regards from Tom :) - Forwarded Message -
Re: [libreoffice-users] MariaDB 5.5.33 Now Available
Fedora has also switched. Mark Stanton One small step for mankind... -- 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 messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Multi-test IF statement in Calc
Hi, Brian Barker schrieb: At 21:28 18/09/2013 +0100, Mark Bourne wrote: Carl Paulsen wrote: I'm trying to build an IF statement that tests if a condition exists in two columns, and assigns the number 1 if it does, and 0 if not. The columns being checked are vLookups which return #N/A if an ID is not found in another table. I'm trying to search for cases where an ID# IS returned in two columns meaning the record shows up in both tables. I can't figure out the syntax for this. I've tried IF(AND(A1#N/A; B1#N/A),1,0) on both the vlookup formula columns and on columns that are pasted without formulas. No luck yet. Can someone chime in on this? Try: =IF(AND(NOT(ISNA(A1)), NOT(ISNA(B1))),1,0) Although the cell is displayed as #N/A, it's not a text value but an error code indicating that a value is not available. ISNA() returns TRUE if a cell contains the #N/A error code, and FALSE otherwise. Indeed. But it's simpler than that, in fact. If you apply De Morgan's laws to the expression AND(NOT(X);NOT(Y)) it simplifies to NOT(OR(X;Y)) so we can simplify your formula to =IF(NOT(OR(ISNA(A1);ISNA(B1))),1,0) And if you exchange the then- and the else-expression, you can drop the NOT function. =IF(OR(ISNA(A1);ISNA(B1)));0;1) Kind regards Regina -- 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 messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Multi-test IF statement in Calc
At 17:40 19/09/2013 +0200, Regina Henschel wrote: Brian Barker schrieb: At 21:28 18/09/2013 +0100, Mark Bourne wrote: Carl Paulsen wrote: I'm trying to build an IF statement that tests if a condition exists in two columns, and assigns the number 1 if it does, and 0 if not. The columns being checked are vLookups which return #N/A if an ID is not found in another table. I'm trying to search for cases where an ID# IS returned in two columns meaning the record shows up in both tables. I can't figure out the syntax for this. I've tried IF(AND(A1#N/A; B1#N/A),1,0) on both the vlookup formula columns and on columns that are pasted without formulas. No luck yet. Can someone chime in on this? Try: =IF(AND(NOT(ISNA(A1)), NOT(ISNA(B1))),1,0) Although the cell is displayed as #N/A, it's not a text value but an error code indicating that a value is not available. ISNA() returns TRUE if a cell contains the #N/A error code, and FALSE otherwise. Indeed. But it's simpler than that, in fact. If you apply De Morgan's laws to the expression AND(NOT(X);NOT(Y)) it simplifies to NOT(OR(X;Y)) so we can simplify your formula to =IF(NOT(OR(ISNA(A1);ISNA(B1))),1,0) And if you exchange the then- and the else-expression, you can drop the NOT function. =IF(OR(ISNA(A1);ISNA(B1)));0;1) And we can also similarly improve my logical expression (that you snipped): =NOT(OR(ISNA(A1);ISNA(B1))) into: =1-OR(ISNA(A1);ISNA(B1)) ... where the subtraction of the logical value from one has the effect of negating it. Apart from its brevity, this has the additional advantage that it becomes a numeric expression so will display as 0 or 1 by default (not as FALSE or TRUE), as the questioner required. Brian Barker -- 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 messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Draw's capacity was reduced after 4.1.1.2 and became very low after the last Win 8 update
On Tue, 17 Sep 2013 20:41:30 -0700 (PDT) mxkuzn mxk...@gmail.com wrote: Re: Go. It's not hard to surpass 3K limit if you keep multiple related layouts in one filelike I do. I need hundreds of them at this stage, each has 200-300 objects, and graphical preview in Draw was very helpful. What exactly are you trying to do? If you're needing multiple game diagrams, wouldn't a specialised tool (like Drago) be better? Or turn each game diagram into its own image before including them in the file. And why does it all have to be in one file? I think any program will likely have speed if not stability issues with files of that many components. -- 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 messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Draw's capacity was reduced after 4.1.1.2 and became very low after the last Win 8 update
On 2013-09-20 06:28, Paul wrote: On Tue, 17 Sep 2013 20:41:30 -0700 (PDT) mxkuzn mxk...@gmail.com wrote: Re: Go. It's not hard to surpass 3K limit if you keep multiple related layouts in one filelike I do. I need hundreds of them at this stage, each has 200-300 objects, and graphical preview in Draw was very helpful. What exactly are you trying to do? If you're needing multiple game diagrams, wouldn't a specialised tool (like Drago) be better? Or turn each game diagram into its own image before including them in the file. And why does it all have to be in one file? I think any program will likely have speed if not stability issues with files of that many components. This seems to be a bug, a regression in 4.1.1.2. I have just gone from 3.64.054.1 and 4.05 is ok. 4.1.1.2 crashes. Win 7 32 bit. Why would you want so many objects? If draw is going to offer opening of PDF's then it needs to accommodate this many objects. My PDF's I open regularly with draw rarely have less than 14000 objects. DXF drawings can easily have thousands of items, EPS also. I don't think it is a design limit or there would be a message and not a crash and draw would not drop support for all the above file types (I would hope), it must be a bug. Anyway, back to 4.05 steve -- 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 messages sent to this list will be publicly archived and cannot be deleted