Re: [libreoffice-users] LO 5.3 glitches

2017-02-03 Thread James E. Lang
That's an interesting point of view Tom. In my opinion any unannounced regression is a proper subject for a bug report and a new capability is the subject for a feature request. But, I'm not a developer. It would be nice if ordinary dictionary definitions applied to the words used! -- Jim

[libreoffice-users]

2017-01-04 Thread James E. Lang
postmas...@btinternet.com) Subject: Re: [libreoffice-users] Calc Options > Libreoffice Calc > General > Expand references when new columns/rows are inserted MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_Part_1_1114535632.1483574101274" X-Mailer: MailDroid/4.49

Re: [libreoffice-users] Re: Transferring Markdown Documents to LibreOffice

2016-11-28 Thread James E. Lang
As I understand it, H wants to convert markdown to odf AND BACK to markdown. Most of the messages in this thread are ignoring that last step. -- Jim -Original Message- From: Joshua Kramer To: H Cc: users@global.libreoffice.org Sent:

Re: [libreoffice-users] Help with LOCalc formula

2016-11-08 Thread James E. Lang
Try this. =IF(B1="","",OFFSET($Z$20,MATCH(B1,$B$20:$B$35,0)-1,25)) -- Jim -Original Message- From: "Pertti Rönnberg" To: "users@global.libreoffice.org" Cc: "Pertti Rönnberg" Sent: Mon, 07 Nov 2016 8:00 Subject:

Re: [libreoffice-users] F-Droid

2016-10-03 Thread James E. Lang
What is the current version of the Android LibreOffice Viewer? I'm certain it's nothing resembling the current version of LO on computers. How much of a link is there between the two projects? -- Jim -Original Message- From: Cley Faye Cc:

Re: [libreoffice-users] Spelling check funnies

2016-09-25 Thread James E. Lang
Interesting to know Marco but where's the sense of humor? -- Jim -Original Message- From: "Marco A.G.Pinto" To: users@global.libreoffice.org Sent: Sun, 25 Sep 2016 15:47 Subject: Re: [libreoffice-users] Spelling check funnies Hello! I am the en_GB

Re: [libreoffice-users] FYI: Writer watermarks template

2016-08-14 Thread James E. Lang
From: Tim---Kracked_P_P---webmaster To: users@global.libreoffice.org Sent: Sun, 14 Aug 2016 17:07 Subject: Re: [libreoffice-users] FYI: Writer watermarks template I always use a image editor - i.e. GIMP - to make images look like watermarks. Then I add it to the

Re: [libreoffice-users] Islamic Calendar

2016-08-11 Thread James E. Lang
Is this possibly tied to the character set? -- Jim -Original Message- From: Gary Dale To: users@global.libreoffice.org Sent: Thu, 11 Aug 2016 14:32 Subject: Re: [libreoffice-users] Islamic Calendar On 11/08/16 04:16 PM, toki wrote: > All: > > Can somebody either

Re: [libreoffice-users] Re: Calc method to change whole column cell content

2016-04-13 Thread James E. Lang
And there *are* text editors (even on Windows) that use regular expressions and thus can perform the transformation relatively painlessly. All the best! -- Jim -Original Message- From: Tom Davies To: users@global.libreoffice.org Sent: Wed, 13 Apr 2016 8:36 Subject:

Re: [libreoffice-users] Volunteers for Documentation

2016-03-27 Thread James E. Lang
I often cringe when I read things with omitted or doubled words or with incorrectly spelled words or with incorrectly selected words. However in the. Interest of harmony and multicultural understanding I generally bite my tongue and say nothing. That said, I can freely dish out constructive

Re: [libreoffice-users] Re: Not archived mails at Gmane

2016-03-13 Thread James E. Lang
Interesting! I have trouble replying to Brian's messages (and to the best of my knowledge, only his) on this list. My problem appears to be triggered by a newline character in his message id. Gmane possibly has a related problem with his posts. I wonder what change took place in Brian's eMail

Re: [libreoffice-users] Calc: background color in cells invisible

2016-02-20 Thread James E. Lang
What is it doing that's wrong? I have seen no problem with it on LO 4.4.7.2 on Windows XP. Likewise on LO 5.0.3.2 on Ubuntu but maybe I'm not doing exactly what you're trying to do. -- Jim -Original Message- From: 1124mars <1124m...@gmx.net> To: users@global.libreoffice.org Sent: Sat,

Re: [libreoffice-users] a question about openning large document with libreoffice writer:

