[libreoffice-users] Problem loading and saving XLS files

2013-02-25 Thread Carl Paulsen
, the file is still only 3-4MB 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:

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

2013-02-26 Thread Carl Paulsen
bject: Re: [libreoffice-users] Problem loading and saving XLS files On 02/25/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 xl

[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. Aut

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 spread

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

2013-03-25 Thread Carl Paulsen
for each row down the search column. If you want a value 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 su

Re: [libreoffice-users] VLOOKUP for Numbers

2013-03-27 Thread Carl Paulsen
g sorted, as you have asked. All that is required 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.libre

[libreoffice-users] Table of Contents woes

2013-05-09 Thread Carl Paulsen
ual Fund Auction Auction Etc. The ToC should read: 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 m

Re: [libreoffice-users] Table of Contents woes

2013-05-10 Thread Carl Paulsen
i missed a better answer) Apols and regards from Tom :) -------- *From:* Carl Paulsen *To:* "users@global.libreoffice.org" *Sent:* Thursday, 9 May 2013, 19:21 *Subject:* [libreoffice-users] Table of Contents wo

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

2013-05-13 Thread Carl Paulsen
having trouble, 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 Lis

[libreoffice-users] Sort problems

2013-05-14 Thread Carl Paulsen
so the columns themselves. 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 --

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

2013-05-15 Thread Carl Paulsen
Mail Mail -> Mail EmailMail -> Email;Mail So semi-colons only occur if there's a value present and not at all if there's only one value present. I hope that makes sense and displays correctly. Carl -- Carl Paulsen -- To unsubscribe

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 equival

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

2013-05-15 Thread Carl Paulsen
If any of the cells is empty, nothing will be added until the next cell that has data. Unfortunately, I'm getting a #NAME? error. I'm assuming some kind of syntax error. Any words of wisdom? Thanks a ton all. Carl On 5/15/13 5:13 PM, Dan Lewis wrote: On 05/15/2013 04:16 PM, Ca

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 wro

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

2013-05-16 Thread Carl Paulsen
02 AM, Tom Davies wrote: Hi :) WoooHooo!! Nicely done! :) Is this whole thread solved now? COngrats of so! Regards from Tom :) *From:* Carl Paulsen *To:* users@global.libreoffice.org *Sent:* Thursday,

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

2013-05-16 Thread Carl Paulsen
n my case. 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.

[libreoffice-users] Save As behavior

2013-05-22 Thread Carl Paulsen
is a setting that controls what happens when I 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

Re: [libreoffice-users] Save As behavior

2013-05-22 Thread Carl Paulsen
r crashed or forgot which 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

Re: [libreoffice-users] Re: appleworks tests

2013-05-24 Thread Carl Paulsen
acLinkPlus 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. -- C

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

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

2013-07-09 Thread Carl Paulsen
if I removed another space, to 3 spaces, which is a format I had previously used, then added a space, the format would get messed up again. It seems that there is some format interpretation going on behind the scenes when a space is added that is not going on when a space is removed. I think someo

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

Re: [libreoffice-users] Re: Libre Vs office

2013-07-10 Thread Carl Paulsen
system (except Mac or iThings) On a Mac it's the same, with the exception that instead of the Ctrl key, you use the Apple/Command key. Otherwise the shortcuts are virtually all the same. Carl -- Carl Paulsen Dover, NH 03820 -- To unsubscribe e-mail to: users+uns

[libreoffice-users] Mail merge manual field entry

2013-08-12 Thread Carl Paulsen
x27;t find 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. T

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

2013-08-12 Thread Carl Paulsen
tire thing 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 t

[libreoffice-users] More mail merge help needed

2013-08-14 Thread Carl Paulsen
ere is a Next Record option but it's only available when there's a database 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: user

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

2012-11-18 Thread Carl Paulsen
urg/ There are some translations in the comments. -- View this message in context: http://nabble.documentfoundation.org/OpenOffice-to-be-dumped-in-Freiburg-tp4019224p4019398.html Sent from the Users mailing list archive at Nabble.com. -- Carl Paulsen 8 Hamilt

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

