Re: [libreoffice-users] Re: Survey about LibreOffice

[Mark Phillips]

I just tried the survey, and it came out as half English and half Spanish.

Mark

On Wed, May 3, 2017 at 5:53 AM, anne-ology  wrote:

>I too tried -
>
>(1) I'm assuming your attempt at placing this into English is due to
> a limited knowledge of our complicated language;
>  the beginning question marks & other symbols throughout are
> superfluous.
>
>(2) the button at the end - containing more symbols - I assumed
> would go to the next page, but merely circled back to the start;
>  is that what you intended?
>
>(3) the categories also don't list whether used by individual for
> business and/or personal use; used by group of individuals; used by some
> sort & size of a for-profit or non-profit organization.
>
>
>
>
>
> From: John R. Sowden 
> Date: Fri, Apr 28, 2017 at 10:34 AM
> Subject: Re: [libreoffice-users] Re: Survey about LibreOffice
> To: users@global.libreoffice.org
>
>
> I tried:
> 1) What is googleapis, a script that was attempted to be run? Sounds rather
> googleish to me.
> 2) In your categories of types of organizations, "Small Businesse" was not
> included. (knowing who the users are will help in improving the product to
> meet the need of the users).
> 3) On the following screen, the language changed from American English
> (Ubuntu's default in my case) to Spanish.  Although I took a couple of
> years of French in high school 50 years ago, it didn't help.
>
> John
>
>
>
> On 04/28/2017 07:48 AM, jorge wrote:
>
> Hi all:
> >
> > I want to remember you the survey ... would you please answer it
> to
> > this link if you haven't done ?
> >
> > https://es.surveymonkey.com/r/L7QT923
> >
> > 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
>

-- 
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] Linux User Groups

[Mark Phillips]

Try googling for a local Linux users group. Short of that, there are active
groups in Phoenix and Portland with email lists you can post questions and
get help.

Mark

On Mar 3, 2017 1:49 PM, "charles meyer"  wrote:

> Hi esteemed mates,
>
> Pardon my off-topic post, but has anyone found a good Linux forum to
> discuss Ubuntu and/or Knoppix issues?
>
> I'm trying to make RecordMyDesktop work on a Knoppix Live distribution on a
> flash drive.
>
> I emailed Klaus Knopper (Knoppix creator) but I just got a robo
> response that he can't respond to emails.
>
> Thanks so much.
>
> Charles.
>
> --
> 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] Mail Merge - Labels

[Mark Phillips]

In my version of LibreOffice (4.2.8.2) there is a check box that says
"Suppress lines with just empty fields" in the mail merge wizard. It is
under the text box where you put the address information (ie ).

Mark

On Wed, Oct 28, 2015 at 1:33 PM, Stan Grigiski 
wrote:

> Hello,
>
> I noticed that when I try to mail merge a data base for labels, the program
> will not supress a field if there is no entry; it will create a space on
> the lable. For example, if I have the field "address 1" set for street
> number and street name and the field "address 2" set for apt#, if a person
> does not have an apt #, it will put a space between the address and city,
> state and zip code. The link below seems to be the only fix I can find.
>
> http://openoffice.blogs.com/openoffice/2007/05/suppressing_bla.html
>
> Is there any way this issue can be addressed on the next update?
>
> Thanks,
>
> --
>
> *Stan Grigiski*
> Medical Claim Service of Southwest Florida, Inc.
> 923 Del Prado Blvd.
> Suite 107
> Cape Coral, FL 33990
>
> Phone: 239-772-2030
> E-mail: st...@wegivepeaceofmind.com
> Web Address: www.wegivepeaceofmind.com
> Like us on Facebook 
>
> LEGAL DISCLAIMER
> The information transmitted is intended solely for the individual or entity
> to which it is addressed and may contain confidential and/or privileged
> material. Any review, retransmission, dissemination or other use of or
> taking action in reliance upon this information by persons or entities
> other than the intended recipient is prohibited. If you received this
> e-mail in error, please contact the sender immediately and delete material
> from any computer.
>
> --
> 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] Installing Libreoffice in Ubuntu

[Mark Phillips]

On Thu, Oct 8, 2015 at 7:47 PM, John R. Sowden 
wrote:

>
> 1) Use the Software Center in Ubuntu.  Never mind that it is not the
> current version.  Never mind that  the version is not posted in the "more
> Info" description, along with the date of the version.
>

Not sure what you are looking at, but on my Ubuntu 14.04 LTS, the version
of libreoffice is clearly displayed in the Software Center. It is at the
bottom of the page - libreoffice-base 1:4.2.8-0ubuntu2