2016-02-16 Thread James E. Lang
Hi Nasrin, That's all interesting but Steve asked what version of LibreOffice (LO) are you using. He also referred you to a discussion on a forum. I don't happen to like forums as well as mailing lists either but I suggest you take a look. You said your sister opened the document faster. Is

Re: [libreoffice-users] Pasting Tabular Data Into Calc From An HTML Source

2016-02-06 Thread James E. Lang
ing it. As I see it step 2.3 is the most complex. -- Jim -Original Message- From: Piet van Oostrum <pie...@pietvanoostrum.com> To: "James E. Lang" <jim+...@lang.hm> Cc: users@global.libreoffice.org Sent: Fri, 05 Feb 2016 2:39 Subject: Re: [libreoffice-users] Past

[libreoffice-users] Pasting Tabular Data Into Calc From An HTML Source

2016-02-04 Thread James E. Lang
LO 4.4.7.2 I receive reports a regular basis from a pizza delivery driver who sends them from his iPad. A raw data dump of the HTML part of a sample report with customer identifying information replaced by "Address 1" and "Address 2" will be pasted below my signature. Receiving this report

Re: [libreoffice-users] Re: question about the best version of libreoffice:

2016-01-20 Thread James E. Lang
Hi Andreas and Tom, It was good to see that someone actually responded to the question that was asked about LO. I don't make much use of Writer so I have little but civility to contribute. I have *reflowed* your messages as quoted below my signature. I would think that for the casual user of

Re: [libreoffice-users] Calc- don't show the decimal point

2016-01-20 Thread James E Lang
Hi Spencer, My comment paragraphs begin with "[" and each, possibly extended, comment ends with "-- jl]". -- Jim -Original Message- From: Spencer Graves To: users@global.libreoffice.org Sent: Tue, 19 Jan 2016 8:37 Subject: Re: [libreoffice-users] Calc-

Re: [libreoffice-users] Calc formula syntax assistance

2015-12-19 Thread James E. Lang
-Original Message- From: "Hylton Conacher (ZR1HPC)" To: LibreOffice Users Sent: Sat, 19 Dec 2015 9:44 Subject: [libreoffice-users] Calc formula syntax assistance Hi, Running :O 5.0.3.2 on IMac and have seen there is a 5.0.4 update,

Re: [libreoffice-users] double brackets

2015-12-13 Thread James E. Lang
Thomas, Unfortunately I no longer have your original post so I'm using quotes of it from Brian Barker's response. My first advice is to create a test copy of the spreadsheet file by saving it as a differently named file. I construct such a file name by adding something like test- or trial-

Re: [libreoffice-users] Re: Importing pictures that are resized.

2015-12-07 Thread James E. Lang
-Original Message- From: dave boland To: Pedro , LibreOffice Sent: Mon, 07 Dec 2015 9:39 Subject: Re: [libreoffice-users] Re: Importing pictures that are resized. On Mon, Dec 7, 2015, at 12:27 PM, Pedro wrote: >

Re: [libreoffice-users] How to return cell address/reference instead of function result with 2d operations?

2015-11-28 Thread James E Lang
-Original Message- From: "Michael D. Setzer II" To: Brian Barker , users@global.libreoffice.org Sent: Fri, 27 Nov 2015 4:53 Subject: Re: [libreoffice-users] How to return cell address/reference instead of function result with 2d

[libreoffice-users]

2015-11-27 Thread James E Lang
postmas...@btinternet.com) Subject: Re: [libreoffice-users] How to return cell address/reference instead of function result with 2d operations? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_Part_0_428968938.1448656389157" --=_Part_0_428968938.1448656389157

Re: [libreoffice-users] Re: Calc 5.0.3.2 AutoCalculate

2015-11-24 Thread James E Lang
-Original Message- From: "m.a.riosv" To: users@global.libreoffice.org Sent: Mon, 23 Nov 2015 21:21 Subject: [libreoffice-users] Re: Calc 5.0.3.2 AutoCalculate Hi James, sorry but I think not a good news.

Re: [libreoffice-users] Calc 5.0.3.2 AutoCalculate

2015-11-23 Thread James E Lang
This same behavior exists in 4.4.6.3 (Windows) Also in both cases my Conditional formatting gets turned off when I turn off AutoCalculate. Unexpected behavior. -- Jim -Original Message- From: "James E. Lang" <jim+...@lang.hm> To: LibreOffice Users <users@global.li

Re: [libreoffice-users] Calc 5.0.3.2 AutoCalculate

