Re: [libreoffice-users] [HOW] impagination like a BOOK?

2013-09-18 Thread manuel_songokuh
hello

my document is libreoffice DRAW, this can does brochure? my size A4 to 
brochure (from tools or from print dialogue) right?

i'm curiosity what is freeware virtual pdf printer? my distro OPENSUSE 12.3 
with KDE 4.10, let me know as soon because today i need to print ufficial but 
before i need try to virtual pdf ok?




 Da: Brian Barker b.m.bar...@btinternet.com
A: users@global.libreoffice.org 
Inviato: Martedì 17 Settembre 2013 15:12
Oggetto: Re: [libreoffice-users] [HOW] impagination like a BOOK?
 

At 13:40 17/09/2013 +0100, Manuel Songokuh wrote:
I'm hard to explain here words but i show you link: 
http://bernaerts.dyndns.org/linux/74-ubuntu/248-ubuntu-imposition-print-book 
there is feature for libreoffice?

Yes: LibreOffice does this very efficiently.  It's weird that this 
web page suggests an exceedingly complicated way of doing what 
LibreOffice does natively!

if YES then how do for libreoffice?

That's exactly the brochure facility that I described in response 
to your previous enquiry.

To print an A5 booklet on (folded) A4 paper:
o Set your page format in LibreOffice Writer to A5 and Portrait - so 
it is the actual format that you want in the finished document.
o Set your printer's settings to A4 and Landscape - as the printing 
will actually be.
o Either:
Tick Tools | Options... | LibreOffice Writer | Print | Pages | Brochure
Or (on the fly):
In the Print dialogue, tick Options... | Pages | Brochure.

As before, if possible install a (freeware?) virtual PDF printer, so 
that you can experiment with the technique without wasting paper.

I trust this helps.

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
-- 
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: Linux hyphenation

2013-09-18 Thread Tom Davies
Hi :)
You could always install the 4.0.5 by downloading directly from the upstream 
website at 
https://www.libreoffice.org/downloads
errr, something like that.  I just typed it rather than copypasted it because 
i've already got far t many tabs open and so i keep losing track of where 
anything is.  

There are 3 main ways of installing software
1.  Stick to the default repos and only use the package managers to find and 
install stuff 
2.  Add extra repos, PPAs and similar repositories of software that has been 
tweaked for your system
3.  Go upstream directly to whichever random website you think might be a 
legitimate download site for the program you are looking for and cross your 
fingers
4.  Get a Cd or Dvd and hope that it really is what you were looking for and is 
legit and doesn't have malware bundled with it
5.  Find the original source code and check it's legitimate and have a quick 
read through to see if anything dodgy jumps out at you and then compile from 
source 

Lets ignore 5, especially in Ubuntu and other gateway distros.  you kinda need 
coding skills and a lot of patience because compiling is a slow painful process 
best left to the experts.  

Windows only offers options 3 and 4 (which are both really the same option) and 
that puts you at the mercy of people who might only be familiar with 1 program 
and may well have no idea about your system.  So i copy what microsoft.com keep 
saying - i recommend that you normally avoid this route but you can trust us 
(honest guv)  

Each route has it's own advantages and disadvantages.  Different people will 
recommend slightly different routes but may not tell you the drawbacks.  I tend 
to stick with 1 as much as possible and get most of my stuff from there but of 
course i add some PPAs and the Medibuntu repos (Medibuntu deals with all the  
multimedia stuff i enjoy using (thanks folks!)).  

I only use option 3 for LibreOffice and Evolution.  In both cases it's because 
i happen to prefer the untweaked version and i like to only upgrade them when i 
want to (and not halfway through doing the newsletter or something big).  So, i 
get no automatic updates nor upgrades but if i put the time in then i can be on 
the ultra-latest versions faster without having to wait for anyone else.    

If i had to install LibreOffice on my dad's boat i would go for the Dvd because 
connecting to the internet is such a pain from his.  There are a few i would 
trust.  The North American Dvd Project is an excellent one and a lot of time 
and hard work goes into those Dvds.  Generally they are worth at least twice as 
much as they cost, possibly more.  I'm not nearly as involved in that as their 
website suggests!  Mostly it's the heroic work of just 1 man.  


Anyway, point is that if you want the ultra-latest versions soon after they 
come out then you kinda have to talk to the PPA or repo maintainers but they 
are never going to be as fast as you can be by downloading directly off the 
upstream downloads page.  

Good luck and regards from 
Tom :)  





 From: soumalya ray soumalya6...@yahoo.co.in
To: users@global.libreoffice.org users@global.libreoffice.org 
Sent: Wednesday, 18 September 2013, 6:02
Subject: Re: [libreoffice-users] Re: Linux hyphenation
 

hi virgil,

---snip---

5. I then upgraded LO to 4.0.4.2 using the 
ppa:libreoffice/libreoffice-4-0 repository. That was a little weird as 
I followed online instructions for upgrading to 4.0.5, but the closest I 
got was 4.0.4.2. Oh, well.


snip---

that is because libreoffice 4.0.5 was upgraded in that ppa only for 
raring 
(https://launchpad.net/~libreoffice/+archive/libreoffice-4-0?field.series_filter=raring);
not for quantal, precise or lucid. 

so, if you are using the ppa
in raring, 4.0.5.2 will be installed; otherwise, 4.0.4.2 is going to be
the latest one from this ppa.

reason is not know to me. may be other members could put some light on this.

regards,


-- 
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] [HOW] impagination like a BOOK?

2013-09-18 Thread Brian Barker

At 08:31 18/09/2013 +0100, Manuel Songokuh wrote:

my document is libreoffice DRAW, this can does brochure?


Apparently yes!


my size A4 to brochure (from tools or from print dialogue) right?


Are you speaking of your earlier need to print A4 pages as a brochure 
on A3 paper?

o Keep the page format in Draw as A4 and Portrait.
o Go to File | Printer Settings... .
o In Properties..., select A3 and Landscape.
o In Options... | Page options, select Brochure.


I'm curiosity what is freeware virtual pdf printer?