2012-11-19 Thread Carl Paulsen
). Carl On 11/19/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 conver

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

2012-11-19 Thread Carl Paulsen
ze. Regards, Joel On Mon, Nov 19, 2012 at 8:28 AM, Marc Paré 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 M

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

2012-11-19 Thread Carl Paulsen
ffectively 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 -- For u

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 nature

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

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

2012-12-12 Thread Carl Paulsen
e are slightly different from each other). Regards from Tom :) From: Brian Barker To: users@global.libreoffice.org Sent: Wednesday, 12 December 2012, 19:54 Subject: Re: [libreoffice-users] Formulas in Calc not showing results At 12:10 12/12/2012 -0500, Ca

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

2012-12-12 Thread Carl Paulsen
ght be going 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

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

2012-12-13 Thread Carl Paulsen
machine a couple of minutes of downtime is unlikely to matter much. Regards from Tom :) From: Brian Barker 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

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

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

[libreoffice-users] crash recovery odd behavior

2013-01-10 Thread Carl Paulsen
perly 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 Hamilto

Re: [libreoffice-users] crash recovery odd behavior

2013-01-10 Thread Carl Paulsen
13, 21:55 Subject: Re: [libreoffice-users] crash recovery odd behavior On 10/01/2013, Carl Paulsen 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 trashed the files b/c I didn&#

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

2013-08-22 Thread Carl Paulsen
above or from elsewhere. Good luck and regards from Tom :) ________ From: Carl Paulsen To: "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

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

2013-08-22 Thread Carl Paulsen
mpler IMHO) or a Base dB 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

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

2013-08-22 Thread Carl Paulsen
er document? Paul On 8/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 ente

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

2013-08-22 Thread Carl Paulsen
Thanks, Carl On 8/22/13 10:21 PM, 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

[libreoffice-users] Grouping objects in Draw

2013-09-08 Thread Carl Paulsen
ify->Group, 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? Tha

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

2013-09-18 Thread Carl Paulsen
n someone chime in on this? Many thanks in advance. -- 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.

Re: [libreoffice-users] Counting Instances

2013-12-29 Thread Carl Paulsen
utton in the "Data Fields" area 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 Stre

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

2014-01-14 Thread Carl Paulsen
ses me from manually saving my documents). -- 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://wik

[libreoffice-users] Connection to SQL database

2014-01-15 Thread Carl Paulsen
e for me to research on my own? 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

Re: [libreoffice-users] Connection to SQL database

2014-01-15 Thread Carl Paulsen
use I only need 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 b

Re: [libreoffice-users] Connection to SQL database

