[libreoffice-users] Spreadsheet Print Behavior

[Dave Liesse]

Hi, all.  I just ran into a problem that has never occurred before, and while I 
had a workaround for my immediate need I'm wondering if I'm just overlooking 
something.

First, the specs: LO v7.3.4.2, Windows 10 fully up to date.

I have some spreadsheets that a client prepared in Google Docs and converted to 
Microsoft Excel before sending to me.  I, of course, opened them in 
LibreOffice.  Because there are a couple of cells out to the right with 
information I don't need at the moment, I set a print range.  Also set the page 
style to print landscape, 1-page width.  When I print, though, only the first 
page prints.  If I also set it to print only 1 page vertically the whole thing 
will print but it's too small to read, even with my 20/10 near vision!

Just wondering if this is working as designed (although I would then wonder 
why), or if I'm simply overlooking something, or if it's a bug.  I've been 
working with this particular series of spreadsheets for some time and never had 
any problems, although this may be the first time any would have been more than 
one page long.  I don't recall this problem with any other documents ever, 
though.

Dave

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] History/Profile Lost after Computer Reboot

[Dave Liesse]

Hi, all.

This isn't the first time this has happened, although it's been a while.  After 
my PC rebooted, when I start LibreOffice it's acting as though it's a brand-new 
installation.  There is no display of historical documents, and I'm pretty sure 
based on experience that if I actually go any farther I'm going to find all my 
customizations are gone, as well.

Unfortunately, this is one area where all the available help doesn't really 
help that much.  Where should I be looking on my hard drive to find any 
relevant files?  I really don't want to have to re-create my autocorrect 
options, in particular, nor my templates.

Some specs:
 • Windows 10, fully up to date
 • LO v7.3
 • Program installed in P:\libreoffice, with the usual amount of things in 
C:\users...
Thanks for any help!

Dave

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] hyphenation

[Dave Liesse]

Chris,

I'm not sure exactly what the problem is.  I hyphenate things all the time with 
no problems.

If Regina's suggestion is what you need, you can also insert the non-breaking 
hyphen with Ctrl-Shift-Hyphen (much faster for me, anyway, then having to move 
my hand to the mouse).

Dave


On Thu, Dec 15, 2022, at 10:20 AM, Chris J. wrote:
> Hi.
> 
> 
> I likely know the answer to this. I'm looking for verification or a 
> better answer.
> 
> 
> The only hyphenation ability in LO Write I'm seeing is for word 
> splitting and end of a line.
> 
> 
> What I'd really like is help with compound adjectives. Does anything 
> like that exist in LO Writer?
> 
> 
> -- 
> 
> Chris Johnson rchristopherjohn...@gmail.com
> Ex SysAdmin, now, writer /Build a man a fire and he'll be warm for a night,
> but set a man on fire and he'll
> be warm for the rest of his life.
> /(Unknown)
> 
> -- 
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org 
> 
> Problems? 
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
> 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Tab Bug?

[Dave Liesse]

Looks like I accidentally sent my response to one respondent instead of to the 
list.  Here's what I said:

--

Using v7.3.4.2, so pretty well up to date.  Language is English (USA) and 
commas/decimals are set correctly.

Tab stops are .5 inches apart, so the numbers definitely overflow (seven digits 
plus commas, 11 point type).  However, in my expectations (a) right tabs should 
work the same as left tabs, regardless of length, and (b) in a word processing 
document I don't expect numbers to be treated any differently from plain text 
-- except in the case of a decimal tab.  I'm using only whole numbers, though.

I need the columns to overlap because of the nature of the report.  I don't 
have space to have three 1.25-inch columns at the right edge of the page and 
the corresponding left tabs on the left side (this is a financial report with 
subaccounts).

Similar problem in the spreadsheet, though it's more expected there.  I need 
the columns to be .5" wide, not wide enough to hold the whole number.  Text 
would overflow into the cell on the right (if it's empty), and I hoped -- but 
didn't really expect -- numbers to do the same to the left.

The problem is that I need numbers to line up properly in right-justified 
columns, without resorting to a fixed-space font (so the leading spaces are the 
same width) and using left tabs.

Dave


On Mon, Aug 8, 2022, at 7:00 PM, Steve Edmonds wrote:
> Does not occur for me in 7.3.4.2
> What text language shows at the bottom of the window frame. (mine is 
> English(UK)
> What decimal separator is shown in Tools>Options>Language settings
> Steve
> 
> On 09/08/2022 12:18, Dave Liesse wrote:
> > Hi, all.  It's been a long time since I've run into a problem of any 
> > significance, so posting here before I look up how to report a bug (partly 
> > to see if this really is one).
> >
> > In a Writer document, I have three Right tab stops set, to show staggered 
> > columns of numbers.  When I type a large number, though, with commas 
> > separating the thousands, the tab stop starts acting as a Decimal stop 
> > instead of Right.  For example, if I type 1,234,567 it acts as though the 
> > tab stop is a Decimal stop and the comma between the 4 and the 5 is a 
> > decimal point.  Might this be a bug?
> >
> > As a secondary note: I don't think this one is a bug, but it's certainly 
> > unexpected behavior.  Because I was in a hurry to get a report out to a 
> > client I tried the same numbers in a spreadsheet, again expecting the 
> > columns would be overlapping.  Numeric values, though, won't overflow the 
> > cell the way text does, even when the cell is specifically right-justified. 
> >  Again, I was in a hurry so I just entered all the numbers as text, but 
> > then had to do my own calculations to show totals (no biggie, since I would 
> > have had to do that anyway in the Writer document, but annoying in a 
> > spreadsheet).
> >
> > The question is really about the first item -- the second one is just a 
> > minor gripe.  Do y'all think this is a bug, or is there some rational 
> > reason the program should behave this way?
> >
> > Dave
> >
> 
> 
> -- 
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org 
> <mailto:users%2bunsubscr...@global.libreoffice.org>
> Problems? 
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
> 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Tab Bug?

[Dave Liesse]

Hi, all.  It's been a long time since I've run into a problem of any 
significance, so posting here before I look up how to report a bug (partly to 
see if this really is one).

In a Writer document, I have three Right tab stops set, to show staggered 
columns of numbers.  When I type a large number, though, with commas separating 
the thousands, the tab stop starts acting as a Decimal stop instead of Right.  
For example, if I type 1,234,567 it acts as though the tab stop is a Decimal 
stop and the comma between the 4 and the 5 is a decimal point.  Might this be a 
bug?

As a secondary note: I don't think this one is a bug, but it's certainly 
unexpected behavior.  Because I was in a hurry to get a report out to a client 
I tried the same numbers in a spreadsheet, again expecting the columns would be 
overlapping.  Numeric values, though, won't overflow the cell the way text 
does, even when the cell is specifically right-justified.  Again, I was in a 
hurry so I just entered all the numbers as text, but then had to do my own 
calculations to show totals (no biggie, since I would have had to do that 
anyway in the Writer document, but annoying in a spreadsheet).

The question is really about the first item -- the second one is just a minor 
gripe.  Do y'all think this is a bug, or is there some rational reason the 
program should behave this way?

Dave

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Fill Series

[Dave Liesse]

I don't have the older version anymore, but it might still be under Edit 
... Fill.  (Took me forever to find the new location in v5.whatever-I-have).


Dave



On 1/12/2017 13:34, toki wrote:


On 01/12/2017 09:09 PM, Eric Beversluis wrote:

Where is "Sheet"? I don't see it on any of the menu drop-downs.

Top menu sequence:
File, Edit, View, Insert, _Sheet_, Data, Tools, Window, Help.

IOW, "Fill Cells" is the drop down menu item to look for.

jonathon





--
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] Version 5.2.1.2 Questions

[Dave Liesse]

I'm noticing some behavior recently that I don't like.  When I installed 
v5.2.1.2, though, I seem to have eliminated all my existing profile 
information so I'm hoping that on the first item, at least, there's just 
a setting that I haven't been able to find.


1.  In Writer, I keep seeing "balloon" spelling suggestions. Can't click 
on them to do anything, so very annoying.  Any way to turn them off?  I 
haven't found anything in the options that does this.


2.  Also in Writer, using an arrow to move up or down is not always 
placing the cursor in the correct place on the second line.  For 
example, I type a line and, at the end, press up-arrow; instead of the 
cursor being at the end of that (shorter) line, it's at a seemingly 
random location within the text.  For another example, if the cursor is 
in the middle a line and I press up-arrow the cursor is then at the end 
of the second (longer) line.  I haven't been able to discern a pattern.  
Is this a known issue?  I'm not familiar enough with the bug reporting 
system to find it.


Since it can make a difference, I'm working in Windows 7 Professional 
64-bit.


Thanks for any insight anyone can provide!

Dave



--
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] Observations on LO v5.2.1.2

[Dave Liesse]

Thanks, Bruce.  I probably looked right over half of these.  As far as 
the find bar issue goes, the problem cleared itself up after 
reinstalling (before, I had the find box and nothing else on that line; 
now it shows up when I press Ctrl-F, like it's supposed to, and the 
other icons are there, as well).


Dave



On 10/14/2016 17:33, Bruce Hohl wrote:

the icons in the menu bars are terrible!  Way too large

Tools > Options;  Left panel: LibreOffice > View; Right panel: Set Icon
Size = Small
If desired, install and select an alternate icon style as well.


as is the bar at the bottom with the "Find" window, which I can't find a

way to get rid of.
View > Tool bars > Find (un-check) (or click the X on the left side of the
Find bar)


I'm not terribly happy with the new opening screen either, with all the

recent documents being displayed
Tools > Options > LO > Advanced :: Expert Configuration | Search for
PickListSize
Set to value desired (including zero).


Keyboard shortcuts are changed

For maximum productivity set your own KB shortcuts under Tools > Customize.


On Fri, Oct 14, 2016 at 6:34 PM, Dave Liesse 
wrote:


Okay, I'll take back part of what I said.  I just reinstalled, and the
destination option does, indeed, appear.  It's just so unobtrusive that I
didn't see it the first time.




On 10/14/2016 13:01, Dave Liesse wrote:


As I might have said when I posted a question about opening a
password-protected Excel file, I updated LO to v5.2.1.2.  Still can't open
that file, but that's not what this post is about.

One reason I delayed updating is what I read with regard to v4 -- the
icons in the menu bars are terrible!  Way too large, as is the bar at the
bottom with the "Find" window, which I can't find a way to get rid of.

I also had some problems with the installation on Windows 7, although
they're different from the thread on that subject.  I chose Custom
installation, as always, but it didn't ask where I wanted to install it.
The installation just took place on drive C, which I reserve for system
files (programs go on P).  I was able to copy the installation to the
correct drive and change the various shortcuts, but for some reason I can't
change the address in the registry.  Fortunately, this doesn't seem to make
a difference.

Of greater concern is that the new installation didn't maintain all my
settings, and every day I'm finding something I need to fix.  The
installation more or less deleted my old one, which I had expected, but all
the paths still point to the ones that were deleted.

I'm not terribly happy with the new opening screen either, with all the
recent documents being displayed (and no way that I've yet found to reduce
the number shown).  Keyboard shortcuts are changed, and while they're now
consistent and make some sense they'll take some getting used to.

I'm sure there are ways to fix some of the things I'm griping about and I
just need to keep looking, but it's sure putting a crimp in my productivity!





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
ubscribe/
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] Observations on LO v5.2.1.2

[Dave Liesse]

Okay, I'll take back part of what I said.  I just reinstalled, and the 
destination option does, indeed, appear.  It's just so unobtrusive that 
I didn't see it the first time.




On 10/14/2016 13:01, Dave Liesse wrote:
As I might have said when I posted a question about opening a 
password-protected Excel file, I updated LO to v5.2.1.2.  Still can't 
open that file, but that's not what this post is about.


One reason I delayed updating is what I read with regard to v4 -- the 
icons in the menu bars are terrible!  Way too large, as is the bar at 
the bottom with the "Find" window, which I can't find a way to get rid 
of.


I also had some problems with the installation on Windows 7, although 
they're different from the thread on that subject.  I chose Custom 
installation, as always, but it didn't ask where I wanted to install 
it.  The installation just took place on drive C, which I reserve for 
system files (programs go on P).  I was able to copy the installation 
to the correct drive and change the various shortcuts, but for some 
reason I can't change the address in the registry.  Fortunately, this 
doesn't seem to make a difference.


Of greater concern is that the new installation didn't maintain all my 
settings, and every day I'm finding something I need to fix.  The 
installation more or less deleted my old one, which I had expected, 
but all the paths still point to the ones that were deleted.


I'm not terribly happy with the new opening screen either, with all 
the recent documents being displayed (and no way that I've yet found 
to reduce the number shown).  Keyboard shortcuts are changed, and 
while they're now consistent and make some sense they'll take some 
getting used to.


