Re: [libreoffice-users] lines and movement with arrow keys

2022-03-10 Thread Carl Paulsen
underlining won't work. I've been using LO for MANY years and early on (perhaps it was before the split with OpenOffice) tab spaces didn't underline.  I stupidly just assumed it still worked that way.  Egg on my face. But I really appreciate the support from this group! Carl On 3/10/22 12:21 AM

Re: [libreoffice-users] lines and movement with arrow keys

2022-03-09 Thread Carl Paulsen
Wow, thank you Regina.  I will look into all of this, but it sounds like it addresses my concerns. Carl On 3/9/22 5:26 PM, Regina Henschel wrote: Hi Carl, Carl Paulsen schrieb am 09.03.2022 um 23:00: I have inserted a line into a text document and have a few questions. First, I need

[libreoffice-users] lines and movement with arrow keys

2022-03-09 Thread Carl Paulsen
I have inserted a line into a text document and have a few questions.  First, I need to make sure it is horizontal.  Is there a way to ensure it is perfectly horizontal and won't print with the offsets for diagonal placement? I am unable to see if it is perfect.  I have done this in the past

Re: [libreoffice-users] Reduce white space between chart border and chart

2019-06-12 Thread Carl Winerich
To:users@global.libreoffice.org Cc:Carl Winerich At 15:42 12/06/2019 -0400, Carl Winerich wrote:How can I reduce the amount of white space between a chart and the border/margin around it?I'm not sure you can. But what you can do, with the same effect, is to use Format

[libreoffice-users] Reduce white space between chart border and chart

2019-06-12 Thread Carl Winerich
How can I reduce the amount of white space between a chart and the border/margin around it? Thanks, Carl -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

[libreoffice-users] Message body messed up appearance

2019-06-08 Thread Carl Winerich
How in the world do I fix the message body appearance so it doesn't return the message disorganized and jumbled together? Thanks, Carl -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how

[libreoffice-users] Fwd: Formula returns incorrect result

2019-06-08 Thread Carl Winerich
No idea how this gibberish got returned I'm trying to calculate the Equation of Time (EoT) to determine the difference between LAN (Local Apparent Noon) and GMT/UT-1  Greenwich Mean Time.  Then I want to plot the EoT curve (a project for later, not

[libreoffice-users] Formula returns incorrect result

2019-06-08 Thread Carl Winerich
I'm trying to calculate the Equation of Time (EoT) to determine the difference between LAN (Local Apparent Noon) and GMT/UT-1  Greenwich Mean Time.  Then I want to plot the EoT curve (a project for later, not now)The following is the formula I use on my calculator.  The

Re: [libreoffice-users] Tabs in selection of text

2019-04-12 Thread Carl Paulsen
only book-like paragraphs) and trying to apply tabs to those.  If I repeatedly use a specific format, I'd definitely consider Styles.  But there seem to be a lot of complicated considerations for using Styles (the nesting/heirarchy topics I mentioned in my other reply). Anyway, thank you. Car

Re: [libreoffice-users] Tabs in selection of text

2019-04-12 Thread Carl Paulsen
just don't see that happening.  And at least in my circles, it's use has dropped off significantly. Carl On 4/8/19 4:44 PM, Dan Lewis wrote: On 4/3/19 8:37 PM, Carl Paulsen wrote: I have a number of "paragraphs" of text (job listing section of a resume) for which I'd like to add

Re: [libreoffice-users] Tabs in selection of text

2019-04-08 Thread Carl Paulsen
LO 6.0.5.2 on Mac Sierra (10.12.6) In some cases I can click into a line and set tabs normally.  In the document where I had the problem I believe it was a bulleted list or indented text (hanging indent I think) where I was having the problem.  I opened the document today and quickly tried it

Re: [libreoffice-users] Tabs in selection of text

2019-04-07 Thread Carl Paulsen
On 4/7/19 12:55 PM, Brian Barker wrote: At 20:37 03/04/2019 -0400, Carl Paulsen wrote: I have a number of "paragraphs" of text (job listing section of a resume) for which I'd like to add tab stops. Are these true paragraphs? I'm not sure why you have given the word sc

[libreoffice-users] Tabs in selection of text