It's a program which, when installed, appears in your list of 
printers.  But there is no physical printer.  Instead, when you use 
the virtual printer - through the print dialogue in the usual way - 
the program creates a PDF document representing what would have been 
printed.  The advantage here is that you can test the Brochure 
facility without wasting paper.



my distro OPENSUSE 12.3 with KDE 4.10, ...


I can't speak for this platform.  Try doing a search for PDF virtual 
printer.  Does this earlier message in this thread help: 
http://listarchives.libreoffice.org/global/users/msg33362.html ?


I trust this helps.

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][RESOLVED] [HOW] impagination like a BOOK?

2013-09-18 Thread manuel_songokuh
thank you
i'm finished JOB LONG TIME and GOAL RESOLVED ALL, BEAUTIFUL FUNNY WITH 
LIBREOFFICE
THIS CASE IS CLOSE AND RESOLVEDD!!!
THANK YOU ALL PEOPLES REPLY TO MEE THANYOU




 Da: Brian Barker b.m.bar...@btinternet.com
A: users@global.libreoffice.org 
Inviato: Mercoledì 18 Settembre 2013 14:32
Oggetto: Re: [libreoffice-users] [HOW] impagination like a BOOK?
 

At 08:31 18/09/2013 +0100, Manuel Songokuh wrote:
my document is libreoffice DRAW, this can does brochure?

Apparently yes!

my size A4 to brochure (from tools or from print dialogue) right?

Are you speaking of your earlier need to print A4 pages as a brochure 
on A3 paper?
o Keep the page format in Draw as A4 and Portrait.
o Go to File | Printer Settings... .
o In Properties..., select A3 and Landscape.
o In Options... | Page options, select Brochure.

I'm curiosity what is freeware virtual pdf printer?

It's a program which, when installed, appears in your list of 
printers.  But there is no physical printer.  Instead, when you use 
the virtual printer - through the print dialogue in the usual way - 
the program creates a PDF document representing what would have been 
printed.  The advantage here is that you can test the Brochure 
facility without wasting paper.

my distro OPENSUSE 12.3 with KDE 4.10, ...

I can't speak for this platform.  Try doing a search for PDF virtual 
printer.  Does this earlier message in this thread help: 
http://listarchives.libreoffice.org/global/users/msg33362.html ?

I trust this helps.

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
-- 
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] [HOW] impagination like a BOOK?

2013-09-18 Thread Kracked_P_P---webmaster
On 09/18/2013 08:32 AM, Brian Barker wrote:
 At 08:31 18/09/2013 +0100, Manuel Songokuh wrote:
 my document is libreoffice DRAW, this can does brochure?

 Apparently yes!

 my size A4 to brochure (from tools or from print dialogue) right?

 Are you speaking of your earlier need to print A4 pages as a brochure
 on A3 paper?
 o Keep the page format in Draw as A4 and Portrait.
 o Go to File | Printer Settings... .
 o In Properties..., select A3 and Landscape.
 o In Options... | Page options, select Brochure.

 I'm curiosity what is freeware virtual pdf printer?

 It's a program which, when installed, appears in your list of
 printers.  But there is no physical printer.  Instead, when you use
 the virtual printer - through the print dialogue in the usual way -
 the program creates a PDF document representing what would have been
 printed.  The advantage here is that you can test the Brochure
 facility without wasting paper.

 my distro OPENSUSE 12.3 with KDE 4.10, ...

 I can't speak for this platform.  Try doing a search for PDF virtual
 printer.  Does this earlier message in this thread help:
 http://listarchives.libreoffice.org/global/users/msg33362.html ?

 I trust this helps.

 Brian Barker



Go to your Package Manager and search for CUPS-PDF.  That is what I use
for Ubuntu.  You should have somethings like that for your system.

If you do not find it, then search for PDF and see if one of the items
is a PDF printer.




-- 
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: Linux hyphenation

2013-09-18 Thread Kracked_P_P---webmaster
On 09/17/2013 01:28 PM, Virgil Arrington wrote:
 On 09/15/2013 11:24 AM, Kracked_P_P---webmaster wrote:
 OK, I went to Synaptic Package Manager and looked up libhyphen.

 It was there as part of the Ubuntu packages.
 Maybe Mint did not install that package.

 So go to your package manager and look up and install that Debian
 package and see if that helps.
 My package was labeled libhyphen0.

 Looking up hyphen, I have the following [but not the entire list]
 installed:
 hyphen-en-us
 libhyphen0
 openoffice.org-hyphenation

 So go that route.
 Look up the packages in you package manager - I prefer to use Synaptic
 which Ubuntu no longer installs by default.  Then install them there.

 You might fix some of your issues.

 As I stated, Mint and I had problems with one if my network printers -
 it did not exist on the network - but would use it as a USB printer.
 Had no issues with Ubuntu 10.04 or 12.04.



 Okay, here's what I've done.

 1. I searched Synaptic for libhyphen and found the same files you
 mentioned. Yet, LO doesn't recognize it.

 2. I then uninstalled my Linux Mint. It was no big deal as I had a
 Bible research program that wouldn't work with it anyway. (I won't
 necessarily blame Mint, but I didn't want to have to chase down two
 Mint problems)

 3. I installed Ubuntu 12.04 LTS using the Wubi installer. That
 installed LO 3.5.x by default. (The Bible research program also worked.)

 4. I checked LO 3.5.x, under Options/Language Settings/Writing Aids/
 and it had the Hunspell spellcheck module, but it did not have any
 modules for Hyphenation, Grammar, or Thesaurus.

 5. I then upgraded LO to 4.0.4.2 using the
 ppa:libreoffice/libreoffice-4-0 repository. That was a little weird
 as I followed online instructions for upgrading to 4.0.5, but the
 closest I got was 4.0.4.2. Oh, well.

 6. I then installed the American English dictionary from the
 dictionary extensions.

 7. Once that was installed, I gained the OpenOffice Thesaurus module,
 but still no Hyphenation or Grammar Checker modules.

 8. Using Synaptic, I found all the same files you listed on your system.

 9. Out of curiosity, I then noticed the packages listed at
 https://launchpad.net/~libreoffice/+archive/libreoffice-4-0. It
 mentions the hunspell package and, immediately after, a hyphen
 package (version 2.8.3-1~lucid1), but no libhyphen package. At this
 point, I'm waaa out of my techno comfort zone.

 This has become a real head scratcher for me. For my actual work, I'm
 still booting into Windows, but the OCD side of me wants to figure
 this out.

 Virgil