I'm sure there are ways to fix some of the things I'm griping about 
and I just need to keep looking, but it's sure putting a crimp in my 
productivity!







--
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] Observations on LO v5.2.1.2

[Dave Liesse]

As I might have said when I posted a question about opening a 
password-protected Excel file, I updated LO to v5.2.1.2.  Still can't 
open that file, but that's not what this post is about.


One reason I delayed updating is what I read with regard to v4 -- the 
icons in the menu bars are terrible!  Way too large, as is the bar at 
the bottom with the "Find" window, which I can't find a way to get rid of.


I also had some problems with the installation on Windows 7, although 
they're different from the thread on that subject.  I chose Custom 
installation, as always, but it didn't ask where I wanted to install 
it.  The installation just took place on drive C, which I reserve for 
system files (programs go on P).  I was able to copy the installation to 
the correct drive and change the various shortcuts, but for some reason 
I can't change the address in the registry.  Fortunately, this doesn't 
seem to make a difference.


Of greater concern is that the new installation didn't maintain all my 
settings, and every day I'm finding something I need to fix.  The 
installation more or less deleted my old one, which I had expected, but 
all the paths still point to the ones that were deleted.


I'm not terribly happy with the new opening screen either, with all the 
recent documents being displayed (and no way that I've yet found to 
reduce the number shown).  Keyboard shortcuts are changed, and while 
they're now consistent and make some sense they'll take some getting 
used to.


I'm sure there are ways to fix some of the things I'm griping about and 
I just need to keep looking, but it's sure putting a crimp in my 
productivity!




--
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] Password-protected Excel file

[Dave Liesse]

Is LO capable of opening an XLSX file that has a password?  I tried it 
with v4.0 and LO thought it was a CSV file.  I just tried with v5.2.1.2 
and LO at least recognizes that there's a password but won't accept it.  
I'm sure this isn't the only client that's going to do this to me, so 
want to check on an LO solution before working it at the client end.


Dave

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

[Dave Liesse]

This was my initial thought, as well.  A problem-solving tool like Lingo 
(which I used in my Operations Research class 10 years ago and still 
find useful) would be perfectly suited to something like this.


Dave Liesse



On 8/22/2016 11:16, Brian Barker wrote:



This problem may be of the sort that would be much easier to solve 
through programming that via a spreadsheet.






--
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] New LibreOffice Book

[Dave Liesse]

This is my busy season at work so I haven't had a lot of time, yet, but 
I downloaded the PDF version and took a quick look at a couple of 
chapters I need the most.  I'm quite impressed.  Good job!


Dave Liesse


--
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] Slow Loading a calc sheet

[Dave Liesse]

I've had slow-loading sheets, but they were always large with a lot of 
calculated fields -- my computer also has 4GB RAM, but I don't remember 
the processor speed (it was 3rd-fastest available when I got the 
machine, but that's about 5½ years ago now).  Do you, perhaps, have a 
number of non-displaying calculated fields?  That's the only thing that 
comes to mind.


Dave Liesse


On 3/15/2016 10:14, John R. Sowden wrote:

xubuntu 14.04 lts, LO v5.0.5.2

When I load a calc file it takes a long time.  The progress bar at the 
bottom immediately goes the the middle, then stops.  I have timed it 
at about 40 seconds until the file is opened.  This seems to be an 
issue only with my "checkbook".   We are on a non-calendar fiscal 
year.  The scrolling through the sheet slows tremendously at the point 
when we switch from december to january, about line 250.  None of the 
other sheets in the file are more than 100 lines long.  This computer 
has 4 GB ram.  Also I do no 'date math' on the date column, but the 
date column (1) is formatted to MM/DD.


thoughts?
John




--
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] Thunderbird potential as the official/default email-client for LO? Re: [board-discuss] BoD decision from 2015-10-05

[Dave Liesse]

I'd be fully supportive of bringing Thunderbird into the LO family. I've 
been a user of both for years and am very concerned about Thunderbird's 
future.  The only Microsoft software I'm willing to actually spend money 
on is Windows, and I wouldn't even do that if there were a Linux version 
of my business software (equivalents aren't acceptable in this case; 
office suite files might be mostly interchangeable, but that's not true 
in other genres and I have to support my clients).


Unfortunately, I'm not in a position to contribute on the technical side 
unless you need a data modeler, logical process modeler, or QA leader.  
My programming skills are way out of date (COBOL and FORTRAN, anyone?), 
but I'm not so long out of the field that my other skills are even 
starting to rust (I do use them informally in other areas).  So far I've 
raised more Thunderbird questions than I'd be able to help with!


Dave Liesse


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

[Dave Liesse]

I agree with the others that you're probably brushing the trackpad 
accidentally.  However, simply moving the cursor doesn't change your 
position in the document; you actually have to click to do that.  If 
you're using the trackpad exclusively, as I do, you should be able to 
turn off just the tapping feature and rely on the buttons to do your 
clicking.


I'm not familiar with your particular machine, but I have a Sony Vaio 
and even putting pressure on the surface *beside* the trackpad can 
sometimes cause the cursor to move (the surface of the trackpad is the 
same as that of the rest of the keyboard; it's just indented for the 
trackpad -- works well most of the time, but I occasionally get the 
jumping cursor, as well, usually just as I'm clicking on where I *think* 
it is).


Incidentally, if you find the cursor is sometimes sluggish when you try 
to move it, it's probably the same root cause -- in my case, a heavy 
palm pad on the keyboard beside the trackpad.


Dave Liesse



On 2/24/2016 10:18, charles meyer wrote:

Hi Folks,

I have a Toshiba Satellite laptop (about 7 years old) running Windows
7. It runs fine and I have no issues with it.

However, when I type in text in a blank document in either Libre
Writer or Word 2003 I’ll complete a sentence or so and then suddenly
the cursor and the last few characters I typed jumps somewhere else in
the plain text document.

I’m not hitting (intentionally) any key to make it do that – it just
jumps around the document at will.

It never does that on the desktop in Libre or Word suggesting it may
be a Toshiba or laptop phenomena.

Has anyone ever encountered this and if so how did you fix it?

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

Re: [libreoffice-users] question about libreoffice 4.3 and automatic spell check

[Dave Liesse]

Pedro,

I'm still using v4.0.0.3.  In this version, at least, I think you can 
get to the automatic spell check options you're looking for by going to 
Tools ... Autocorrect Options ... Options (tab).  In that screen you 
have the opportunity to specifiy what corrections are active during 
typing and during manual correcting.


If that's not what you mean, and you're looking for whether or not 
spellcheck runs automatically all the time, that's handled through an 
item on the standard menu bar.  You'll see two icons with a check mark 
and the letters ABC; one of these has a red squiggly line.  The one 
without the line runs spellcheck (just like pressing F7), the other 
toggles automatic checking on and off.


For a list of shortcut keys go to Help (press F1), search on "keyboard 
shortcuts", then select "Shortcut Keys for LibreOffice Writer".  This 
gives you a list of the standard shortcuts; it won't show any customized 
ones.


There doesn't seem to be any foolproof way of setting a file to 
read-only.  You can set a document to be opened read-only by going to 
File ... Properties ... Security (tab) and checking the "Open file 
read-only" box.  Other users can only open it as read-only, but they can 
make a copy and then save it with the original file name. To be fair, I 
think this workaround exists with almost any program, not just LO.


Dave



On 2/16/2016 23:35, nasrin khaksar wrote:

hi every one.
i have three questions and hope that you help me in these cases like
previous times.
1/ in libreoffice 4.4 and above, an option added for activate or
deactivate automatic spell check in the tools menu that i can select
whether i want automatic spell check to be checked or not.
whats about version 4.3? how can deactivate automatic spell check in
versions before 4.4?
2/ how can i see full list of libreoffice writer shortcuts?
and 3/ is it possible to save a document in read only mode?
for example: i write and save my document in read only mode to becomes
unchangable like pdf documents?
thanks for your help and god bless you all.





--
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: Avery 8167 label printing

[Dave Liesse]

I've never had any luck with any of the Avery templates I've tried 
(although my problem has been mostly with left-to-right adjustments 
rather than top-to-bottom).  I finally just got in the habit of setting 
my paragraph position as 1/8" into the label; fooling with the template 
specs didn't do the job.




On 2/9/2016 10:39, Ken Springer wrote:

On 2/6/16 1:16 PM, Ken Springer wrote:

Printing is off the mark vertically by about an eighth of an inch
vertically, lower on the page than correct.

Labels print fine on Avery 8160.

No adjustments of any kind to the template was made.

LO 4.4.7.2


FWFW, it doesn't work in the latest version of Open Office, either.  :-(





--
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] Calc - Sorting - Alphabetically

[Dave Liesse]

If you choose an ascending sort then it will sort A to Z; descending 
will sort Z to A.  I believe that as long as there is one non-numeric 
cell then it will sort based on characters rather than values, but 
someone else should confirm that.


Dave Liesse



On 2/8/2016 18:41, charles meyer wrote:

Hi Folks,

I have all my data in Column A.

I wish to sort alphabetically.

I highlight all the data in every cell in column A, choose Data>Sort
but in the criteria I don't see anything for alphabetically,

How does one sort alphabetically?

Thank you!




--
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] Save As bug

[Dave Liesse]

Doesn't LO automatically add .odt to the filename (unless overridden by 
the user)?  In Windows, at least, that's accomplished by selecting the 
file type in the Save As dialogue.


Dave Liesse


On 12/17/2015 10:57, Brian Barker wrote:

At 11:20 17/12/2015 -0700, Steve Edmonds wrote:
I have noticed a bug in Save As from writer, long standing. I know 
the reason for what is happening, but not sure if fixed in the 5 
series (I am still on 4). If you open the below file and click Save 
As I have the file name curtailed to TN16 in the dialogue, LO does 
not pass the whole file name to the Save As dialogue.

TN16.779SoftwareConfigurationofAzureSeriesInstruments
<http://nabble.documentfoundation.org/file/n4169631/TN16.779SoftwareConfigurationofAzureSeriesInstruments> 



If this bug could be verified in the 5 series I will file a bug report.


Is this exactly a bug? Do you, in fact, know the reason for it 
happening? Your original file name is missing its proper extension of 
".odt". The part of the existing name after the dot is - surely quite 
properly? - interpreted as its extension. Then when you do a Save 
As..., the program offers to correct the inappropriate extension to 
the appropriate one. How is that a bug?


If you correct the original mistake by adding the correct extension to 
the file name before you open it, the Save As... will surely work with 
no problem. Doesn't LibreOffice use extensions (along with actual file 
contents) to determine in what format to interpret any document file?


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] Re: Supress address2 field if blank

[Dave Liesse]

Taking just a very quick look at this, I agree that there is no 
*obvious* way in a label to suppress blank lines.  If you use the Mail 
Merge Wizard, though, the option is there.


Not saying this is a solution; I was just looking because I knew I'd 
seen it in there somewhere.  Perhaps someone with the time to do so can 
do a test with the wizard, look at the result, and see where it shows up 
in the finished document.


Dave Liesse


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

[Dave Liesse]

BUT ... don't forget that English English and American English use 
quotation marks differently!  In American English, single marks are used 
primarily to set off a second item within a pair of double marks.


Dave



On 12/4/2015 10:09, toki wrote:

On 04/12/2015 11:45, Kolbjørn Stuestøl wrote:


In Norwegian the double quotes are telling the reader that this is not a real 
turtle but something turtle-like.


The same grammatical construction also applies to English. (IOW, your
original double quotes were correct.)

jonathon





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

[Dave Liesse]

That's a reference to an old saying: "Perfect is good's worst enemy" (or 
"Perfect is the worst enemy of good").  Sort of the same thing as 
paralysis by analysis -- if you spend too much time striving for 
perfect, you don't realize when it's good enough.


Dave


On 12/3/2015 16:58, anne-ology wrote:


I have found some wordings which I don't understand, so have placed
?s by them ...
   as in this e-message "the perfect is the goods worst enemy I am
told";
  haven't a clue as to what you might be referring  ;-)





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

[Dave Liesse]

This looks like fun, but I can't commit to getting anything at all done 
in a short time!  I'll be happy to help as I can, though.


Dave Liesse



On 12/3/2015 12:57, Kolbjørn Stuestøl wrote:
A few years ago I wrote a kind of tutorial or small manual for 
LibreLogo. (Did you know it exists in LibreOffice?)
At last I got some time to translate it to English. My problem is that 
English is my second or third language, so I am not comfortable 
writing it. Therefore I would be very happy if someone would give me 
some corrections about the language in this tutorial. And of course 
other errors that will be found.


(Yes, I know I should have polished the site a bit more, but the 
perfect is the goods worst enemy I am told).