2019-04-03 Thread Carl Paulsen
I have a number of "paragraphs" of text (job listing section of a resume) for which I'd like to add tab stops.  I select the lines and click the tab stop I want, then click in the ruler, but nothing happens.  I see no menu item to format tabs, though I did stumble into one dialog box with Tabs

Re: [libreoffice-users] Auto recovery problem

2019-02-06 Thread Carl Paulsen
Thanks for this suggestion.  I'll try it next time I notice the problem (which could be soon since I'm not convinced I've fixed it). Carl On 2/4/19 8:09 PM, Girvin Herr wrote: Carl, I have experienced this endless auto-recovery on startup problem before. Whenever I got it, I "rese

Re: [libreoffice-users] Mailing labels from mail merge

2019-02-04 Thread Carl Paulsen
more simple and reliable. Carl On 2/4/19 6:53 PM, Carl Paulsen wrote: Hi Wayne, This is off list so I should probably post this to the support list, but after  a while of fiddling around, removing the databases I'd registered (Tools | Options | Base | Databases), closing LO, and then re

Re: [libreoffice-users] Auto recovery problem

2019-02-04 Thread Carl Paulsen
is happening is the documents get saved and closed, and then there's some kind of flag in the file that didn't get reset by the save, which marks it as damaged/needing recovery.  So it triggers the auto-recovery system even when it's not needed. Carl On 2/4/19 6:06 PM, Dan Lewis wrote: Two

[libreoffice-users] Auto recovery problem

2019-02-04 Thread Carl Paulsen
t when I'm showing friends and clients. Carl -- 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 arch

[libreoffice-users] Mailing labels from mail merge

2019-02-04 Thread Carl Paulsen
I'm trying to build a set of "Avery 5160" labels to match the letters I'm printing via mail merge, using the same spreadsheet data source.  When I select Mailing Labels as the new document type, I am presented with a drop-down list of databases.  I've registered the spreadsheet during the

Re: [SUSPECT] Re: [libreoffice-users] date, day number, week number in one cell

2018-07-12 Thread Carl Winerich
-of-the-year in there. Thank you, all, for your efforts. Carl   On 07/12/2018 04:12 AM, Brian Barker wrote: > At 19:30 11/07/2018 -0400, Carl Winerich wrote: >> It's back to the same old question; ... > > Indeed so - and the answer is very much the same as on the previous > two

Re: [SUSPECT] Re: [libreoffice-users] date, day number, week number in one cell

2018-07-12 Thread Carl Winerich
On 07/12/2018 04:12 AM, Brian Barker wrote: At 19:30 11/07/2018 -0400, Carl Winerich wrote:It's back to the same old question; ...Indeed so - and the answer is very much the same as on the previous two occasions you have asked this.In a calendar, how can I put the day's

Re: [libreoffice-users] date, day number, week number in one cell

2018-07-11 Thread Carl Winerich
number of the month. Here’s a link to the Calc calendar template I’m trying to use- https://extensions.libreoffice.org/templates/calendar-creator The template is very useful and I don’t want to interfere or mess up the calendar creation- which it does perfectly. Thank you, Carl

[libreoffice-users] date, day number, week number in one cell

2018-07-11 Thread Carl Winerich
don’t want to interfere or mess up the calendar creation- which it does perfectly. Thank you, Carl -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + m

Re: [libreoffice-users] Can't edit array