I do not use Repository or PPA for installing LibreOffice.  I download
the Debian install from the web site.  The only issue with that is you
will need to remove the previous installed version first.   That is a
whole different discussion why that is required.

I run 4.0.5 on Ubuntu and have one Windows system using 4.1.1.






-- 
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]

2013-09-18 Thread Tom Davies
Hi :)
Thanks :)  So prolly not hugely useful for LibreOffice or MS formats.  
LibreOffice does have a couple of tools built-in.  There is a Track changes 
and a Compare Documents but we occasionally get a thread grumbling about them 
not being perfect.  It's pretty rare but when i stumbled across mention of Meld 
recently upgrading i wondered if it might be a good answer next time we get a 
grumble.  

It sounds like Meld had a few issues itself but their announcement suggests 
that they have recently fixed tons of problems so it might be worth another try 
for non-Office stuff.  

Anyway, thanks for the feedback, it's good to have feedback from someone with 
useful experience.  
Thanks and regards from 
Tom :)  





 From: Paul paulste...@afrihost.co.za
To: users@global.libreoffice.org 
Sent: Wednesday, 18 September 2013, 0:39
Subject: Re: [libreoffice-users]
 

Hi Tom,

I use Meld (and have used a few others). Haven't used it (or any of the
others) for LO or MS Office files, though.

It's pretty good for plain text files like config files or source code.
I've used it on generated files before (Visual Studio form files), and
it was helpful, but blocks of text that were the same tended to be
moved around arbitrarily, and showed up as differences in the file. I'm
not sure how much of a problem that would be with LO source files, but
in theory it should be helpful for determining if two copies of a file
are different, and by how much. That might allow you to determine which
version is more recent, that sort of thing.

Ideally I suppose one would want an LO viewer that allowed one to load
two files side-by-side, and scroll them in tandem. Maybe even have
differences, additions and deletions highlighted. A custom LO diff
tool, essentially. But short of that, something like Meld is probably
going to be useful.

Paul



On Tue, 17 Sep 2013 18:54:53 +0100 (BST)
Tom Davies tomdavie...@yahoo.co.uk wrote:

 Hi :)
 Has anyone used Meld 
 
 http://meldmerge.org/
 to compare ODF documents (or ones using an MS format).  From their
 screen-shots it looks great for text-editors and might be fantastic
 if it does work for ODF.  
 
 Just wondered 
 
 a)  if anyone had tried it and 
 
 b)  if anyone thought it might be better to have an external tool
 that compared a wide range of  file-typesrather than just relying on
 different in-built ones in  different programs.  
 
 Regards from 
 
 Tom :)  


-- 
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
-- 
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



[libreoffice-users] MariaDB 5.5.33 Now Available

2013-09-18 Thread Tom Davies
Hi :)  

Another stable release from MariaDb.  


Last time a few of the BoD slapped my wrists for posting 'irrelevant' and 
'off-topic' posts and cited forwarding the last MariaDb announcement as an 
example, meanwhile a few  people here suggested that it was good to hear about 
because so many GnuLinux distros are swapping out MySql (Oracle's) and 
replacing with MariaDb (which i thought had recently merged with another fork 
of MySql or something).  

Regards from 
Tom :)  





 From: MariaDB Announce List annou...@mariadb.org
To: annou...@mariadb.org 
Sent: Tuesday, 17 September 2013, 19:35
Subject: [MariaDB Announce] MariaDB 5.5.33 Now Available
 

The MariaDB project is pleased to announce the immediate availability
of MariaDB 5.5.33.

This release features the addition of TokuDB as an additional storage
engine option. There are also bug and other fixes. See the Release
Notes and Changelog for details.


- - Links  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

MariaDB 5.5.33 Stable (GA)
- Release Notes: https://mariadb.com/kb/en/mariadb-5533-release-notes
- Changelog: https://mariadb.com/kb/en/mariadb-5533-changelog
- Downloads: https://downloads.mariadb.org/mariadb/5.5.33

Overview of MariaDB 5.5: https://mariadb.com/kb/en/what-is-mariadb-55

APT and YUM Repository Configuration Generator:
  - https://downloads.mariadb.org/mariadb/repositories/


- - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - -

MariaDB includes a User Feedback plugin. This plugin is disabled by
default. If enabled, it submits basic, completely anonymous MariaDB
usage information. This information is used by the developers to track
trends in MariaDB usage to better guide development efforts.

If you would like to help make MariaDB better, please add feedback=ON
to your my.cnf (my.ini on Windows) file!

See http://mariadb.com/kb/en/user-feedback-plugin for more information.


- - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

The project always strives for quality, but in reality, nothing is
perfect. Please take time to report any issues you encounter at:

- http://mariadb.org/jira


- - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - -

If you would like to contribute to MariaDB, please see our
contributing and donations pages. We also have merchandise
available in a cafepress store.

- https://mariadb.com/kb/en/contributing

- https://mariadb.org/en/donate/

- http://www.cafepress.com/mariadb

We hope you enjoy MariaDB!

--
MariaDB: An Enhanced Drop-in Replacement for MySQL
        Website - http://mariadb.org
        Twitter - http://twitter.com/mariadb
        Google+ - http://google.com/+mariadb
       Facebook - http://fb.com/MariaDB.dbms
  Knowledgebase - http://mariadb.com/kb
___
announce mailing list
annou...@mariadb.org
https://lists.askmonty.org/cgi-bin/mailman/listinfo/announce
To unsubscribe, send an email with unsubscribe as the Subject: to 
announce-requ...@mariadb.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://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: Linux hyphenation

2013-09-18 Thread Tom Davies
Hi :)
Ahhh, the Wubi.  For most people it does work really well and for many years 
but just occasionally it runs into weird problems that just don't happen on a 
proper dual-boot system.  