The link is: http://www.stuestoel.no/office/logo/en/logo-startside.php

Of course this is free stuff open to all users of LibreOffice.

I know that only a few people use Logo as a programming language, but 
it is funny. So perhaps give it a try.


Kolbjørn




--
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] pptx files can't be opened when created with Impress 5.0.x

[Dave Liesse]

Something else to be aware of is that a presentation with sound is not 
compatible; the two programs handle sound completely differently.  
PowerPoint stores sound within the application, while Impress only 
stores links to the sound files (voice of experience here!).


Dave Liesse


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

[Dave Liesse]

I'm not quite sure what you're asking, but...

If you're trying to sort entire rows by the value in a single column, 
you need to select the rows.  When you go to the sort menu, simply 
select the column you want as your sort key.  You might have to go to 
the Options tab to indicate whether or not your data selection includes 
a header row; like in Excel, how this comes up seems to be completely 
random (in other words, I've never discerned a pattern to how it works).


If I'm misunderstanding your question, please try again!

Dave




On 8/18/2015 07:49, Lyle wrote:

I am moving from Excel to Calc..and trying to sort a column...

In Excel, I can select a column, then, prior to the sort can tell 
excel to include the entire row data to 'move' along with the data in 
the column.


How do I do that in Libre Office?

TIA

lyle






--
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] Shortcut for "Recent documents"

[Dave Liesse]

It's been "U" for as long as I've been using LO (and OO before that).

Dave



On 8/11/2015 10:25, Mark Stanton wrote:

Does anyone here know why, in version 4.4(.5.2) is the shortcut for
"Recent Documents" on the "File" menu "U"? It always (?) Used to be
"R". There doesn't appear to be any clash which would stop it being
"R" now, not in Writer at least.

Anyone?

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] [OT] Operating Environment Survey

[Dave Liesse]

While we're waiting for a formal survey to be developed:

My primary machine is a Sony Vaio laptop with Windows 7, used for both 
home and work.  While I have a UNIX background and would be willing to 
experiment with LINUX, there is software I need for work that comes in 
Windows or Windows.  (Windows is, however, the only thing for which 
Microsoft gets a dime of my money.)


I have four older computers, as well: two laptops and two desktops. The 
desktop that is in anything resembling use runs Windows 2000, the newer 
laptop has Windows XP, and the other two have Windows NT. None of these 
is connected to the Internet and I keep them around (a) out of habit, 
(b) because the upgrades to some of my favorite games are actually 
retrogrades, and (c)
I some have old software that I like but can't justify paying to upgrade 
-- it's just for my own use, so compatibility isn't an issue.


I'll never buy Apple equipment simply because I'm allergic to 
proprietary hardware!  Software is bad enough.


Just so you know where I'm coming from: I had about 35 years in IT 
before getting laid off from my position as Quality Manager for a 
software company (and my understanding is that they've ever since 
regretted dismantling the Quality Department).  I now have my own 
accounting practice, so I'm much more a user than a techie though I can 
still do logical design with the best of them (I also spent time as a 
data modeler, as well as the usual programming gigs).  As a user, I'm 
less likely to be willing to put the time into learning the 
technicalities of newer tech stuff.


Dave Liesse



On 7/18/2015 18:25, James E Lang wrote:

The big discussion of Linux over the past 24+ hours has me wondering: What 
operating environment(s) do other members of this list use at home and at work? 
What factors influence the choice?

To set the tone, here are my answers:

• I am retired so "at work" is not applicable
• At home we have a desktop dual boot Windows XP (and Ubuntu Linux) computer, a 
laptop dual boot Kubuntu Linux (and pre-installed Windows Vista) computer and 
several other laptop, desktop, and dedicated server (Ubuntu Linux based) 
computers. I also have Android Lollipop, Android Kit Kat, and Android Jelly 
Bean tablets and phones. I have nothing from Apple.
• Windows XP is used primarily for single player gaming and e-Sword Bible 
software though it also is used to run LO, FireFox and Pegasus Mail 
(proprietary though free of cost).
• Kubuntu Linux is my general purpose "go to" environment. My first Linux 
system used what I believe was the penultimate marketed version from SuSE before the 
first release of Open SuSE. I liked the flexibility that was inherent in the KDE desktop 
environment and found the UI to be quite similar to that of Windows at the time. I have 
briefly tried Gnome and Unity desktop environments but KDE is my personal first choice.
• If I had a tablet computer that I thought could support my Linux usage it, 
too, would run Kubuntu Linux, LO, etc.
• Apple equipment is too expensive for me and from what I've heard about the 
company's software policies, they are too restrictive to suit me.
• Dual boot capabilities are seldom used to deviate from the above information.
• The BSODs on Windows influenced my initial adoption of Linux.




--
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] LibreOffice's documentation (pdf and online)

[Dave Liesse]

Some added thoughts with a fresh brain this morning:

1.  I like the embedded help because it's quicker to use.  Also, in good 
traditional fashion, I pretty much expect it to be updated more 
frequently than a printed manual, even if that manual is in electronic 
format.


2.  Once upon a time (remember I've been around since the days of 
Hollerith cards and paper tapes), there were two types of manuals: User 
Manuals and Reference Manuals.  The user manuals were more conceptual 
and tutorial, helping people learn how to use a program (yes, I still 
call them programs rather than apps -- apps are for mobile devices, 
which I don't use for computing; I still talk about directories instead 
of folders, too).  The reference manuals were just that -- details about 
the various commands, functions, subroutines, etc.  The reference manual 
aspect is what I really look for in the embedded help.  The user manual 
is what I tend to go to the PDF version to find.


Dave


--
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] LibreOffice's documentation (pdf and online)

[Dave Liesse]

Here are my responses.

1.  I seldom look at the PDF documentation.  Mostly I find what I need 
through the F1 key, and also because I forget it's there until I go 
searching for an answer online.  I'll also go to the PDF when I'm trying 
to understand an entire concept (like styles, which still are winning 
the battle).


2.  I use the F1 key all the time.  I came to LO after using Windows 
since it was created and F1 is the first thing I do to get help on any 
program.  It's nice when it's context-sensitive, but just going to the 
built-in help is sufficient.


3.  Most of the time I'm using any documentation it's via the F1 key (or 
the menu equivalent, if I already have my fingers on the trackpad) and 
I'm usually coming from a spreadsheet, looking for the parameters for a 
specific function.  This is one of the few areas where in my experience 
MS Office is actually superior to LO; in MSO the functions are grouped 
better for ease in finding what you're looking for (arithmetic 
functions, logical functions, etc.).  In the LO help you often have to 
know what function you want to use, even if what you're looking for is 
what function fits your current need -- like having to know how to spell 
a word before you can look up its spelling in the dictionary.


4a.  Some have suggested videos.  Personally, while I have no trouble 
with either my vision or my hearing, I hate the trend toward doing 
everything on videos.  They take longer than reading, they annoy other 
people in the office, and usually they're not the best choice for what I 
need at the time.  They might be useful for longer topics (like those 
blasted styles), but not for syntax questions, for example.


4b.  My preference is for a manual's information to be available 
locally.  I'm not always in a location with Internet access, and 
sometimes I turn off my modem because I don't want any new mail 
downloaded (I have 18 mailboxes to manage, and if I close the email 
program before I check them all then the new messages are no longer 
flagged as new; unread isn't a sufficient status).


Thanks for asking for our input.  I've rewritten seven sets of bylaws 
for various organizations, so I don't envy you and the rest of the 
volunteers on this project!


Dave Liesse




On 6/24/2015 09:58, dallen wrote:

Hi All,

I'm an experienced Technical Writer beginning work on LibreOffice's
documentation, but I have some questions for LibreOffice users:

1) Does anyone EVER look at the pdf documentation? If not, why not?
2) Does anyone EVER click the F1 key for help? If not, why not?
3) Do you see any overall issues concerning the documentation?
4) If the presentation of the documentation were to change to make it
more useful, what would it look like?

Thanks for anyone's help.

Davidaa



--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-s-documentation-pdf-and-online-tp4152516.html
Sent from the Users mailing list archive at Nabble.com.




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

[Dave Liesse]

Speaking as an accountant, I'm not sure why you would want the balance 
to show 0.  Nevertheless, what you need is:


=IF(E5=0,0,F4+E5)

And, of course, you want to copy that to each cell in the F column.

Dave Liesse
Skingco Services, LLC




On 4/13/2015 16:16, Barry Premeaux 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

Re: [libreoffice-users] LibreOffice Sort Bug ?

[Dave Liesse]

If "Sort By" shows the data in the first cell then it is being treated 
as a column header.  Go to the Options tab and correct the item 
regarding the sort range including the header.


Dave




On 3/25/2015 16:06, Wade Smart wrote:

Hmm I just tried to sort going through the
sort menu and I still cant get it to sort
properly.

It does numbers just fine though.
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005


On Wed, Mar 25, 2015 at 6:04 PM, Wade Smart  wrote:

**cough cough** .. feature understood.
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005


On Wed, Mar 25, 2015 at 6:02 PM, Michael Tiernan
 wrote:

On 3/25/15 6:53 PM, Wade Smart wrote:

I have 4.2.7.2 on Ubuntu 14.04 and you are correct, sort is not working.

When I reported it, I provided a great deal of information about it and
was told "Not a bug" and "works for me" by those who have the power to
close bugs.

My argument was/is that if you use the sort arrows (as you have done
here) then you're asking/telling LO to sort the selected rows with no
options.

Instead it was deemed correct that instead, LO assumes the first cell
found is used as a label regardless of any other settings.

This "feature" (*cough*) cost me a number of hours of work to get around
and avoid.

The argument is that since you can use the "Sort" menu option and change
this behavior *for each sort occurrence* then there's a work around for
the "feature" and we should be happy with that.

--
   << MCT >> Michael C Tiernan. http://www.linkedin.com/in/mtiernan
   Non Impediti Ratione Cogatationis
   Women and cats will do as they please, and men and dogs
should relax and get used to the idea. -Robert A. Heinlein


--
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: Default printer issues in Writer

[Dave Liesse]

Is the user printing via Ctrl-P (or the menu equivalent) or by clicking 
on the shortcut icon?  I've never seen the shortcut use anything other 
than the Windows default printer, but the long way does revert to the 
last printer chosen.


Dave



On 6/10/2014 14:59, musik7 wrote:

Sorry about that, this system is Windows 7 Ultimate, 32 bit.

Mark- I sent the end user an email to have them test printing then saving to
see if that keeps the settings, so I will let you know if that helps or not.
I know that we have tried printing and closing/re-opening the files, and it
seemed to keep the printer settings for a few minutes then revert.  I don't
believe we ever hit save before closing though, so hopefully that will help.

Thanks.



--
View this message in context: 
http://nabble.documentfoundation.org/Default-printer-issues-in-Writer-tp4112021p4112030.html
Sent from the Users mailing list archive at Nabble.com.




--
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] paste into the edit box

[Dave Liesse]

I, on the other hand, avoid that "mouse thing" like the plague.  I can 
still type a command line command faster than going through three layers 
of a menu.


Dave


On 4/21/2014 16:50, John R. Sowden wrote:

On 04/21/2014 02:42 PM, Dave Liesse wrote:

Don't think I've ever run across the right-click behavior you mention,
but I just left-click in the box and then Ctrl-V (I never use a menu if
there's a shortcut key available -- too slow!).

Dave




On 4/21/2014 13:09, John R. Sowden wrote:

why can't I right click on paste to paste text into the edit box
instead of having to go to the edit-->paste drop down menu?

no one has ever asked, or is there a technical reason?

John




this reminds me of when my wife, a legal secty as a teenager, was told 
to use the function keys under Word Perfect.  Her response was 'you 
mean I have to leave the home row?'


When I am a cuttin' and a pastin', I'm usin' that mouse thing. Ctrl-V 
(from Wordstar/DOS, which is what staff uses in our office), means I 
have to drop that mouse thing and use the keyboard.  I'm just looking 
for a flow of motion, and I found it unusual that the edit box would 
be excluded from the use of the cut and paste mouse features.


John







--
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] paste into the edit box

[Dave Liesse]

Don't think I've ever run across the right-click behavior you mention, 
but I just left-click in the box and then Ctrl-V (I never use a menu if 
there's a shortcut key available -- too slow!).


Dave




On 4/21/2014 13:09, John R. Sowden wrote:
why can't I right click on paste to paste text into the edit box 
instead of having to go to the edit-->paste drop down menu?


no one has ever asked, or is there a technical reason?

John




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

[Dave Liesse]

This might be something to add to the list of differences between MSO 
and LO.  This one drives me nuts frequently!  As much as we all think LO 
is obviously the superior product, we do need to remember that most 
people will be coming to it from MSO and will want to know what to be 
watching out for.


Dave



On 4/2/2014 04:19, Cor Nouws wrote:

Hi Tinkerer,

Tinkerer wrote (02-04-14 11:54)

In Libre 4.2.2.1 Mac version.
I have a five sheet Calc document and when I set the page margins to print
one sheet, the margins for the other sheets are also altered.
Should I list this as a bug?

No, it is common behaviour.
You can apply different page styles for different sheets. Pls see F11
and the Help for more info :)