2015-11-23 Thread James E. Lang
I had this problem before with different spreadsheet package from different office suites. Regards, and hope this help, [Again I thank you for trying. Your suggestion obviously worked for you but it's not working for me. -- jl] Jorge Rodríguez -- Jim El dom, 22-11-2015 a las 23:32 -0800, James

[libreoffice-users] Calc 5.0.3.2 AutoCalculate

2015-11-22 Thread James E. Lang
LO 5.0.3.2 Calc (Linux) I turned AutoCalculate off (Alt+T, N, C) but LO takes the same four minutes (plus or minus five seconds) to process a changed value in one cell as it took with AutoCalculate turned on. Does that make sense? If so, is there any other way to accelerate the entry or

[libreoffice-users] Cut & Paste in Calc

2015-11-18 Thread James E. Lang
Version 5.0.3.2 (Linux) I cut (Ctrl+X) U3:U2870 each cell of which contains a formula, deleted U2, selected GT3, and attempted to paste (Ctrl+V). With prior versions of LO that I've used this would have placed the former contents of U3:U2870 into GT3:GT2870 but with this version I get a Text

Re: [libreoffice-users] Cut & Paste in Calc

2015-11-18 Thread James E. Lang
It appears that maybe the intermediate step (delete U2) might have confused LO and thus interfered with the functioning of the paste operation. I have successfully cut and pasted other similarly sized ranges in the past 23 hours. -- Jim -Original Message- From: "James E. Lang&

Re: [libreoffice-users] LibreOffice 4.4, 5.0 : firefox personas not work with path url...why?

2015-11-15 Thread James E Lang
Anne, While it is true that Firefox and LibreOffice are different it is not in the way you state. Both are programs. Firefox is a program that essentially fetches textual and image files from local or remote file systems and displays them in the manner directed by a markup language which is

Re: [libreoffice-users] Large spreadsheet does not open in LibreOffice.

2015-11-14 Thread James E. Lang
Oops, Dan. Your link contained errors. After a couple of educated guesses I found http://wiki.documentfoundation.org/documentation/Publications Your posted domain name was incorrect and the page name needed an upper case P rather than the lower case p. I hope this correction helps somebody

Re: [libreoffice-users] Large spreadsheet does not open in LibreOffice.

2015-11-13 Thread James E. Lang
-Original Message- From: Joel Madero To: toki Cc: users@global.libreoffice.org Sent: Fri, 13 Nov 2015 21:12 Subject: Re: [libreoffice-users] Large spreadsheet does not open in LibreOffice. On 11/13/2015 08:23 PM, toki wrote: > On

Re: [libreoffice-users] Re: Compatibility

2015-11-02 Thread James E. Lang
"Ordinary end user" is a trade marked phrase for what company? -- Jim -- 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

Re: [libreoffice-users] Re: Announcing OpenOffice 4.1.2

2015-10-29 Thread James E. Lang
I am a devoted LO user. That said, AOO & LO are cousins. Birth announcements are welcome in most families. -- Jim -Original Message- From: Joel Madero To: ville...@t-online.de Cc: "users@global.libreoffice.org" Sent: Thu, 29 Oct

Re: [libreoffice-users] Re: Shortcut changes

2015-10-20 Thread James E. Lang
Sorry but my ignorance is showing. What is the "UX mailing list?" Please explain. -- Jim -Original Message- From: Joel Madero To: Alexander Thurgood Cc: "users@global.libreoffice.org" Sent: Tue, 20 Oct

[libreoffice-users]

2015-10-19 Thread James E. Lang
postmas...@btinternet.com) Subject: Re: [libreoffice-users] Too many messages on this mailing list?? How to avoid being swamped ... MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_Part_0_844023051.1445245203873" --=_Part_0_844023051.1445245203873

Spam? Re: [libreoffice-users] Microsoft outlook support number 1-844-815-2122

2015-10-19 Thread James E. Lang
-- Jim -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/

Re: [libreoffice-users] Shortcut changes

2015-10-18 Thread James E Lang
Thank you Mark, -Original Message- From: libreoffice-ml.mbou...@spamgourmet.com To: users@global.libreoffice.org Sent: Sun, 18 Oct 2015 10:06 Subject: Re: [libreoffice-users] Shortcut changes James E Lang wrote: > -Original Message- From: > libreoffice-ml.mbou...@spamgourm

Re: [libreoffice-users] Shortcut changes

2015-10-18 Thread James E. Lang
-Original Message- From: James E Lang <je...@lang.hm> To: users@global.libreoffice.org, libreoffice-ml.mbou...@spamgourmet.com Sent: Sun, 18 Oct 2015 13:11 Subject: Re: [libreoffice-users] Shortcut changes Thank you Mark, -Original Message- From: libreoffice-m