The Wubi is installed inside Windows and depends on MS Windows co-operating 
with the Ubuntu.  Various crucial systems such as the boot-loader and the 
file-system are basically MS systems instead of the proper GnuLinux ones.  The 
GnuLinux ones are built to be stable.  Years ago several antivirus programs 
would inaccurately report various false-positives.  There are other distros 
which also have clever ways of installing inside Windows without having to 
resort to too many layers or emulators or virtual machines but the whole idea 
seems flawed to me.  MS are not renowned for co-operating with other systems.  
Still, a lot of good work goes in and the systems are usually stable for most 
people but a few are unlucky without any obvious reason.  

Sorry Virgil!
Apols and regards from 
Tom :)  






 From: Virgil Arrington cuyfa...@hotmail.com
To: users@global.libreoffice.org 
Sent: Tuesday, 17 September 2013, 20:22
Subject: Re: [libreoffice-users] Re: Linux hyphenation
 

Unless anyone else is bothered by this behavior in the Linux LO, I'm letting 
it go.

I just uninstalled my Ubuntu wubi install. I'm going to leave it for a while 
before trying again. My Windows LO works fine, and so for now, I'll stay 
here. I have another life I have to live.

Thanks to all who were interested in this issue.

Virgil

-Original Message- 
From: Virgil Arrington
Sent: Tuesday, September 17, 2013 1:28 PM
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Re: Linux hyphenation

On 09/15/2013 11:24 AM, Kracked_P_P---webmaster wrote:
 OK, I went to Synaptic Package Manager and looked up libhyphen.

 It was there as part of the Ubuntu packages.
 Maybe Mint did not install that package.

 So go to your package manager and look up and install that Debian
 package and see if that helps.
 My package was labeled libhyphen0.

 Looking up hyphen, I have the following [but not the entire list]
 installed:
 hyphen-en-us
 libhyphen0
 openoffice.org-hyphenation

 So go that route.
 Look up the packages in you package manager - I prefer to use Synaptic
 which Ubuntu no longer installs by default.  Then install them there.

 You might fix some of your issues.

 As I stated, Mint and I had problems with one if my network printers -
 it did not exist on the network - but would use it as a USB printer.
 Had no issues with Ubuntu 10.04 or 12.04.



Okay, here's what I've done.

1. I searched Synaptic for libhyphen and found the same files you
mentioned. Yet, LO doesn't recognize it.

2. I then uninstalled my Linux Mint. It was no big deal as I had a Bible
research program that wouldn't work with it anyway. (I won't necessarily
blame Mint, but I didn't want to have to chase down two Mint problems)

3. I installed Ubuntu 12.04 LTS using the Wubi installer. That installed
LO 3.5.x by default. (The Bible research program also worked.)

4. I checked LO 3.5.x, under Options/Language Settings/Writing Aids/ and
it had the Hunspell spellcheck module, but it did not have any modules
for Hyphenation, Grammar, or Thesaurus.

5. I then upgraded LO to 4.0.4.2 using the
ppa:libreoffice/libreoffice-4-0 repository. That was a little weird as
I followed online instructions for upgrading to 4.0.5, but the closest I
got was 4.0.4.2. Oh, well.

6. I then installed the American English dictionary from the dictionary
extensions.

7. Once that was installed, I gained the OpenOffice Thesaurus module,
but still no Hyphenation or Grammar Checker modules.

8. Using Synaptic, I found all the same files you listed on your system.

9. Out of curiosity, I then noticed the packages listed at
https://launchpad.net/~libreoffice/+archive/libreoffice-4-0. It
mentions the hunspell package and, immediately after, a hyphen
package (version 2.8.3-1~lucid1), but no libhyphen package. At this
point, I'm waaa out of my techno comfort zone.

This has become a real head scratcher for me. For my actual work, I'm
still booting into Windows, but the OCD side of me wants to figure this out.

Virgil

-- 
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


-- 
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
-- 
To unsubscribe 

[libreoffice-users] CONVERT function in Calc

2013-09-18 Thread Tom Davies
Hi :)
I think John from the Docs Team could use some help with the Convert 
function.  I think the questions are
1.  Is it possible for a normal user to edit the lists used in the Convert 
function
2.  how to do 1 if it is possible?  



3.  Are other people having trouble with Convert in 4.1.x?  

4.  Is Convert now legacy and unsupported having been replaced by a newer 
function (i've forgotten the name but i'm sure they mentioned the name of a 
replacement)?

Regards from 
Tom :)  






 From: John Smith clicks...@yahoo.co.uk
To: documentation documentat...@global.libreoffice.org 
Sent: Tuesday, 17 September 2013, 21:45
Subject: [libreoffice-documentation] CONVERT function in Calc
 

Hi all.
I'm working on the Appendix B chapter for Calc and I am looking at the 
=CONVERT function. This function converts a numerical value from one 
unit of measure, to another unit of measure in the same group, for 
example feet into yards, both in the distance group.
Within the dialogue of the Function Wizard is a statement Converts a 
value according to a conversion table in the configuration (main.xcd).

My question is basically a two parter; is this list available to a user, 
and if so how do you access it? and because the two parameters in the 
function for units are both case sensitive and entered inside quotes, 
how do you find what the valid entries are for these parameters?
The  syntax is CONVERT(Number, text, text) where text is the unit of 
conversion.

I have tried a few of the entries which I found here; 
http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01-part2.html#CONVERT
such as lbm and stone for mass, pt and qt for volume and ft 
and in for distance, without success.

Pulling my hair out here:-) . Please help.

Regards
JohnS
-- 
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] MariaDB 5.5.33 Now Available

2013-09-18 Thread jomali
When it includes an OSX installer, I'll consider it.

