Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


I worked for the same corporation for 34 years - about the 2nd half of that in Training & 
Development. Our corporate "standard" was MS Office Pro, which if we used it at work, we had a free 
copy at home. Up until about the last year or so of that career I had used everything, except 
Access. I had just started trying to learn it when I took an excellent early retirement package. 
And, it has been the same thing with OO & now LO - I still haven't gotten into Base. But from what 
I knew about Access, you are probably right that putting it into Base is an excellent option at 
this point. So . . . maybe I'll jump in see what I can do with it.
Roxy


Hi :)
These mails go out to a lot of people and are stored in archives for years but
you are all good so far.  With 500 people i would move it to a proper database,
Base, rather than keep it on spreadsheets.


The spreadsheet sheet that you have already can be the main table.  Base can
read it without doing much to it.  Then instead of using a 2nd sheet use a
"Query".  The formulas are almost exactly the same and it ends up looking like a
table anyway.  When you are more comfortable with Base then you can do fancy
forms and mail-merges, labels and stuff to make a prettier tables, or for
letters, "id badges" and stuff.


Regards from
Tom :)




----- Original Message ----
From: Roxy Robinson <rocmar62@ranchwireless.com>
To: users@global.libreoffice.org
Sent: Sat, 11 June, 2011 18:59:53
Subject: Re: [libreoffice-users] Merge cell problem LO3.3.2.2

Tom,
Thanks for your suggestions - I guess I will have to try that since I'm  not
getting what I want with what I'm doing.
This is "off" the subject issue,  but I come from a very small town. My high
school class - 1961 -  was the  first to got over 50. We had 60 in the class, 55
who "walked" on graduation  night. The other 5 finished in summer school. The
classes continued to grow  after that, though I don't think they ever went over
100; and are probably  running around 70-75 now, if not less.
I just finished organizing my class's  50th reunion and am now putting together
a reunion for the classes of 1955-1964.  The total number of students during
that period is, according to my spreadsheet,  500. I dare say, I knew, and
remember about 490 of those, along with quite a few  others from the classes
before and after. We were all like one big family - you  usually knew whole
families because you knew someone in your class, or within 2  or 3 years of your
class. Your classmates were, essentially, your group of  friends.
Anyway, every class in this group has, in some format, a database of  their
classmates and their information. Each class has a few that have gone  "missing
in action", but we are all working together to find everyone. This will  be the
4th, I think, combined reunion like this over the past 50 years, and this
combined database is something that got started after the first one. But, it has
not been updated since the last reunion in 1997. Every classmate - there are a
few exceptions - has given there info to freely share with everyone. And
everyone at this reunion will receive a copy of this spreadsheet I'm working
on.
Roxy

Hi :)

I did something similar once.  It's easier  to keep the data intact, in the 3
separate columns for data entry and for  sorting the lists into alphabetical
order and stuff but then use a 2nd  worksheet (2nd tab at the bottom) to use
formulas to add the 3 names  together. eg
A2 = Sheet1.A2 & " " & Sheet1.B2 & " " & Sheet1.C2
You might have renamed the worksheet tabs so just swap the new name  for
"Sheet1"
but still make sure there is a dot . after it and before the  cell address.

There are issues with "Data Protection" and respecting  people's right to
privacy
but if they have given you their addresses and know  that it's for sharing
with
the whole class then that sort-of implies that  they have given you
permission.
I'm not sure wheter it's legally enough but  it probably gives you a good
position.
Good luck and regards from
Tom  :)




----- Original Message ----
From: Roxy Robinson <rocmar62@ranchwireless.com>
To: users@global.libreoffice.org
Sent: Sat, 11 June, 2011 15:51:55
Subject: [libreoffice-users] Merge  cell problem LO3.3.2.2

I have a 15 page spreadsheet of classmate  addresses, phone numbers, email,
etc.
I "manipulate" this information in  several different ways to give my
classmates
different kinds of  "directories". Anyway, their names are in the first 3
columns. This  particular spreadsheet is going to include ALL the information
on
each  person, will be printed on legal sized paper in landscape format, so I
need
a little more room to contain everything on the width of the  page.
So  (SEVERAL TIMES) I have merged the cells in the first 3  columns. This
contains  the parts of their names, and allows me to  conserve enough room to
get
everything on the width of the page. But  every time I close LO, and then
come
back to work on this spreadsheet,  the cells are no longer "merged". They
will
not stay merged. I haven't  gotten all the way through the spreadsheet - at
one
time - to merge the  cells. Would the "un-merged" cells that are left in the
3
columns keep  the ones above them from staying merged, or am I doing
something
wrong? I  just don't understand - time after time - I merge them, come back
and
they are no long merged??????????
Roxy

--
Unsubscribe  instructions: E-mail to users+help@global.libreoffice.org
In  case of problems unsubscribing, write to
postmaster@documentfoundation.org
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



--
Unsubscribe instructions: E-mail  to users+help@global.libreoffice.org
In  case of problems unsubscribing, write to postmaster@documentfoundation.org
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

--
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In  case of problems unsubscribing, write to postmaster@documentfoundation.org
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


--
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
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

-- 
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.