Re: [libreoffice-users] Tooo many messages on this mailing list?? How to avoid being swamped ...

2015-10-18 Thread James E Lang
Using a web browser to send and receive eMail is the least likely to maintain threading. OTOH most servers that natively use a browser interface also allow third party mail clients (e.g. Thunderbird, Outlook, Pine, etc.) access via POP3 and/or IMAP (IMAP4) for receiving and SMTP for sending

Re: [libreoffice-users] Shortcut changes

2015-10-18 Thread James E Lang
-Original Message- From: libreoffice-ml.mbou...@spamgourmet.com To: users@global.libreoffice.org Sent: Sun, 18 Oct 2015 6:40 Subject: Re: [libreoffice-users] Shortcut changes James E. Lang wrote: > I am not a user of Base but I am a frequent user of Calc. Shortcut changes > are ext

Re: [libreoffice-users] Shortcut changes

2015-10-17 Thread James E. Lang
Thank you Alex for bringing up the topic of shortcut changes. I guess there is no gate keeper WRT shortcut assignments in LO. I am not a user of Base but I am a frequent user of Calc. Shortcut changes are extremely disruptive for users. My least favorite (most detested!!) such change occurred

Re: [libreoffice-users] Threading

2015-10-16 Thread James E Lang
This reply is being sent from my Android phone using MailDroid. I don't think it'll break threading except in receiving clients that use the subject for threading like Pegasus Mail for Windows does. -- Jim -Original Message- From: libreoffice-ml.mbou...@spamgourmet.com To:

Fwd: Re: [libreoffice-users] Threading test case

2015-10-16 Thread James E Lang
Alright! This is a forwarded message with the subject changed, the body trimmed, and sent from a different eMail account (Gmail) to really try to break the threading. I'm also sending a BCC of it to a separate Gmail address of mine that won't route the message through this list. Let's see what

[libreoffice-users] Replies

2015-10-14 Thread James E. Lang
Curious -- Does anyone know from what country Mr. Lee is sending his posts. His English is good though somewhat stilted. Interleaved in the following are some comments [... -- jl] regarding replies. -- Jim -Original Message- From: Philip Jackson To:

Re: [libreoffice-users] Dear Libre Office team

2015-10-13 Thread James E. Lang
Hi Alexander, My remarks below are tagged as [... -- jl] A few words appear in FULL CAPS for emphasis. -Original Message- From: Alexander Y Lee To: users@global.libreoffice.org Sent: Tue, 13 Oct 2015 6:59 Subject: [libreoffice-users] Dear Libre Office team Hi,

Re: [libreoffice-users] Re: Installing Libreoffice in Ubuntu

2015-10-12 Thread James E. Lang
See below as [...] -- Jim -Original Message- From: Alex Thurgood To: users@global.libreoffice.org Sent: Sun, 11 Oct 2015 2:46 Subject: [libreoffice-users] Re: Installing Libreoffice in Ubuntu Le 10/10/2015 23:36, Italo Vignoli a écrit : Suffice it to say that

Re: [libreoffice-users] LTS

2015-10-12 Thread James E. Lang
This tread has veered sharply off course from the original post thus my change of the Subject. If AOO Issued security and stability updates in a timely manner and if they issued a battle tested version of LO every couple of years or so, it could serve as a LTS outlet for the bleeding edge LO.

Re: [libreoffice-users] Android version

2015-09-14 Thread James E Lang
The last I tried them, neither was ready for prime time but that may have changed since time passes so quickly for me now. -- Jim -Original Message- From: Tom Davies To: "users@global.libreoffice.org" Sent: Mon, 14 Sep 2015 5:42

Re: [libreoffice-users] LibreOffice Damaged

2015-09-14 Thread James E Lang
My opinion is that renaming a folder (directory) is much safer than removing (deleting) it until a problem is fully resolved. That way you have the option to recover personal data (options, plugins, etc.) from the uncorrupted portion of the old before it's gone or to perform a post mortem

Re: [libreoffice-users] Re: Android version

2015-09-14 Thread James E Lang
Tom, For what it's worth, KingSoft is a company in China. -- Jim -Original Message- From: Tom Davies To: Alexander Thurgood Cc: "users@global.libreoffice.org" Sent: Mon, 14 Sep 2015 7:46 Subject: Re:

Re: [libreoffice-users] Re: Android version

2015-09-14 Thread James E Lang
- From: James E Lang <jim+...@lang.hm> To: Alexander Thurgood <alex.thurg...@gmail.com>, Tom Davies <tomc...@gmail.com> Cc: "users@global.libreoffice.org" <users@global.libreoffice.org> Sent: Mon, 14 Sep 2015 8:02 Subject: Re: [libreoffice-users] Re: Android