On Wednesday, September 18, 2013, Tom Davies wrote:

 Hi :)

 Another stable release from MariaDb.


 Last time a few of the BoD slapped my wrists for posting 'irrelevant' and
 'off-topic' posts and cited forwarding the last MariaDb announcement as an
 example, meanwhile a few  people here suggested that it was good to hear
 about because so many GnuLinux distros are swapping out MySql (Oracle's)
 and replacing with MariaDb (which i thought had recently merged with
 another fork of MySql or something).

 Regards from
 Tom :)




 
  From: MariaDB Announce List annou...@mariadb.org javascript:;
 To: annou...@mariadb.org javascript:;
 Sent: Tuesday, 17 September 2013, 19:35
 Subject: [MariaDB Announce] MariaDB 5.5.33 Now Available


 The MariaDB project is pleased to announce the immediate availability
 of MariaDB 5.5.33.

 This release features the addition of TokuDB as an additional storage
 engine option. There are also bug and other fixes. See the Release
 Notes and Changelog for details.


 - - Links  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

 MariaDB 5.5.33 Stable (GA)
 - Release Notes: https://mariadb.com/kb/en/mariadb-5533-release-notes
 - Changelog: https://mariadb.com/kb/en/mariadb-5533-changelog
 - Downloads: https://downloads.mariadb.org/mariadb/5.5.33

 Overview of MariaDB 5.5: https://mariadb.com/kb/en/what-is-mariadb-55

 APT and YUM Repository Configuration Generator:
   - https://downloads.mariadb.org/mariadb/repositories/


 - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - -

 MariaDB includes a User Feedback plugin. This plugin is disabled by
 default. If enabled, it submits basic, completely anonymous MariaDB
 usage information. This information is used by the developers to track
 trends in MariaDB usage to better guide development efforts.

 If you would like to help make MariaDB better, please add feedback=ON
 to your my.cnf (my.ini on Windows) file!

 See http://mariadb.com/kb/en/user-feedback-plugin for more information.


 - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

 The project always strives for quality, but in reality, nothing is
 perfect. Please take time to report any issues you encounter at:

 - http://mariadb.org/jira


 - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - -

 If you would like to contribute to MariaDB, please see our
 contributing and donations pages. We also have merchandise
 available in a cafepress store.

 - https://mariadb.com/kb/en/contributing

 - https://mariadb.org/en/donate/

 - http://www.cafepress.com/mariadb

 We hope you enjoy MariaDB!

 --
 MariaDB: An Enhanced Drop-in Replacement for MySQL
 Website - http://mariadb.org
 Twitter - http://twitter.com/mariadb
 Google+ - http://google.com/+mariadb
Facebook - http://fb.com/MariaDB.dbms
   Knowledgebase - http://mariadb.com/kb
 ___
 announce mailing list
 annou...@mariadb.org javascript:;
 https://lists.askmonty.org/cgi-bin/mailman/listinfo/announce
 To unsubscribe, send an email with unsubscribe as the Subject: to
 announce-requ...@mariadb.org javascript:;
 --
 To unsubscribe e-mail to: 
 users+unsubscr...@global.libreoffice.orgjavascript:;
 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



-- 
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



[libreoffice-users] Multi-test IF statement in Calc

2013-09-18 Thread Carl Paulsen
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 #NA 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#NA; B1#NA),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?


Many thanks in advance.
--

Carl Paulsen

Dover, NH 03820


--
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] MariaDB 5.5.33 Now Available

2013-09-18 Thread Girvin Herr
FYI: I just checked the latest Slackware Linux development distro and 
they have switched to Mariadb for the next release.  Slackware has a 
history of dropping software packages when the supplier varies from the 
Open Source paradigm or refuses to fix security problems. I guess Oracle 
has gone too far.

Girvin Herr


On 09/18/2013 08:51 AM, Tom Davies wrote:

Hi :)

Another stable release from MariaDb.


Last time a few of the BoD slapped my wrists for posting 'irrelevant' and 
'off-topic' posts and cited forwarding the last MariaDb announcement as an example, 
meanwhile a few  people here suggested that it was good to hear about because so 
many GnuLinux distros are swapping out MySql (Oracle's) and replacing with 
MariaDb (which i thought had recently merged with another fork of MySql or 
something).

Regards from
Tom :)





  From: MariaDB Announce List annou...@mariadb.org
To: annou...@mariadb.org
Sent: Tuesday, 17 September 2013, 19:35
Subject: [MariaDB Announce] MariaDB 5.5.33 Now Available
  


The MariaDB project is pleased to announce the immediate availability
of MariaDB 5.5.33.

This release features the addition of TokuDB as an additional storage
engine option. There are also bug and other fixes. See the Release
Notes and Changelog for details.


- - Links  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

MariaDB 5.5.33 Stable (GA)
- Release Notes: https://mariadb.com/kb/en/mariadb-5533-release-notes
- Changelog: https://mariadb.com/kb/en/mariadb-5533-changelog
- Downloads: https://downloads.mariadb.org/mariadb/5.5.33

Overview of MariaDB 5.5: https://mariadb.com/kb/en/what-is-mariadb-55

APT and YUM Repository Configuration Generator:
   - https://downloads.mariadb.org/mariadb/repositories/


- - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - -

MariaDB includes a User Feedback plugin. This plugin is disabled by
default. If enabled, it submits basic, completely anonymous MariaDB
usage information. This information is used by the developers to track
trends in MariaDB usage to better guide development efforts.

If you would like to help make MariaDB better, please add feedback=ON
to your my.cnf (my.ini on Windows) file!

See http://mariadb.com/kb/en/user-feedback-plugin for more information.


- - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

The project always strives for quality, but in reality, nothing is
perfect. Please take time to report any issues you encounter at:

- http://mariadb.org/jira


- - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - -

If you would like to contribute to MariaDB, please see our
contributing and donations pages. We also have merchandise
available in a cafepress store.

- https://mariadb.com/kb/en/contributing

- https://mariadb.org/en/donate/

- http://www.cafepress.com/mariadb

We hope you enjoy MariaDB!

--
MariaDB: An Enhanced Drop-in Replacement for MySQL
 Website - http://mariadb.org
 Twitter - http://twitter.com/mariadb
 Google+ - http://google.com/+mariadb
Facebook - http://fb.com/MariaDB.dbms
   Knowledgebase - http://mariadb.com/kb