Cheers,





--
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] Multiple columns in Writer

[Dave Liesse]

And, for those of us who find using menus to be a major inconvenience 
compared to keyboard shortcuts, The Insert ... Manual Break ... Type ... 
Column Break can be accomplished with Ctrl-Shift-Enter.


Nothing to add to the rest of the comments!

Dave



On 3/30/2014 22:10, Brian Barker wrote:

At 21:27 30/03/2014 -0700, Andrew Noname wrote:
I would like to divide my page into two independently controlled 
columns.  Creating columns is easy enough to do.  However, I want the 
text in each column to start at the top of each column.  Think of two 
lists that are independent of each other, column 2 is NOT simply a 
continuation of column 1.  [...]


I know that I can hit enter 30 times or so in the first column in 
order to start the text at the top of the second column, but I was 
hoping there was a smarter way, ...


You can get to the top of a new column very simply and neatly by going 
to Insert | Manual Break... | Type | Column break.  But that still 
doesn't really serve your purpose, since although you talk of a single 
page, your text might eventually want to expand to multiple pages.  In 
that case, text from the left column would flow into the right column 
on the first page, not the left column on the second; text from the 
right column on the first page to the left column, not the right 
column, of the second.  These are called "newspaper columns".



Simple in concept... not so simple to make happen in Writer.


Actually, it is very simple.  Go to Table | Insert > | Table... and 
create a table with two columns and (probably) one row.  You will find 
that the table cells expand as necessary to accommodate your text - 
even to additional pages - and that the two columns will remain 
independent.


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] stop automatic scrolling

[Dave Liesse]

I have also noticed this in various programs.  Clicking in the scroll 
bar does stop it, and I haven't had it scroll past where the cursor is 
(if it's still in the scroll bar).  This is primarily in newer versions 
of software, and my suspicion is that it's related to programming for 
mobile devices or tablets.  I do have one application where clicking in 
the scroll bar causes the list to jump to the point where the click was 
done; I'll see if the developers can tell me whether there's any 
correlation.


Dave Liesse


On 3/21/2014 14:10, Girvin Herr wrote:

Greetings,
I am not sure this is a LibreOffice problem.  I have seen it in other 
applications, such as Firefox as well.  I think it is an unstable 
mouse or mouse driver effect.  I noticed it usually occurs when I am 
hovering the mouse cursor in the vertical scroll bar.  I found that 
clicking somewhere in the vertical scroll bar usually stops it.  I 
haven't seen it lately, but then maybe I stopped hovering the mouse 
cursor in the vertical scroll bar.

Girvin Herr


On 03/21/2014 03:24 AM, Tom Davies wrote:

Hi :)
Have you tried renaming your User Profile yet?
https://wiki.documentfoundation.org/UserProfile

That often fixes weird things that shouldn't happen = particularly if
they haven't always happened and just started mysteriously one day for
no apparent reason (perhaps after adding a new Extension)
Regards from
Tom :)



On 21 March 2014 09:59, Thomas Blasejewicz  wrote:

Good evening
Probably this is a stupid question, but ...
I noticed time and again, that LO starts scrolling and cannot be
stopped, until the end of the file is reached,
when I click below the blue rectacle on the right side scroll bar in
order to get just a little further down.

I have been looking, and searching the help documentation for 
"automatic

scrolling" (or similar expressions), but
could not find yet the trick to make LO stop this. (it is really
annoying, when you are taken to place you don't want to go to)

How do you stop, or customize, this behavior.

Thank you.
Thomas

--
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] OT: Windows, sort text file, can I use LibO maybe?

[Dave Liesse]

Actually, this can be done more easily in Writer.  You have to select 
the text to be sorted, then choose Tools...Sort.


The trick is to adjust the sort parameters in the dialog window. For 
Key1 you want to select column 2 (default is 1), then choose the 
Character radio button, click on the ellipsis, and select the space 
character (the second empty box; the first one is a carriage return).


This won't necessarily sort the third and subsequent words, but if 
necessary the sorted blocks of text can be further sorted and refined 
(just sort on column 3, then 4, and so long until done).  A bit of work, 
but easier than writing a script in a language you don't know!


Dave


On 3/17/2014 11:51, Jay Lozier wrote:


On 03/17/2014 02:32 PM, Tanstaafl wrote:

Hi all,

I'm working on a little problem that I'd really like to resolve. It 
doesn't really have anything to do with Libreoffice, other than I 
thought I might be able to use Calc to do the sort...


I have a text file. Each line is one record.

I can use the raw windows Sort command to sort the file, and that 
works fine, but I need to sort it based on the second column, not the 
first, and the windows sort command doesn't allow this.


The columns are separated by a space, but to complicate matters, the 
second column can contain multiple space separated words.


All I need to do is sort the file based on the text found AFTER the 
first space on each line (ie, the second column).


Is it maybe possible to do this somehow with Calc on the command line?

Or, does anyone have any other ideas?

Thanks,

Charles


Charles,

The problem is the second column. Can you regenerate the text file 
easily such as requerying a database and saving the file with column 
delimiter such as colon, semicolon, or tab?


If not and the file is not very large or has patterns. you can use, 
you can open it to text editor like Notepad. Then systematically 
replace each pattern such as "0 a" with "0;a" using Find/Replace.


Along this line if you know a scripting language such as Python, Ruby, 
or Perl a script using regular expressions might work.


Once the file has been cleaned up, Calc can do the data sorting.




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

[Dave Liesse]

Probably the second most critical compatibility issue is that Impress, 
the presentation software, doesn't tend to play nice with PowerPoint.  
Basic presentations are fine, but as soon as sound and graphics are 
involved the incompatibility grows exponentially (in my experience).


Dave


On 3/13/2014 23:40, Jay Lozier wrote:

Hamida,

LO can generate files that are MSO compatible. Occasionally, there are 
problems with MSO files with a complex structure. Also, MSO 2013 will 
read the ODF files version 1.2 which is the current ODF standard. LO 
uses ODF as its default format.


Do you have a specific requirements that you want addressed?

The major compatibility issue is LO does not use the same macro 
language as MSO (Visual Basic for Applications - VBA).


Jay

On 03/13/2014 08:50 PM, Hamida Begum wrote:

is the program compatible with microsoft office?






--
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] Change character attributes

[Dave Liesse]

Well, that too, but Change Case is actually an item in the menu.

Dave


On 2/14/2014 17:49, Pikov Andropov wrote:

Right!!

Format > Character > Effects

Thanks.

Dave Liesse has written on 2/14/2014 8:36 PM:

Pikov,

This is an option in the Format menu.

Dave


On 2/14/2014 17:30, Pikov Andropov wrote:

Some word processors permit you to select a bunch of character and
change the case.

I couldn't find that in LO. I sit in fact there?

Thanks.





--
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] Change character attributes

[Dave Liesse]

Pikov,

This is an option in the Format menu.

Dave


On 2/14/2014 17:30, Pikov Andropov wrote:

Some word processors permit you to select a bunch of character and
change the case.

I couldn't find that in LO. I sit in fact there?

Thanks.




--
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] Calc: help with VLOOKUP

[Dave Liesse]

If you look at the help for VLOOKUP, the second sentence says "This 
function checks if a specific value is contained in the first column of 
an array."


Dave



On 2/14/2014 12:55, Pikov Andropov wrote:

Dave Liesse has written on 2/10/2014 4:00 PM:

The first problem I see is that your lookup value -- in this case the ID
number -- has to be the first column in the lookup array.

When I moved the ID number to the first column, my VLOOKUP worked! Where
does it say that that is a requirement?




--
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] Calc: help with VLOOKUP

[Dave Liesse]

The first problem I see is that your lookup value -- in this case the ID 
number -- has to be the first column in the lookup array.


Using your specific example, the VLOOKUP function would be used in 
column E of Sheet 2.  If you were wanting to also copy the price from 
Sheet 1 (which you've said you're not), you would need another VLOOKUP 
in Column F.



