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

2022-03-10 Thread Carl Paulsen
, John Kaufmann wrote: Carl, On 2022-03-09 17:00, Carl Paulsen wrote: I have inserted a line into a text document and have a few questions. ...  I have done this in the past using tab spaces with a right justified tab, but LO won't underline tab spaces. ... At the conclusion of her elegant

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] Tabs in selection of text

2019-04-12 Thread Carl Paulsen
at a time, in others I  just set the default style for the block of text and then re-formatted characteristics, including tabs. If there are a lot of paragraphs to format the same way, I would suggest creating a style and then you can easily apply the same formatting repeatedly. Steve On 09/04/2019 0

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
directory somewhere so I can just copy it back to resolve such a problem and still keep my settings. HTH. Girvin Herr On 2/4/19 4:13 PM, Carl Paulsen wrote: Windows 10.  I think the LO version is either 6.1.4 or the previous one. Note that earlier in the day I was struggling with the same proble

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
things are needed to help you: your version of LibreOffice, and your operating system. Dan On 2/4/19 4:43 PM, Carl Paulsen wrote: I'm trying to create a mail merge document for a letter.  I'm adding fields directly to retain formatting control and NOT have to deal with a text block which is how

[libreoffice-users] Auto recovery problem

2019-02-04 Thread Carl Paulsen
I'm trying to create a mail merge document for a letter.  I'm adding fields directly to retain formatting control and NOT have to deal with a text block which is how the wizard inserts addresses.  I've had some success after a LONG time trying to figure out how to do this.  Documentation is a