___
announce mailing list
annou...@mariadb.org
https://lists.askmonty.org/cgi-bin/mailman/listinfo/announce
To unsubscribe, send an email with unsubscribe as the Subject: to 
announce-requ...@mariadb.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://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] [HOW] impagination like a BOOK?

2013-09-18 Thread Steve Edmonds


On 2013-09-19 00:32, Brian Barker wrote:



I'm curiosity what is freeware virtual pdf printer?


It's a program which, when installed, appears in your list of 
printers.  But there is no physical printer.  Instead, when you use 
the virtual printer - through the print dialogue in the usual way - 
the program creates a PDF document representing what would have been 
printed.  The advantage here is that you can test the Brochure 
facility without wasting paper.



my distro OPENSUSE 12.3 with KDE 4.10, ...


I can't speak for this platform.  Try doing a search for PDF virtual 
printer.  Does this earlier message in this thread help: 
http://listarchives.libreoffice.org/global/users/msg33362.html ?


I trust this helps. 

Hi.
The standard KDE printer dialogue allows you to print to PDF as 
standard. It is the top selection above your printers.
My LO print dialogue is different, but on the last tab has print to 
file, if PDF is set in device options then it is as PDF, I need to have 
a printer configured though that gives an A3 paper option.

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



Re: [libreoffice-users] [HOW] impagination like a BOOK?

2013-09-18 Thread Steve Edmonds

Hi.
I think cups-pdf does what ps2pdf does, may be a few more options.
Steve
On 2013-09-19 07:09, Tom Davies wrote:

Hi :)
Yes, i don't see the point of the extra program either.  I can print 
to file and then usually have a choice between Pdf and PS.  I don't 
see what else those other programs are offering.

Regards from
Tom :)



*From:* Steve Edmonds steve.edmo...@ptglobal.com
*To:* users@global.libreoffice.org
*Sent:* Wednesday, 18 September 2013, 19:51
*Subject:* Re: [libreoffice-users] [HOW] impagination like a BOOK?


On 2013-09-19 00:32, Brian Barker wrote:

 I'm curiosity what is freeware virtual pdf printer?

 It's a program which, when installed, appears in your list of
 printers.  But there is no physical printer. Instead, when you use
 the virtual printer - through the print dialogue in the usual way -
 the program creates a PDF document representing what would have been
 printed.  The advantage here is that you can test the Brochure
 facility without wasting paper.

 my distro OPENSUSE 12.3 with KDE 4.10, ...

 I can't speak for this platform.  Try doing a search for PDF virtual
 printer.  Does this earlier message in this thread help:
 http://listarchives.libreoffice.org/global/users/msg33362.html ?

 I trust this helps.
Hi.
The standard KDE printer dialogue allows you to print to PDF as
standard. It is the top selection above your printers.
My LO print dialogue is different, but on the last tab has print to
file, if PDF is set in device options then it is as PDF, I need to have
a printer configured though that gives an A3 paper option.
Steve

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org 
mailto: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






--
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] MariaDB 5.5.33 Now Available

2013-09-18 Thread Girvin Herr
I just checked the Slackware Current (unreleased yet, but available 
for testing) website again to see if the release notes had been updated 
with the reason to switch from MySQL to MariaDB.  Alas, they have not 
updated that file from the 14.0 release yet.  I think you are correct in 
that there are a lot of applications, including KDE4 I discovered, that 
use MySQL and Slack must verify they will all work with MariaDB before 
they release a distro with it.


As another datapoint, I just checked the Slack 14.0 release, the latest 
release, and MariaDB is not included in the extra directory of the 
distro.  That implies that back when 14.0 was released (c. 2012), Slack 
was not intending to replace MySQL with MariaDB.  The extra directory 
usually contains experimental packages that Slack is considering, but 
they have not yet tested them enough to include them in the normal 
installation.  From what I saw on the current website, MariaDB is not 
going to be in the extra directory, but in the installation itself.  
That change is a big step and a fast decision by Slackware - that is, if 
it is not changed before the release of current.


On a personal note, my biggest concern is whether MariaDB will work with 
the Oracle Java connector I am using to interface with LO Base, or do I 
have to research all that again to get the correct configuration.


   mysql-connector-java-5.1.18
   jdk/jre-6u37

Yes, it is old, but it works and I don't have to deal with the paranoid 
Oracle website.


Girvin


On 09/18/2013 12:12 PM, Tom Davies wrote:

Hi :)
I think Oracle has always gone too far.  I suspect the delay with 
Slackware switching was due to just how embedded MySql is in so many 
things and they wanted to make sure MariaDb really would work in as 
many of those places or ways as possible.


Thanks for the feedback!  I feel a bit vindicated again :)  It is 
going to affect office systems so i figure it is good for us to be 
aware of what is going on.

Thanks and regards from
Tom :)



*From:* Girvin Herr girvin.h...@sbcglobal.net
*To:* users@global.libreoffice.org
*Sent:* Wednesday, 18 September 2013, 19:49
*Subject:* Re: [libreoffice-users] MariaDB 5.5.33 Now Available

FYI: I just checked the latest Slackware Linux development distro and
they have switched to Mariadb for the next release. Slackware has a
history of dropping software packages when the supplier varies from the
Open Source paradigm or refuses to fix security problems. I guess Oracle
has gone too far.
Girvin Herr


On 09/18/2013 08:51 AM, Tom Davies wrote:
 Hi :)

 Another stable release from MariaDb.


 Last time a few of the BoD slapped my wrists for posting 
'irrelevant' and 'off-topic' posts and cited forwarding the last 
MariaDb announcement as an example, meanwhile a few  people here 
suggested that it was good to hear about because so many GnuLinux 
distros are swapping out MySql (Oracle's) and replacing with MariaDb 
(which i thought had recently merged with another fork of MySql or 
something).


 Regards from
 Tom :)




 
  From: MariaDB Announce List annou...@mariadb.org 