>
> or
>
> 20 Go to libreoffice.org.  Press the big download button.  Now what?
> Start googling for instructions.
> Expect the instructions to not tell you:
> an explanation of each command.
> where the program will end up on your system.
> whether it will automatically get rid of the remnant files and even
> the original downloaded files.
> how to deal with the help, and why.
>

Hmmm.and of course, Microsoft Office or any other Microsoft alternative
software will tell you all these things when you install it? I think not.

>
> or
>
> 3) Google like I did last night and find that there are "ppa"s, with a
> well written explanation of the "fresh ppa" being better and why. Now try
> to find how to install the most current version, whether you have a copy on
> your computer or not.
>
> and
>
> How to deal with dependencies, not just finding out that you have
> "dependency problems" but also that LO will not install due to them.
>
> It seems that this is a universal Linux problem.  If you don't know the
> intricacies of Linux, then you shouldn't be using it.  So much for
> attaining more market share.
>

If you don't want to deal with dependencies, then install the LO from the
Software Center, and stop whining. If you want a different version, then
learn how to read, handle dependencies, work from the command line, and
stop whining.

If you find Linux and LO so offensive that you have to publicly whine like
this instead of asking meaningful questions about a particular prorblem, I
suggest you purchase Microsoft Windows, Microsoft Office, and pay for a
support plan so you can complain to someone in India or Ireland about your
problems.

Linux (and life) is about learning to help yourself.

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

Re: [libreoffice-users] Help needed exporting libo guides from odt to pdf

[Mark Phillips]

Print the odf document from Writer using the CUPS pdf printer. This will
give you a pdf of the document.

Mark

On Tue, May 19, 2015 at 5:16 PM, elcico2001 ??? elcico2...@yahoo.it
wrote:

 Hello all,
 Need a little help to export from odt to pdf the translated to italian wg;
 problem is fields (cross references) regarding figures are not exported
 properly; for instance the sentence see figure 10 becomes see 10 and
 the word figure is lost.

 I have tried different libo versions (kubuntu 14.04 libo 4.2.8(?) - winxp
 libo 4.2.2 - winxp libo 3.6.7 - lubuntu 15.04 libo 4.4.2), but the only one
 that works is libo 3.5.4 on debian old-stable.
 As I'd like to update my debian old-stable... :)  anyone can help on this?
 Could you tell me what is used to export english guides, as I've seen the
 problem does not exist for these guides.

 Also searched for bugs; just found this one, but I doubt it's the same
 problem:

 https://bugs.documentfoundation.org/show_bug.cgi?id=42346

 Thank you :)
 P.S. Not subscribed to users@global, so please reply me cc.

 --
 cico
 
 Icq/Licq/Gaim #175451007
 Debian Powered Linux Registered User #310800 at http://counter.li.org
 No retreat baby no surrender
 http://www.retenergie.it - coop di produttori e utilizzatori di energia
 da fonti rinnovabili
 tad evaarthamaatra-nirbhaasaM svaruupa-shuunyam iva samaadhiH
 Sanskrit - Realize it's the common language ;-)


 --
 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] Basic Calc Question

[Mark Phillips]

I don't understand the references to a conditional statement and the
reference to 0. But, to create a running balance, you just use a sum with
the first cell anchored. For example, assume entries are in the first
column, A starting at A1, and you want the running total in column B
starting at B1. B1 would have the formula =sum($a$1:a1). Then copy this
formula into the cells below B1, and you will have a running total of the
numbers in column A. Try it and you will see how it works.

b1 has =sum($a$1:a1)
b2 has =sum($a$1:a2)
b3 has =sum($a$1:a3)

and so on.

Mark

On Mon, Apr 13, 2015 at 4:16 PM, Barry Premeaux bpreme...@gmail.com wrote:

 I'm a novice at spreadsheets, and google hasn't turned up an answer.
 Probably because I haven't worded the question properly. I am trying to
 build a general ledger. I have my running balance in the F column and
 transactions in the E column. I am trying to construct a conditional
 statement that takes the running balance in F4 and adds it to the -/+
 transaction in E5 and put the new balance in F5. But when the E5 is $0.00,
 I want F5 to remain $0.00 as well until a new transaction is entered.

 Barry

 --
 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] Thank you LibreOffice.

[Mark Phillips]

+10 to all the developers and other contributors to this great project!

Mark