2018-06-27 Thread Carl Winerich
On 06/27/2018 02:03 PM, Brian Barker wrote: At 12:45 27/06/2018 -0400, Carl Winerich wrote:I have a spreadsheet; Calendar.ods, that refers to (or is linked) another spreadsheet; Begin_Here (copy).ods. When I try to expand the range of the of Begin_Here (copy

[libreoffice-users] Can't edit array

2018-06-27 Thread Carl Winerich
it by using ctrl-/ then F2 works but the same error message appears. Here's the complete array found in Calendar.ods; ='file:///home/Carl/My Documents/Calendar/Begin_Here (copy).ods'#$Sheet1.A1:E75 How can I expand the range? Thank you, Carl -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] Two formulas in one cell?

2018-06-02 Thread Carl Winerich
returned for the first formula even though the cell is formatted as a D. How can these format requirements be maintained? Thanks, Carl On 06/02/2018 06:10 PM, Brian Barker wrote: > At 17:20 02/06/2018 -0400, Dotty Carl Noname wrote: >> In cell A2 the following formula is plac

Re: [libreoffice-users] Calc SLOW with filtering large data set

2018-02-20 Thread Carl Paulsen
le with memory management but there was no option for memory management that I could find. I don't know if that's intentional or a bug, but I thought I should mention it. Again, that is in v.6.0.1. Carl On 2/19/18 11:07 PM, Carl Paulsen wrote: OK, a little more info. I just ended up trying the s

Re: [libreoffice-users] Calc SLOW with filtering large data set

2018-02-19 Thread Carl Paulsen
on a Windows 10 machine but so fast when running LO 5 on a Windows 7 machine? And is there any connection to Excel being so slow on both machines? Thx On 2/19/18 10:49 PM, Carl Paulsen wrote: I work with large spreadsheets and have used both Excel and Calc in the past. I have a large file with 10

[libreoffice-users] Calc SLOW with filtering large data set

2018-02-19 Thread Carl Paulsen
I work with large spreadsheets and have used both Excel and Calc in the past. I have a large file with 10 or so sheets, many of which are large and one has just over 35,000 records. In this sheet there is a field that is boolean (0 or -1). When I filter on this field in Excel it takes

Re: [libreoffice-users] Excel file .xls not opening properly

2015-03-10 Thread Carl Paulsen
on the Windows machine but I guess I hadn't checked this third one. My hint (inspired by your reply) was that TextEdit on a Mac thought the file was empty except for two blank lines. That program can usually open any file, so there was clearly something odd going on. Carl On 3/10/15 5:09 AM

Re: [libreoffice-users] Calc formula ...

2015-03-10 Thread Carl Paulsen
Wow, excellent suggestions Brian. Your ideas are always spot on. Thanks. Carl On 3/10/15 4:08 AM, Brian Barker wrote: At 19:20 10/03/2015 +1300, David Love wrote: I have a three column spreadsheet. Column A. Date - The dates are consecutive Column B. Production - The Production has a daily

Re: [libreoffice-users] Your message to LibreOffice awaits moderator approval

2014-06-27 Thread Carl Paulsen
://lists.freedesktop.org/mailman/confirm/libreoffice/2bda60b63da22656939eec470ed36b22e6552623 This message is NOT useful. Whom is it for and why was it sent to the entire list? Tom - moderator -- Carl Paulsen -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http

Re: [libreoffice-users] Calc worksheet stalls when opening

2014-03-14 Thread Carl Paulsen
Tom, This was indeed a helpful post (beyond just this thread). I didn't know it worked that way and didn't realize it could get corrupted. Nice to know! Carl On 3/13/14 9:17 AM, Tom Davies wrote: Hi :) Ok, so it's probably something in the upgrade or in the User Profile. Easiest one

Re: [libreoffice-users] vlookup not working

2014-03-07 Thread Carl Paulsen
Thanks, Brian. I finally got a chance to look at this, and it appears it was, in fact, formatted to text (though I can't figure out how that would have happened b/c I didn't do anything before setting up the formula). When I set it to General, it worked. I appreciate your help! Carl

[libreoffice-users] vlookup not working

2014-03-06 Thread Carl Paulsen
appreciated. -- Carl Paulsen -- 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

Re: [libreoffice-users] Re: Reply-To?

2014-03-04 Thread Carl Paulsen
if we're even using the same software! Maybe there's a difference between my Mac version and whatever you are using? Carl On 3/4/14 11:48 AM, Tanstaafl wrote: On 3/4/2014 10:37 AM, Tanstaafl tansta...@libertytrek.org wrote: On 3/3/2014 9:12 PM, Carl Paulsen carlpaul...@comcast.net wrote

Re: [libreoffice-users] Re: Reply-To?

2014-03-04 Thread Carl Paulsen
, but that shouldn't be too hard to learn (I'm not THAT old of a dog...). Thanks again. Carl On 3/4/14 2:31 PM, John Mary Linge wrote: On 3/4/14, 1:51 PM, Carl Paulsen wrote: I still see no Smart Reply but in the email window itself there is the Reply Lists button, which I will be trying to use. I