Re: [libreoffice-users] Re: LibreOffice 5.0 Review Rating | PCMag.com

2015-08-25 Thread James E Lang
So PC Magazine links (pcmag.com) in UK get converted to uk.pcmag.com and some place else they get converted to au.pcmag.com? Nasty! It's hard to communicate that way. Censorship? -- Jim -Original Message- From: Mike Scott m...@scottsonline.org.uk To: users@global.libreoffice.org Sent:

Re: [libreoffice-users] Images copied to Libre Office Writer from Shutter look so pixelated

2015-08-03 Thread James E Lang
Strange. I'm not seeing a difference in quality between the two images. :-( From your description I expected the difference to be striking. [[Regarding WPS, I have experienced trouble between it and LibreOffice. With both installed on XP I was not given the ability to open a csv file with ...

Re: [libreoffice-users] [CALC] printing several copies of the same sheet

2015-08-03 Thread James E Lang
Hi Alain, Try changing your collation selection. I think that will solve your problem. -- Jim -Original Message- From: Rafnews raf.n...@gmail.com To: users@global.libreoffice.org Sent: Mon, 03 Aug 2015 3:23 Subject: [libreoffice-users] [CALC] printing several copies of the same sheet

[libreoffice-users] Erroneous Verbiage in LibreOffice Built-in Help

2015-08-02 Thread James E Lang
I just discovered that at least in V4.3.7.2 of LibreOffice the following verbiage found in the built-in help for function PMT but that also exists many other places within the built-in help is not always, if ever(?), true. In the LibreOffice Calc functions, parameters marked as optional can be

Re: [libreoffice-users] Calc:- Moving a fixed page break.

2015-07-18 Thread James E Lang
If it is indeed a manually inserted page break you can delete it by selecting a cell immediately beyond the break and then using these key strokes: Alt+E B and either R or C depending on the orientation of the break That's Menu Edit, Item Delete Page Break, and either sub item Row Break or

[libreoffice-users] [OT] Operating Environment Survey

2015-07-18 Thread James E Lang
The big discussion of Linux over the past 24+ hours has me wondering: What operating environment(s) do other members of this list use at home and at work? What factors influence the choice? To set the tone, here are my answers: • I am retired so at work is not applicable • At home we have a

Re: [libreoffice-users] Anyone log into LibreOfficeForum.org?

2015-07-15 Thread James E Lang
Not to contradict the other three responses that I've seen thus far, but yes, since the time you posted tgis question I have been able to access those forums and to post to them. I registered using FireFox for Android and found the captcha code to be a mess of special characters with what I

Re: [libreoffice-users] Upload a picture to http://ask.libreoffice.org

2015-07-13 Thread James E Lang
Java Runtime Environment? I guess your statement was intended to be in jest. -- Jim -Original Message- From: anne-ology lagin...@gmail.com To: users@global.libreoffice.org Sent: Mon, 13 Jul 2015 9:10 Subject: Re: [libreoffice-users] Upload a picture to http://ask.libreoffice.org

Re: [libreoffice-users] {Off Topic: FOSS Solutions} How to use LibreOffice to blur ...?

2015-07-13 Thread James E Lang
This list is intended to cover LibreOffice issues (not all FOSS). That said, LibreOffice is not the software equivalent of a Swiss Army Knife. There really are things it is not designed to do. This photo editing request appears to fall into that inappropriate tool for the task category. I

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

2015-06-25 Thread James E Lang
Hi, PDF? I'm not sure I know where to look for LO documentation in this format? F1? I use it often. It needs to be compartmenalized (Calc, Writer, Math, Macro interface [UNO], ...) Its installation also needs to be better integrated into the LO installation process. HTML? I occasionally

Re: [libreoffice-users] Randomly lost sheet

2015-06-14 Thread James E Lang
So this is an intermittent problem that is not even reliably reproducible using the same file? -- Jim -Original Message- From: Andrea Venturoli m...@netfence.it To: users@global.libreoffice.org Sent: Fri, 12 Jun 2015 0:53 Subject: [libreoffice-users] Randomly lost sheet Hello. A

Re: [libreoffice-users] Re: open files automatically (a Star Basic macro)

2015-05-31 Thread James E Lang
Hi Andreas, Your Star Basic macro looks very interesting. It is not super complex (initialization, a loop, and a super simple supporting function). Has anyone given it a test drive? As I read the macro, the while loop looks suspect. Isn't it testing the length of a directory name [