This can be set up in advance, but you'll need to use an exact lookup 
unless you know you exact lookup range ahead of time (in which case you 
don't need to worry about searching an empty area).


I know this didn't answer all your questions, but others will chime in.

Dave



On 2/10/2014 12:03, Pikov Andropov wrote:

Something is not working for me. Hope someone can help.

I have a two-sheeted speadsheet.

Sheet 1 has three columns as follows:
A. Name
B. Price (ignorable as far as this example is concerned)
C. ID number

Sheet 2 has three columns as follows:
A. Item Code
B. Item description
C. Minimum bid (ignorable as far as this example is concerned)

The operator will be given a piece of paper with an Item code, an ID
number and a price. I would like him to be able to look up an Item code
in Sheet 2 and then, in that row, enter the ID number (column D?). A
VLOOKUP formula would paste the Name into an available column (E?) and
the operator would enter the price into the next column (F?).

Where do I type the =VLOOKUP formula?

Can I save the sheet with the formula so I can set this strategy up
ahead of time?

How do I get the formula to apply properly to every row?

What should the initial formula look like?

Thank you.




--
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: low traffic lately?

[Dave Liesse]

FWIW, I've done some searching of my email since my earlier post. It 
seems that I get the "Reply All" button for lists that are Yahoo! 
groups, and "Reply List" for lists that use real list servers.


Dave


On 1/28/2014 16:23, Peter West wrote:
I've just switched to Thunderbird from Apple Mail, and the Reply List 
button is very handy indeed.


There is a minority of lists that exhibit the same behaviour as this 
one with replies. The fact that it is a minority makes it all the more 
likely that I will send replies to the wrong address - the OP.


P.S. Apple has had ongoing problems with Mail in Mavericks, and I 
suspect they have decided to phone home about everyone you add to the 
address list of an email.  Using Contacts groups became painfully slow.


On 29/01/2014 9:59 am, Dave Liesse wrote:
Virgil, I don't think it's just the list. The mail client must have 
something to do with it, as well; I use Thunderbird and have a "Reply 
List" option on this list, while on some others I do and some I don't.


Dave





--
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: low traffic lately?

[Dave Liesse]

Virgil, I don't think it's just the list.  The mail client must have 
something to do with it, as well; I use Thunderbird and have a "Reply 
List" option on this list, while on some others I do and some I don't.


Dave


On 1/28/2014 14:47, Virgil Arrington wrote:

Brad wrote:


Unfortunately, at least one MUA (guess which one) uses "Reply All" to
mean "Reply List".  This simply confuses matters.


I'm assuming you're meaning MS. Actually, with my MS Windows Live Mail 
interface, "Reply All" means just that; it replies to everyone in the 
original message, whether individual or list (which is why Brad will 
get two copies of this message). There's nothing confusing about that. 
The "problem," if that is the right way to put it, is that it has no 
"Reply List" option (at least none that I can see.)


The frustration is that, if I want to reply only to the list, I have 
to hit "Reply All" and then delete all the addresses that aren't the 
list. Now, is that the fault of MS Live Mail, or the way the list was 
set up? As has been repeatedly reported by others, this is the *only* 
list (at least that I use) that behaves this way. I'm more inclined to 
blame the list than MS's email software.


I'm not a huge fan of MS, but I'm also not going to blame them for 
problems they didn't create.


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

Re: [libreoffice-users] Calc: Inline Formatting

[Dave Liesse]

That sounds like what I was looking for.  I'll play with it later. 
Thanks much!


Dave


On 1/24/2014 17:02, Brian Barker wrote:

At 12:33 24/01/2014 -0800, Dave Liesse wrote:
Two simple questions which should be available through Help, but I 
haven't been able to find anything.


1.  Is there a way to format content within a formula?  I need a cell 
that concatenates a properly-formatted date to some text, but I can't 
find any way to specify the date format.


2.  In conjunction with #1, is there a function to return an entire 
date in external format rather than having to get the month, day, and 
year separately?  All I've found is a way to convert a human date to 
an internal date.


The TEXT() function is your friend.


I build the cell formula as
=CONCATENATE("my text",$r$2)

... what I really want is MM/DD/.
Any ideas how to simplify this?


="my text "&TEXT(R2;"MM/DD/")

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

[libreoffice-users] Calc: Inline Formatting

[Dave Liesse]

Two simple questions which should be available through Help, but I 
haven't been able to find anything.


1.  Is there a way to format content within a formula?  I need a cell 
that concatenates a properly-formatted date to some text, but I can't 
find any way to specify the date format.


2.  In conjunction with #1, is there a function to return an entire date 
in external format rather than having to get the month, day, and year 
separately?  All I've found is a way to convert a human date to an 
internal date.




Here's the background of what I'm trying to do, in case it's not all 
clear above.  I'm using Calc to replicate a form produced by another 
system; the other system only lets me go out a certain distance in the 
future but my client wants it for a longer period.  What I create won't 
be a perfect match, but it'll be close enough.  For this particular job, 
mainly due to other formatting issues, Calc is a better choice than Writer.


The date appears several times on the form, so I naturally just want to 
enter it once.  In two cases it appears after standard text that is 
centered in its cell.  I build the cell formula as


=CONCATENATE("my text",$r$2)

where R2 is the cell in which I've entered the date.  The formula as 
written here returns the internal date, so I tried this one:


=CONCATENATE("my text",MONTH($r$2),"/",DAY($r$2),"/",YEAR($r$2))

Unfortunately, this one gives me a single digit for the month and the 
day, and what I really want is MM/DD/.  If I could just do this 
inline it would be a lot easier than having to then figure out how Calc 
will generate leading zeroes for me (which would also require inline 
formatting or a lot more embedded functions).


Any ideas how to simplify this?

Dave


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

[Dave Liesse]

On the Windows version of Thunderbird your radio boxes are actually 
command buttons (or whatever the proper term is -- I've never been a 
visual developer).  The "Reply List" is being called a smart button 
because it changes between "Reply List" and "Reply All" according to the 
message headers.  I've found very few cases anymore where it says "Reply 
All" in connection with list mail, although I'm sure it still happens 
for some lists.


Dave



On 12/4/2013 13:32, Doug McGarrett wrote:
Now in the gray area, above the actual message, I have the From, the 
Subject,

and the To, filled in, and way over at the right I have radio boxes with
Reply, Reply List, (checkmark) Forward, Archive, Junk and Delete.
Under Delete is a time, which is wrong, and under that is Other 
Actions (checkmark).
Under Other Actions is a pull-down menu, but it doesn't have a "Smart 
Button."
My Thunderbird is 17.0.2, running at the moment on Linux Mint 14, but 
I've never

seen any Smart Button on any version.

--doug






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

[Dave Liesse]

I agree that the merge can be done from Calc -- I do that frequently.

I also agree, though, that it takes more effort than it should to set up 
labels.  Even using the templates included in the program I've never had 
the output fit properly on the first pass (but I've learned to print on 
a plain sheet of paper, then hold it up to the light against label 
stock, and figure out what adjustment is needed).


Dave Liesse


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

[Dave Liesse]

Depends on your mail client, too.  In Thunderbird, when a message comes 
from a list server the reply buttons are "Reply" and "Reply List" (the 
latter replacing "Reply All").  Much easier to deal with than lists that 
are set up the other way (for me, anyway).


Dave


On 12/3/2013 13:37, Peter West wrote:

Unfortunately, this list is set up to reply to the author, not the list. I've 
been caught by that on numerous lists.  To eliminate the duplication, I have to 
Reply-all, then remove the OP from the To, and move the Cc field to the To 
field. I generally do that; I've just done it. Yes, it's a pain, and it's more 
of a pain to do the courtesy than to delete the duplicate that comes in.

If you don't like the policy, ask the list manager whether it can be changed. I 
have never been able to comprehend why a mailing list would default that way. 
Replying to the OP only is the outlier, not the norm.

Peter West

"We have only five loaves here, and two fish."

On 4 Dec 2013, at 2:06 am, Dave Howorth  wrote:


anne-ology wrote:

   not true.

That'll be why there's a support article about the problem then, and
numerous threads in forums.

https://support.google.com/mail/answer/8395?hl=en


PS Please don't copy me on any reply. That's just plain rude.

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

[Dave Liesse]

I've had troubles in the past finding specific financial functions, as 
well.  Can't help from the function standpoint in this case, but you 
could always fall back on the actual equation:


FV = PV*(1+i)^n

where FV is future value, PV is present value, i is the periodic 
interest rate, and n is the number of periods.


Dave



On 11/27/2013 15:10, Cliff Scott wrote:

I haven't done much spread sheet formula work so please don't mind a couple
of simple questions.

I would like to do two things:

1. Calculate compound interest on an amount given the rate and number of
interest periods. Looking at the list of functions there are lots of ones
that come close to that, but I wasn't able to find one that would do exact
that.

2. How do I write a conditional loop in Calc? If I want to calculate a
formula for 10 iterations how would I do that? For instance
Value=Value*N+Value. That would give me the compound interest also. I can do
it with a bunch of cells strung out each one representing one interest
period, but for any length of time it becomes unwieldy.

Thank you very much for any help.

Cliff




--
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] Exporting Impress Slide Show

[Dave Liesse]

This is a follow-up to a question I asked in August.  I'm still 
struggling with trying to create something that can be used in other 
systems.  Here's what I've done:


1.  Created a slide show in Impress.  Slides auto-advance after 5 
seconds, and transitions are used to play appropriate music files. 
Previous tests by myself and others on this list have shown that the 
links to the audio files follow relative rather than absolute paths.


2.  Saved as .pps file.  Copied presentation and audio file directory -- 
pathing kept intact -- to thumb drive.


3.  Open .pps file on another computer that doesn't have LibreOffice 
installed.  Slide show runs, music does not play.  Confirmed music files 
are present.


4.  Rename original audio file directory on my hard drive for testing.  
Run slide show from thumb drive on my own computer.  Opens in Impress, 
of course, and does not auto-run.  Music plays properly.


This slide show is for distribution to others via DVD, and I'm really 
getting frustrated with it.  I'd hate to think that the hours I've spent 
on it have been wasted and that I have to start over with another 
application.  But I can't assume anything about the software anyone else 
has, and just about everyone has the ability to view a .pps file 
regardless of their OS (I can be pretty sure, but not 100% positive, 
that everyone on my distribution list is using either Windows or Mac 
machines).  Can anyone see anything I've overlooked?


Dave


--
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] Picture size controls...

[Dave Liesse]

I actually find the dialog box more useful, since I'm usually trying to 
set an exact width for an image.


I'd been frustrated with the mouse resizing because I didn't know about 
having to shift to maintain the ratio.  In my experience, most software 
keeps the ratio if you click and drag the lower right corner; shift is 
not necessary.  You learn something new every day!


Dave



On 10/29/2013 15:11, Paul wrote:

This is just off the top of my head, I haven't actually experimented
with this, but isn't the "keep ratio" checkbox in the dialog window
just for resizing by way of the width and height values in the dialog
window itself, and has nothing to do with drag operations? Dragging to
resize has its own way of keeping ratio, by holding down shift or some
such, doesn't it?

That's the way I understand it, at least, and it seems correct to me.
Works that way in lots of software, I think.

Paul



On Tue, 29 Oct 2013 16:05:31 -0600
Ken Springer  wrote:


Well...  The following seems really dumb.   :-(

1.  Insert a picture in a document
2.  Select the picture, rt. click and select "Picture" from
the popup box 3.  Click the Type tab, and check "Keep ratio".

Leave the dialogue box open or close it, your choice.

Grab a corner handle, adjust the size, but the ratio is NOT retained.

Surely, this is not right.

The ratio is kept if you manually change the size in the dialogue box.






--
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] Calc Function Wizard - IF Result differences

[Dave Liesse]

I still think the VLOOKUP function can help tremendously but it does, in 
practice, need one or two more columns in the lookup table.


The table as it exists has the number of units in each range, rather 
than the values at the breakpoints.  These breakpoint values are vital, 
as they are what are needed to make VLOOKUP work in the first place.  
They can be calculated, based on the units per range, but the actual 
numbers must be in the first column of the lookup table.


The other column that would help immensely is the summed amount for all 
the lower-level ranges.  The best illustration I can think of from the 
US income tax calculation:


Looking at only the rates for income over $100,000 (for smaller amounts 
the tax is looked up in a table rather than calculated), for one filing 
status, we see that the marginal tax rate is:


25% for taxable income > $100,000 and <= $142,700
28% for $142,700 < income <= $217,450
33% for $217,450 < income <= $388,350
35% for income > $388,350

In the past the worksheets would have shown the total tax at the top of 
the previous bracket, plus the rate on the income above the threshold.  
For example, if the income was $150,000 the worksheet would have said 
$27,729 + 28% of the amount over $142,700.  This can be replicated in 
the lookup table.


The worksheets now start with the marginal rate and subtract another 
value representing the difference in rates for the lower income. That 
same range now says 28% minus $12,221.  The answer is the same, just 
arrived at differently -- and can still be replicated in the lookup table.


I'm not sure how all this fits into the 12-month consideration 
introduced after the original question, but I hope it explains how 
VLOOKUP can make the conditionals a lot easier -- if not for this 
particular case, then for someone else with a similar question.


Dave Liesse


--
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: North America Pub Chat

[Dave Liesse]

Actually, that time zone chart is not quite accurate.  The differences 
are correct for daylight time, but not for standard time.


PST (GMT/UCT - 8)
MST (GMT/UCT - 7)
CST (GMT/UCT - 6)
EST (GMT/UCT - 5)

PDT (GMT/UCT - 7)
MDT (GMT/UCT - 6)
CDT (GMT/UCT - 5)
EDT (GMT/UCT - 4)

And, of course, our daylight (summer) time has to be different from the 
rest of the world.  We start earlier and end later than the European 
countries, so the difference from another given time zone isn't constant.


Dave


On 10/7/2013 10:30, Joel Madero wrote:

hip. Really 1 hour a month is enough time to give back a bit.

Hi,

I dont know if I can make it this Friday, but could you also point 
out the time
in UTC too? For a continental european guest a time like "12:00pm 
EST" is

ultimately confusing -- is that EST or 2400EST?


Sure, apologies for that :)

So for North America (or at least United States) we have:
PST (GMT - 7)
MDT (GMT -6)
CST (GMT - 5)
EST (GMT - 4)

Once I get a head count of who theoretically would be interested if 
the time was right, we can start discussing what specific time will 
work and I'll make sure to do the conversion to GMT :) As of now it 
looks like 1200 (1900 GMT) on Friday isn't going to work as there just 
doesn't seem to be availability/interest.


All the best,
Joel




--
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] downloaded .doc file will only open as read-only

[Dave Liesse]

This is what I was going to suggest, as well.  Any document I get via 
email is read-only, regardless of its source software (I use Thunderbird 
as my client).  Saving the document makes it read/write.


Dave

On 9/28/2013 12:33, Tom Davies wrote:

Hi :)
Errr, it's probably an attachment that just needs to be downloaded/saved onto your machine first.  
Another way is to open the file and then choose "Save As ..." to save the file onto your 
computer properly.  Then the icon-bar and stuff should become visible or stop being "greyed 
out".
Regards from
Tom :)




  From: M Henri Day 
To: Michael Hartigan 
Cc: "LibreOffice, users" 
Sent: Saturday, 28 September 2013, 20:12
Subject: Re: [libreoffice-users] downloaded .doc file will only open as 
read-only
  


2013/9/28 Michael Hartigan 


I have a job application in .doc format, which LibreOffice will only open
in read-only mode.  I need to fill in the fields and send it back to my
prospective employer in .doc format.  I have checked the file properties
and it is not a read-only file.  I am using
Version: 4.1.0.4
Build ID: 89ea49ddacd9aa532507cbf852f2bb22b1ace28

and am running Windows 8.

Thank you for any help you may be able to provide.

Michael


​Michael, have you tried copying the entire text of the document in
question with «Ctrl+A» and pasting it into a new document with «Ctrl+V» ?
That should allow you to fill in the required fields and therewith resolve
the problem​


​Henri​




--
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] spacing after punctuation

[Dave Liesse]

Virgil, I'll have to disagree with your last sentence.  It's quite 
obvious to me when there are two spaces after a sentence-ending period 
rather than just one, even with proportional fonts (allowing for the 
possibility that there's a font somewhere with a wider space than the 
others).  I prefer the double space, myself.


Dave

On 9/5/2013 15:45, Virgil Arrington wrote:

Anne,

Don't misunderstand me. I much prefer a single space after sentence 
ending punctuation for reasons I have written many times before. I was 
just surprised that Jury advocated going further and using an even 
narrower space. I consider that a little over the top, even for an 
obsessive typophile like me. I doubt that any such narrowing would 
even be noticeable by the typical reader. And the optical illusion of 
a wider space that Jury notes is caused by the inherent space included 
with periods and commas should satisfy the two space folks.


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

Re: [libreoffice-users] Re: Suggestion: Change the zoom with Ctrl+ Plus(+) and Minus(-) Key shortcuts