Re: [libreoffice-users] Re: Reply-To?

2014-03-03 Thread Carl Paulsen
Tanstaafl, where is the smart reply button? I'm running T-Bird 24.3.0 (latest update for me) and see no such button. I have either Reply or Reply to List, but no smart button and no preference or option for such a button that I can find. I'm on a Mac. Sure would be helpful. Carl On 3/3

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

2014-02-14 Thread Carl Paulsen
want to or can't sort the array, be sure to set sort order to 0 or FALSE. HTH, Carl On 2/14/14 3:55 PM, 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

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

2014-02-10 Thread Carl Paulsen
me know if you want me to send you the sample file directly (I won't do so until I hear from you). If others want to see it too, let me know and I'll just post to Nabble (I don't think I have an account yet, but will figure it out). Carl On 2/10/14 4:00 PM, Dave Liesse wrote: The first

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

2014-02-10 Thread Carl Paulsen
clarify. Again, I can post this if it helps. Carl On 2/10/14 10:07 PM, Carl Paulsen wrote: OK, the item that you want to look up to return the price or name needs to be in both spreadsheets (otherwise you won't find a match!). IF (big IF here) the ID# and item code are the same for each item

[libreoffice-users] MS Office woes

2014-02-07 Thread Carl Paulsen
frustrations with LO users. To be fair, there are a few minor things I've appreciated in MSO, but the frustrations are legion. -- Carl Paulsen Dover, NH 03820 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] MS Office woes

2014-02-07 Thread Carl Paulsen
). -- Carl Paulsen Dover, NH 03820 -- 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] MS Office woes

2014-02-07 Thread Carl Paulsen
to the general user, even if it IS true. Again, specific examples help. Carl On 2/7/14 10:47 PM, null wrote: Hello, I thought I should add to the rant: If you think Microsoft Excel not being able to import formats it exports is bad, consider Microsoft's disastrous OpenXML standards

Re: [libreoffice-users] MS Office woes

2014-02-07 Thread Carl Paulsen
I suppose you're right. With some work I could have found a workaround, and I appreciate your idea. My issue is much more about the way MSO is set up by default, and changes to that are not especially apparent. But your point is well taken. Carl On 2/7/14 11:26 PM, marianne-x wrote: On 2

Re: [libreoffice-users] Need help with a calculation for an auction

2014-02-06 Thread Carl Paulsen
Let's not forget the Pivot Table option, though I know that wasn't the option you were thinking of. On 2/6/14 5:17 PM, Paul wrote: I seem to recall your question, and I think you're looking for Subtotals under the Data menu. 1. Sort by name 2. Subtotals on the Data menu Paul On Thu, 06

Fwd: Re: [libreoffice-users] Calc question

2014-01-24 Thread Carl Paulsen
: Carl Paulsen carlpaul...@comcast.net Reply-To: cpaul...@alumni.middlebury.edu To: Alan B abo...@gmail.com Isn't this the role of the pivot table? That could provide a total for both number (of purchases) and total of price if set up correctly. Maybe I'm missing something here

Re: Fwd: Re: [libreoffice-users] Calc question

2014-01-24 Thread Carl Paulsen
. Carl On 1/24/14 11:53 AM, Pikov Andropov wrote: What's a pivot table? Pointers to introductory tutorials will be appreciated. Thanks. Original Message Subject:Re: [libreoffice-users] Calc question Date: Fri, 24 Jan 2014 07:50:14 -0500 From: Carl Paulsen

Re: [libreoffice-users] Help needed with LibreOffice Calc 4.1.3.2

2014-01-21 Thread Carl Paulsen
Hi Tom, You can try View-Value Highlighting for the email column. That works on my Mac running LO 4.1.4. But it still leaves the gray cell background fill. As for gridlines, I don't know if that can be done. Carl As for the gridlines, On 1/20/14 9:29 PM, Tom Williams wrote: Hi

Re: [libreoffice-users] Re: Connection to SQL database

2014-01-17 Thread Carl Paulsen
that lets me start Apache and MySQL but there's no PHPMyAdmin option available and no apparent way to launch it from the start button. I'm reinstalling now in case I screwed up the first installation. I hope that works. Cheers, Carl On 1/17/14 5:55 AM, Alex Thurgood wrote: Le 16/01/2014 14:45

Re: [libreoffice-users] Re: Connection to SQL database

2014-01-17 Thread Carl Paulsen
, but next I've been given a 250MB file to open then export! In any case, it ended up being easier to just work within MySQL and phpMyAdmin for this purpose, but I'll try to use Base to connect over the weekend just to learn it. Anyway, thanks again, especially to Alex and Jay. Carl On 1/17/14 1

Re: [libreoffice-users] Re: Connection to SQL database

2014-01-16 Thread Carl Paulsen
for the tome. Carl On 1/16/14 5:41 AM, Tom Davies wrote: Hi :) Hmmm, actually i've only just realised that a 2nd grab from the 'proprietary' back-end data-tables might not be such a nightmare. Just keep a copy of the current export as it is so that the new grab can be compared against it. Any