On Mon, Feb 2, 2015 at 7:20 PM, anne-ology lagin...@gmail.com wrote:

in agreement.



 From: Thisis theone thisistheone8...@gmail.com
 Date: Mon, Feb 2, 2015 at 3:02 PM
 Subject: [libreoffice-users] Thank you LibreOffice.
 To: users@global.libreoffice.org


 I'm proud that a great, free and open source office suite exists.

 Thank you LibreOffice, thank you in the name of humanity.

 --
 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] Currently Using Spreadsheet for Personal Project - Thinking About Database

[Mark Phillips]

Joel,

A suggestion from left field, but it will help you in the long run. Take a
look at the django project - https://www.djangoproject.com/. It is a
framework for creating database driven web sites. It is very easy to use
and very powerful. The framework automatically creates all the plumbing you
need to build a project (such as database tables), and allows you, the
designer, to focus on the higher level problems of your design (what the
page views should look like). The user community is very helpful. There are
also many inexpensive hosting options for a public facing dajngo project,
or you can just run it locally on your own machine.

Try the tutorial and you will see how easy it is to use -
https://docs.djangoproject.com/en/1.6/intro/tutorial01/.

Good luck!

Mark


On Mon, Aug 11, 2014 at 6:28 AM, Oogie McGuire oog...@desertweyr.com
wrote:


 On Aug 10, 2014, at 11:19 PM, Joel Madero jmadero@gmail.com wrote:

  FWIW, the typical heavy reader will take 210 years to read a million
  pages:
  *  Heavy Reader being defined as reading 17 books per year.
  (
 http://libraries.pewinternet.org/2012/04/04/part-2-the-general-reading-habits-of-americans/
 )
  *  A book is defined as 280 pages (64,000 words) long.
  (http://www.huffingtonpost.com/2012/03/09/book-length_n_1334636.html)

 Oh Gosh, what do they call folks like me? GG

 I average 64+ books a year, 1 a week plus one a month. Down a bit this
 year due to textbooks but still… G


 Eugenie (Oogie) McGuire
 Desert Weyr, LLC - Black Welsh Mountain Sheep http://www.desertweyr.com/
 LambTracker - Open Source SW for Shepherds http://www.lambtracker.com
 Paonia, CO USA


 --
 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] Currently Using Spreadsheet for Personal Project - Thinking About Database

[Mark Phillips]

Calibre is also a great idea/solution for this project, unless one of the
goals of the project is to learn about databases and how to use a database
to solve a real world problem. I added the second clause, because just
learning about databases an admirable goal, but imo, one also should learn
how to build the bits that allow an end user to create/read/update/delete
data in the database. Django is one vehicle for doing this. Paul, I have to
disagree with your analysis of django...I have worked with many
non-programmers on building useful projects with that framework. There is a
learning curve, but it is not insurrmountable by a non-programmer. ymmv.

Mark


On Mon, Aug 11, 2014 at 3:26 PM, Paul paulste...@afrihost.co.za wrote:

 Hi Joel,

 Some comments on your diagram, in the order I thought of them, not of
 importance:

 1) I tend to use integers for primary keys. Smallints only go into the
 thousands, and most of the stuff I have worked on has needed to be able
 to scale well beyond that. Even things that seem small to start with
 have a habit of growing unexpectedly, and you don't want to have to
 change your database design down the road for something small like
 that.

 Planning ahead really is the name of the game with databases, as
 half the reason we use them to begin with is to handle things that
 have grown beyond our simple spreadsheets, or that are expected to
 become unwieldy in the future. The whole point of a good design is
 that it should handle this sort of thing. And the extra storage space
 really shouldn't be an issue. For example, a quick estimate
 suggests that using integer instead of smallint for keys in the diagram
 you gave will only use an extra 1 mb of storage space if you go all the
 way up to the limit of the smallint range, and beyond that it is
 academic as you would be *required* to use int instead of smallint.

 But for a home project you're unlikely to exceed that number, so this
 is fine. It's just worth being aware of this when designing it, so that
 you know the choices you have made, and why you have made them.

 I would make them unsigned smallints, though. Not really a good idea to
 use negative numbers for keys, and so making them signed just wastes
 half their range.

 2) I wouldn't put a Read flag in the Book table. You have a Status
 table with a ReadStatus, so this would be duplication of data.

 3) Same with the SeriesComplete flag in the Series table. You can get
 that information by doing a query that would check if all the books in
 the series are in the read status.

 It's usually much better practice to generate this sort of information
 as you need it from the relevant pieces of information in the database
 (assuming you have all the required pieces in the database), than to
 store this information a second time, which is just duplication. Even
 if the space wasted isn't important, it just leads to the possibility
 of the data being inconsistant.

 The only time one stores such things is when the actual calculation to
 work this out from the pieces of data takes so long that it is actually
 necessary to store calculated results to save time in the application.

 4) Same with AuthorID in the Series table. Each book will have an
 author, so you don't need a series author. That way if the books in the
 series are written by different authors everything still works. This
 way, who would the series author be, and how would that be any
 different from the authors of the individual books?

 Note that you can still show this information in the frontend when
 viewing the series. You can make a query to check if the authors of all
 the books in the series are the same, and if so show that author, but
 if they are different just show various or something.

 Also, when entering all the books in a series, you can still have the
 frontend ask you for the series information first, including author,
 and if you fill it in then it will prepopulate the author field when
 adding each book.

 Of course, maybe you actually do have a use for a series author as
 separate to the authors of the individual books, so maybe this does
 make sense to you, it just doesn't seem right to me.

 5) Some people want author names to be a single field, which is simpler
 for some things, and avoids hassles with authors with multiple names,
 and other people want them to be a name and surname field, which does
 mean you can do things like order by surname or order by first name. And
 avoids the problem of you sometimes entering the name surname first and
 sometimes first name first.

 With the name split into parts it is easier to check if the author
 exists by both name and surname when entering new authors, so even if
 you mistype one of them the author will still be found if they are
 already in the database, but this can still be done if the name is all
 in one field, it is just harder. You can also still sort the author
 list by surname and by first name, it is just harder if both are 