mailto:annou...@mariadb.org

 To: annou...@mariadb.org mailto:annou...@mariadb.org
 Sent: Tuesday, 17 September 2013, 19:35
 Subject: [MariaDB Announce] MariaDB 5.5.33 Now Available


 The MariaDB project is pleased to announce the immediate availability
 of MariaDB 5.5.33.

 This release features the addition of TokuDB as an additional storage
 engine option. There are also bug and other fixes. See the Release
 Notes and Changelog for details.


 - - Links  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

 MariaDB 5.5.33 Stable (GA)
 - Release Notes: https://mariadb.com/kb/en/mariadb-5533-release-notes
 - Changelog: https://mariadb.com/kb/en/mariadb-5533-changelog
 - Downloads: https://downloads.mariadb.org/mariadb/5.5.33

 Overview of MariaDB 5.5: https://mariadb.com/kb/en/what-is-mariadb-55

 APT and YUM Repository Configuration Generator:
- https://downloads.mariadb.org/mariadb/repositories/


 - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - -

 MariaDB includes a User Feedback plugin. This plugin is disabled by
 default. If enabled, it submits basic, completely anonymous MariaDB
 usage information. This information is used by the developers to track
 trends in MariaDB usage to better guide development efforts.

 If you would like to help make MariaDB better, please add feedback=ON
 to your my.cnf (my.ini on Windows) file!

 See http://mariadb.com/kb/en/user-feedback-plugin for more information.


 - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

 The project always strives for quality, but in reality, nothing is
 perfect. Please take time to report any issues you encounter at:

 - http://mariadb.org/jira


 - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - -

 If you would like to 

Re: [libreoffice-users] Multi-test IF statement in Calc

2013-09-18 Thread Mark Bourne

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 #NA 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#NA; B1#NA),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?

Many thanks in advance.


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.


Hope that helps.

Mark.

--
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



[libreoffice-users] Re: Linux hyphenation

2013-09-18 Thread Urmas

Tom Davies:

The Wubi is installed inside Windows and depends on MS Windows co-operating 
with the Ubuntu.  Various crucial systems such as the boot-loader and the 
file-system are basically MS systems instead of the proper GnuLinux ones.


That has no relation to the system stability. 




--
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: Linux hyphenation

2013-09-18 Thread Paul



On Thu, 19 Sep 2013 04:03:25 +0700
Urmas davian...@gmail.com wrote:

 Tom Davies:
 
 The Wubi is installed inside Windows and depends on MS Windows
 co-operating with the Ubuntu.  Various crucial systems such as the
 boot-loader and the file-system are basically MS systems instead of
 the proper GnuLinux ones.
 
 That has no relation to the system stability. 

Uh, sure it does. They are different systems, therefore they have
different stability issues. Any two parts that are *different* will have
the potential for different problems.

In this case there is the additional factor that these subsystems
are integral to the whole, and many other parts of the system further
down the line are made with the assumption that these underlying
subsystems function a certain way. In well written systems, subsystems
make as few assumptions about other parts of the system as possible,
but it does still happen more often that one would hope for. And when
they are as different as linux and windows are, sometimes those
assumptions become invalidated, which can cause further instability.


Paul

-- 
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

2013-09-18 Thread Brian Barker

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)

But we can do more.  The result of the NOT() function - which you are 
then testing using the IF() function - is a logical value, TRUE or 
FALSE.  But such logical values can be (mis)interpreted as numbers, 
with TRUE being one and FALSE zero - exactly the values you 
require.  So we don't need the IF() function at all.  Just use

=NOT(OR(ISNA(A1);ISNA(B1)))
This function will give you a logical result: TRUE or FALSE.  But if 
you format the result cells as Number, you will see the ones and 
zeroes that you seek.  If you wish to calculate further with these 
values, you don't even have to worry about formatting: just use them 
in arithmetic as they are.


I trust this helps.

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] [HOW] impagination like a BOOK?

2013-09-18 Thread Kracked_P_P---webmaster

CUPS-PDF is my default printer.
It has all of the needed options to create a PDF file that other
programs would want/  LO has the export to PDF options, but I tend to
use CUPS-PDF for printing web pages and then physically printing only
the sheets that I want.   You can also decide what the file resolution
was to be, including 600 and 1200 DPI and the image quality/compression
that goes into the file.

doPDF is similar, but is for Windows.

There are some big advantages to having a PDF printer installed, even
with LO's export to PDF.  I use both equally when I need a PDF file from
a LO document.

As for ps2pdf - I thought you needed a .ps file to start with.  Could be
wring, but that was what I was told years ago.





On 09/18/2013 03:20 PM, Steve Edmonds wrote:
 Hi.
 I think cups-pdf does what ps2pdf does, may be a few more options.
 Steve
 On 2013-09-19 07:09, Tom Davies wrote:
 Hi :)
 Yes, i don't see the point of the extra program either.  I can print
 to file and then usually have a choice between Pdf and PS.  I don't
 see what else those other programs are offering.
 Regards from
 Tom :)


 
 *From:* Steve Edmonds steve.edmo...@ptglobal.com
 *To:* users@global.libreoffice.org
 *Sent:* Wednesday, 18 September 2013, 19:51
 *Subject:* Re: [libreoffice-users] [HOW] impagination like a BOOK?


 On 2013-09-19 00:32, Brian Barker wrote:
 
  I'm curiosity what is freeware virtual pdf printer?
 
  It's a program which, when installed, appears in your list of
  printers.  But there is no physical printer. Instead, when you use
  the virtual printer - through the print dialogue in the usual way -
  the program creates a PDF document representing what would have been
  printed.  The advantage here is that you can test the Brochure
  facility without wasting paper.
 
  my distro OPENSUSE 12.3 with KDE 4.10, ...
 
  I can't speak for this platform.  Try doing a search for PDF virtual
  printer.  Does this earlier message in this thread help:
  http://listarchives.libreoffice.org/global/users/msg33362.html ?
 
  I trust this helps.
 Hi.
 The standard KDE printer dialogue allows you to print to PDF as
 standard. It is the top selection above your printers.
 My LO print dialogue is different, but on the last tab has print to
 file, if PDF is set in device options then it is as PDF, I need to have
 a printer configured though that gives an A3 paper option.
 Steve

 -- 
 To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
 mailto: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






-- 
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: Linux hyphenation