[libreoffice-users] Connection to SQL database

2014-01-15 Thread Carl Paulsen
? Thanks very much, Carl -- Carl Paulsen Dover, NH 03820 -- 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] Connection to SQL database

2014-01-15 Thread Carl Paulsen
, Carl On 1/15/14 12:11 PM, Jay Lozier wrote: Carl Backend is a database term that refers to the database itself such as MySQL, JET (MS Access), SQL Server, etc. Most non DBA's refer to the GUI tools (BASE, Access) as the database when in fact they are used to connect various backends. Base

Re: [libreoffice-users] Connection to SQL database

2014-01-15 Thread Carl Paulsen
, either in MySQL or in Base or Access. But I need to figure out how to do that in such a way that I can assess what data is there and export into a csv file. Thanks again. Any more help is always appreciated. Carl On 1/15/14 2:43 PM, Jay Lozier wrote: Carl SQL is the query language used

Re: [libreoffice-users] Re: Connection to SQL database

2014-01-15 Thread Carl Paulsen
Sent to just Alex T by mistake: On 1/15/14 1:41 PM, Carl Paulsen wrote: OK, this is VERY helpful. I decided to try reading the file in a text editor and that was instructive! The file is about 13MB, and from a quick read through, the vast majority seems to be actual data in a kind of comma

Re: [libreoffice-users] Re: Connection to SQL database

2014-01-15 Thread Carl Paulsen
,'03718C','MEMBERSHIP0','NONE','CRD','NUL','','NONE','','',1,1,NULL,NULL,'2008-05-14 15:39:14','jessi','2008-08-07 17:17:40','george'),(2,467,NULL,'2007-06-11',35.00,'04379C','MEMBERSHIP0','NONE','CRD','NUL','','NONE','','', -- Carl Paulsen Dover, NH 03820 -- To unsubscribe e-mail to: users

[libreoffice-users] Auto save didn't work?

2014-01-14 Thread Carl Paulsen
). -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- 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

Re: [libreoffice-users] Counting Instances

2013-12-29 Thread Carl Paulsen
and change the function from sum to count. OK Using a pivot table has the advantage, that you do not need to know beforehand, which song titles are contained in the list. Kind regards Regina -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- To unsubscribe e-mail to: users

[libreoffice-users] Multi-test IF statement in Calc