[Dave Liesse]

This works, from what others have posted, but it doesn't help those of 
us using laptops with touchpads (i.e., no mouse or scroll wheel).


Dave


On 9/4/2013 07:04, Alexander Thurgood wrote:

Le 04/09/13 11:42, logos a écrit :


Can you not do this with the Ctrl and mouse scroll wheel forward/backward ?

On Mac, this works in Writer/Calc/Draw/Impress (unless of course, you
don't have a mouse, but you can use the touchscreen instead).


LO Version: 4.1.1.2
Build ID: 7e4286b58adc75a14f6d83f53a03b6c11fa2903

on OSX 10.8.4

Alex





--
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] converting .odt to .doc

[Dave Liesse]

Tom, that's not an option in this case.  The file has to be uploaded 
(via a third party) and will reject an ods file before even looking at it.


Odd about the xlsx formats changing, since through its shenanigans (I'm 
being generously polite with that term) a few years ago Microsoft got it 
accepted as an international standard.


Dave


On 8/21/2013 10:46, Tom Davies wrote:

Hi :)
Send them an Ods, the native format for OpenOffice, LibreOffice and 
many others.


Perhaps also send them a Csv.

Always avoid the formats that have the extra X at the end as they keep 
changing with every new release of MS Office such that one version 
sometimes messes up the documents created in another version.

Regards from
Tom :)



    *From:* Dave Liesse 
*To:* users@global.libreoffice.org
*Sent:* Wednesday, 21 August 2013, 18:40
*Subject:* Re: [libreoffice-users] converting .odt to .doc

I have a similar problem when saving a spreadsheet as .xls or
.xlsx --
the format is not always recognized at the other end. When I have a
chance to work with the IRS (to whom I'm trying to upload the
spreadsheet, to report education) and figure out exactly where the
failure occurs I'll pass the word along here.  Their software has
some
problem with the .xls version, and won't even recognize the .xlsx
as a
spreadsheet.

Dave



On 8/21/2013 01:44, tamas czovek wrote:
> Hi,
> When I convert .odt documents to .doc or .docx the original
formatting gets
> messed up with, in .doc, half the footnotes lost sometimes. How
can I
> prevent this from happening? I use Ubuntu 12.04 and LibreOffice
3.5.7.2.
> Wishes,
> Tamas


-- 
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] converting .odt to .doc

[Dave Liesse]

I have a similar problem when saving a spreadsheet as .xls or .xlsx -- 
the format is not always recognized at the other end.  When I have a 
chance to work with the IRS (to whom I'm trying to upload the 
spreadsheet, to report education) and figure out exactly where the 
failure occurs I'll pass the word along here.  Their software has some 
problem with the .xls version, and won't even recognize the .xlsx as a 
spreadsheet.


Dave



On 8/21/2013 01:44, tamas czovek wrote:

Hi,
When I convert .odt documents to .doc or .docx the original formatting gets
messed up with, in .doc, half the footnotes lost sometimes. How can I
prevent this from happening? I use Ubuntu 12.04 and LibreOffice 3.5.7.2.
Wishes,
Tamas



--
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] Impress: Sound Links

[Dave Liesse]

Thanks, Joaquin.  I did look at the Guide, but it must have been a 
different version; the instructions weren't as specific.  Or, looking 
again at your quote, it might have been in a different section 
(principle is the same, but I'm doing a transition, not inserting a 
media file -- the section on transitions does talk about linking to the 
files, but doesn't say anything about putting them in the same directory).


Brian, I had some issues with testing -- trust me, I did try!  Had to do 
with available machines more than anything else (and the fact that I was 
doing it at home while all my disks are at the office).


Dave


On 8/20/2013 02:56, Joaquín Lameiro wrote:

Hi.

I have excerpt this parragraph from the LibreOffice Impress Guide at 
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Impress_Guide:


"Impress
only links media files and does not embed a media file into a
presentation. Therefore if a presentation is moved to a different
computer, any links will be broken and the media files will not play.
To prevent this from happening:
1. Place any media files which are included in a presentation in the 
same folder where the presentation is stored.
2. Insert the media file in the presentation.
3. Send both the presentation and any media files to the computer which is 
to be used for the presentation and place both files in the same folder on that 
computer."

So, it works as both Brian and Dave had already deduced. As long as you keep 
everything in the same folder (or in the root of the CD), there should be no 
problem. I suppose you also can put the sound files in a sub-folder, so 
everything would be more tidy.
Regards,
Joaquín




  De: Brian Barker 
Para: users@global.libreoffice.org
Enviado: Martes 20 de agosto de 2013 8:25
Asunto: Re: [libreoffice-users] Impress: Sound Links
  


At 22:37 19/08/2013 -0700, Dave Liesse wrote:

Well, it was a kick in the teeth to learn that sounds are only
linked instead of being imbedded in the presentation, but at least
that'll keep the size down.  My question, though, is whether the
links use absolute or relative paths.

It's a simple job to test this, of course - and the answer appears to
be relative.


I put together a presentation that's for distribution via DVD, and
of course I have no idea in advance what drive letter any given
recipient will have.  I have no problem with putting the sound files
on the disk, but need to know what type of pathing is being
used.  If it's relative, I'm already in good shape; if it's
absolute, then I'm hosed.

This kinda makes it impossible to distribute a slide show
electronically, as well, if you want sound with it.

Surely all you need to do is to put your audio file in the same
folder as your presentation when you insert it, and to require your
correspondents to have both files in the same folder - wherever that
might be - before attempting to use them?

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

[libreoffice-users] Impress: Sound Links

[Dave Liesse]

Well, it was a kick in the teeth to learn that sounds are only linked 
instead of being imbedded in the presentation, but at least that'll keep 
the size down.  My question, though, is whether the links use absolute 
or relative paths.  I put together a presentation that's for 
distribution via DVD, and of course I have no idea in advance what drive 
letter any given recipient will have.  I have no problem with putting 
the sound files on the disk, but need to know what type of pathing is 
being used.  If it's relative, I'm already in good shape; if it's 
absolute, then I'm hosed.


This kinda makes it impossible to distribute a slide show 
electronically, as well, if you want sound with it.


Dave


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

[Dave Liesse]

That would be correct.  It's the incoming mail that's scanned, not the 
outgoing -- and too many spam checkers look only at the IP address.  It 
doesn't matter if there are 4000 users on your shared, hosted server; as 
far as they're concerned if one's guilty, all are guilty, as if we have 
any say over who else shares the server.


Dave

On 8/17/2013 12:41, James Knott wrote:

Mark's Google A/c wrote:

I've been getting a *lot* of failed mail notifications from the
mailing list over the last few weeks.

After extensive investigation, there doesn't appear to be anything
wrong with my mailbox or mail servers, so I'm curious, how many other
people get this, either frequently or occasionally?  Is it just me?

Mark Stanton




I occasionally get bounced mail from the different lists I'm on.  It's
usually the recipient that has the problem.




--
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] Can't find setting

[Dave Liesse]

Which would be fine, but it doesn't.

Dave



On 8/15/2013 09:17, Ruth Ann wrote:

On 8/15/2013 10:28 AM, James Knott wrote:

So, how would it tell the difference between the end of a sentence,
terminated with a period and a sentence containing a period used as part
of an abbreviation such as "Dr." or "etc."?
Having just spent several weeks learning all about Object Oriented 
Programming, I would answer that by saying it should not matter how it 
can tell the difference, but only that it does. ;-)





--
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] Can't find setting

[Dave Liesse]

Well, that's what someone decided, and it is the standard for HTML, but 
it still is not universally accepted.  A double space, whatever minimal 
width the space is, makes it clear that a sentence has ended.  There is 
an obvious difference from a single space following an abbreviation, for 
example.  I don't expect a word processor to eliminate extra spaces (and 
I long ago disabled that "correction").


Dave



On 8/14/2013 20:38, Brian Barker wrote:

At 21:23 14/08/2013 -0500, Michael Morse wrote:
For some reason, I am no longer able to make a series of spaces using 
the space bar.  After one space, pressing the space bar will not 
advance the cursor.


Rejoice!  This is how all word processors should work.  Countable 
spaces exist only in Typewriterland.  With proper type faces, the 
space between words is anything from a minimum value up to whatever is 
required to range across a line.  The spacebar no longer represents an 
actual amount of space but merely indicates a word break in the text.  
If you need to space material differently, you do it properly - using 
tabs, tables, frames, or whatever.


I don't remember changing anything so I have no idea where to even 
begin to look for whatever setting I assume I must have changed to 
cause this behavior.  Can someone help me how please?


Yes: forget about multiple spaces and set up proper spacing using the 
correct facilities of your word processor, whichever that is.


(Oh, but if you really want to fossilize in Typewriterland in the 
previous millennium, go to Tools | AutoCorrect Options... | Options 
and remove the tick from "Ignore double spaces".  And hang your head 
in shame.)


;^)

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] LO 4 install deletes 3.6

[Dave Liesse]

Thanks, Andrew; I hadn't noticed this before.  My LO 3.4 directory is 
still present, but practically empty.  This is NOT good behavior if the 
user is not notified first.  I'll be sure to go back and find your 
earlier message and save it, for future use.  When there's an upgrade 
(as opposed to a patch), I want the ability to test it before abandoning 
my old software.  Guess I'm fortunate not to have had issues going from 
3.4 to 4.0!


Dave


On 7/24/2013 08:13, Andrew Brown wrote:

Hi Virgil

You have observed correctly. I have just done a test of installing two 
version of AOO under Windows 7, and quite correctly, it installs it's 
own local cache/store of settings, per version, thus allowing two 
copies to work side by side, as long as you create two distinct 
install folders (by default I never allow any installing program's 
defaults in Windows 7, many known issues with virtual links to folders 
etc). And correct in your observation, as well as my earlier supplied 
info, LO does not do this, rather opting for a single user settings 
store, detecting another install of LO, and uninstalling it, before 
installing the upgrade (or possible downgrade). But this is not a bad 
thing though, as covered by other respondees.


The link I supplied in my earlier email shows one how to overcome this 
issue of LO and a universal store, allowing for two versions 
simultaneous and operational on Windows 7.


Regards

Andrew



--
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] Calc - allow users to format cells on protected sheets

[Dave Liesse]

Depends on where you open it.  If I double-click an email attachment to 
open it, I can't make any changes at all (not even column width).  Once 
I save it to my hard drive, it becomes unprotected.


I think what the OP is referring to is that in Excel you can do whatever 
you want to a protected spreadsheet -- you just can't save the changes.  
Thus, you can do a lot of "what if" analysis but can't mess up someone 
else's work.


Dave


On 7/18/2013 11:44, Tom Davies wrote:

Hi :)
I think if you open an Excel spreadsheet that is supposedly "protected" in Calc 
then you bypass all the password protections and stuff.

My company's (well the place where i work, it's not really mine as such) 
finance lady was somewhat horrified when i was easily able to fix a problem for 
her despite having no idea what the password was.  I hadn't even realised the 
spreadsheet was supposedly protected!
Regards from
Tom:)







From: Tanstaafl 
To: users@global.libreoffice.org
Sent: Thursday, 18 July 2013, 15:47
Subject: [libreoffice-users] Calc - allow users to format cells on protected 
sheets


Hello,

Microsoft Excel has the ability to allow users to apply formatting
changes to protected cells when a sheet is protected.

Is there any possible way to do this in Calc?

Thanks

--
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] Spell check not working on 3x5 flash cards

[Dave Liesse]

When I had this problem, there was no dictionary associated with the 
spell check.  Don't remember the exact fix, and no explanation for why 
this would suddenly become an issue; just something to consider.


Dave
On 07/01/2013 10:49 AM, Al Vesper wrote:

I have a file with lots of pages of rather ordinary text formatted for
printing on 3x5 cards, and ran the spell checker in writer before 
printing

the cards.  Spell check said (almost instantly) that it had completed
successfully and would I like to start again at the beginning. I said 
yes
and it said it had again not found any misspelled words.  While 
reviewing

the printed cards, I have come across misspelled words ("Remved" and
"contermost") and am left wondering what went wrong...