Re: [libreoffice-users] Samsung Galaxy Tablet 2

[Mark Phillips]

Try AirdroidGreat for sharing files etc from Android to pc.

Mark
On Apr 11, 2014 6:31 PM, James Knott james.kn...@rogers.com wrote:

 charles meyer wrote:
  I only have a standard sd card - tablet requires  a micro sd card and
  the process look complicated on this tablet.

 There are adapters that allow you to use a micro SD card in a standard
 slot.  You just remove the micro SD from the tablet, slide it into the
 adapter and then plug the SD adapter into the reader.


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

[Mark Phillips]

Let's compromise, and start all posts in the middle of the post.

We will spend so much time trying to follow the thread, that no one will
have time to complain about where the post is written.

Mark
On Feb 6, 2014 11:32 AM, Tom Davies tomc...@gmail.com wrote:

 Hi :)
 Rule # 1 is there are no rules
 Rule # 2 see rule 1
 Regards from
 Tom :)



 On 6 February 2014 11:21, Peter West li...@pbw.id.au wrote:
  What do you do with these guys?  They can't help themselves. Libre? Ha.
 
 
  On 6/02/2014 9:06 pm, e-letter wrote:
 
  On 06/02/2014, Peter West li...@pbw.id.au wrote:
 
 
  When I see someone hinting, suggesting, urging or just plain bullying a
  top-poster to reform his or her bad habits, I'll buy in. And of course,
  you can do the same thing if the shoe is on the other foot.
 
 
  At least we have an admission: it's a poor habit.
 
  Can we just let posters do their own thing?
 
 
  Let's drive however we like; rules are un-necessary! ;)
 
 
  --
  Peter West
  For what does it profit a man if he gains the whole world and loses or
  forfeits himself?
 
  --
  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 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] We want to create a questionnaire...

[Mark Phillips]

I suggest you check out Survey Monkey http://www.surveymonkey.com. You
create the survey, they host and collect the data for you. it is free for
simple surveys.

Mark

On Wed, Jun 20, 2012 at 1:46 AM, Mirosław Zalewski
mini...@poczta.onet.plwrote:

 On 20/06/2012 at 03:54, jennys8.ama...@dfgh.net wrote:

  However, the  questionnaire is rather long; it has about 70-plus
 questions.
  A text document may be better to use because the person can save their
  progress and easily resume  anytime.

 There is online survey tool called LimeSurvey. It is open sourced and
 depends
 on PHP and MySQL (if you have website, then I believe you do meet these
 requirements). It gives users option to save survey and resume for later.
 It is used by quite a few universities out there. I recommend you give it a
 try.

 Their website is at http://www.limesurvey.org/ . You will find
 documentation
 and demo page there as well.
 --
 Best regards
 Mirosław Zalewski

 --
 For unsubscribe instructions e-mail to: users+h...@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


-- 
For unsubscribe instructions e-mail to: users+h...@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] Labels