Re: [libreoffice-users] Re: open files automatically (a Star Basic macro)

2015-05-31 Thread James E Lang
in order to activate the Subroutine? -- Jim -Original Message- From: Andreas Säger ville...@t-online.de To: users@global.libreoffice.org Sent: Sun, 31 May 2015 13:54 Subject: [libreoffice-users] Re: open files automatically (a Star Basic macro) Am 31.05.2015 um 22:43 schrieb James E Lang

Re: [libreoffice-users] open files automatically

2015-05-28 Thread James E Lang
Hi Toki, That is a Linux shell script is it not? I think it's been established that the OP is a Windows user. Please identify the Windows equivalent file as well as the quoted Linux file. I am guessing that it exists in the user's file system once LO is installed and that it is invoked when

Re: [libreoffice-users] Re: Calc: Cutting and Pasting Ranges

2015-05-05 Thread James E Lang
: [libreoffice-users] Re: Calc: Cutting and Pasting Ranges Am 05.05.2015 um 12:48 schrieb James E Lang: I had a troubling experience that I want to share. Cut Paste from a range of cells on one sheet (e.g. Sheet4.A1:AL418) to a location on another sheet (e.g. Sheet2.XA1) leaves formulas

[libreoffice-users] Calc: Cutting and Pasting Ranges

2015-05-05 Thread James E Lang
I had a troubling experience that I want to share. Cut Paste from a range of cells on one sheet (e.g. Sheet4.A1:AL418) to a location on another sheet (e.g. Sheet2.XA1) leaves formulas that reference a range of cells (e.g. Sheet4.P$3:P$1230) that is partially but not entirely within the Cut

O.T. Re: [libreoffice-users] Libre Calc - moving text in cell + comparison chart

2015-04-28 Thread James E Lang
XThis (my message) IS off topic but I'm trying to figure out where and why Re: [SPAM?] got added to the subject of Susan's message, The five headers that pertain to spam are: X-Virus-Scanned: amavisd-new at bilbo2.documentfoundation.org X-Spam-Flag: NO X-Spam-Score: -1.9 X-Spam-Level:

[libreoffice-users] Calc wasting paper

2015-04-27 Thread James E Lang
I don't know whether my problem is caused by the existence of formulas that evaluate as empty strings [e.g. =IF(A1=Hide,,0) with the condition being TRUE] or of repeated rows specified in a print range (e.g. $2) but leaving Include output of empty pages unticked on the LibreOffice Calc tab of

Re: [libreoffice-users] CORRECTED SOLUTION selecting cells in calc sheet

2015-04-27 Thread James E Lang
For anyone who might have taken an interest in this discussion, I omitted a right parenthesis when I first posted this formula. It is now correct. -- Jim -Original Message- From: James E Lang jim+...@lang.hm To: users@global.libreoffice.org, pete nikolic pg.nikol...@gmail.com Sent: Sat

Re: [libreoffice-users] Libre Calc - moving text in cell + comparison chart

2015-04-26 Thread James E Lang
Ctrl+Enter does the job for as long as I can remember in the LibreOffice/OpenOffice.org Calc product line. -- Jim -Original Message- From: charles meyer reachmepl...@gmail.com To: users@global.libreoffice.org Sent: Sun, 26 Apr 2015 11:33 Subject: [libreoffice-users] Libre Calc - moving

Re: [libreoffice-users] selecting cells in calc sheet

2015-04-25 Thread James E Lang
a better technique I hope they will chime in. I've never seen anyone else post a practical use for this function but for me, any spreadsheet program that lacks support for it fails to gain my acceptance. -- Jim -Original Message- From: pete nikolic pg.nikol...@gmail.com To: James E Lang

Re: [libreoffice-users] selecting cells in calc sheet

2015-04-25 Thread James E Lang
before the values of interest in A1:A50. This process gets a little bit (to say the least) more hairy if there are intervening cells. -- Jim -Original Message- From: pete nikolic pg.nikol...@gmail.com To: James E Lang jim+...@lang.hm, users@global.libreoffice.org Sent: Sat, 25 Apr

Re: [libreoffice-users] selecting cells in calc sheet

2015-04-25 Thread James E Lang
and paste or fill vertically to recover. I hope this satisfies your requirements, If not then you'll have to explain your requirements better. -- Jim -Original Message- From: pete nikolic pg.nikol...@gmail.com To: James E Lang jim+...@lang.hm Sent: Sat, 25 Apr 2015 8:38 Subject: Re

Re: [libreoffice-users] selecting cells in calc sheet