2013-09-18 Thread Virgil Arrington
I've tried both the Wubi install and a proper dual boot system of Windows 
and Ubuntu. It's been a long time, so I can't recall exactly why, but it 
seems that the Wubi installation gave me something that the true dual-boot 
system didn't. I seem to remember that, in the true dual boot system, I 
couldn't use LO in Ubuntu to access the documents in my Windows partition. 
There seemed to be greater separation between the Windows and Ubuntu sides 
of things. But, in the Wubi installation, I could easily access my Windows 
system by going through File System/Host.


And, when I went to delete the proper Ubuntu partition, I was met with the 
horrible grub loader that I had to undo and fix before I could even boot 
from Windows again. So, I preferred Wubi, even though I knew that it wasn't 
a real Linux system.


My problem now is that I really want to like Linux. I don't want to keep 
relying on MS and Windows, etc., but every time I try Linux in any form, I 
come across some roadblock that prevents me from committing. I've tried 
several versions of Ubuntu, both Wubi and proper as Tom puts it, and I've 
tried the Windows installation of Mint 15 (both 32 and 62 bit). After a 
while, I realize I'm spending a ton of time just trying to make my Linux 
system catch up to what I can already accomplish in Windows. Even LO works 
better for me in Windows than in Linux. Simple things like getting my style 
list box to properly dock to one side of the screen works easily in Windows, 
but I could never get it to work properly in Ubuntu (but I could in Mint... 
go figure). And, I had some keyboard issues with my numeric keypad in both 
Mint and Ubuntu -- nothing major, but an irritation nonetheless.


I still have a Mint installation on a jump drive. For now, when I want to 
play, I'll just boot from that and gain more experience. Once I learn more 
then I may invest the time and effort into a proper Linux system.


Virgil



-Original Message- 
From: Tom Davies

Sent: Wednesday, September 18, 2013 11:45 AM
To: Virgil Arrington ; users@global.libreoffice.org
Subject: Re: [libreoffice-users] Re: Linux hyphenation

Hi :)
Ahhh, the Wubi.  For most people it does work really well and for many years 
but just occasionally it runs into weird problems that just don't happen on 
a proper dual-boot system.


The Wubi is installed inside Windows and depends on MS Windows co-operating 
with the Ubuntu.  Various crucial systems such as the boot-loader and the 
file-system are basically MS systems instead of the proper GnuLinux ones. 
The GnuLinux ones are built to be stable.  Years ago several antivirus 
programs would inaccurately report various false-positives.  There are other 
distros which also have clever ways of installing inside Windows without 
having to resort to too many layers or emulators or virtual machines but the 
whole idea seems flawed to me.  MS are not renowned for co-operating with 
other systems.  Still, a lot of good work goes in and the systems are 
usually stable for most people but a few are unlucky without any obvious 
reason.


Sorry Virgil!
Apols and regards from
Tom :)






From: Virgil Arrington cuyfa...@hotmail.com
To: users@global.libreoffice.org
Sent: Tuesday, 17 September 2013, 20:22
Subject: Re: [libreoffice-users] Re: Linux hyphenation


Unless anyone else is bothered by this behavior in the Linux LO, I'm letting
it go.

I just uninstalled my Ubuntu wubi install. I'm going to leave it for a while
before trying again. My Windows LO works fine, and so for now, I'll stay
here. I have another life I have to live.

Thanks to all who were interested in this issue.

Virgil

-Original Message- 
From: Virgil Arrington

Sent: Tuesday, September 17, 2013 1:28 PM
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Re: Linux hyphenation

On 09/15/2013 11:24 AM, Kracked_P_P---webmaster wrote:

OK, I went to Synaptic Package Manager and looked up libhyphen.

It was there as part of the Ubuntu packages.
Maybe Mint did not install that package.

So go to your package manager and look up and install that Debian
package and see if that helps.
My package was labeled libhyphen0.

Looking up hyphen, I have the following [but not the entire list]
installed:
hyphen-en-us
libhyphen0
openoffice.org-hyphenation

So go that route.
Look up the packages in you package manager - I prefer to use Synaptic
which Ubuntu no longer installs by default.  Then install them there.

You might fix some of your issues.

As I stated, Mint and I had problems with one if my network printers -
it did not exist on the network - but would use it as a USB printer.
Had no issues with Ubuntu 10.04 or 12.04.




Okay, here's what I've done.

1. I searched Synaptic for libhyphen and found the same files you
mentioned. Yet, LO doesn't recognize it.

2. I then uninstalled my Linux Mint. It was no big deal as I had a Bible
research program that wouldn't work with it anyway. (I won't 

[libreoffice-users] tabloid paper. was: [HOW] impagination like a BOOK?

2013-09-18 Thread Tom Davies
Hi :)
I thought the whole point of tabloid paper was that it was the cheapest 
around and thus the publishers could print more runs more often and even charge 
less but still make a decent profit.  Surely the famous 
stack'em high, sell'em cheap comes from the ability of tabloids to 
undercut the more serious newspapers.  Everything else is better 
quality, even toilet paper (actually my granny could sometimes make the 
sunday papers last all week this way).  The sheets were so porous that 
they were also a firm favourite for wrapping fishchips in for the 
walk back from the chippie (preferably not the same bit of paper as was 
used for the other use).  Then that was banned because the print was smudge off 
the page and while that added to the flavour (again the 2nd use rather than the 
1st) is was discovered to be a little bit toxic.  So i thought we were trying 
to put the tabloid paper behind us and upgrade.  


It's interesting to hear that tabloid paper is now considered more official and 
desirable for printing news!  
Regards from 
Tom :)


- Forwarded Message -
From: Kracked_P_P---webmaster webmas...@krackedpress.com
To: users@global.libreoffice.org 
Sent: Tuesday, 17 September 2013, 16:10
Subject: Re: [libreoffice-users] [HOW] impagination like a BOOK?
 

snip /

One reason I did not test it on my tabloid paper, was the price of the
paper itself.  It is hard to find it locally, so I usually have to order
it online.  I can never find the 13x19 inch paper, so it is also an
online purchase.  Shipping costs or paper can be expensive, 

snip /

-- 
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