--
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] Style Question (Similar to Helen's, for Plays)

[Dave Liesse]

Disregard my comments about the number formatting.  I just learned the 
difference between line numbering and outline numbering!


Dave


--
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] Style Question (Similar to Helen's, for Plays)

[Dave Liesse]

On 6/26/2013 11:10, Brian Barker wrote:

At 10:11 26/06/2013 -0700, Dave Liesse wrote:
I belong to a radio theater group and often serve as director, which 
means I'm responsible for the scripts for those shows.  There are 
some standard requirements for the script format, and I haven't been 
able to figure out how to make them happen automagically through 
formatting or styles. Would appreciate any help.  Here is what I need:


1.  Header on every page.  No problem with that by itself, but see #2.
2.  Every line numbered.  Problem I've had here is (a) headers get 
the numbers, too, ...


I'm puzzled.  Are you using Insert | Header to create a real header?  
If so, I don't see that the header is included in line numbering.


That was a few versions of LO ago, so it might have been a 
version-specific glitch.  But yes, that's how I did it.





... and (b) numbering needs to start over on each page.


o Go to Tools | Line Numbering... and tick "Show numbering".
o At the bottom, tick "Restart every new page".

Thanks for this one.  I'm so used to turning numbering on with the icon 
that I didn't even think to look for a menu item to give me more options 
(I don't recall seeing the toolbar in the past, either, which also has 
this option).


Separate question about formatting the numbers, though.  I'm sure I'm 
missing something obvious, but I can't find anyplace to (a) eliminate 
the indent on the number, and (b) eliminate the period that follows.  
Best guess I have is that it's a combination of character and paragraph 
styles, but haven't found the magic combination, yet.  All I want is a 
number flush with the left margin, no punctuation.


3.  Need a hanging indent, for spoken lines that don't fit on one 
physical line, but need a tab within the indent (between the line 
number and the text) so the character's name can be inserted.


o Go to right-click | Edit Paragraph Style... | Indents & Spacing | 
Indent.

o Set "Before text" to some suitable positive value.
o Set "First line" to the corresponding negative value.

For each speech, type the character name, press Tab, and then type the 
speech text.  The Tab character will move the start of the text to the 
indented paragraph boundary.




I overlooked the obvious here -- put a tab character in the indent 
section, so in theory that's where typing will begin after the 
auto-number is followed by a tab character.  Just need to figure out the 
previous issue, now.



I trust this helps.



Everything helps -- we all need reminders now and then, and anything new 
is gravy!



Brian Barker




Dave


--
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] Style Question (Similar to Helen's, for Plays)

[Dave Liesse]

Helen's query reminded me of one I tried to post but at the time the 
list server decided my mail server was a spammer (the drawbacks to 
shared servers).  Mine's a little more complex, though.


I belong to a radio theater group and often serve as director, which 
means I'm responsible for the scripts for those shows.  There are some 
standard requirements for the script format, and I haven't been able to 
figure out how to make them happen automagically through formatting or 
styles.  Would appreciate any help.  Here is what I need:


1.  Header on every page.  No problem with that by itself, but see #2.

2.  Every line numbered.  Problem I've had here is (a) headers get the 
numbers, too, and (b) numbering needs to start over on each page.


3.  Need a hanging indent, for spoken lines that don't fit on one 
physical line, but need a tab within the indent (between the line number 
and the text) so the character's name can be inserted.  Don't remember 
the exact problem I've had with this, but it might not be one if item #2 
can be resolved.


As I say, any help would be greatly appreciated!

Dave


--
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] advanced notes question

[Dave Liesse]

Is the document opening in read-only mode?  If you opened it directly 
from an email it might be -- this happens to me all the time.  If that's 
the case, you'll want to save it first and then (re)open it.



On 6/25/2013 12:31, Mirosław Zalewski wrote:

On 25/06/2013 at 18:04, Brian Barker  wrote:


Found it. Thanks. Unfortunately, it's greyed out, which I presume
means that LibreOffice isn't detecting the comments in the document.
Am I right?

I think not.  Now you need to tick Tools | Options... | LibreOffice
Writer | View | Display | Comments.  Then the menu item should become
active.

My simple test shows that both these options (in menu and in Tools → Options)
do the same. So if menu item is grayed out, then LO is unaware of any comments
in file.
I would consider it a bug.



--
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] Replying to users

[Dave Liesse]

On 5/22/2013 07:13, V Stuart Foote wrote:
So, use the "respond to all" option of your email reader of choice, it 
SHOULD pick up the mail list address. Delete the "other" direct 
addresses. And finally TRIM away any of the extra crud in the message. 
Leave just enough for the message to stand on its own, but not be 
distracting either to read--or when viewed in context in a News group 
reader or a web archive like Nabble. Stuart 


That's one of the nice things about Thunderbird: I have a "Reply List" 
button that replaces "Reply All" when a message comes from what I 
consider to be a properly-behaved list server.  I also have the option 
to reply just to the original author of a message.  If the list server 
has the list as the "Reply-To" address, then "Reply" goes to the list 
and "Reply All" creates the duplicate message to the original poster.


Dave


--
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: [Solved] Re: [libreoffice-users] "Case" function equivalent in Calc

[Dave Liesse]

Here's a formula that works.  It's ugly, but it works.

=MID(SUBSTITUTE(SUBSTITUTE(";"&A1&";"&B1&";"&C1&";"&D1&";",";;",";"),";;",";"),2,LEN(SUBSTITUTE(SUBSTITUTE(";"&A1&";"&B1&";"&C1&";"&D1&";",";;",";"),";;",";"))-2)

The thing to do in a case like this is to break the problem down into 
sections.  There are many ways to approach this specific question, but 
here's my thought process.


1.  Go ahead and concatenate all the cells and worry later about whether 
or not they contain data.  Insert semicolons between values.


2.  Include a semicolon at the beginning and end of the string to 
accommodate the next two steps (in case the first or last cell is empty).


3.  Where two semicolons are consecutive, eliminate one of them.

4.  Eliminate the semicolons at the beginning and end of the string.

After that, I break the functions down to simplify construction of the 
monster.


A.  =MID([string],2,LEN([string]-2)
This strips the beginning and ending semicolons.

B.  =SUBSTITUTE([string],";;",";")
This replaces every instance of two semicolons with a single 
one.  Unfortunately, the function is not recursive, so if there are 
three in a row it will only make one replacement.  This why the final 
formula has two instances of the SUBSTITUTE function.


C.  [string] is the concatenation of everything.

Hope this helps!

Dave



On 5/16/2013 07:23, Carl Paulsen wrote:

Hi Tom.

Well, not quite.  In my particular case this formula worked.  But with 
some off-list input from smarter brains than mine, I realize it 
wouldn't work under many situations.


It turns out the formula would need to change a bit, otherwise what I 
did would leave a trailing semi-colon where column X is blank.  In 
fact, it's a tricky situation b/c a semi-colon is needed after U3 if 
U3 has a value AND any of the others has a value, otherwise not. Then, 
if V3 has a value and any of the other later cells has a value, there 
should be another semi-colon.  Etc. etc.  In the last case, a 
semi-colon should follow W3 only if there's a value in X3.


I've tried a bunch of formulas and the closest I've come is the 
following:


=A13&IF(NOT(ISBLANK(A13))AND(NOT(ISBLANK(B13)))OR(NOT(ISBLANK(C13)))OR(NOT(ISBLANK(D13))),";","")&B13&IF(NOT(ISBLANK(B13))AND(NOT(ISBLANK(C13)))OR(NOT(ISBLANK(D13))),";","")&C13&IF(NOT(ISBLANK(C13))AND(NOT(ISBLANK(D13))),";","")&D13 



But that clearly doesn't work.  Note I'm working in a test sheet and 
am using different cells.  This formula leaves leading semi-colons 
under a number of situations and double semi-colons under others. I'm 
not entirely sure CASE would work any better here though.


Anyone want to help out, great.  But it's a pretty specialized 
situation, so I understand if not.


Carl


On 5/16/13 3:02 AM, Tom Davies wrote:

Hi :)
WoooHooo!!  Nicely done! :)  Is this whole thread solved now? 
COngrats of so!

Regards from
Tom :)




*From:* Carl Paulsen 
*To:* users@global.libreoffice.org
*Sent:* Thursday, 16 May 2013, 1:44
*Subject:* Re: [libreoffice-users] "Case" function equivalent in 
Calc


At long last I got this to work.  Syntax is "ISBLANK" and not
"ISEMPTY"
- aaa.  My Filemaker days are getting in my way.  
Replace

all "isempty" below with "ISBLANK" and it works perfectly now.

Carl


On 5/15/13 6:38 PM, Carl Paulsen wrote:
> So in the absence of a Case function, here's what I've done so
far as
> a calculated solution.  Note that the data I want to concatenate
is in
> cells U3, V3, W3, and X3.  In Y3, I put the following:
>
> =U3 & IF(NOT(isempty(U3)),";","") & V3 &
IF(NOT(isempty(V3)),";","") &
> W3 & IF(NOT(isempty(W3)),";","") & X3
>
> The idea is that I put together U3, a semicolon if U3 isn't
empty (and
> nothing if it is), V3 and a semicolon if V3 isn't empty, W3 and a
> semicolon if W3 isn't empty, and X3.  If any of the cells is 
empty,

> nothing will be added until the next cell that has data.
>
> Unfortunately, I'm getting a #NAME? error.  I'm assuming some
kind of
> syntax error.  Any words of wisdom?
>
> Thanks a ton all.
> Carl
>
>
>
> On 5/15/13 5:13 PM, Dan Lewis wrote:
>> On 05/15/2013 04:16 PM, Carl Paulsen wrote:
>>> Anyone know if there is an equivalent to the Filemaker Pro 
"Case"

>>> function?  It's kinda like the "IF" function but is simpler to
>>> concatenate multiple conditions. It basically says If
something is
>>> true then do what is specified, if the next thing is, then do
that,
>>> if the next thing is true, do that, etc.
>>>
>>> Here's what I need to do.  Take 4 columns and concatenate with a
>>> semi-colon between the values, but not string together two
>>> semi-colons consecutively.  Like:
>>>
>>> PhoneEmailMail -> Phone;Email;Mail
>>> Phone   

Re: [libreoffice-users] "Case" function equivalent in Calc

[Dave Liesse]

All I've ever been aware of is nested IF statements, which get to be a 
royal pain.  If there is a CASE equivalent (it's also present in just 
about any programming language), I'll be just as happy as you!


Dave



On 5/15/2013 13:16, Carl Paulsen wrote:
Anyone know if there is an equivalent to the Filemaker Pro "Case" 
function?  It's kinda like the "IF" function but is simpler to 
concatenate multiple conditions.  It basically says If something is 
true then do what is specified, if the next thing is, then do that, if 
the next thing is true, do that, etc.


Here's what I need to do.  Take 4 columns and concatenate with a 
semi-colon between the values, but not string together two semi-colons 
consecutively.  Like:


Phone Email Mail -> Phone;Email;Mail
Phone  Mail -> Phone;Mail
   Mail -> Mail
  EmailMail -> Email;Mail

So semi-colons only occur if there's a value present and not at all if 
there's only one value present.

I hope that makes sense and displays correctly.

Carl



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

[Dave Liesse]

As an end user, I'd like to ask one follow-up question to your third 
point.  This is an "I don't understand" type of question, by the way, 
not a challenge.


Are you implying that if I want to, say, indent one paragraph with no 
other changes, I should create a new style for that?  Seems like a lot 
of work since it can be done with one mouse clicks (or, if I ever get 
around to learning how to create shortcut keys, one keystroke 
combination) plus navigating to the paragraph.