2015-04-25 Thread James E Lang
If I'm right, which is a mighty big IF, then the task is quite easily accomplished but I'll await your response to my suppositions before going any further. Besides that I need some sleep. -- Jim -Original Message- From: pete nikolic pg.nikol...@gmail.com To: James E Lang jim

Re: [libreoffice-users] Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?

2015-04-24 Thread James E Lang
One possibility comes to mind as to why empty cells are saved. If formatting has been applied to the empty cells then they must be saved even if no values are currently stored in those cells. As a trivial example consider the four cell range A1:B2 which contain no values but the four cells are

Re: [libreoffice-users] selecting cells in calc sheet

2015-04-24 Thread James E Lang
Pete, You still leave a lot unsaid such as whether the result is in a single fixed location, what if anything is in the even numbered rows of column C, whether any other column can be used for identification purposes, what if anything is below the most recent month's data, etc. You imply that

Re: [libreoffice-users] column limit in libreoffice 4.3.something

2015-04-23 Thread James E Lang
I am using LO version 4.3.5.2. Its spreadsheet size is limited to 1G cells (1K columns by 1M rows) per sheet. I don't know how many sheets are allowed. YMMV but I know that these spreadsheet size limits are currently quite sufficient for my needs. I also know that I currently have no desire to

Re: [libreoffice-users] [Calc] Relative references behavior for worksheets

2015-04-22 Thread James E Lang
Hi Ady, I have practically zero experience with other spreadsheet programs and such experience as I do have has me comparing them against LO (or OOo) not vice versa. That said, it is my OPINION that intersheet references should be of the class specified (absolute if entered with a leading $

Re: [libreoffice-users] Re: [Calc] Relative references behavior for worksheets

2015-04-22 Thread James E Lang
Ah! My response was based on entering the whole formula through the keyboard. That's my modus operandi (sp?). You're talking about using the mouse to generate references. I'll back away as I have nothing useful to say about your method. -- Jim -Original Message- From: Ady

Re: [libreoffice-users] libreoffice issue: libreoffice for android crashed

2015-04-22 Thread James E Lang
Sorry Chengyi Lin that i have no answers but your questions raise questions of my own. Does LibreOffice for Android have its own mailing list? How far advanced is the project? -- Jim -Original Message- From: 林承益 chengyi@keywie.com To: users users@global.libreoffice.org Sent: Tue,

Re: [libreoffice-users] Re: Heads up -- LibreOffice 5.0 is on the horizion

2015-04-21 Thread James E Lang
Cor and Jorge, IMO a design like this would be acceptable in a private user environment but not in many corporate environments. Maybe LibreOffice could consider offering two themes. -- Jim -Original Message- From: Cor Nouws oo...@nouenoff.nl To: jorge jrodrigue...@cpcecr.com Cc:

Re: [libreoffice-users] [LibreOffice Writer] Table with alternat[]e row color

2015-04-20 Thread James E Lang
Thank you Andrew. That looks like it's a full answer to the question. I have learned something from this. I might not use it often but I now have it in my bag of tools and who knows -- Jim -Original Message- From: Andrew Pitonyak and...@pitonyak.org To: James E. Lang je

[libreoffice-users]

2015-04-20 Thread James E Lang
-0700, James E Lang wrote: Maybe I'm being over sensitive but I sensed hostility in your response to me. Oh, no: not at all! Sorry you got that impression. Indeed, I was surprised that you hadn't explicitly suggested that my rejection of the method as a dead duck in my earlier message was wrong

[libreoffice-users]

2015-04-19 Thread James E Lang
postmas...@btinternet.com) Subject: Re: [libreoffice-users] [LibreOffice Writer] Table with alternat[]e row color MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Alain, I don't know whether you consider this to be simple and automatic but what I've

[libreoffice-users]

2015-04-19 Thread James E Lang
Sent: Sun, 19 Apr 2015 22:27 Subject: Re: [libreoffice-users] Table with alternat[]e row color At 20:21 19/04/2015 -0700, James E Lang wrote: From: Brian Barker: The automatic way to colour spreadsheet rows alternately is to use Conditional Formatting and create a formula using the ROW() function

Re: [libreoffice-users] Basic Calc Question

2015-04-14 Thread James E Lang
-Original Message- From: Barry Premeaux bpreme...@gmail.com To: users@global.libreoffice.org Sent: Mon, 13 Apr 2015 16:17 Subject: [libreoffice-users] Basic Calc Question I'm a novice at spreadsheets, and google hasn't turned up an answer. Probably because I haven't worded the question

[libreoffice-users] Test Message

