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

2024-01-15 Thread 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

Re: [libreoffice-users] hyphenation

2022-12-15 Thread 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

Re: [libreoffice-users] Tab Bug?

2022-08-09 Thread Dave Liesse
guage 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 > > signif

[libreoffice-users] Tab Bug?

2022-08-08 Thread 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

Re: [libreoffice-users] Fill Series

2017-01-12 Thread 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

[libreoffice-users] Version 5.2.1.2 Questions

2016-11-30 Thread 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

Re: [libreoffice-users] Observations on LO v5.2.1.2

2016-10-14 Thread Dave Liesse
> 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 <dslie...@liessefamily.ne

Re: [libreoffice-users] Observations on LO v5.2.1.2

2016-10-14 Thread 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

[libreoffice-users] Observations on LO v5.2.1.2

2016-10-14 Thread 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

[libreoffice-users] Password-protected Excel file

2016-10-04 Thread 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

Re: [libreoffice-users] challenge...

2016-08-22 Thread 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

Re: [libreoffice-users] New LibreOffice Book

2016-03-25 Thread 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

Re: [libreoffice-users] Slow Loading a calc sheet

2016-03-15 Thread Dave Liesse
-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

Re: [libreoffice-users] Thunderbird potential as the official/default email-client for LO? Re: [board-discuss] BoD decision from 2015-10-05

2016-02-26 Thread Dave Liesse
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

Re: [libreoffice-users] Jumping cursor

2016-02-24 Thread Dave Liesse
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

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

2016-02-17 Thread 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

Re: [libreoffice-users] Re: Avery 8167 label printing

2016-02-09 Thread 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

Re: [libreoffice-users] Calc - Sorting - Alphabetically

2016-02-08 Thread 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

Re: [libreoffice-users] Save As bug

2015-12-17 Thread 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

Re: [libreoffice-users] Re: Supress address2 field if blank

2015-12-11 Thread Dave Liesse
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

Re: [libreoffice-users] LibreLogo tutorial

2015-12-04 Thread 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:

Re: [libreoffice-users] LibreLogo tutorial

2015-12-03 Thread 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

Re: [libreoffice-users] pptx files can't be opened when created with Impress 5.0.x

2015-10-11 Thread 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

Re: [libreoffice-users] Sorting help

2015-08-18 Thread 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

Re: [libreoffice-users] Shortcut for Recent documents

2015-08-11 Thread 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

Re: [libreoffice-users] [OT] Operating Environment Survey

2015-07-19 Thread Dave Liesse
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

Re: [libreoffice-users] LibreOffice's documentation (pdf and online)

2015-06-25 Thread 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

Re: [libreoffice-users] LibreOffice's documentation (pdf and online)

2015-06-24 Thread Dave Liesse
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

Re: [libreoffice-users] Basic Calc Question

2015-04-13 Thread 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

Re: [libreoffice-users] LibreOffice Sort Bug ?

2015-03-25 Thread 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

Re: [libreoffice-users] Re: Default printer issues in Writer

2014-06-10 Thread 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

Re: [libreoffice-users] paste into the edit box

2014-04-21 Thread 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

Re: [libreoffice-users] paste into the edit box

2014-04-21 Thread 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

Re: [libreoffice-users] Multiple columns in Writer

2014-03-31 Thread 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:

Re: [libreoffice-users] stop automatic scrolling

2014-03-21 Thread Dave Liesse
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

Re: [libreoffice-users] OT: Windows, sort text file, can I use LibO maybe?

2014-03-17 Thread 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

Re: [libreoffice-users]

2014-03-14 Thread 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

Re: [libreoffice-users] Change character attributes

2014-02-16 Thread 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

Re: [libreoffice-users] Calc: help with VLOOKUP

2014-02-14 Thread 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

Re: [libreoffice-users] Change character attributes

2014-02-14 Thread 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:

Re: [libreoffice-users] Calc: help with VLOOKUP

2014-02-10 Thread 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

Re: [libreoffice-users] Re: low traffic lately?

2014-01-28 Thread 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

Re: [libreoffice-users] Re: low traffic lately?