2013-09-18 Thread Carl Paulsen
in two columns meaning the record shows up in both tables. I can't figure out the syntax for this. I've tried IF(AND(A1#NA; B1#NA),1,0) on both the vlookup formula columns and on columns that are pasted without formulas. No luck yet. Can someone chime in on this? Many thanks in advance. -- Carl

[libreoffice-users] Grouping objects in Draw

2013-09-08 Thread Carl Paulsen
, and they all seemed to become a part of some kind of group. I can then copy and paste that group, but I can't re-size the group as a whole. I essentially want to group each object into one so that it gets treated as if it were one object, not three. Can anyone help? Thanks, -- Carl Paulsen Dover, NH

Re: [libreoffice-users] Mail merge manual field entry

2013-08-22 Thread Carl Paulsen
Thanks, Tom. I've been away for a while. These links are handy, but on a quick look don't answer my questions. But...I'll keep looking. Carl On 8/17/13 6:27 AM, Tom Davies wrote: Hi :) I am not certain how to do this but it 'should' be fairly easy. it probably isn't but it should

Re: [libreoffice-users] Re: Mail merge manual field entry

2013-08-22 Thread Carl Paulsen
or a connected dB for someone who knows a little more. Carl On 8/19/13 4:38 AM, Alex Thurgood wrote: Le 12/08/2013 22:12, Carl Paulsen a écrit : Hi Carl, 1) Create a Writer document template with the size of the label you require or use one of the pre-supplied label formats provided with LO. 2

Re: [libreoffice-users] More mail merge help needed

2013-08-22 Thread Carl Paulsen
to make it actually function as a merge document. Carl On 8/15/13 10:29 AM, Paul D. Mirowsky wrote: I am not an expert, but I do have a question. Does Salesforce have a database connector that will allow you to use LibreOffice Base as an intermediary to your Writer document? Paul On 8

Re: [libreoffice-users] More mail merge help needed

2013-08-22 Thread Carl Paulsen
to non-profits for Salesforce and simple mail merges are a key concern. Salesforce has it's own weaknesses in that realm, but it's what I/we are stuck with. I'm working on learning all I can about it so I can speak with authority on more than just MSO. Thanks, Carl On 8/22/13 10:21 PM

[libreoffice-users] More mail merge help needed

2013-08-14 Thread Carl Paulsen
connected. Finally, I've been through a lot of documentation so if there's a good mail merge document online, that might be enough. -- Carl Paulsen Dover, NH 03820 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

[libreoffice-users] Mail merge manual field entry

2013-08-12 Thread Carl Paulsen
any way to do this. Is there a way? Also, Salesforce provides some templates for the merges and I can see what I need to do, but the fields they provide in their templates are not relevant to what I need, and I can't replace their merge fields with the ones I do need. Thanks. -- Carl

Re: [libreoffice-users] Mail merge manual field entry

2013-08-12 Thread Carl Paulsen
just to edit that document. That function might also allow me to hand-enter field names for this merge document. Carl On 8/12/13 4:12 PM, Carl Paulsen wrote: Hi all, I need to create a mail merge that will, I hope, be used with Salesforce for mail merge communications. I need to create

Re: [libreoffice-users] Error in Calc custom formats between closing and opening a file

2013-07-09 Thread Carl Paulsen
All box first). This will paste the data and not the formula. Carl On 7/9/13 8:11 PM, Paul wrote: Hi Regina, Terribly sorry about the delay in following up on your suggestions. I didn't mean to just disappear like that. It's been a bit hectic here, and I haven't had time to try

Re: Re: [libreoffice-users] Re: Info from 3 cells merged into 1 - was [libreoffice-users] Error in Calc custom formats between closing and opening a file -

2013-07-09 Thread Carl Paulsen
Arrgghhh. This was supposed to be a reply to the Re: Info from 3 cells merged into 1 thread. Sorry! On 7/9/13 8:31 PM, Carl Paulsen wrote: I sent the following, but apparently not to the list: Well, if all you need is to manually copy and paste, then copy the cells, move to the other

Re: [libreoffice-users] Info from 3 cells merged into 1

2013-07-08 Thread Carl Paulsen
And then, in the interest of being complete, you of course need to copy and paste that formula to all relevant rows... Carl On 7/8/13 1:46 PM, Steve Edmonds wrote: Hi. In the cell D1 where you want the result, you use =CONCATENATE(A1,B1,C1). Steve On 2013-07-09 05:31, Marino

Re: [libreoffice-users] To the moderators

2013-05-29 Thread Carl Paulsen
FWIW, I did not see Sharon's message come through the email version (just checked my inbox and trash and didn't find a message with that subject). But...I seem not to get all messages. I recently missed at least some of a thread on AppleWorks file conversion, but I got some of them. Carl

Re: [libreoffice-users] Re: appleworks tests

2013-05-24 Thread Carl Paulsen
separately so wonder if it's packaged with AppleWorks 6. Can't any docs be saved that way and re-opened in LO or just about anything else? With a quick test on an AW text document fomatted to print envelopes, the conversion worked quite well, keeping page settings intact. -- Carl Paulsen On 5

[libreoffice-users] Save As behavior

2013-05-22 Thread Carl Paulsen
use Save As - anyone know of this? At some point I may post a feature request, but wonder if others would like to see such behavior or know why it wouldn't work. Thanks. -- Carl Paulsen -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org