2015-04-14 Thread James E. Lang
Please disregard this message. It is a test of the use of an identity in Pegasus Mail. This identity is used only for posts to the LibreOffice Users mailing list and cannot be properly tested without that address in the To header. -- Jim -- To unsubscribe e-mail to:

Re: [libreoffice-users] Basic Calc Question

2015-04-13 Thread James E Lang
-Original Message- From: Barry Premeaux bpreme...@gmail.com To: users@global.libreoffice.org Sent: Mon, 13 Apr 2015 16:17 Subject: [libreoffice-users] Basic Calc Question I'm a novice at spreadsheets, and google hasn't turned up an answer. Probably because I haven't worded the question

Re: [libreoffice-users] Basic Calc Question

2015-04-13 Thread James E Lang
-- Jim -Original Message- From: Barry Premeaux bpreme...@gmail.com To: users@global.libreoffice.org Sent: Mon, 13 Apr 2015 16:17 Subject: [libreoffice-users] Basic Calc Question I'm a novice at spreadsheets, and google hasn't turned up an answer. Probably because I haven't worded the

Re: [libreoffice-users] Re: Calc and number of copies does not work

2015-04-12 Thread James E Lang
See the solution to this problem at the bottom of this top post (no flames please). I have experienced the same problem recently. I'm running LO 4.3.5.2 on Windows XP using a print server to a Samsung SCX 4035FR printer printing double sided which is way more information than you need to know.

[libreoffice-users] Calc wastes paper

2015-04-12 Thread James E Lang
Calc printed 26 pages. All but two of them contain nothing but column headers as specified by the Repeat Rows ($2) specification in the Print Range definition and cells that all evaluated to an empty string (). This is in spite of the fact that I did not tick Include output of empty pages

Re: [libreoffice-users] Calc: How to concat CTRL+ENTER to a string?

2015-04-11 Thread James E Lang
to a string? James E Lang - jim+...@lang.hm wrote: On a Windows platform I use CHAR(13)CHAR(10) [CR+LF] instead of just CHAR(10) [LF] which I use on a Linux platform or just CHAR(13) [CR] which I would expect to use on a MAC platform Those are the conventions for plain text files on those

[libreoffice-users] Calc: Using Internet Sites to Determine Driving Distances

2015-01-17 Thread James E. Lang
Highly technical issue: I have a spreadsheet that, among other things, contains street addresses. I need to determine the driving distance between pairs of addresses. From within Calc, how can I use a site on the internet (i.e. Open Street Maps, Google Maps, MapQuest, etc.) to determine the

Re: [libreoffice-users] Another spreadsheet destroyed.

2014-10-24 Thread James E Lang
Pardon my ignorance. What do you mean when you speak of dialogues in LO Calc? -- Jim -Original Message- From: Johnny Rosenberg gurus.knu...@gmail.com To: LibreOffice Användare users@global.libreoffice.org Sent: Wed, 22 Oct 2014 12:01 Subject: [libreoffice-users] Another spreadsheet

Re: [libreoffice-users] How to ensure all new text entered into a document is different font, without changing the old font settings of the document?

2014-06-18 Thread James E Lang
I'm not sure whether this question has been resolved. I assume that your document is a questionnaire that you attach to email for distribution purposes and that the recipients fill out the answers and send the completed questionnaire back to you. My (low tech) approach would look like this.

[libreoffice-users] Test

2014-06-12 Thread James E Lang
-- Jim -- 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:

[libreoffice-users] Print Orientation (Calc)

2014-05-05 Thread James E. Lang
When I set the print orientation for Sheet 1 to Landscape the print orentation for Sheet 2 is also changed even though the data on Sheet 2 is better printed with orientation = Portrait. What is the rationale for this behavior? Is there a preference setting that unlinks the sheets with regard

Re: [libreoffice-users] Re: table: clipping of numbers: still helpless

2014-04-30 Thread James E Lang
Does the silly form get submitted electronically or on paper? -- Jim -Original Message- From: william drescher will...@techservsys.com To: users@global.libreoffice.org Sent: Wed, 30 Apr 2014 4:23 Subject: [libreoffice-users] Re: table: clipping of numbers: still helpless On 4/27/2014

Re: [libreoffice-users] Upgrade Problem on Windows

2014-04-29 Thread James E Lang
'msciexec' is not recognized … -- Jim -Original Message- From: Regina Henschel rb.hensc...@t-online.de To: users@global.libreoffice.org Sent: Mon, 28 Apr 2014 13:14 Subject: Re: [libreoffice-users] Upgrade Problem on Windows Hi James, James E Lang schrieb: Hi Florian. -Original

  1   2   >