2014-01-28 Thread Dave Liesse
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

[libreoffice-users] Calc: Inline Formatting

2014-01-24 Thread 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

Re: [libreoffice-users] Mail Merge and Labels

2013-12-04 Thread Dave Liesse
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

Re: [libreoffice-users] email notifications

2013-12-04 Thread 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

Re: [libreoffice-users] email notifications

2013-12-03 Thread 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

Re: [libreoffice-users] Question

2013-11-27 Thread 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

[libreoffice-users] Exporting Impress Slide Show

2013-11-17 Thread 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

Re: [libreoffice-users] Picture size controls...

2013-10-29 Thread 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

Re: [libreoffice-users] Calc Function Wizard - IF Result differences

2013-10-21 Thread Dave Liesse
-- 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

Re: [libreoffice-users] Re: North America Pub Chat

2013-10-07 Thread 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

Re: [libreoffice-users] downloaded .doc file will only open as read-only

2013-09-28 Thread 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

Re: [libreoffice-users] spacing after punctuation

2013-09-05 Thread 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

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

2013-09-04 Thread 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

Re: [libreoffice-users] converting .odt to .doc

2013-08-21 Thread 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

Re: [libreoffice-users] converting .odt to .doc

2013-08-21 Thread Dave Liesse
release of MS Office such that one version sometimes messes up the documents created in another version. Regards from Tom :) *From:* Dave Liesse dslie...@liessefamily.net *To:* users@global.libreoffice.org

[libreoffice-users] Impress: Sound Links

2013-08-20 Thread 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

Re: [libreoffice-users] Impress: Sound Links

2013-08-20 Thread Dave Liesse
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

Re: [libreoffice-users] Failed mail

2013-08-17 Thread 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

Re: [libreoffice-users] Can't find setting

2013-08-15 Thread 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

Re: [libreoffice-users] Can't find setting

2013-08-15 Thread 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.

Re: [libreoffice-users] LO 4 install deletes 3.6

2013-07-24 Thread 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

Re: [libreoffice-users] Calc - allow users to format cells on protected sheets

2013-07-18 Thread 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

Re: [libreoffice-users] Spell check not working on 3x5 flash cards

2013-07-01 Thread 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

[libreoffice-users] Style Question (Similar to Helen's, for Plays)

2013-06-26 Thread 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

Re: [libreoffice-users] Style Question (Similar to Helen's, for Plays)

2013-06-26 Thread 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

Re: [libreoffice-users] Style Question (Similar to Helen's, for Plays)

2013-06-26 Thread 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

Re: [libreoffice-users] advanced notes question

2013-06-25 Thread 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

Re: [libreoffice-users] Replying to users

2013-05-22 Thread 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

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

2013-05-16 Thread 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

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

2013-05-15 Thread 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

Re: [libreoffice-users] Paragraph styles

2013-04-30 Thread 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

Re: [libreoffice-users] Paragraph styles

2013-04-29 Thread 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

Re: [libreoffice-users] Paragraph styles

2013-04-29 Thread Dave Liesse
: 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

Re: Fwd: Re: [libreoffice-users] VLOOKUP for Numbers

2013-03-25 Thread 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

[libreoffice-users] Text Outlining

2013-03-22 Thread 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

Re: [libreoffice-users] Text Outlining

2013-03-22 Thread 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

Re: [libreoffice-users] Text Outlining

2013-03-22 Thread Dave Liesse
:19, Dave Liesse dslie...@liessefamily.net 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

Re: Fwd: Re: [libreoffice-users] new version of LO gives gibberish for excel file.

2013-03-06 Thread 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

Re: [libreoffice-users] Managing Templates in Writer

2013-02-27 Thread Dave Liesse
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 dslie...@liessefamily.net To: users@global.libreoffice.org Sent: Tuesday

Re: [libreoffice-users] Managing Templates in Writer

2013-02-26 Thread Dave Liesse
On 2/26/2013 01:17, Mirosław Zalewski wrote: On 26/02/2013 at 01:58, Dave Liesse dslie...@liessefamily.net 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

[libreoffice-users] Managing Templates in Writer

2013-02-25 Thread 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