[Mark Phillips]

Sylvain,

Go to avery.com, look for the software tab, select design and print online.
All the labels are there, you can import from any database,  and you print
on your desktop printer. It just works.

Mark
On Mar 24, 2012 2:20 PM, Sylvain Bromberber sbrom...@mit.edu wrote:

 Could you say a little more. Where do I find such templates?

 Sylvain

 -Original Message- From: Don C. Myers
 Sent: Saturday, March 24, 2012 4:10 PM
 To: users@global.libreoffice.org
 Subject: Re: [libreoffice-users] Labels

 Hi Sylvain,

 None of that is necessary with the table style templates.

 Don

 On 03/24/2012 03:37 PM, Sylvain Bromberber wrote:

 I am using File then New then Labels. I then requested instructions on
 width, columns, rows etc. but the output when I click on new document does
 not fit the instructions.

 Sylvain

 -Original Message- From: Dan Lewis
 Sent: Saturday, March 24, 2012 12:58 PM
 To: users@global.libreoffice.org
 Subject: Re: [libreoffice-users] Labels

 On Sat, 2012-03-24 at 12:42 -0400, Sylvain Bromberber wrote:

 The Labels formatting seems utterly Kaput! No resemblance between what
 the formatting specifications are and what appears. I am on Windows 7
 and and have LO 3.5.0rc3.

 Sylvain