(Just for the record, the indent and outdent keystrokes are probably the 
thing I miss most from MS Word, and there's not much that I miss.)


Dave




On 4/30/2013 12:40, Virgil Arrington wrote:

Several of the posts have brought me to thinking a few random thoughts.

1. There's a difference between *using* styles and *creating/editing* 
them. In the LyX/LaTeX world, as well as the HTML/CSS world, one is 
indeed forced to used styles (called "environments" in LaTeX speak) 
because that's the way the system works. The styles/environments are 
created by supposed experts who create document "classes," or 
templates. But, neither the classes nor the environments are easy to 
modify. The end-user selects the environment he wants (\chapter, 
\section, \quote, etc.) and then lets the program do the work. As one 
writer mentioned, it truly separates the operations of writing and 
typesetting/formatting. Markdown editors in the HTML world also allow 
such clean separation. None of the WYSIWYG word processors (Word, LO, 
OO, AbiWord, etc.) provide such a clean separation between editing and 
formatting. And, yet...


2. In the LyX/LaTeX world, it all works very well...until you want to 
modify a small formatting parameter for a specific paragraph. Yes, it 
can be done, but it's not intuitive, nor encouraged. Despite the 
advanced formatting capabilities of LyX or LaTeX, few writers use 
them, I believe in part because making even a small change from the 
default settings sometimes requires a massive on-line search for the 
right command to change.


3. In the Word/LO world, this case of the "one off" paragraph 
modification is where I see resistance to styles from end-users. I've 
got paragraph style for just about every possible situation, but there 
may be a single paragraph where a user wants to change one parameter. 
If the user doesn't understand styles, he'll just apply direct 
formatting to the paragraph, without creating and/or modifying a 
style. Thus, just having users write with templates and styles created 
by others will only take people so far. At some point in time, they 
will need to learn how to create and/or modify styles. Otherwise, 
they'll have documents with a mixture of styles and direct formatting, 
the beginning of what could grow into a mess. I believe AbiWord has 
(or had) a feature to "lock styles" meaning a person could be locked 
out of changing formatting directly. All formatting changes would have 
to go through styles. I'm sure it would be a maddening feature for the 
uninitiated, but it would encourage people to learn to do use styles 
in the "right" way.


4. Document collaboration is a real bugaboo. We lawyers share 
documents repeatedly. I would create a document using styles, and send 
it off to a colleague for further edits. I would get it back with a 
mess of styles and direct formatting. I see no answer to this 
conundrum, simply because our programs allow so many different ways of 
accomplishing the same tasks, and I couldn't expect a colleague to 
listen to my styles tutorial when all he wanted to do was make a small 
edit to my proposed contract.


5. I agree that LO's styles work much better than Word's. With LO, I 
can list my styles hierarchically, so I can change a parameter in one 
high level style and have it changed in all lower level styles based 
on the same higher style. (So, no, you don't have to change each and 
every style just to change the font throughout a document). Word has 
styles based on other styles as well, but I have yet to find a clean 
way to list them in the style box in a hierarchical manner.


Virgil






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

[Dave Liesse]

Just ran across it recently.  I've skimmed the whole thing but haven't 
had the time to read it in detail and apply the knowledge (I'm a tax 
professional, but the season doesn't end exactly on 15 April!).  Hope to 
find some time soon to devote to it.


Dave


On 4/29/2013 16:46, Dan Lewis wrote:

On 04/29/2013 05:10 PM, Dave Liesse wrote:
I'll admit to not using styles, but not so much because I don't want 
to.  I've been using the various word processing programs since PCs 
were first produced, before the concept of styles.  They came out 
shortly after, of course, but they got little or no attention in the 
limited technical press that I followed at the time.  By the time 
they were in widespread use, I was pretty well entrenched in my ways.


I've tried reading the documentation on them, but (a) I never have 
the time to sit down and actually learn them and (b) the 
documentation isn't all it could be -- this goes for MS as well as 
OO/LO.  The biggest problem I've had, and I still don't know the 
answer, is how to actually save the styles so they're available for 
any document.  I don't like any of the defaults, but don't see the 
point of creating a style that is usable only in one document, so I 
just do all the hard-formatting I need (which may take up more disk 
space, but it's also a lot more flexible as far as I can tell).


I'm slowly catching on, but it's going to be a while.
 Have you read chapter 3, Using Styles and Templates, of the 
Getting Started Guide? It was written using a template containing all 
the styles that were needed. I use the same template to write several 
chapters of the Base Guide. It also contains what I need even though 
the topics are vastly different.


--Dan




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

[Dave Liesse]

I'll admit to not using styles, but not so much because I don't want 
to.  I've been using the various word processing programs since PCs were 
first produced, before the concept of styles.  They came out shortly 
after, of course, but they got little or no attention in the limited 
technical press that I followed at the time.  By the time they were in 
widespread use, I was pretty well entrenched in my ways.


I've tried reading the documentation on them, but (a) I never have the 
time to sit down and actually learn them and (b) the documentation isn't 
all it could be -- this goes for MS as well as OO/LO.  The biggest 
problem I've had, and I still don't know the answer, is how to actually 
save the styles so they're available for any document.  I don't like any 
of the defaults, but don't see the point of creating a style that is 
usable only in one document, so I just do all the hard-formatting I need 
(which may take up more disk space, but it's also a lot more flexible as 
far as I can tell).


I'm slowly catching on, but it's going to be a while.




On 4/29/2013 11:00, Virgil Arrington wrote:

I'd like to get some general opinions about paragraph styles.

I am a retired lawyer who led a local government law office. When I 
was working at that office, I tried in vain to get my employees to use 
paragraph styles. For them, styles were a bother to set up and 
maintain. I love using them, but then I'm as much a word processor 
junkie as I am an end-user.


Now, I teach a paralegal course in technology at my local university. 
I recently spent three weeks teaching styles to my students and they 
have resisted me all the way. My sense is that people just trying to 
get their work done see paragraph styles as an nuisance, not 
appreciating the amount of time they can save by investing a little at 
the beginning.


What about the rest of you. Do you use styles? Do you find that other 
less-techy types avoid them?


It makes me wonder if there is a way to make them more accessible to 
people less inclined to invest time in their technology as opposed to 
getting a task done.


Virgil




--
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: Fwd: Re: [libreoffice-users] VLOOKUP for Numbers

[Dave Liesse]

I agree that the original question is a little confusing.  What 
everybody seems to have forgotten in their replies, though, is that if 
the lookup list is sorted then a non-match will be treated as if it 
matched the next lower value (for example, looking up 6 in a list of odd 
numbers will return the value from the row containing 5).  If you need 
to know that this is not an exact match, the value in that row can be 
compared to the search value.



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

[Dave Liesse]

Well, that's the kind of suggestion I'm looking for.  In Word, when I 
had to use it, outlines could be applied at the character level. I've 
never had to think about all the "hard" ways of doing it, so I 
appreciate this idea.


Dave


On 3/22/2013 14:36, T. R. Valentine wrote:

On 22 March 2013 16:19, Dave Liesse  wrote:

Thanks for the replies so far.  It occurs to me that I can be a little more
clear -- I'm just trying to do the equivalent of circling some text in a
Word document being sent to me.  This isn't for an original document.

Then why not use the Drawing toolbar to draw a rectangle (or other
shape) around the text, setting the fill to 100% transparency and the
line to the colour and weight of your choice?


--
T. R. Valentine
Your friends will argue with you. Your enemies don't care.
'When I get a little money I buy books; and if any is left I buy food
and clothes.' -- Erasmus




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

[Dave Liesse]

Thanks for the replies so far.  It occurs to me that I can be a little 
more clear -- I'm just trying to do the equivalent of circling some text 
in a Word document being sent to me.  This isn't for an original document.


Dave



On 3/22/2013 12:51, Regina Henschel wrote:

Hi Dave,

Dave Liesse schrieb:

One of the writers in the Windows Secrets newsletter recently compared
OO and LO to MS Office, and I have to agree with him when he implied the
LO web site is somewhat disorganized and confusing. Thus, this posting
that is probably an enhancement request, but I can't find anywhere else
to do such a thing.

I've used OO and LO for several years, and have found very little that I
did in Office that I can't do now.  One thing, though, is beyond the
nuisance level but short of being a game stopper.  I need the ability to
outline text within a paragraph.  I know a block of text can be
highlighted with a different background or foreground color, but I need
something that can actually be useful in a printed document. Sometimes
underlining is insufficient, because it's not distinguishable from other
underlined text.

As an example of what I want, just envision a box around "what I want"
in this sentence.  Obviously, outlining a paragraph doesn't do the 
trick.


Anyway, that's what I'd like to see sometime -- or, if I'm missing how
to do it now, somebody please let me know!


You can write the text into a frame and anchor this frame 'as character'.
You can write the text into a text box and anchor this shape 'as 
character'.

You can overline the text in addition to underline.

You can make nice typography and give up emphasizing with lines.

Kind regards
Regina





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

[Dave Liesse]

One of the writers in the Windows Secrets newsletter recently compared 
OO and LO to MS Office, and I have to agree with him when he implied the 
LO web site is somewhat disorganized and confusing. Thus, this posting 
that is probably an enhancement request, but I can't find anywhere else 
to do such a thing.


I've used OO and LO for several years, and have found very little that I 
did in Office that I can't do now.  One thing, though, is beyond the 
nuisance level but short of being a game stopper.  I need the ability to 
outline text within a paragraph.  I know a block of text can be 
highlighted with a different background or foreground color, but I need 
something that can actually be useful in a printed document.  Sometimes 
underlining is insufficient, because it's not distinguishable from other 
underlined text.


As an example of what I want, just envision a box around "what I want" 
in this sentence.  Obviously, outlining a paragraph doesn't do the trick.


Anyway, that's what I'd like to see sometime -- or, if I'm missing how 
to do it now, somebody please let me know!


Dave


--
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: Fwd: Re: [libreoffice-users] new version of LO gives gibberish for excel file.

[Dave Liesse]

It all depends on how your mail client (standalone or online) works.  
When a reply automatically posts to the list, Thunderbird has the 
standard "Reply" and "Reply All" options.  If the reply goes to the 
individual, they change to "Reply" and "Reply List."  This strikes me as 
being the most sensible approach.


Dave


On 3/6/2013 15:02, Tom Davies wrote:

Hi :)
It might be worth writing to the board-discuss list to let them know you are 
not happy with the way replies to the list work.  You are not alone in that!

Congrats about fixing your problem tho!  A tad weird but good to know you fixed 
it.  Nicely done! :)
Congrats and regards from
Tom :)





--
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] Managing Templates in Writer

[Dave Liesse]

Didn't even know about this one.  Have to admit that although I've had 
35+ years in the software world (mostly in data base design, data 
modeling, and quality assurance), when it comes to LibreOffice I'm just 
a plain old user and don't know about everything that's out there!


Yes, thanks, I got the problem solved (see my message sent just before 
yours).


Dave




On 2/27/2013 10:11, Tom Davies wrote:

Hi :)
Have you found the guides on
https://wiki.documentfoundation.org/Documentation/Publications
or just using the in-built help?  Both do lag a bit but the wiki-pages's 
Getting Started Guide is for the 4.0.0.  The chapters are all done but people 
are still proof-reading the full book.

Did you manage to solve the templates issue?
Regards from
Tom :)






____
From: Dave Liesse 
To: users@global.libreoffice.org
Sent: Tuesday, 26 February 2013, 0:58
Subject: [libreoffice-users] Managing Templates in Writer

I recently installed v4.0 (v4.0.0.3, to be exact) and, of course, all the setup I finally 
accomplished in v3.4 is gone.  My primary concern is the default style, which has 
reverted to .79" (2 cm) margins as the default. Being in the US, I'd rather have 
defaults of 1".

The help appears to be a bit behind the program, and I can't figure out how to save 
any changes so when I open a new document I get my 1" margins.  Here's what I 
have done so far:

1.  Change the margins, then save a new template named "Normal". This is 
insufficient, as it doesn't become my default template.

2.  Change the default page style, then re-save the "Normal" template.  Still 
no change.

3.  Try to make this my default template.  Help says go to File ... Templates 
... Organize, but File ... Templates doesn't exist.

4.  Go to Customize and try to add Manage Templates to the File menu.  This 
appears in the Customize area, but never shows up in the menu even after 
leaving the program and coming back (although it remains in Customize).

I'd guess I'm missing a step somewhere, but I can't find what it is.  Any ideas?

-- 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] Managing Templates in Writer

[Dave Liesse]

The actual path is simply File ... New ... Templates.  Certainly not an 
intuitive place to look for it if I want to manage existing templates!


Once I found this (with your help), it was a simple task to set my new 
"Normal" template as the default and it seems to have worked. Many thanks!


Dave



On 2/26/2013 01:17, Mirosław Zalewski wrote:

On 26/02/2013 at 01:58, Dave Liesse  wrote:


1.  Change the margins, then save a new template named "Normal". This is
insufficient, as it doesn't become my default template.

LibreOffice does not work this way. It's MS Office that assumes that Normal
template is default one.
Which may cause quite a headache when copying documents to other computers...


3.  Try to make this my default template.  Help says go to File ...
Templates ... Organize, but File ... Templates doesn't exist.

Go for File → New → From template
(or similar - I do not have English LO 4.0 at the moment to check actual
spelling).
New template manager will fire up, which gives you opportunity to change
default template.




--
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] Managing Templates in Writer

[Dave Liesse]

I recently installed v4.0 (v4.0.0.3, to be exact) and, of course, all 
the setup I finally accomplished in v3.4 is gone.  My primary concern is 
the default style, which has reverted to .79" (2 cm) margins as the 
default. Being in the US, I'd rather have defaults of 1".


The help appears to be a bit behind the program, and I can't figure out 
how to save any changes so when I open a new document I get my 1" 
margins.  Here's what I have done so far:


1.  Change the margins, then save a new template named "Normal". This is 
insufficient, as it doesn't become my default template.


2.  Change the default page style, then re-save the "Normal" template.  
Still no change.


3.  Try to make this my default template.  Help says go to File ... 
Templates ... Organize, but File ... Templates doesn't exist.


4.  Go to Customize and try to add Manage Templates to the File menu.  
This appears in the Customize area, but never shows up in the menu even 
after leaving the program and coming back (although it remains in 
Customize).


I'd guess I'm missing a step somewhere, but I can't find what it is.  
Any ideas?


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