[libreoffice-users] I have a question on Libre - office Calc !

2012-07-26 Thread Lynne Stevens



omega
The
Omega sector
America's Last
Line of
Defense

*How do I use data base RA1 to check RE1 for duplicates ?
*

*


*

On 07/25/2012 06:54 PM, Dan wrote:
 Could you create and send me a presentation to my email address? 
3-5 slides may be sufficient. I need to see what you are doing and 
perhaps how you are doing it.


--Dan

anne-ology wrote:

That's great ... but it doesn't work that way for me.

Forinstance, this last presentation I chose the blue border 
... and

I always choose the blank slide [although this refuses to remain the
default], ... then I chose the effects, the timing, ... then there's no
place to choose the font for the text.

Then I added twice the number of slides I figured I'd need 
[added 50

this time] ... then clicked on 'apply to all'.

Then I added text to the first slide - the size of the font here
would be different being the header, [I chose papyrus with red] ...
then I went on to the next slide ... and added the text 
... it

was Ariel with black,
so I 'selected all'  re-chose the font  color ... ditto 
for

each subsequent slide; each time, I can return to hit the 'apply to all'
... but the text  color do not remain.

These details are added for you, Dan, although it 
works/doesn't work
the same no matter what other styles I've chosen, either initially or 
as I

add the new slides.

Andrew, I think you're the only one who understands to what I'm
referring; thanks.



On Wed, Jul 25, 2012 at 3:00 PM, Dan elderdanle...@gmail.com wrote:

  Could we be more detailed in this thread, please? I don't know 
what
mean when you ask So you're able to change the text on all the 
slides?
What type of change are you talking about? Are you talking about 
changing

the font of the text on all the slides?
  You have not even stated what style you have applied to your 
text.
Nor have you stated what styles you are using in your slides. Nor 
have you
described what layout you have selected from the Layout section of 
the Task

Pane. Please give us some details.
  I was using styles in Impress before OOo 2.0. For all layouts 
which
have a title box at the top of the page, LO and AOO apply the 
Title style
listed in the Presentation styles list. Modifying this style 
modifies all
the titles in all the slides at the same time. You have a copy of my 
slide
show. Change one of the styles in the Title style and look at the 
titles in

all the styles. For example, in the Font Effects tab, change the font
color. This will change the font color for every slide title in the
presentation. What I have described is how Impress has worked for 
years.


--Dan


anne-ology wrote:


 So you're able to change the text on all the slides?;
then mine has a bug in it somewhere ... carried over 
from OO I

guess  ;-)

 So, all you computer geniuses, what's the solution? - I'm 
awaiting

your responses now.



On Wed, Jul 25, 2012 at 1:38 PM, Andrew Brager apb3...@bak.rr.com
wrote:

   I don't know anything about the inner workings of LO. I'm actually
just a


beginner with LO and I had never opened Impress until you posted.

The method I described below allows you to change all the slides 
at the
same time, so you only have to make the change once.  Of course if 
you

add
more slides you need to do it again for the new slides. No, it's not
ideal
and yes it would be nice if it worked the way you describe.  Good 
idea!





On 7/25/2012 8:26 AM, anne-ology wrote:

 Exactly my point, BUT it has to be done with each slide  ;-)

 It would be nice, if the font was selectable on that 
initial page

when starting a new file ...
 [would this expand the size of LO even more than it 
is?; if

so,
I guess, it's better this way, just frustrating at times.]

 I've even added more slides than I would need, in order 
to see if

the font  color will hold, but it won't  ;-)




On Tue, Jul 24, 2012 at 10:58 PM, Andrew Brager apb3...@bak.rr.com

wrote:


   I missed the part where you were using Impress, I thought you were
using


Writer. After re-reading your original post and some of the other
responses I think I now understand what you really want.

I also have not been able to figure out a way to do it exactly as 
you
described, the best I could come up with is to go to the 
outline tab,
select all the text, then change the font.  That way, all of your 
slides

will have the same font for that one file.











--
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] I have a question on Libre - office Calc !

2012-07-26 Thread Lynne Stevens



omega
The
Omega sector
America's Last
Line of
Defense

*The second thing you do is to explain your problems with more details. 
What do you mean that you use data base RA1? ( RE0001 is a name of 
the file entire data base 126 columns long ) This is a cell, (cell ? I 
am dealing with the entire Column of cells ) isn't it? You seem to want 
to check RE1 for duplicates, but duplicates of what? ( contents of 
the data base ) Just the cell ( NO its the name of the data base file ) 
RA0001? Or, do you want to check for a range of cells?
 And again, DO NOT reply to me. Send the new email to 
users@global.libreoffice.org. Include the Subject:  I have a question 
on Libre - office Calc ! Then explain what you want in more detailed 
terms in the message.


No it is a ENTIRE Data base . . USING data base A to check data base 
B for duplicates *


*The RA0001 and RE0001 were names of the files given to me by Thomas . . 
I thought is was self explanatory as to what was needed Data base A is 
the main one and Data Base B is a second one and it contains changes in 
status of something. .  Or the same Information in the new file . .

*

*But the entire data base is 126 fields ( columns ) long contains tons 
of crap and information about houses for sale Thomas is a going to be 
realestate person ( or so he says ) and is looking for a short cut to do 
stuff with . . *


*Each data base starts with a field ( column A ) number by the recorders 
office and in another field ( column R ) there is a status with a letter 
there . .
Both data bases are the same except for status Column . . has number, 
names, dates, office, seller, seller company, phone numbers, and on for 
126 Columns
Of which Thomas only wants to use 49 of them for his use I have already 
figured out how to do that part . .

*


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