2014-01-15 Thread Carl Paulsen
sy to deal with and increment nicely. The only requirement for a primary key 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, et

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
ndation_code`, `dm_in_kind_desc`, `dm_comment`, `dm_send_thank_you`, `dm_in_thank_you_set`, `dm_from_distribution_id`, `dm_user_field1`, `dm_created`, `dm_created_by`, `dm_modified`, `dm_modified_by`) VALUES (1,467,NULL,'2008-05-12',60.00,'03718C','MEMBERSHIP0','

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

2014-01-16 Thread Carl Paulsen
it's a case of a single snapshot to rescue data from a sinking Cloud then none of that is a worry and the single export routes are perfect So it's really route 1 that i'm curious about and really in a yes/no way rather than in any detail. Carl doesn't seem to be thinking along thos

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

2014-01-17 Thread Carl Paulsen
g 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, Carl Paulsen a écrit : Hi Carl, Let's start at the source... You have access to a file containing DDL (data definition language) and D

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

2014-01-17 Thread Carl Paulsen
Carl On 1/17/14 1: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

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

2014-01-21 Thread Carl Paulsen
occasionally click them to send messages from Mozilla 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: us

Fwd: Re: [libreoffice-users] Calc question

2014-01-24 Thread Carl Paulsen
From: Carl Paulsen Reply-To: cpaul...@alumni.middlebury.edu To: Alan B 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 though.

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

[libreoffice-users] MS Office woes

2014-02-07 Thread Carl Paulsen
NOT know its own file type? Rant done. Just thought I'd share specific 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.

Re: [libreoffice-users] MS Office woes

2014-02-07 Thread Carl Paulsen
re legion. Dover, NH 03820 [very pretty area - especially in the colourful fall] Indeed! SNOWY and cold now though (which is good if you're willing to get out in it as I am). -- Carl Paulsen Dover, NH 03820 -- To unsubscribe e-mail to: users+unsubscr...@global.li

Re: [libreoffice-users] MS Office woes

2014-02-07 Thread Carl Paulsen
,000 pages long! So, it really doesn't do what Microsoft said it would do; they made the system so complex 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

Re: [libreoffice-users] MS Office woes

2014-02-07 Thread Carl Paulsen
On 2/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

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

2014-02-10 Thread Carl Paulsen
column (F?). Where do I type the =VLOOKUP formula? Can I save the sheet with the formula so I can set this strategy up ahead of time? How do I get the formula to apply properly to every row? What should the initial formula look like? Thank you. -- Carl Paulsen 8 Hamil

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

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

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

2014-02-14 Thread Carl Paulsen
ur lookup value -- in this case the ID number -- has to be the first column in the lookup array. When I moved the ID number to the first column, my VLOOKUP worked! Where does it say that that is a requirement? -- Carl Paulsen Dover, NH 03820 -- To unsubscribe e-mail to: users+unsubscr...@g

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

2014-02-15 Thread Carl Paulsen
ps, so the added step of naming could end up saving me some time as well. Carl On 2/15/14 2:55 AM, Jean-Francois Nifenecker wrote: Le 14/02/2014 23:06, Carl Paulsen a écrit : A few hints for vlookups: I find I usually want to add "hard" references for the array so that it always looks

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

2014-03-03 Thread Carl Paulsen
fic command. Computers cannot (yet) read minds. What you can do is tell the computer what you want to do - in this case, to use the keyboard shortcut to Reply List, do: CTRL-SHIFT-L Or, you could use the 'Smart Reply' button, which automatically switches to 'Reply List' f

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

2014-03-04 Thread Carl Paulsen
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 wrote: On 3/3/2014 9:12 PM, Carl Paulsen wrote: Tanstaafl, where is the smart reply bu

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

2014-03-04 Thread Carl Paulsen
y lists button, 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,

[libreoffice-users] vlookup not working

2014-03-06 Thread Carl Paulsen
erences A2. Any wisdom is greatly 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:

Re: [libreoffice-users] vlookup not working

2014-03-07 Thread Carl Paulsen
Carl 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

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

2014-03-14 Thread Carl Paulsen
Easiest one 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 guidelin

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

2014-06-27 Thread Carl Paulsen
ing URL: http://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.libreoffic

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

2015-03-10 Thread Carl Paulsen
, =IF(AND(COUNT(B1:B7)>0;MOD(ROW();7)=0);AVERAGEIF(B1:B7;">0");"") would suffice. If they have (or may have) explicit zero values, try: =IF(AND(COUNTIF(B1:B7;">0")>0;MOD(ROW();7)=0);AVERAGEIF(B1:B7;">0");"") I trus

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

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

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

2018-02-19 Thread Carl Paulsen
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 or

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

2018-02-20 Thread Carl Paulsen
the long file 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 j

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

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

Re: [libreoffice-users] Auto recovery problem

2019-02-04 Thread Carl Paulsen
Dan Lewis wrote: Two 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

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

2019-02-04 Thread Carl Paulsen
made 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, an

Re: [libreoffice-users] Auto recovery problem

2019-02-06 Thread Carl Paulsen
he good profile in a 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 w

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

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-12 Thread Carl Paulsen
e room, but for a number of reasons (not just Styles) I 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

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

2019-04-12 Thread Carl Paulsen
he tabs one paragraph 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 repeatedl

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

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 to

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

2022-03-10 Thread Carl Paulsen
/10/22 12:21 AM, 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 concl