[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: [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
Thanks, Bill. After trying a few things, I discovered that this file doesn't open in Windows using M$ Office either, so there's something wrong with it. I had moved 3 files from Windows to my Mac to work on them, and that's where I noticed the problem. The other two files had opened fine on

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

2015-03-10 Thread Carl Paulsen
(or may have) explicit zero values, try: =IF(AND(COUNTIF(B1:B7;0)0;MOD(ROW();7)=0);AVERAGEIF(B1:B7;0);) I trust this helps. Brian Barker -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http

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
to check is the User Profile so please rename it https://wiki.documentfoundation.org/UserProfile -- 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

Re: [libreoffice-users] vlookup not working

2014-03-07 Thread Carl Paulsen
On 3/7/14 3:11 AM, Brian Barker wrote: At 18:27 06/03/2014 -0500, Carl Paulsen wrote: I have a spreadsheet that won't calculate a vlookup. The formula displays as the formula, not the result. I can think of two possibilities: o You have Calc configured to display formulae, not results. Go

[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
. -- 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/global

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

2014-02-14 Thread Carl Paulsen
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? -- 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] Calc: help with VLOOKUP

2014-02-10 Thread Carl Paulsen
? How do I get the formula to apply properly to every row? What should the initial formula look like? Thank you. -- 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

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 try to force more people to using Microsoft Office, and now their products can't read files. Regards, xmlhttprequest.o...@gmail.com -- Carl Paulsen Dover, NH 03820 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help

Re: [libreoffice-users] MS Office woes

2014-02-07 Thread Carl Paulsen
/7/2014 9:10 PM, Carl Paulsen wrote: The biggest problem is that if the formula doesn't meet MSO's standards, you can't leave it in place to work on later. I've had formulas which took me days to work out, and if I can't leave them in place even when faulty, then I have to re-create them each

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
Thunderbird. Also, is it possible to adjust the thickness of grid lines shown in a spreadsheet, if we enable display of grid lines? Thanks in advance! Peace... Tom -- Carl Paulsen Dover, NH 03820 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http

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

2014-01-17 Thread Carl Paulsen
, Carl Paulsen a écrit : Hi Carl, Let's start at the source... You have access to a file containing DDL (data definition language) and DML (data manipulation language). This file has the extension .sql. Essentially, this file is a kind of dump from the mysql/mariadb database. The dump includes

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

2014-01-17 Thread Carl Paulsen
:19 PM, Carl Paulsen wrote: Thanks yet again, Alex. A couple of things. First I don't have access to the server from which the file originated. So I've set up both MySQL/Server and XAMP on my Windows machine hoping to get one to work for me. I've used PHPMyAdmin before so I thought that would

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

2014-01-16 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

[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
the database. Jay On 01/15/2014 11:55 AM, Carl Paulsen wrote: OK, thanks everyone. My system: Mac: OS 10.6.8 and LO 4.0.4.2 (I was thinking of upgrading to LO 4.1.4) PC: Win7 and OOo 3.2 (I could install any version of LO on the PC) I'm pretty far over my head here based on how little I

Re: [libreoffice-users] Connection to SQL database

2014-01-15 Thread Carl Paulsen
is that is unique to the table. If you are using MySQL or MariaDB (MariaDB is a MySQL fork) a pretty good book specific to that family is MariaDB: A Crash Course by Ben Forta. It covers basic SQL, basic database design, etc. Jay On 01/15/2014 01:34 PM, Carl Paulsen wrote: Thanks, Jay, that is VERY

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
and regards from Tom :) From: Carl Paulsen carlpaul...@comcast.net To: users@global.libreoffice.org users@global.libreoffice.org Sent: Monday, 12 August 2013, 23:22 Subject: Re: [libreoffice-users] Mail merge manual field entry A related question, which may help

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
/14/2013 1:35 PM, Carl Paulsen wrote: I'm trying to create mail merge documents that contain merge fields for a document that can't connect directly to the data source. That source (Salesforce) can read the documents if the field names are correctly entered. I can type the field names in manually

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

2013-08-22 Thread Carl Paulsen
, Steve Edmonds wrote: Hi. Are you wanting to upload this document as a template for a SF extended mail merge. Do you need this document in .doc format (seems so from my quick look at SF instructions). Steve On 2013-08-23 13:48, Carl Paulsen wrote: Thanks, Paul. I've been away for a bit

[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
at how this section of the code is operating, there are subtle bugs in it. I will try to install the beta as soon as I can, and will test again and report back. Thanks again for the help Paul -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- To unsubscribe e-mail

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
column “D” would include facts from column “A”+”B”+”C”, so in column “D” I can see “data/12345.jpg”. Is there a way to make this happen? - Thanks in advance! Best regards, Marino Assarsson -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- To unsubscribe e-mail

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
:) *From:* Carl Paulsen carlpaul...@comcast.net *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

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
:) *From:* Carl Paulsen carlpaul...@comcast.net *To:* users@global.libreoffice.org users@global.libreoffice.org *Sent:* Thursday, 9 May 2013, 19:21 *Subject:* [libreoffice-users] Table of Contents woes

[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
is that column C should be sorted - and that is no problem, of course. I trust this helps. Brian Barker -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help

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
LibreOffice 3.5.6.2 Mac OS 10.6.8 I have a spreadsheet with 4 sheets. File has been taking a long time to save (10 seconds or so for a 650kb file). Auto-filter is currently on for at least one sheet. This morning I closed the file because after saving, the display of the grid was wrong.

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
/2013 06:19 PM, Carl Paulsen wrote: I'm using LO 3.5.6.2 on a Mac OS 10.6.8 I'm working on a critical project analyzing data from Salesforce (I'll call it SF) for non-profit SF users. When I export xls files from SF, if those files are greater than something like 7,000 records (a dozen or so

[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
January 2013, 21:55 Subject: Re: [libreoffice-users] crash recovery odd behavior On 10/01/2013, Carl Paulsen carlpaul...@comcast.net wrote: LO crashed ( I think I ran out of battery on my laptop) with 3 documents open. When re-opening some time later, 3 documents failed recovery. I had probably

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

2012-12-14 Thread Carl Paulsen
places to find out. There must be forums or soemthing worth asking. Apols and regards from Tom :) From: Carl Paulsen carlpaul...@comcast.net To: users@global.libreoffice.org Sent: Thursday, 13 December 2012, 12:25 Subject: Re: [libreoffice-users] Formulas

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

2012-12-13 Thread Carl Paulsen
from Tom :) From: Brian Barker b.m.bar...@btinternet.com To: users@global.libreoffice.org Sent: Wednesday, 12 December 2012, 22:21 Subject: Re: [libreoffice-users] Formulas in Calc not showing results At 16:35 12/12/2012 -0500, Carl Paulsen wrote: Restart

[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
/12 8:09 AM, Regina Henschel wrote: Hi, Carl Paulsen schrieb: In practical use, I would NOT say LO (or OOo) has a high file compatibility with MS Office. Virtually every file I receive from MS Office users has some kind of problem (bullet lists almost NEVER convert correctly, at least from MSO

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

2012-11-19 Thread Carl Paulsen
, 2012 at 8:28 AM, Marc Paré m...@marcpare.com wrote: Hi Carl, Le 2012-11-19 08:34, Carl Paulsen a écrit : Thanks, Regina. I know there are other ways to contribute, but I don't necessarily know what they are. Templates is one way, but the real issue I see is going from MSO to LO/OO. We can't

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

2012-11-19 Thread Carl Paulsen
of the market, can effectively render it manditory for me to use its proprietary file format Regulation of markets, so that they remain as free and accessible as possible, is one of the principle tasks of government Henri -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310

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

2012-11-19 Thread Carl Paulsen
Without trying to defend MS, it can only dominate markets that customers allow it to dominate. Nobody is forced to purchase MS products. They do so because, for whatever reason, they perceive that MS serves their needs. One of those needs is file compatibility with others, which by its

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

2012-11-18 Thread Carl Paulsen
://nabble.documentfoundation.org/OpenOffice-to-be-dumped-in-Freiburg-tp4019224p4019398.html Sent from the Users mailing list archive at Nabble.com. -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org