The labels in what? What are you using to format them? What part of
 LO are you using? With more specific information, someone might be able
 to help you.

 --Dan



 --


 **


 --
 For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
 org users%2bh...@global.libreoffice.org
 Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
 unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.**documentfoundation.org/**
 Netiquette http://wiki.documentfoundation.org/Netiquette
 List archive: 
 http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted


 --
 For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
 org users%2bh...@global.libreoffice.org
 Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
 unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.**documentfoundation.org/**
 Netiquette http://wiki.documentfoundation.org/Netiquette
 List archive: 
 http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted



-- 
For unsubscribe instructions e-mail to: users+h...@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] Address Books

[Mark Phillips]

Stephanie,

Take a look at google apps. You get a free account as a non-profit with
your own domain (not gmail.com). It has address book, email lists, document
sharing, members, calendars, etc. All accessible over the internet. You can
publish your organization's web site through here, if you want. Everyone in
your organization would have an email address
your_name@your_organization.org, or whatever your domain name is. If you
don't have a domain, go to godaddy.com and register one for around
$10/year.

See - http://www.google.com/apps/intl/en/nonprofit/index.html  If you are a
U.S. nonprofit organization of over 3,000 users, you are now eligible
for Google
Apps for Business http://www.google.com/apps/intl/en/business/index.html at
a 40% discount ($30/user/year). If your organization is under 3,000 users,
you can apply for the free Google Apps for Education through the Google for
Nonprofits site.

I did this for my non-profit (I have less than 3,000 users), and it has
been very helpful. Note: a user is someone who works in your organization;
not one of your donors.

Mark

On Wed, Mar 14, 2012 at 1:22 PM, Stephanie Dutcher sdutche...@gmail.comwrote:

 I work for a non-profit youth organization, and we are trying to figure out
 a way to organize all of our members' information without a big cost to
 us.  Would I be able to create something like an address book using a
 template in the LibreOffice Database?

 I am envisioning something where we can't see all the information right
 when we open it.  I'd like it to be some kind of format where we have to
 click on a tab or something to view each member's information, and they
 would have an entire page dedicated to them.  Is that possible to do?

 Thank you,
 Stephanie Dutcher

 --
 For unsubscribe instructions e-mail to: users+h...@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



-- 
For unsubscribe instructions e-mail to: users+h...@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] Calc DMIN Question

[Mark Phillips]

I have a table of running times in one sheet called 'times'. The table has
row headings name, first, second, home for the player's name, the time
running to first, the time running to second, and the time running home.
For example:


*Player* *Date* *First* *Second* *Home*
Player 1 08/14/11 3.54 7.63 15.54
Player 2 08/14/11 3.50 7.57 15.06
Player 3 08/14/11 4.10 8.07 16.40

In another sheet I have a table where I want to calculate some values (Min,
Max, Avg) from the raw data in 'times', so I need to use DMIN and DMAX,
DSUM, and DCOUNT. The table for the fastest time looks like:

*Fastest Times*  *Player* *First* *Second* *Home*  Player 1 3.25 6.88
13.73  Player
2 3.28 6.78 13.46  Player 3 3.28 6.84 13.25

To calculate the min time for a player, I set up an auxiliary table as in
the help examples, with table headings and field number from the 'times'
table for the DMIN function

C D E F  32 *Fields:* *3* *4* *5*  33



 34 *Player* *First* *Second* *Home*  35 Player 1


 36



 37 *Player* *First* *Second* *Home*  38 Player 2


 39



 40 *Player* *First* *Second* *Home*  41 Player 3



To calculate the fastest time for player 1 I use =DMIN(times, D32,
C34:F34). Using this approach, I need a set of search criteria for every
player. Is there a way to use the player's name in the first column of
the Fastest Times table as part of the search criteria, so I don't need to
make a separate search criteria for every player?

Thanks!

Mark

-- 
For unsubscribe instructions e-mail to: users+h...@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: Calc DMIN Question

[Mark Phillips]

On Wed, Feb 8, 2012 at 7:41 AM, Andreas Säger ville...@t-online.de wrote:

 http://wiki.services.**openoffice.org/wiki/**Documentation/OOo3_User_**
 Guides/Calc_Guide/DataPilothttp://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/DataPilot

 Select your list including column headers.
 DataPilotStart...
 Drag players into [Row Fields]
 Drag times into [Data Fields], double-click, change Sum to Min


Thanks for the recommendation - I have never used pivot tables and after
some experimenting, I got it to work.

I am puzzled by one part. I want to sort the table of min values for first
from lowest to highest, but I cannot find how to so that. In the OO docs,
it says right click in the pivot table and select properties, but I don't
have that option (
http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Results_2).
How do I sort the data in LibreOffice?

Thanks,

Mark

-- 
For unsubscribe instructions e-mail to: users+h...@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: Calc Question Regarding Sheets and Formulas

[Mark Phillips]

Thanks! That did the trick!

Mark

On Mon, Jan 2, 2012 at 3:14 PM, MiguelAngel mari...@miguelangel.mobiwrote:

 El 02/01/12 22:23, Mark Phillips escribió:

 My apologies, gmail decided to send the message before I was
 finished..I will try it again.

 A row has Jan 3, Jan 8, Jan 12, in each of three columns. These
 string are really formatted dates. I have three sheets with names Jan 3,
 Jan 8, Jan 12. I want to write a formula (vlookup) that has a reference
 'Jan 3'.a1:g14, but I want the Jan 3 sheet name to be taken from the
 cell
 that has Jan 3 in it. I can then copy the formula across the spreadsheet
 in
 the row under the dates and refer to each succeeding sheet.

 I hope this makes sense!

 Thanks,

 Mark


 On Mon, Jan 2, 2012 at 2:18 PM, Mark Phillipsmark@**
 phillipsmarketing.biz m...@phillipsmarketing.bizwrote:

  Is there a way to have a text string in a cell and use that text string
 in
 a formula for the sheet name?e


 For example, I have this

 row 1:
 row 2





 One method is use INDIRECT(TEXT(ceelwithdate;**MMM D).A1:g14) to
 compose the address.

 Miguel Ángel.

 --
 For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
 org users%2bh...@global.libreoffice.org
 Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
 unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.**documentfoundation.org/**
 Netiquette http://wiki.documentfoundation.org/Netiquette
 List archive: 
 http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted



-- 
For unsubscribe instructions e-mail to: users+h...@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] Calc Question Regarding Sheets and Formulas

[Mark Phillips]

Is there a way to have a text string in a cell and use that text string in
a formula for the sheet name?

For example, I have this

row 1:
row 2

-- 
For unsubscribe instructions e-mail to: users+h...@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: Calc Question Regarding Sheets and Formulas

[Mark Phillips]

My apologies, gmail decided to send the message before I was
finished..I will try it again.

A row has Jan 3, Jan 8, Jan 12, in each of three columns. These
string are really formatted dates. I have three sheets with names Jan 3,
Jan 8, Jan 12. I want to write a formula (vlookup) that has a reference
'Jan 3'.a1:g14, but I want the Jan 3 sheet name to be taken from the cell
that has Jan 3 in it. I can then copy the formula across the spreadsheet in
the row under the dates and refer to each succeeding sheet.

I hope this makes sense!

Thanks,

Mark


On Mon, Jan 2, 2012 at 2:18 PM, Mark Phillips m...@phillipsmarketing.bizwrote:

 Is there a way to have a text string in a cell and use that text string in
 a formula for the sheet name?

 For example, I have this

 row 1:
 row 2




-- 
For unsubscribe instructions e-mail to: users+h...@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