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


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

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.