Re: [libreoffice-users] Save As behavior

2013-05-22 Thread Carl Paulsen
file was open and made a mistake resulting in too much lost data. I do think this issue cold be handled better, and would be ideal if the user could choose how LO worked with Save As. But again, maybe there's a reason I don't know about that forces it to work the way it does. -- Carl Paulsen

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

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

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

2013-05-16 Thread Carl Paulsen
. But I didn't have them and didn't want to add them. On 5/16/13 3:28 PM, mcmurchy1917-libreoff...@yahoo.co.uk wrote: Just a quick question. What happens if any of the fields already contains a semi-colon? Iain On Thursday 16 May 2013 10:23:23 Carl Paulsen wrote: Hi Tom. Well, not quite

[libreoffice-users] Case function equivalent in Calc

2013-05-15 Thread Carl Paulsen
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 -- Carl Paulsen -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http

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

2013-05-15 Thread Carl Paulsen
Another way to state this is I'd like a Columns to Text function, but where I can specify semi-colon as the separator and it won't place two separators together consecutively. Thanks again, Carl On 5/15/13 4:16 PM, Carl Paulsen wrote: Anyone know if there is an equivalent to the Filemaker

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

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

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

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

[libreoffice-users] Sort problems

2013-05-14 Thread Carl Paulsen
. Since I'm using vlookup a bunch, with static references (to work properly in my case), this re-sorting will screw up the entire file. I can't afford the time to recreate the vlookups each time I sort. I didn't have latter this problem under 3.x.x Carl -- Carl Paulsen 8 Hamilton Street Dover

[libreoffice-users] Trouble opening Excel file fixed in 4.0.3

2013-05-13 Thread Carl Paulsen
, you might try this. -- Carl Paulsen -- 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] Table of Contents woes

2013-05-10 Thread Carl Paulsen
intentionally use. Thanks, Carl On 5/10/13 2:16 AM, Tom Davies wrote: Hi :) Have you been able to manually edit it? It does look as though something is very wrong. It looks like 2 styles have been applied to each heading. First as a sub-heading and then as a main heading. Sometimes

[libreoffice-users] Table of Contents woes

2013-05-09 Thread Carl Paulsen
: Fundraising History Annual Fund Auction Etc. ToC screen grab (I've inserted a screen-shot image here but not sure it'll get through to the group.) Any idea what's going on and how I can fix it? Thanks so much. -- Carl Paulsen Dover, NH -- To unsubscribe e-mail to: users+unsubscr

Re: [libreoffice-users] VLOOKUP for Numbers

2013-03-27 Thread Carl Paulsen
/A. Then I fixed it and it works. Thanks Brian. Excellent little exercise for me to learn more about VLOOKUP. Carl On 3/26/13 12:48 AM, Brian Barker wrote: At 21:17 25/03/2013 -0700, Jason C. Wells wrote: OK. Take two. Since VLOOKUP for numbers with an inequality is not meaningful

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

2013-03-25 Thread Carl Paulsen
from another column returned where there ISN'T a match, you'll have to specify how the spreadsheet would identify that value. A small spreadsheet might help if you show us what you'd LIKE to see returned. But make sure it's pretty small so we can see any patterns easily. -- Carl Paulsen

[libreoffice-users] Help! Sheets tab not showing in Calc

2013-03-13 Thread Carl Paulsen
think of anything else that would cause this, nor how to access the other sheets. Help please! Thanks! Carl -- 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

Solved: Re: [libreoffice-users] Help! Sheets tab not showing in Calc

2013-03-13 Thread Carl Paulsen
, hiding the sheet tabs. I simply clicked the left edge of the bottom scroll bar and dragged to the right to uncover the tabs. Not sure how that happened, but it's working now. Whew! Thanks, Carl On 3/13/13 1:07 PM, Carl Paulsen wrote: LibreOffice 3.5.6.2 Mac OS 10.6.8 I have a spreadsheet

Re: [libreoffice-users] Problem loading and saving XLS files

2013-02-26 Thread Carl Paulsen
don't see a build for Mac OS and I always have LOTS of trouble building from source code. I may try it eventually, though, so thanks. It certainly sounds interesting. Carl On 2/26/13 6:44 AM, Tom Davies wrote: Hi :) I'm just wondering if Gnumeric might be better at opening the file? Calc

[libreoffice-users] Problem loading and saving XLS files

2013-02-25 Thread Carl Paulsen
but it's complete (all 21000 records). -- Carl Paulsen Dover, NH 03820 -- 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

[libreoffice-users] crash recovery odd behavior

2013-01-10 Thread Carl Paulsen
closed every time I open LO. They of course fail each time. I've looked for a setting to clear out the list of files that crashed, but can't find it. Is this by design? If so, can I somehow clear out the file list so it opens normally? Thanks, Carl -- Carl Paulsen 8 Hamilton Street Dover

Re: [libreoffice-users] crash recovery odd behavior

2013-01-10 Thread Carl Paulsen
OK, 3 people suggested cancel. I tried that , then restarted LO and, lo and behold, it bypassed the recovery routine. I'm assuming it will work this way even after rebooting, so I think my question has been solved. Thank you so much everyone. Carl On 1/10/13 7:13 PM, webmaster

Re: [libreoffice-users] Formulas in Calc not showing results

2012-12-14 Thread Carl Paulsen
it for the entire OS). I do hope to look into Linux and the like one day... Cheers, Carl With Ubuntu there is some setting that allows you to make the start-up procedure open up everything that you had open when you shut-down. There might be something similar on Mac but i don't know of good

Re: [libreoffice-users] Formulas in Calc not showing results

2012-12-13 Thread Carl Paulsen
case, obviously re-starting or re-booting didn't matter. This is all a lot more complicated that just re-booting. Cheers, Carl On 12/13/12 1:39 AM, Tom Davies wrote: Hi :) Lol, +1 Even on GnuLinux distros (mainly Ubuntu ime tbh) it's a good plan to do a reboot to ensure that services

[libreoffice-users] Formulas in Calc not showing results

2012-12-12 Thread Carl Paulsen
LO = 3.5.6.2 for Mac OS 10.6 AutoCalculate is on I'm trying to build a simple text concatenation (forumula is =CONCATENATE(Dear ,Q2), though I also tried it as =Dear Q2). The formula only shows as the text of the formula, not the result of the formula. Using the formula builder, it shows

Re: [libreoffice-users] Formulas in Calc not showing results

2012-12-12 Thread Carl Paulsen
on. Restart the software or reboot the computer sometimes helps these odd glitches. Carl On 12/12/12 3:45 PM, Brian Barker wrote: At 12:10 12/12/2012 -0500, Carl Paulsen wrote: I'm trying to build a simple text concatenation (formula is =CONCATENATE(Dear ,Q2), though I also tried it as =Dear Q2

Re: [libreoffice-users] Re: OpenOffice to be dumped in Freiburg ?

2012-11-19 Thread Carl Paulsen
is a good example) that is easily found? I've seen some general lists of how to contribute, but I haven't searched much for more specifics. In any case it should probably be front and center on the website (again, not the develop, donate $$, etc. generic list, but more specifics). Carl On 11/19

Re: [libreoffice-users] Re: OpenOffice to be dumped in Freiburg ?

2012-11-19 Thread Carl Paulsen
Thanks, all. My resources are such that it'd be hard for me to contribute much, but it's helpful to know there are small ways I could pitch in. I will see if I can make room to contribute in some way. And the specific suggestions are indeed helpful. Carl On 11/19/12 11:31 AM, Joel Madero

Re: [libreoffice-users] Re: OpenOffice to be dumped in Freiburg ?

2012-11-19 Thread Carl Paulsen
Here, here. But what about gov'ts mandating simply that the format structure be open (without mandating a specific one be used)? That's not political IMHO. Carl On 11/19/12 3:15 PM, M Henri Day wrote: 2012/11/19 VA cuyfa...@hotmail.com At the risk of getting political, the last thing I

Re: [libreoffice-users] Re: OpenOffice to be dumped in Freiburg ?

2012-11-19 Thread Carl Paulsen
and marketing and you might actually break the monopoly for good. Furthermore, if enough people forced gov't to accept standardized document types (e.g. ODT or even PDFs!), the monopoly would weaken. Carl -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http

  1   2   >