Re: [libreoffice-users] LO 5.3 glitches

[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

-Original Message-
From: Tom Davies 
To: "users@global.libreoffice.org" 
Sent: Fri, 03 Feb 2017 7:44
Subject: Re: [libreoffice-users] LO 5.3 glitches

Hi :)
Right now is a good time to post bug-reports and "feature requests".

"Feature requests" are what most 'normal' (ie non-devs) of us think of as
bugs.  It includes features that used to work but now don't and features
that don't quite work at all.

"Bug reports" are only things that cause the program or entire system to
crash (or that escalate privileges to super-users/ super-user/
administrator - but as normal users we probably wouldn't notice such
escalation).  In chatting with each other we often call things "bugs" or
say a thing is "buggy" but if it doesn't crash the system or cause it to
close unexpectedly, then it doesn't fit the developers notion of "bug", so
there is no point posting a bug-report about it - instead post as a
feature-request.

Similarly with the term "stable".  However badly a thing behaves, such as
familiar functionality suddenly not working, then the devs don't think of
that as showing the program is unstable.  A program is only unstable if it
crashes (or maybe that escalation thing) or if it crashes the whole
system.  LibreOffice is particularly unlikely to do either of those things
- there is a measurement of that sort of stability and LibreOffice scores
extraordinarily highly, far above much more respected or well-known
software.

It is nice to hear about good&bad issues with new the branch of LibreOffice
as it allows us to be better prepared for the questions that 'normal' users
are likely to ask on this mailing list.  However reporting an issue to this
mailing list is extremely unlikely to result in the issue being (what we
would probably refer to as being) fixed.


Right now is probably the best time for doing proper bug-reports and
feature-requests because it's the time when the greatest percentage of devs
are focused on this branch and most interested in it's outcomes.

Regards from
Tom :)


On 3 February 2017 at 15:21, Tim---Kracked_P_P---webmaster <
webmas...@krackedpress.com> wrote:

>
> I used Linux Mint on a test system.  What Desktop version are you using -
> MATE or Cinnamon?  I used MATE when I tested Linux Mint.
>
> I use Ubuntu with the MATE desktop [16.04LTS] and I also have the LO
> desktop icon,s plus the icons for Writer and Calc in the "top panel".  I
> have not tried the 5.3.x.x version, since I just upgraded to 5.2.4.2.
> After I do the needed work this month, or two, I will test 5.3.x.x on my
> testing laptop.
>
> The need to change the Icon Properties to launch LO from the desktop/panel
> icons is a concern for me.  Will I have to do similar to Ubuntu Mate when I
> go to 5.3.x.x?
>
>
>
>
> On 02/03/2017 09:38 AM, Paul D. Mirowsky wrote:
>
>> Try changing the Icon properties set to allow execute.
>>
>> This may help.
>>
>>
>> On 2/2/2017 7:36 PM, Dave Stevens wrote:
>>
>>> Minor ones, the download and install were fine and that fixed my lack
>>> of spell-checking that I was complaining of here a while back.
>>>
>>> I'm using Linux Mint 18. The new icons for version 5.3 showed up in the
>>> start menu and they work. My boot process ends at a desktop so I like
>>> to have a LO Writer icon on the desktop so I can start there if I want.
>>> I popped up the start menu, went into "office" then with the mouse
>>> over the LO Writer icon, dragged it to the desktop, leaving me with a
>>> desktop icon as launcher. Clicking on the desktop icon gives a dialog
>>> box with a message, "untrusted application launcher" and "The
>>> application launcher 'libre-office5-3writer.desktop' has not been marked
>>> as trusted. If you do not know the source of this file, launching it
>>> may be unsafe." Below are two buttons, "Launch anyway" and "Cancel" I
>>> always launch and it works fine. Still it would be nice to make it
>>> trusted.
>>>
>>> Also the icon has a little lock emblem in the top right corner.
>>> Ordinarily I expect to see that when I'm running as a user and trying
>>> to launch a program owned by root. And finally I'd like to be able to
>>> change the icon image and label text but an attempt to rename through
>>> the icon properties dialogue box leaves me with a message box telling me
>>> the item could not be renamed and 'unable to rename desktop file.'
>>>
>>> All small stuff the upgrade is still very worthwhile.
>>> TIA
>>>
>>> Dave
>>>
>>>
>>>
>>
>>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://

[libreoffice-users]

[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 (Android 4.4.2)
User-Agent: MailDroid/4.49 (Android 4.4.2)

--=_Part_1_1114535632.1483574101274
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: base64

SSBob3BlIHRoZXNlIGNvbW1lbnRzIGFyZSBoZWxwZnVsLgoKSW5zZXJ0aW5nIG9yIGRlbGV0aW5n
IG9uZSBvciBtb3JlIHJvd3MgKGNvbHVtbnMpIHJlcXVpcmVzIG1hbnVhbCBpbnRlcnZlbnRpb24g
aW4gdGVybXMgb2YgcGF0Y2hpbmcgcmVmZXJlbmNlcyBpbiBtYW55IGNhc2VzIHdoZXJlIGEgZm9y
bXVsYSBvbiBvbmUgc2lkZSBvZiB0aGUgaW5zZXJ0IG9yIGRlbGV0ZSBwb2ludCBpbmNsdWRlcyBh
IHJlbGF0aXZlIHJlZmVyZW5jZSB0byBhIGNlbGwgb24gdGhlIG9wcG9zaXRlIHNpZGUgb2YgdGhh
dCBwb2ludC4gVGhlIG1vc3Qgb2J2aW91cyBpcyBhIHJlZmVyZW5jZSB0byB3aGF0IHdhcyBmb3Jt
ZXJseSBpbiB0aGUgcm93IChjb2x1bW4pIGltbWVkaWF0ZWx5IGFkamFjZW50IHRvIHRoZSBmb3Jt
dWxhIGJ1dCB0aGlzIGlzIG5vdCBieSBhbnkgbWVhbnMgdGhlIG9ubHkgaW5zdGFuY2Ugb2YgdGhp
cyBpc3N1ZSBhbmQgQ2FsYyBjYW5ub3QgYmUgZXhwZWN0ZWQgdG8gYmUgYSBtaW5kIHJlYWRlci4g
CgpJIHNvbHZlIHRoaXMgInByb2JsZW0iIGJ5IENvcHlpbmcgY2VsbHMgdGhhdCBoYXZlIG5vdCBi
ZWVuIGFmZmVjdGVkIGJ5IHRoZSBpbnNlcnQgYW5kIHRoZW4gUGFzdGluZyBvciBQYXN0aW5nIFNw
ZWNpYWwgKGZvcm11bGEpIGludG8gdGhlIHJvd3MgKGNvbHVtbnMpIHRoYXQgYXJlIG5lYXIgZW5v
dWdoIHRvIHRoZSBpbnNlcnQgcG9pbnQgdG8gbmVlZCB0aGlzIG1hbnVhbCBpbnRlcnZlbnRpb24u
IE9ubHkgYSBsaXZpbmcsIGJyZWF0aGluZywgcGVyc29uIGtub3dzIHdoYXQgcm93cyAoY29sdW1u
cykgdGhvc2UgbWF5IGJlLgoKVGlwOiBDYWxjIGRvZXMgcGVybWl0IENvcHlpbmcgY2VsbHMgYmVm
b3JlIHBlcmZvcm1pbmcgYW4gaW5zZXJ0IG9yIGRlbGV0ZSBhbmQgdGhlbiBQYXN0aW5nIG9yIFBh
c3RpbmcgU3BlY2lhbCBsYXRlci4gSSBoYXZlIGVuY291bnRlcmVkIG90aGVyIG9mZmljZSBzdWl0
ZXMgdGhhdCBkb24ndCBwZXJtaXQgdGhpcy4KCi0tIApKaW0KCi0tLS0tT3JpZ2luYWwgTWVzc2Fn
ZS0tLS0tCkZyb206IEJyaWFuIEJhcmtlciA8Yi5tLmJhcmtlckBidGludGVybmV0LmNvbT4KVG86
IHVzZXJzQGdsb2JhbC5saWJyZW9mZmljZS5vcmcKU2VudDogV2VkLCAwNCBKYW4gMjAxNyA5OjI3
ClN1YmplY3Q6IFJlOiBbbGlicmVvZmZpY2UtdXNlcnNdIENhbGMgT3B0aW9ucyA+IExpYnJlb2Zm
aWNlIENhbGMgPiBHZW5lcmFsID4gRXhwYW5kIHJlZmVyZW5jZXMgd2hlbiBuZXcgY29sdW1ucy9y
b3dzIGFyZSBpbnNlcnRlZAoKQXQgMTE6MzggMDQvMDEvMjAxNyAtMDUwMCwgQ2hhcmxlcyBNYXJj
dXMgd3JvdGU6Cj5UaGlzIGRvZXNuJ3Qgc2VlbSB0byBiZSB3b3JraW5nIGZvciBtZSwgYW5kIGhh
c24ndCBmb3IgYSBsb25nIHRpbWUsIAo+SSBqdXN0IGtlZXAgZm9yZ2V0dGluZyB0byBhc2sgYW5k
IGdvIGZpbGUgYSBidWcgaWYgaXQgaXMgYnJva2VuLiBJIAo+aGF2ZSBhIHNwcmVhZHNoZWV0IHRo
YXQgaGFzIG51bWVyb3VzIGZvcm11bGFzIGluIGNlcnRhaW4gY2VsbHMgaW4gCj5lYWNoIHJvdy4g
V2l0aCB0aGUgb3B0aW9uIHJlZmVyZW5jZWQgaW4gdGhpcyBlbWFpbCBzdWJqZWN0IGVuYWJsZWQs
IAo+d2hlbiBJIGluc2VydCBhIG5ldyByb3csIHNob3VsZG4ndCBpdCBhdXRvbWF0aWNhbGx5IHBv
cHVsYXRlIHRoZSAKPmNvcnJlc3BvbmRpbmcgY2VsbHMgaW4gdGhlIG5ldyByb3cgd2l0aCB0aGUg
Zm9ybXVsYXMgZnJvbSB0aGUgcm93IAo+YWJvdmUgKG9yIGJlbG93IGlmIEkgaW5zZXJ0ZWQgYWJv
dmUpPwoKTm8sIEkgdGhpbmsgbm90LiBJdCBzaG91bGQgZG8gd2hhdCBpdCBjbGFpbXMsIGkuZS4g
ZXhwYW5kIHJlZmVyZW5jZXMsIApub3QgZHVwbGljYXRlIGZvcm11bGFlLiBJdCdzIG5vdCByZWFs
bHkgYWJvdXQgd2hhdCBpcyBpbiB0aGUgbmV3IHJvd3MgCm9yIGNvbHVtbnMsIGJ1dCBhYm91dCBy
ZWZlcmVuY2VzICplbHNld2hlcmUqIHRvIHJhbmdlcyB3aGljaCBtYXkgb3IgCm1heSBub3QgbmVl
ZCB0byBpbmNsdWRlIHRoZW0uIElmIHlvdSBoYXZlIGEgcmVmZXJlbmNlIHNvbWV3aGVyZSB0bywg
CnNheSwgQjM6QjkgYW5kIHlvdSBpbnRyb2R1Y2UgYSBuZXcgcm93IDYsIHN1Y2ggcmVmZXJlbmNl
cyB3aWxsIAphdXRvbWF0aWNhbGx5IGJlIGV4cGFuZGVkIHRvIEIzOkIxMCBzbyBhcyB0byBpbmNs
dWRlIHRoZSBuZXcgY2VsbCBCNiAKYXMgd2VsbCBhcyB0aGUgb3JpZ2luYWwgc2V2ZW4gY2VsbHMu
IFRoaXMgYXBwbGllcyBpcnJlc3BlY3RpdmUgb2YgdGhlIApjb25kaXRpb24gb2YgdGhlIG9wdGlv
biB5b3UgaWRlbnRpZnkuCgpJZiwgYWx0ZXJuYXRpdmVseSwgeW91IGludHJvZHVjZSBhIG5ldyBy
b3cgMTAgKG9yIGEgbmV3IHJvdyAzKSAtIAphZGphY2VudCB0byBpbnN0ZWFkIG9mIHdpdGhpbiB0
aGUgZXhpc3RpbmcgcmFuZ2UgLSByZWZlcmVuY2VzIAplbHNld2hlcmUgd2lsbCBiZSB1cGRhdGVk
IG9ubHkgaWYgdGhlIG9wdGlvbiBpbiBxdWVzdGlvbiBpcyB0aWNrZWQuCgpJIHRydXN0IHRoaXMg
aGVscHMuCgpCcmlhbiBCYXJrZXIKCgotLSAKVG8gdW5zdWJzY3JpYmUgZS1tYWlsIHRvOiB1c2Vy
cyt1bnN1YnNjcmliZUBnbG9iYWwubGlicmVvZmZpY2Uub3JnClByb2JsZW1zPyBodHRwOi8vd3d3
LmxpYnJlb2ZmaWNlLm9yZy9nZXQtaGVscC9tYWlsaW5nLWxpc3RzL2hvdy10by11bnN1YnNjcmli
ZS8KUG9zdGluZyBndWlkZWxpbmVzICsgbW9yZTogaHR0cDovL3dpa2kuZG9jdW1lbnRmb3VuZGF0
aW9uLm9yZy9OZXRpcXVldHRlCkxpc3QgYXJjaGl2ZTogaHR0cDovL2xpc3RhcmNoaXZlcy5saWJy
ZW9mZmljZS5vcmcvZ2xvYmFsL3VzZXJzLwpBbGwgbWVzc2FnZXMgc2VudCB0byB0aGlzIGxpc3Qg
d2lsbCBiZSBwdWJsaWNseSBhcmNoaXZlZCBhbmQgY2Fubm90IGJlIGRlbGV0ZWQKCg==
--=_Part_1_1114535632.1483574101274
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: base64

PGRpdj5JIGhvcGUgdGhlc2UgY29tbWVudHMgYXJlIGhlbHBmdWwuPGJyLz4KPGJyLz4KSW5zZXJ0
aW5nIG9yIGRlbGV0aW5nIG9uZSBvciBtb3JlIHJvd3MgKGNvbHVtbnMpIHJlcXVpcmVzIG1hbnVh
bCBpbnRlcnZlbnRpb24gaW4gdGVybXMgb2YgcGF0Y2hpbmcgcmVmZXJlbmNlcyBpbiBtYW55IGNh
c2VzIHdoZXJlIGEgZm9ybXVsYSBvbiBvbmUgc2lkZSBvZiB0aGUgaW5zZXJ0IG9yIGRlbGV0ZSBw
b2ludCBpbmNsdWRlcyBhIHJlbGF0aXZlIHJlZmVyZW5jZSB0byBhIGNlbGwgb24gdGhlIG9wcG9z
aXRlIHNpZGUgb2YgdGhhdCBwb2ludC4gVGhlIG1vc3Qgb2J2aW91cyBpcyBhIHJlZmVyZW5jZSB0
byB3aGF0IHdhcyBmb3JtZXJseSBpbiB0

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

[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: Mon, 28 Nov 2016 6:29
Subject: Re: [libreoffice-users] Re: Transferring Markdown Documents to 
LibreOffice

There is a utility called MultiMarkdown that will write flat ODF files
readable by LO.

On Nov 28, 2016 8:34 AM, "H"  wrote:

> On 11/28/2016 03:11 AM, Marc Paré wrote:
>
>> Hi Tim
>>
>> Le 2016-11-27 à 18:02, Tim---Kracked_P_P---webmaster a écrit :
>>
>> Does CentOS 6.8 have access to the "ttf-mscorefonts-installer" package?
>>>
>>> This package includes Arial and Times New Roman and many of the core
>>> fonts you get with a Windows install.  I use the DEB package, but
>>> hopefully there is a RPM package as well.
>>>
>>> On my main laptop, I have Arial in "normal" style, monospaced,
>>> condensed, narrow, and rounded font sets.
>>>
>>> Actually, I have over 180 fonts in my ".font"folder, and have over 14GB
>>> of font files on my "file server".
>>>
>>>
>> No need to add fonts, LibreOffice will substitute quite easily with the
>> Liberation family of fonts which are pretty well identical to Arial, the
>> same with Times font. No need to install any MS fonts if you don't need to.
>> The fonts shipped with LibreOffice are such that they will offer the
>> largest success with respect to interoperability with fonts.
>>
>> Marc
>>
>>
>> I know that but the point is that pandoc seems to have defined certain
> fonts for the various elements in a markdown document which it should not.
> It is irrelevant whether LO has substitutable fonts or not.
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Help with LOCalc formula

[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: [libreoffice-users] Help with LOCalc formula

Best Spreadsheet Experts,
May I ask for help having a more elegant formula in LOCalc (v.5.0.3; win10)

Description
I try to get a little extra to my pension savings by experimenting on 
the share market and follow up the results using Calc (not a database).
I have a spreadsheet with two ranges – range(1) directly above range(2).

r(1) specifies per row every specific purchase/sell event (date, company 
name, amount, etc).
To calculate the actual "to-day"-result for this specific event (row) we 
need the "to-day"-value for this company's share (in e.g. column X), 
which value is taken from respective company's row in col.Z in r(2).
r(1) has yearly 100-130 rows (events)

Range(2) lists each company named in the above Range(1) and has in col.Z 
the corresponding share's "to-day"-value. These inserted share values 
varies from one day to the next.
There are now 10-15 companies (rows) listed in r(2) – not in alphabetic 
order.
r(2) sums the up-to-date result per company and the total result.

Problem
The belowe example simplified to 5 events concerning 3 companies may 
clearify the problem with the formula in X1 copied down col.X:
=if(B1=$B$20;$Z$20;if(B1=$B$21;$Z$21;(ifB1=$B$22;$Z$22;0)))

As you can see: with 15 (or more) companies (and >100 events) the 
formula will grow and become very long and sensitive for mistakes.
VLOOKUP does not seem to be an option, at least it requires a completely 
new setup of the page.

Range(1) - events
A   B C…. X
1. nokia   5,o
2. kone 41,o
3. nokia   5,o
4. fiskars 12,o
5. kone41,o

Range(2) - companies
A B C... Z
20 nokia   5,o
21 fiskars   12,o
22 kone 41,o

Any suggestion will be very interesting.
Thank you in advance
Pertti Rönnberg/Finland


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] F-Droid

[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: "users@global.libreoffice.org" 
Sent: Mon, 03 Oct 2016 15:49
Subject: Re: [libreoffice-users] F-Droid

2016-10-04 0:31 GMT+02:00 toki :

>
> > therefore why is it up to LO users to update their directory.
>
> F-Droid only lists FLOSS that specifically requests to be included. One
> of the few responsibilities of the requester, is that both app updates,
> and program descriptions are kept current.
>
> As such, it is legitimate to ask why the app has not been updated at
> F-Droid.


​There's nothing on the F-Droid page for the viewer or in the submission
thread that indicate submission from the LibreOffice​ foundation. As far as
I can tell, it was submitted by someone at Collabora, who isn't there
anymore.

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Spelling check funnies

[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 speller maintainer.

I have just added to it:
15023) Ainsworth (+'s - name - Wikipedia)
15024) Bleiler (+'s - name - Wikipedia)
15025) Colburn (+'s - name - Wikipedia)
15026) Chetham (+'s - name - Wikipedia)
15027) Routledge (+'s - name - Wikipedia)
15028) Malkin (+'s - name - Wikipedia)
15029) Potts (+'s - name - Wikipedia)
15030) Slater (+'s - name - Wikipedia)
15031) Crossley (+'s - name - Wikipedia)
15032) Heswall (+'s - name - Wikipedia)

Every two months there is a release for OpenOffice and LibreOffice.

It will be fixed when that happens.

Kind regards,
 >Marco A.G.Pinto
   


On 24/09/2016 13:06, John Willerton wrote:
> Hi All,
>
>
> I read the forum regularly but this is my first post. It's only
> light-hearted but I don't see why that should be against the rules.
>
> Using the spelling checker in LO Writer version 5.0.5.2 on Windows 7 Pro, I
> recently passed over a fairly common English surname, "Ainsworth".
>
> The spelling checker gave some wonderful suggestions,

…

> Has anyone else found some funnies. If so ,why not share them? The forum
> does not have to be grindingly technical all day every day.
>

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 document as a background.

The key was how you took the original image and modify it with 
brightness and contrast controls till it looked like a watermark. This 
was with OOo since LO was not created yet.

My best one was a letterhead logo that printed out using a laser printer 
and would not be viewable when you used a scanner or copy machine.  I 
used it for a not-for-profit organization that I have been on the board 
with since 2007[?].

[ Almost sounds like magic! -- jl ]

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Islamic Calendar

[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 point to or explain why Islamic Calendar functions
> are only available for the following locales:
> * ar_EG: Arabic Egypt;
> * ar_LB: Arabic Lebanon;
> * ar_SA: Arabic Saudi Arabia;
> * ar_TUN: Arabic Tunisia;
>
> I couldn't find anything on the LibreOffice website in English, Dutch,
> or German. Baidu, Yandex, DuckDuckGo were equally uninformative. :(
>
> jonathon
That's an interesting question. Why should calendars be tied to locales? 
For example, an English-speaking Muslim living in the EU or North 
America may well want to use an Islamic calendar for some purposes. 
Similarly, an Asian person living elsewhere may find it useful to work 
with the "Chinese" calendar.

And then there are the Julian versus Gregorian calendars use in various 
Christian denominations. While all European nations use the Gregorian 
calendar secularly, the Julian is still used for religious purposes.

Is this a case of the locales being overused for things that aren't 
really location dependent?

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] undo functionality

[James E. Lang]

Hi B. S. 

I am simply a user of LibreOffice, not a developer. 

The tone of the original post on this thread was rather brusk. How do you 
envision undo to function as opposed to how it currently functions (mechanisms 
please -- not just results)? How should a block of changes to be undone be 
defined? This level of discourse was lacking in what was taken to be a rant. 
Vinegar was there but honey was not. 

BTW, you did send a long diatribe to the list which means it went to 
"everybody." No, the Pope and Prime Minister of The Netherlands probably did 
not see it so literally speaking you didn't send it to everybody. 

The first response addressed your tone and stated the reality (like it or not) 
about things getting changed by *developers* who may not find the requested 
change (which in this instance was not identified) to be of immediate interest 
to them. Developers of Open Source projects like LibreOffice are oftentimes 
users of the software themselves. In general there is no hierarchy of managers 
to assign tasks to a programmer on the project whether the programmer is 
interested in the task or not. 

The original responder also suggested that you delve into the code and submit a 
patch that would implement the feature that you feel is lacking. You did state 
in a later post that you are a software developer so aside from the size and 
complexity of the project that ought not to be such a daunting task. Other 
posts by you seem to imply that you are only interested in performing 
development work if you are paid money for doing so. I truly hope I 
misunderstood that. The spirit of FOSS development is entirely different.

Nobody is suggesting that you kiss the ring on the developers' hands. Simply 
state _how_ undo in Writer can be made better. Hopefully that will lead to a 
rational discussion and result in an even better product for everybody. Ranting 
and threatening will accomplish little if any good.

-- 
Jim

-Original Message-
From: "B.S." 
To: Users 
Sent: Wed, 01 Jun 2016 13:35
Subject: Re: [libreoffice-users] undo functionality

Joel Madero schreef op 01-06-2016 22:10:
> :) Funny enough I almost did the same but out of respect for your
> choice to keep things private, I chose not to. You've not given the
> same consideration so:

That's funny indeed.

> Heads up to this user - he has zero respect for the community, enjoys
> wasting everyone time, and wants to use the list as a means to waste
> everyone's time with a long novel (which I rightfully ignored). He
> clearly just is using a user support thread for a free and open source
> project powered by incredible volunteers as a means to complain and
> whine.

Let's explain a little what those statements mean, because it is easy.

First, you are assuming dreadfully wrong intent with everything I have 
written. That is usually a way to disqualify contributions when you have 
no real arguments to do so.

Secondly, I did not send that long novel to everyone, so you are wrong 
again, and attributing something to me, that I clearly consciously 
avoided doing in the first place. Great for that.

Secondly again, you are doing that thing: embellish your own position in 
a way to discredit my own. Not only do you have to state, you feel, to 
treat my attempts here as lacking any merit, but also that my intent is 
for them to not have any merit.

So that thing I just asked you to do: to assume good intent, well, let's 
just say that you are a bit of a hard learner in that sense. Not a 
problem. But still what happens.

You must discredit my entire person to keep support here from other 
people on this list.

And at the same time, you must slime with those other people, and state 
how great you think they are, because I just said that you have rather 
low regard for them.

We call this "damage control mode". I don't think you are all that good 
at it, but all the same, it is just what is.

Hence all those smiles, and those "warmest regards". They are just a 
slight bit insincere, but that doesn't matter, it's the idea or the 
thought that counts, right?


> I stand by what I said - the product works for tens of millions of
> users, I use it daily for professional work, and I have zero will to
> read a multi-page rant from a verbose user that likes going WAY off
> topic. He seems to have a lot more time to waste than I do.

Completely ignoring the topic at hand yourself.

By your logic, because something "works" for millions of people, 
apparently it works "all the time". Or, similarly or conversely, it 
never fails to work for them. After all, it is just some blanket 
statement. A car may work for millions of people too, even if it breaks 
down every 20 miles. Depends on your definition of "working" doesn't it? 
Further more, it says nothing about things that might be improved, or 
things that might be individually lacking. It is just a way of avoiding 
that subject.

And actually I have no time to waste but a good reason why I am 
doin

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

[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] Re: Calc method to change whole column cell 
content

Hi :)
CSV format can be easily edited in normal text-editors before opening in
Calc.  Sometimes its easier to use a simpler tool to do a part of the job
rather than use a complicated route in a heavier tool such as Calc.
Regards from
Tom :)


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Volunteers for Documentation

[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 criticism. My native language is 
English (US) though I also spent 3 1/2 years in New Zealand where English (UK) 
is the norm. I am a 77 year old retired computer programmer without database 
experience. I use LibreOffice Calc heavily and LibreOffice Writer sporadically.

It would be my honor to be able to give back to the project in the manner 
suggested.

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 origination process 
around 19 Sep 2013. Maybe he changed ISPs or changed from one eMail client to 
another or to a web mail interface. I don't know but there is a definite 
problem there.

-- 
Jim

-Original Message-
From: Nino Novak 
To: users@global.libreoffice.org
Sent: Sat, 12 Mar 2016 2:27
Subject: [libreoffice-users] Re: Not archived mails at Gmane

On 04.01.2016 at 15:51 Nino Novak wrote:
> On 04.01.2016 at 14:49, Brian Barker wrote:
>> At 07:51 04/01/2016 -0500, William Drescher wrote:

>>> Brian's original post never did show up in my newsgroup feed (gmane).
>>
>> How right you are! Nothing from me has appeared in Gmane since 19 September
>> 2013. You may have to choose a service which works, without censoring 
>> replies.
>>
>> Does anyone know why I am persona non grata? I wonder how many others are ...
> 
> Strange, in deed.
> 
> I just sent a request for explanation to gmane.org, will report their
> reaction hopefully soon :)

Here is what I asked and what Lars from Gmane.org replied :

 in gmane.comp.documentfoundation.libreoffice.user, mails written by Brian
 Barker obviously do not get archived since 19 Sept 2013 (exact date not
 verified).
 
 Can you explain, why?

>>> The usual reason is that the messages in question contain the
>>> X-No-Archive header.  I haven't examined the messages in question,
>>> though.
>> 
>> As you could see from the attached mail I sent you, it has no X-No-Archive
>> header. So there is no obvious reason not to archive it at Gmane from my
>> POV. But yet it is omitted. Can we have it archived, please?
> 
> There are no filters for content on Gmane, so there's nothing I can do.

Now, I have no more ideas what else we could do about this issue. It remains
a mystery.

Sorry for that,
Nino



-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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, 20 Feb 2016 15:39
Subject: [libreoffice-users] Calc: background color in cells invisible

Hi,
In Calc the background color feature of cells is not working.
Who can give me any advice in which LO version the background formating is
working properly.
LO V5.0.4.2 on Win7.
Thanks for any ideas,
mars



--
View this message in context: 
http://nabble.documentfoundation.org/Calc-background-color-in-cells-invisible-tp4176124.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 she using the same version 
of LO? Is her computer faster? Does it have more memory? You need to follow up 
on all these questions.

-- 
Jim

-Original Message-
From: nasrin khaksar 
To: Steve Edmonds 
Cc: users@global.libreoffice.org
Sent: Tue, 16 Feb 2016 10:54
Subject: Re: [libreoffice-users] a question about openning large document with 
libreoffice writer:

hi again.
my system is little old.
my system property is:

System Properties

System:
Microsoft Windows XP
Professional
Version 2002
Service Pack 3
System Properties

System:
Microsoft Windows XP
Professional
Version 2002
Service Pack 3
Computer:
Genuine Intel(R) CPU
 T2250  @ 1.73GHz
1.73 GHz, 2.49 GB of RAM
Physical Address Extension
and my file is doc.
libreoffice is very fast and responsive in docx and odt file in
compare to doc files.
i tried many versions of libreoffice and the result was approximately the same.

On 2/16/16, Steve Edmonds  wrote:
> It is interesting that there are similarities with the recent discussion
>   Re: LO5.1 on Linux - Opening Writer document takes >1hr Able to be
> viewed on nabble
>
> View this message in
> context:http://nabble.documentfoundation.org/LO5-1-on-Linux-Opening-Writer-document-takes-1hr-tp4175443p4175491.html
>
> What version of LO do you have.
> Steve
>
> On 2016-02-17 03:57, nasrin khaksar wrote:
>> hi every one.
>> i have a question when i want to open one document which has 960 pages
>> and about 9.5 mb with writer on windows xp.
>> when i try to open it, it needs exactly 1 hour and 45 minute to be
>> opened completely.
>> i gave my document to my sister for testing.
>> for her it took only 65 minute for openning.
>> whats the problem source and what should i do?
>> i think that my document is simple without images and graphical
>> thinks, but i am not shure.
>> because i use nvda screen reader and i dont know about graphics.
>> thanks for your answer and god bless you all.

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[James E. Lang]

Thank you, Piet. 

So do I need to install LO 3.6.7.2 in order to correct this? Or, should I 
implement the following twelve steps?

1) use my eMail client to copy these frequent reports to my computer from Gmail

2) run a script or program to:

2.1) open that file

2.2) strip out everything before 

2.3) unpack the Quoted-Printable encoding (preserving the character set 
specification somehow)

2.4) save the file

3) switch to Calc

3.1) insert a temporary sheet from the file

3.2) select all data from that sheet

3.3) switch to the sheet where the data belongs

3.4) paste in the appropriate location

3.5) delete the temporary sheet

I think all those steps are doable. Per your suggestions, step 3.1 could be 
"open the HTML file in LO," step 3.3 would be "switch to the main document," 
and step 3.5 would be "close the source (temporary) spreadsheet without saving 
it. As I see it step 2.3 is the most complex.

-- 
Jim

-Original Message-
From: Piet van Oostrum 
To: "James E. Lang" 
Cc: users@global.libreoffice.org
Sent: Fri, 05 Feb 2016 2:39
Subject: Re: [libreoffice-users] Pasting Tabular Data Into Calc From An HTML 
Source

James E. Lang wrote:

 > 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 via Pegasus Mail I have two potentially
 > useful ways to paste the content of these reports into LO Calc
 > (HTML and RTF). Each of these has a issue though I can work with
 > the RTF method far more easily than the HTML method.
 > 
 > My problem with the HTML method (which, by the way, also exists
 > with tables of data copied directly from my power company's web
 > site) is that the header row () contains a colspan attribute
 > that is misapplied by LO. In this  row the first (and only)
 > field is not merged across any columns to its right but it should
 > be merged across 14 additional columns. In the first row below that
 > the first field is not (nor should it be) merged at all but in the
 > next four rows the first field is erroneously merged progressively
 > over 15, 29, 43, and 57 columns. The first (and again only) field
 > in the second table's  row is merged across 71 columns instead
 > of 11. The first field of next row is merged across the same 71
 > columns though it should not be merged at all and on the remaining
 > two rows the first field is erroneously merged across 81 and then
 > 91 columns.
 > 
 > Has anyone else experienced this anomaly?
 
This is a known bug: https://bugs.documentfoundation.org/show_bug.cgi?id=74577
 
It seems this bug is more or less forgotten, as it is a regression, it has been 
identified when the bug was introduced, but there has been no activity for more 
than one year.

By the way, I noticed some anomalies in your HTML code. When I opened it in 
Firefox, two fields of the tables had moved out of the tables. It appears there 
are some Non-Breaking-Spaces in it which cause this. After replacing these with 
normal spaces, the tables appear as they should.

Secondly, when I open the HTML file with LibreOffice (version  5.1 RC 3) it 
opens as a spreadsheet with the correct layout, except the background colors. 
Also possible with Sheet > Insert Sheet From File.
So this might be a workaround for you.
-- 
Piet van Oostrum 
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 via Pegasus Mail I have two potentially useful ways to 
paste the content 
of these reports into LO Calc (HTML and RTF). Each of these has a issue though 
I can work 
with the RTF method far more easily than the HTML method.

My problem with the HTML method (which, by the way, also exists with tables of 
data copied 
directly from my power company's web site) is that the header row () 
contains a colspan 
attribute that is misapplied by LO. In this  row the first (and only) field 
is not merged 
across any columns to its right but it should be merged across 14 additional 
columns. In the 
first row below that the first field is not (nor should it be) merged at all 
but in the next four 
rows the first field is erroneously merged progressively over 15, 29, 43, and 
57 columns. The 
first (and again only) field in the second table's  row is merged across 71 
columns 
instead of 11. The first field of next row is merged across the same 71 columns 
though it 
should not be merged at all and on the remaining two rows the first field is 
erroneously 
merged across 81 and then 91 columns.

Has anyone else experienced this anomaly? 

I don't know how LO determines what is a numeric field amd what is a textial 
field when 
pasting from the clipboard by my problem with the RTF method is LO gets it 
backward. Cells 
that received numeric fields get formatted as Category Text with Format @ and 
those that 
receive textual fields get formatted as Category Number with Format General. 
This means 
that if I subsequently enter a formula [e.g. =SUM(A5:A15)] where a numeric 
field (e.g. 5 or 
$7.52) had been that formula gets interpreted as text instead of being 
interpreted as a 
formula. The values in A5:A15 (which were also pasted from an HTML source) are 
zero since 
they are formatted as text so the formula can not work anyway. This is not 
theory. I stumbled 
upon this when i tried to shift some columns without retaining their former 
location info (Copy, 
Del, Pas
Can anyone else verify this?

Are there any bugzilla reports regarding any of these issues? Into how many 
bugzilla reports 
should I break this down? [HTML -- 1? or 2?. RTF -- 1? or 2? Inability to enter 
a formula that 
is recognized as such into a Category Text Format @ cell -- ?] I see the 
possibility of possibly 
as many as five separate bugzilla reports but I don't look forward to 
submitting them.

--
Jim

=== Start of the source HTML data =
Pizza Deliver=
iesCHKTicketWhereWhenLastPriceCashCard=E2=88=86 paypayreconcilia=
tiontipincome=
OrdersNote812718Address 1=
 2/3/16, 8:54 PM1$54.4=
7$59.47$5.74-$10.74$5.00$10.741<=
td nowrap=3D""><=
/td>812719Address 2 2/3/16, 8:55 PM1$42.98$49.98<=
br>$4.67-$11.67$7.00$11.67=
1812719Address 2=
 2/3/16, 8:56 PM1-$0.67$0.00$0.00$0.00$0.000second trip to excha=
nge salad dressings0/3$97.45$0.00$109.45-$0.67$10.41-$22.41$12.00$22.412=
Other TransactionsCHKTicketWhere<=
th nowrap=3D"">WhenLastPrice<=
th nowrap=3D"">CashCardpay=E2=88=86 payNote812719Address 2 2/3/16, 8:56 PM1=
$0.00=
-$0.670/1$0.00$0.00$0.00=
$0.00-$0.67Sent from my iPad=
 
=== End of pasted raw view of the second part =
  
--- End of forwarded message ---


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 Writer who mostly uses it as a text 
document reader like the original poster said describes his usage of LO, it 
makes little difference which version of LO one uses. 

The diatribe that occurred against the original poster's signature block is 
regrettable and in my opinion unwarranted. While I'm convinced that Islam is in 
error and Christianity is true, I can pray for the followers of Islam and for 
the peace of Jerusalem.

-- 
Jim

-Original Message-
From: Tom Davies 
To: "Andreas Säger" 
Cc: "users@global.libreoffice.org" 
Sent: Wed, 20 Jan 2016 19:24
Subject: Re: [libreoffice-users] Re: question about the best version of 
libreoffice:

Hi :)
+1
errr, at least wrt 3.5 - i'm not sure about trolls.

I think as a general rule the later versions of a branch tend to be more 
reliable in terms of their functionality and probably more stable too (although 
i've never had LO out-right crash or anything).  So for the 3.5 branch the 
3.5.4 was probably more stable and reliable than the 3.5.0.  With the 4.2 
branch hopefully it's become smoother and more reliable with each "Service 
Pack", such that 4.2.1 was a bit better, 4.2.2 quite a bit better, 4.2.3 even 
better and with the 4.2.5 being nearly the best.  The best version in the 4.2 
branch 'should be' the 4.2.6 but sometimes branches don't bother to go that far 
because the x.x.5 was plenty "good enough" (or other reasons for moving onto a 
newer branch).

The advantage with newer branches 'should be' that they just have better 
functionality, greater compatibility with the ever-changing MS formats.  
Although they are initially "stable" (using the devs definition of the word - 
errr and extra-ordinarily so, especially when compared to pretty much any other 
software apparently) some older functionality may have temporarily been 
inadvertently broken. Hopefully the "code clean-up" has significantly reduced 
the amount of unexpected breakages of completely unrelated things.

So the 4.3.6 should be about as stable and reliable as the 4.2.6 and the 4.4.6. 
 There is not much point in trying out the earlier releases of any branch, just 
skip straight to the one with the highest 3rd digit.

However what 'should be' and "what really is" are often completely opposite 
from each other in so many areas of life.  So i would be fairly interested in 
Nasrin's opinions about how closely the last few branches seem to have followed 
that "general rule", especially "with
regards to" ( = wrt ) "accessibility issues" such as screen-readers.

There is a separate mailing list for accessibility issues but it's so inactive 
that i doubt anyone is still on it and it may have even been closed down a few 
years ago without me noticing it being stopped.  I suspect that a lot of people 
moved to Apache Open Office when IBM donated it's fork of OO.o to AOO.  
OpenOffice is such a close relative of LibreOffice nowadays that it doesn't 
make a huge difference which is being used imo.

I think the main thing creating a problem for "what should be" is Java and 
Base.  If they can be avoided then maybe the "general rule" is fairly valid.  
With either Base or Java being used then it becomes a lot less clear, unless 
things have changed radically in the last couple of years.

Regards from
Tom :)

On 20 January 2016 at 12:51, Andreas Säger  wrote:
> Am 20.01.2016 um 13:36 schrieb Andreas Säger:
>>
>> I used 3.5 for many years with no problems.
>>
>>
>
> Oh, shit. Did I feed a troll?

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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- don't show the decimal point

You need Format > Cells > Numbers: Format code = 

With this, 0.1 appears as "" and 0.6 as "0001".

[He wants 0.1 to appear as "1000" and 0.6 as "6000".

[The first response he received is the most simple. Calc has no method to 
directly format numbers the way he wants them.

[He stated that he wants the trigonometric function values unchanged (as I 
understood him: directly usable in calculations without a finagle factor) but 
DISPLAYED without the decimal point character. Hiding the true value column and 
displaying with format "" a column with values ten thousand times the true 
value is by far his best solution as I see it. -- jl]

For more on this, see 
"https://help.libreoffice.org/Common/Number_Format_Codes";

[This does not address his issue which is to suppress the decimal point before 
the fractional part of the number. -- jl]

   Spencer Graves


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc formula syntax assistance

[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, 
however, perhaps my issue does not require an update.

Anyway, the formula involves COUNTIF with the search range on another 
sheet and the search criteria in a cell adjacent to the countif formula.

=COUNTIF(Data.$C$4:C$492,$B17)

[Did you try this?
=COUNTIF(Data.$C$4:$C$492,.$b17)
Note, I made two adjustments to your formula
• Absolute column reference for the end of the range (your probable intent)
• Sheet reference in the search criteria
The second change is likely to resolve your problem. If not, then you may have 
one or more cells with extraneous space(s). If the extraneous space(s) are in 
the search criteria you can add the TRIM function call there. -- jl]

Each search criteria (B17), is text consisting of spaces, numbers and 
special characters i.e. BLUE GUM LANE (NO'S 1 – 17)

On my version of LO this formula displays a zero as the count of the 
search criteria however on reviewing the Data sheet, I can identify at 
least one exact replica within range, yet it is not counted?

Any ideas to get the correct answer of the number of times a field appears?

Regards
Hylton

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] double brackets

[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- to the front of the original file name. Then experiment 
with this test copy. Twenty thousand rows are not to be trifled with while 
poking and prodding a live file. Also remember that you can generally undo your 
experimental changes.

See further comments below.

-Original Message

At 02:16 14/12/2015 +0900, Thomas Blasejewicz wrote:

>Setting the language under "Format cells" -> "numbers" to German now 
>switches SOME (but not all) numbers like "50,000" to "50.000" 

Regarding those that did not change: 

Are these values computed? If yes, what is done in the formula? Or if no, try 
F2 and look to see whether the number is preceded by a single quote 
(apostrophe) which signifies that the number is a text string instead of a true 
number. 

What is the number format (Alt+O, L) for those cells? Though unlikely, it is 
possible that a custom format has been employed.

>(Some) 
>Numbers appearing on the screen as "5" do not change at all. 

Same comments.

>The 
>latter one being the German localization. I am still fighting with 
>the problem, that this works in some cells, but not all (probably 
>because of the format of the entered data?). It would be helpful to 
>find a way change the thousand separator for "," to "." and the 
>decimal separator the other way around, because there are quite 
>literally thousands of items that need to be changed that way ...

The German language localization should have done that for true numeric values 
that are formatted with the thousands separator attribute.

Brian also gave you very good information about numbers as text.

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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:
> dave boland wrote
> > On Mon, Dec 7, 2015, at 11:35 AM, Regina Henschel wrote:
> >> Hi Dave,
> >> 
> >> dave boland schrieb:

-->8=

Oh, I have GIMP 2.8.14,
and LO version 5.0.2.2.  The O.S. in Ubuntu 15.15.  

[Ubuntu 15.10? Ubuntu tags its distributions with year.month with releases in 
April and October. Thus 15.10 is the October, 2015 version. -- jl]

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 operations?

On 27 Nov 2015 at 12:31, Brian Barker wrote:

Date sent:  Fri, 27 Nov 2015 12:31:39 +
To: users@global.libreoffice.org
From:   Brian Barker 
Subject:Re: [libreoffice-users] How to return cell address/reference
instead of function result with 2d operations?

> At 22:07 27/11/2015 +1000, Michael D. Setzer II wrote:
> >On 27 Nov 2015 at 11:11, Brian Barker wrote:
> >>At 03:56 27/11/2015 -0500, Edwar Cifuentes wrote:
> >>>On 11/26/2015 09:26 AM, Tom Webb wrote:
> On 2015-11-25 17:26, Edwar Cifuentes wrote:
> >When using functions like MAX on a 2d range how can I get the 
> >cell's address/reference returned instead of the result value?
> >e.g. if I have this table starting at A1...
> >123
> >456
> >How can I get ... C2 Instead of ... 6
> >
> >I know I could something containing MATCH if it were just a 
> >single row or column but here I have a table spanning several 
> >rows and columns and there seems to be no equivalent of MATCH 
> >for these situations.
> 
> The following will find the address of the Max value. If there 
> are duplicate values it shows the last location.
> =ADDRESS(MAX((A1:C2=MAX(A1:C2))*ROW(A1:C2)),MAX((A1:C2=MAX(A1:C2))*COLUMN(A1:C2)),4)
> This is an array function and you need to use Ctrl-Shift-Enter 
> instead of Enter.
> >>>
> >>>Hey, this works!
> >>
> >>Sadly, I don't think it does. If the largest value happens to be 
> >>duplicated in different rows and columns, the formula generates the 
> >>address of neither but instead that of the intersection of that row 
> >>and that column. Try changing either B1 or A2 to 7: for such 
> >>separate changes the formula works. But now change both B1 and A2 
> >>to 7: the formula generates neither B1 nor A2 but B2 - which is not 
> >>either of the cells containing the equal largest values.
> >>[...]
> >
> >In my testing, I didn't see that, it appears to result with the last 
> >one highest values.
> 
> So you cannot have tested with the particular rogue case I 
> identified, then: identical largest values in both different rows and 
> different columns? The problem will show up, of course, only if the 
> intersection of the relevant row and column - the incorrect result - 
> doesn't happen to be one of the cells containing those identical 
> largest values.

You are correct, I had generally had the highest value in C2, and then 
duplicated it in other cells, and it kept giving me c2, but when c2 has a lower 
value but c1 did, it did still give c2. I've only seen that the conditional 
formatting with the condition to equal max(a1:c2) highlights all the matching 
cells. Just don't know if there is a further method needed to get the cell 
address or just highlighting the cell.

[My comments follow. -- jl]

Conditional formatting significantly slows updates in large spreadsheets. I 
suggest using

MAX(OFFSET(A1,(MAX(A1:C2=MAX(A1:C2))-1),0,1,COLUMNS(A1:C2))*ROW(A1:C2)=MAX(A1:C2))*COLUMN(A1:C2)

instead of 

MAX(A1:C2=MAX(A1:C2))*COLUMN(A1:C2) 

as the Column parameter in the ADDRESS() function call. This should find the 
last occurrence of the maximum value in the last row that contains that value.

That said, when I tried the originally proposed formula I ended up with an 
array displaying

F6L6   R6
F12 L12 R12

instead of C3. I don't understand why.

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users]

[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
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: base64

CgotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQpGcm9tOiBCcmlhbiBCYXJrZXIgPGIubS5iYXJr
ZXJAYnRpbnRlcm5ldC5jb20+ClRvOiB1c2Vyc0BnbG9iYWwubGlicmVvZmZpY2Uub3JnClNlbnQ6
IEZyaSwgMjcgTm92IDIwMTUgMTE6MjYKU3ViamVjdDogUmU6IFtsaWJyZW9mZmljZS11c2Vyc10g
SG93IHRvIHJldHVybiBjZWxsIGFkZHJlc3MvcmVmZXJlbmNlIGluc3RlYWQgb2YgZnVuY3Rpb24g
cmVzdWx0IHdpdGggMmQgb3BlcmF0aW9ucz8KCkF0IDEzOjU2IDI3LzExLzIwMTUgLTA1MDAsIEVk
d2FyIENpZnVlbnRlcyB3cm90ZToKPk9uIDExLzI3LzIwMTUgMDY6MTEgQU0sIEJyaWFuIEJhcmtl
ciB3cm90ZToKPj5JdCdzIEJvb2xlYW4gZXhwcmVzc2lvbiwgZ2l2aW5nIHRoZSByZXN1bHQgVFJV
RSBvciBGQUxTRS4gSXQncyAKPj50ZXN0aW5nIHRoZSBpbmRpdmlkdWFsIGNlbGxzIGluIHRoZSBy
YW5nZSBBMTpDMiB0byBkZXRlcm1pbmUgCj4+d2hldGhlciB0aGV5IGFyZSBlcXVhbCB0byB0aGUg
bWF4aW11bSB2YWx1ZSBvZiB0aGF0IHJhbmdlLiBJdCBtYXkgCj4+c2VlbSBzdHJhbmdlIHRvIGJl
IGFibGUgdG8gd3JpdGUgc3VjaCBhbiBleHByZXNzaW9uIGZvciBhbiBlbnRpcmUgCj4+cmFuZ2Ug
aW5zdGVhZCBvZiBmb3IgaW5kaXZpZHVhbCBjZWxscywgYnV0IHRoYXQgaXMgdGhlIHBvd2VyIG9m
IGFycmF5IGZvcm11bGFlLgoKW1NvLCBkb2VzID1TVU0oQTE6QzI9TUFYKEExOkMyKSkgcmV0dXJu
IGEgY291bnQgb2YgY2VsbHMgdGhhdCBlcXVhbCB0aGUgbWF4aW11bSB2YWx1ZT8gSSdtIGN1cnJl
bnRseSBhd2F5IGZyb20gYSBjb21wdXRlciB3aGVyZSBJIGNvdWxkIHRlc3QgdGhpcy4KClNvbWVv
bmUgcG9pbnRlZCBvdXQgdGhhdCBhbiBpbmNvcnJlY3QgYWRkcmVzcyBtaWdodCBiZSByZXR1cm5l
ZCBpZiB0aGVyZSBpcyBhIG5vbiBjb2xpbmVhciBwYWlyIG9mIG1heGltdW0gdmFsdWVzLiBDYW4g
dGhpcyBiZSByZXNvbHZlZCB0byBsb2NhdGUgYSBtYXhpbXVtIGNlbGwgYnkgdXNpbmcgdGhlIE9G
RlNFVCgpIGZ1bmN0aW9uPyBXaGF0IEknbSBwcm9wb3NpbmcgaXM6Cgo9QUREUkVTUyhNQVgoKEEx
OkMyPU1BWChBMTpDMikpKlJPVyhBMTpDMikpLE1BWCgoT0ZGU0VUKEExLE1BWCgoQTE6QzI9TUFY
KEExOkMyKSkqUk9XKEExOkMyKSktMSwwLDEsMyk9IApNQVgoQTE6QzIpKSpDT0xVTU4oQTE6QzIp
KSw0KQoKT25jZSBhZ2FpbiBJIGFkbWl0IHRvIG5vdCBoYXZlIHRlc3RlZCB0aGlzIGJ1dCBpdCBs
b29rcyB0byBtZSBsaWtlIGl0IG91Z2h0IHRvIHdvcmsuIFRoZSBPRkZTRVQoKSBmdW5jdGlvbiBj
YWxsIHJlc3RyaWN0cyB0aGUgc2VhcmNoIGZvciB0aGUgY29sdW1uIGNvbnRhaW5pbmcgdGhlIG1h
eGltdW0gdmFsdWUgdG8gYSByb3cgdGhhdCBpcyBrbm93biB0byBjb250YWluIHRoYXQgdmFsdWUu
IC0tIGpsXQoKLS0gCkppbQoKPkkgc2VlLiBJIGVudGVyZWQgPShBMTpDMiA9IE1BWChBMTpDMikp
IGluIGEgc2VwYXJhdGUgY2VsbCBhbmQgaXQgCj5nZW5lcmF0ZWQgYSAyeDMgdHJ1ZS9mYWxzZSB0
YWJsZSBjb3JyZXNwb25kaW5nIHRvIHRoZSBvbmUgSSBjcmVhdGVkLiAKPlRoZSBib3R0b20gcmln
aHQgY2VsbCByZXR1cm5lZCBUUlVFIGJlY2F1c2UgaXQgY29ycmVzcG9uZHMgdG8gNiwgdGhlIAo+
aGlnaGVzdCB2YWx1ZSBpbiBteSBvcmlnaW5hbCB0YWJsZS4KPgo+PVJPVyhBMTpDMikgZ2VuZXJh
dGVzIGEgb25lIGNvbHVtbiB0YWJsZSB3aXRoIG51bWJlcmVkIHJvd3MuCj4KPk5vdywgdGhlIHdo
b2xlIGZpcnN0IGFyZ3VtZW50IG9mIHRoZSBBRERSRVNTIGZ1bmN0aW9uIGlzIAo+PShNQVgoKEEx
OkMyPU1BWChBMTpDMikpKlJPVyhBMTpDMikpKSwgd2hpY2ggbG9va3MgbGlrZSAKPiJtdWx0aXBs
eWluZyIgYSB0YWJsZSBieSBhbm90aGVyIHRhYmxlLiBXaGF0IGRvZXMgaXQgcmVhbGx5IG1lYW4/
IAo+ZG9lcyBpdCBraW5kIG9mIHN1cGVyaW1wb3NlIHRoZSB0d28gdGFibGVzIGFuZCByZXR1cm4g
dGhlIGhpZ2hlc3QgCj52YWx1ZT8gZG9lcyBpdCBtdWx0aXBseSB0aGUgaGlnaGVzdCB2YWx1ZSBm
cm9tIHRhYmxlIDEgd2l0aCB0aGUgCj5oaWdoZXN0IGZyb20gdGFibGUgMj8gb3Igd2hhdCBkb2Vz
IGl0IGV4YWN0bHkgZG8/CgooSXQncyBub3QgbXkgZm9ybXVsYSwgaW4gZmFjdCwgYnV0IC4uLikg
dGhlIG11bHRpcGxpY2F0aW9uIGlzIGJldHdlZW4gCnRoZSByZXNwZWN0aXZlIEJvb2xlYW4gdmFs
dWVzIGFuZCB0aGUgcmVsZXZhbnQgcm93IG51bWJlcnMuIFRoaXMgCnJlbGllcyBvbiB0aGUgZmFj
dCB0aGF0IENhbGMgc3RvcmVzIFRSVUUgYXMgb25lIGFuZCBGQUxTRSBhcyB6ZXJvLiBTbyAKdGhl
IEZBTFNFICh6ZXJvKSB2YWx1ZXMgLSBmb3IgY2VsbHMgd2l0aCBzbWFsbGVyIHZhbHVlcyAtIHN1
cHByZXNzIAp0aGVpciByb3cgdmFsdWVzLCBhbmQgdGhlIFRSVUUgKG9uZSkgdmFsdWUgLSBmb3Ig
dGhlIGNlbGwgY29udGFpbmluZyAKdGhlIGxhcmdlc3QgdmFsdWUgLSBwcmVzZXJ2ZXMgdGhlIHJv
dyB2YWx1ZSBmb3IgdGhhdCBjZWxsLiBBbmQgdGhhdCAKb25lIHJlbWFpbmluZyB2YWx1ZSBtdXN0
IG5vdyBiZSBmb3VuZCBieSBNQVgoKSBhcyB0aGUgbGFyZ2VzdC4gQSAKc2ltaWxhciBwYXJ0IG9m
IHRoZSBvcmlnaW5hbCBmb3JtdWxhIGV4dHJhY3RzIHRoZSBjb2x1bW4gbnVtYmVyICgxIApmb3Ig
Y29sdW1uIEEsIDIgZm9yIGNvbHVtbiBCLCBldGMuKSBhbmQgdGhlIEFERFJFU1MoKSBmdW5jdGlv
biAKY29tYmluZXMgdGhlc2UgdHdvIG51bWJlcnMgdG8gZm9ybSB0aGUgYWRkcmVzcyBvZiB0aGUg
cmVxdWlyZWQgY2VsbCAKaW4gdGhlIGZvcm0gIkMyIiAob3Igd2hhdGV2ZXIpLgoKSSB0cnVzdCB0
aGlzIGhlbHBzLgoKQnJpYW4gQmFya2VyCg==
--=_Part_0_428968938.1448656389157
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: base64

PGJyLz4KPGJyLz4KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS08YnIvPgpGcm9tOiBCcmlhbiBC
YXJrZXIgJmx0OzxhIGhyZWY9Im1haWx0bzpiLm0uYmFya2VyQGJ0aW50ZXJuZXQuY29tIj5iLm0u
YmFya2VyQGJ0aW50ZXJuZXQuY29tPC9hPiZndDs8YnIvPgpUbzogPGEgaHJlZj0ibWFpbHRvOnVz
ZXJzQGdsb2JhbC5saWJyZW9mZmljZS5vcmciPnVzZXJzQGdsb2JhbC5saWJyZW9mZmljZS5vcmc8
L2E+PGJyLz4KU2VudDogRnJpLCAyNyBOb3YgMjAxNSAxMToyNjxici8+ClN1YmplY3Q6IFJlOiBb
bGlicmVvZmZpY2UtdXNlcnNdIEhvdyB0byByZXR1cm4gY2VsbCBhZGRyZXNzL3JlZmVyZW5jZSBp
bnN0ZWFkIG9mIGZ1bmN0aW9uIHJlc3VsdCB3aXRoIDJkIG9wZXJhdGlvbnM/PGJyLz4KPGJyLz4K
QXQgMTM6NTYgMjcvMTEvMjAxNSAtMDUwMCwgRWR3YXIgQ2lmdWVudGVzIHdyb3RlOjxici8+CiZn
dDtPbiAxMS

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

[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.
https://bugs.documentfoundation.org/show_bug.cgi?id=56896
https://bugs.documentfoundation.org/show_bug.cgi?id=92664

[Thank you for those links. I'm not sure how much they apply to the problem I'm 
encountering but they are certainly interesting. 

I'm not interested in migrating to Excel under any conceivable circumstance. I 
don't even want to use WPS (the Chinese clone of Excel) though that might be an 
answer in terms of performance. :(

Does anyone know whether WPS can be run via Wine on Linux? I know it does not 
play fair with LO on Windows. I don't think programs on Linux through Wine can 
override system settings. As long as I could control the software update 
process I think I might trust WPS if it were running on Linux. -- jl]

Maybe the problem is in relation with your formulas in the conditional format, 
using functions inside CF makes it very slow. I think specially with
the STYLE() function.

[Thank you Miguel.

I do not use _any_ functions in my very simplistic conditional formatting. I 
have six custom styles defined that differ from the default style in terms only 
of their background color. They apply to the range Sheet1.AH3:AJ2870. They are 
activated by six conditions as follows

Condition 1: Formula is $Sheet2.$AP3=1
Condition 2: Formula is $Sheet2.$AP3=2
...
Condition 6: Formula is $Sheet2.$AP3=6

This color codes the background in columns AH through AJ on the first sheet 
based on any of six specific values or none of them in column AP on the second 
sheet. Unchecking AutoCalculate turns off this color coding but does not 
streamline data entry which is taking place in columns AH through AJ on the 
first sheet. IOW, unchecking AutoCalculate not only fails to accelerate data 
entry but it also hides visual clues as to what data is supposed to be entered. 
-- jl]

Regards.
Miguel Ángel.

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc 5.0.3.2 AutoCalculate

[James E. Lang]

-Original Message-
From: jorge 
To: j...@lang.hm
Cc: users@global.libreoffice.org
Sent: Mon, 23 Nov 2015 7:50
Subject: Re: [libreoffice-users] Calc 5.0.3.2 AutoCalculate

Hi:

I've had this kind of problem before. As I understand it is because the 
spreadsheet has a lot of formulas into it. Then when you enter a new value or 
formula to be calculate, it recalculate all formulas again of the spreadsheet 
that you are using.

I only can solve with uncheck autocalculate 

[Thank you Jorge but that's exactly what I reported trying in my original 
message. It still takes the same four minutes after I enter or revise a single 
value before it lets me do anything more _and_ the hiding of conditional 
formatting when AutoCalculate is unchecked is another 
_unexpected_and_undesirable_ behavior. Can anybody else contribute a solution 
to my problem? -- jl]

and continue working entering new data and when I have enough new information, 
run autocalculate to update and review it.

[Actually I intended to use F9 for this but maybe that's what you mean. -- jl]

I don't know if increase the memory improve the result of autocalculate.

[I remember recently seeing someone suggesting a memory tweak but I don't 
recall what to try in that regard. The Linux version is running on a laptop 
computer with a solid state disk drive and without crowding memory. According 
to top,

KiB Mem: 3072748 total, 2961416 used, 111332 free, 540732 buffers
KiB Swap: 7817776 total, 321948 used, 7495828 free, 571112 cached Men

and for soffice.bin top reports

VIRT 1599776 RES 385276 SHR 76000 %CPU 99.9 %MEM 12.5

With AutoCalculate unchecked I reentered the value 2.2 in cell AI1289 and top 
recorded 3 minutes 59 seconds of CPU time consumed by soffice.bin before that 
process returned to an idle state.

My point is that AutoCalculate should not even be taking place since I 
unchecked it but it obviously is. 

Once again, I am experiencing this issue in the Windows version of LO 4.4.6.3 
_and_ in the Linux version of LO 5.0.3.2. -- jl]

I think that 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 E Lang escribió:
> 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" 
> To: LibreOffice Users 
> Sent: Sun, 22 Nov 2015 22:26
> Subject: [libreoffice-users] Calc 5.0.3.2 AutoCalculate
> 
> 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 alteration of raw data?
> 
> FWIW the spreadsheet has ~3,000 rows on each of two sheets and a total of 
> ~300,000 formulas.
> 
> -- 
> Jim


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc 5.0.3.2 AutoCalculate

[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" 
To: LibreOffice Users 
Sent: Sun, 22 Nov 2015 22:26
Subject: [libreoffice-users] Calc 5.0.3.2 AutoCalculate

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 alteration of raw data?

FWIW the spreadsheet has ~3,000 rows on each of two sheets and a total of 
~300,000 formulas.

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Calc 5.0.3.2 AutoCalculate

[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 alteration of raw data?

FWIW the spreadsheet has ~3,000 rows on each of two sheets and a total of 
~300,000 formulas.

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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" 
To: LibreOffice Users 
Sent: Wed, 18 Nov 2015 0:00
Subject: [libreoffice-users] Cut & Paste in Calc

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 Import screen that looks like 
data is coming from a different type of documents such as a csv file.

This is unexpected, even _if_ correct, behavior. 

Oops, the formulas got stripped. The computed values got pasted instead such as 
could have been done formerly by a Paste Special. 

• Can this behavior be confirmed?

• Did I do something incorrectly?

• Is this a planned change of behavior?

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Cut & Paste in Calc

[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 Import screen that looks like 
data is coming from a different type of documents such as a csv file.

This is unexpected, even _if_ correct, behavior. 

Oops, the formulas got stripped. The computed values got pasted instead such as 
could have been done formerly by a Paste Special. 

• Can this behavior be confirmed?

• Did I do something incorrectly?

• Is this a planned change of behavior?

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 frequently HTML. 

LibreOffice is another program. It essentially reads reasonably (exception MS) 
well understood files of data frequently used in an office context (letters, 
reports, spreadsheets, databases, presentations, etc.), displays, edits, and 
writes them out.

Each is a powerful program but they differ in their purpose.

-- 
Jim

-Original Message-
From: anne-ology

   Are you comparing FireFox with LO?;
  FireFox is a website where LO is a program.

 


-Original Message-
From: anne-ology 
To: manuel_songo...@yahoo.it
Cc: users@global.libreoffice.org
Sent: Sat, 14 Nov 2015 14:24
Subject: Re: [libreoffice-users] LibreOffice 4.4, 5.0 : firefox personas not 
work with path url...why?

   Are you comparing FireFox with LO?;
  FireFox is a website where LO is a program.

   If you are desirous of using some of these screensavers on your
computer,
  then open FireFox, not LO,
 go to those URLs,
download whatever to your machine.

   Then with that image on your machine, you can place it as a
screensaver or use however else -
  assuming that these images are for public usage  ;-)

   Hoping this answers your questions,



From: 
Date: Sat, Nov 14, 2015 at 10:29 AM
Subject: [libreoffice-users] LibreOffice 4.4, 5.0 : firefox personas not
work with path url...why?
To: "users@global.libreoffice.org" 


hello from Libreoffice 4.3 is best than 4.4 and 5.0 for PATH URL from a
theme firefox (personas), BECAUSE:4.4 and 5.0 is changed GUI and delete
path of url.. see screenshot of libreoffice 4.3:
http://www.osside.net/wp-content/uploads/2014/10/libfoxtheme8.jpg
 and see GUI of 5.0:
https://wiki.documentfoundation.org/images/thumb/1/19/Firefox_themes_browser.jpeg/600px-Firefox_themes_browser.jpeg

then you try go to:  from firefox theme personas:
https://addons.mozilla.org/it/firefox/addon/dandywater/
 copy link and go to in dialog of libreoffice 5.0 (4.4)
results: it's not detected the theme personas.This is problem.. missed
input for PATH URL...
my case situation : libreoffice 4.4 and 5.0 i try write in dialog of
libreoffice 5.0 (4.4) search form:
1) "Dandelion Seeds . Water Droplets" not detected!
 2)"VanillaOrchids" not detected!
 SO THIS IS IMPOSSIBLE TO USE...instead version 4.3 is TRUE worked 'copy
and paste' url path!this is true EASY TO USE IT FOR USER
NEWBIEit'sRIGHT?
but please to ask to team developers to ADD new INPUT-TEXT for URL...it's
simple to add new input-text, it is right?SO to keep the dialog of 4.4 and
5.0 and ADD new input-text for url, it's possible?
 i use linux opensuse 13.2 64bit, libreoffice 4.3, libreoffice 4.4,
libreoffice 5.0.thank you

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

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

Thanks to the others who also responded. 

FWIW, my unwieldy spreadsheet thrashed about for hours when I tried to add 30 
rows near the bottom of the 2810 active rows on each of two sheets. This was on 
Windows XP. I finally terminated the process which was running alone and using 
"403,500 KB" of memory. I _will_ try migrating this file to my Kubuntu system. 
If that doesn't work then it's really desperation time.

-- 
Jim

-Original Message-
From: elderdanlewis 
To: "users@global.libreoffice.org" 
Sent: Sat, 14 Nov 2015 9:15
Subject: Re: [libreoffice-users] Large spreadsheet does not open in LibreOffice.

Documents for LibreOffice:

http://wiki.documentationfoundation.org/documentation/publications

   The Base Guide section contains my writings. The Base Handbook has been 
translated from the German.

Dan
-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 13/11/2015 19:27, Joel Madero wrote:
>
>> I have never seen a 150 mb functional spreadsheet before.
> That size is not uncommon in environments where Excel is the only office
> tool that the employees know how to use.

Trust me...I know. I worked somewhere where we had a 750 meg excel file
that crashed multiple times a day and was entirely useless. When I
suggested that someone (meaning I) take the time to do it rightIT
pushed back heavily and was afraid that I'd break something (as if
things weren't already horribly broken).

I recommend to most people who see their spreadsheets creeping into the
10's to 100's of megs to start looking at how to structure databases and
do things right instead of horrible hacks that tend to have lots of
issues - despite many people trying, a spreadsheet is not a database.

[Joel, although I agree that my 7 MB spreadsheet has gotten unwieldy, I have no 
clue how to design and implement a database to replace the mess. I suspect that 
most users who have these oversized, abused, spreadsheets have the same 
problem. Businesses should be able to hire a database designer but as a retired 
individual I don't have financial resources to even get training in database 
design. So I appear to be stuck. I won't go into any of my spreadsheet's 
details here. Suffice it to say I recognize that it has become a kludge.

At 7,145 KB after about 45 weeks accumulation of data I can see the possibility 
that the .ods file could expand past 8MB for the full year. Then it will start 
over and I'll need to figure out how to carry over some values computed from 
this year's data to the new spreadsheet. -- jl]

Best,
Joel

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Compatibility

[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
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 2015 12:53
Subject: Re: [libreoffice-users] Re: Announcing OpenOffice 4.1.2

Again all of that is irrelevant on this particular mailing list. It would
be like you going to Microsoft's forums and posting about OOo (of
LibreOffice) - it just doesn't make sense and isn't appropriate.

Anyways, I'm going to go ahead and delete the thread as I don't
particularly care all that much. I just think it's illogical and
unreasonable to think that this is the right place for these messages.


Joel

On Thu, Oct 29, 2015 at 12:41 PM, Andreas Säger 
wrote:

> Am 29.10.2015 um 17:50 schrieb Florian Reisinger:
> > Hi,
> >
> > On the contrary it is interesting to see if and when yes how often Open
> Office will release. I thought of it as being dead as there has not been a
> release in a relative long period of time.
> >
> > So thanks for informing ;)
> >
> > PS: @Bastián: You just started a probably long discussion ;)
> >
>
> This was the first bug fix release since 13 months. On my laptop I have
> both suites installed. I prefer AOO.
>
>
>
> --
> 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/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>



-- 
*Joel Madero*
LibreOffice QA Volunteer
jmadero@gmail.com

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Shortcut changes

[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 2015 9:23
Subject: Re: [libreoffice-users] Re: Shortcut changes

>
>
> The only problem is that it wasn't actually discussed on the UX mailing
> list, but only came up in the bug reference, which was copied to the UX
> mailing list.
>
> Additionally, this bug initially concerned absolute file referencing in
> Calc, so would have passed under the radar of most people concerned by
> Base UX issues even if there had been a discussion (which there wasn't,
> at least not on the mailing list).
>

Sure - I'm not saying they catch everything or discuss everything, as that
would be very difficult to do. All I'm saying is that such a discussion
(even if done after the fact) can improve discussions for the future and
lead to a better product. The user mailing list typically isn't a good
place for discussing improvements (if the goal is to reach out to
contributors), nor is commenting with caps lock on as this just irritates
contributors (from my experience over the years) and adds nothing to the
fruitful and positive attitude in the project.

Just my two cents. I know all of the people on the UX team and they are all
fantastic people who are always open to bringing in new voices and
incorporating lots of ideas moving forward.


Best,
Joel



-- 
*Joel Madero*
LibreOffice QA Volunteer
jmadero@gmail.com

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users]

[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
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: base64

SWYgSSdtIG1pc3Rha2VuIHRoZW4gSSdtIHNvcnJ5LiBNeSB1bmRlcnN0YW5kaW5nIGlzIHRoYXQg
d2l0aCBQT1AzIG9uY2UgeW91IGRvd25sb2FkIHRoZSBtZXNzYWdlIHRvIHlvdXIgbWFpbCBjbGll
bnQgaXQgYmVjb21lcyB0aGUgY2xpZW50J3MgInByb3BlcnR5LiIgWWVzIGl0J3MgcG9zc2libGUg
dG8gcHJlIHNjYW4gYSBwYXJ0IG9mIHlvdXIgaW5jb21pbmcgZU1haWwgdXNpbmcgUE9QMyB0byBy
ZWplY3Qgc29tZSBzcGFtIG9yIG92ZXJzaXplIG1lc3NhZ2VzIGJ1dCBub3QgdG8gZG93bmxvYWQg
aXQgdHdpY2Ugd2l0aG91dCBzZXJ2ZXIgcGVyc29ubmVsIHJldHJpZXZpbmcgaXQgZnJvbSBiYWNr
dXAuIFRoaXMgaXMgd2hhdCBJIG1lYW50LiBGV0lXIGl0IGhhcyBiZWVuIG1hbnkgeWVhcnMgc2lu
Y2UgSSB1c2VkIFBPUDMuCgpTbyBpbiB3aGF0IGRldGFpbCBhbSBJIG1pc3Rha2VuPwoKLS0gCkpp
bQoKLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0KRnJvbTogQnJpYW4gQmFya2VyIDxiLm0uYmFy
a2VyQGJ0aW50ZXJuZXQuY29tPgpUbzogdXNlcnNAZ2xvYmFsLmxpYnJlb2ZmaWNlLm9yZwpTZW50
OiBTdW4sIDE4IE9jdCAyMDE1IDE1OjQ2ClN1YmplY3Q6IFJlOiBbbGlicmVvZmZpY2UtdXNlcnNd
IFRvbyBtYW55IG1lc3NhZ2VzIG9uIHRoaXMgbWFpbGluZyBsaXN0Pz8gSG93IHRvIGF2b2lkIGJl
aW5nIHN3YW1wZWQgLi4uCgpBdCAxNToyNyAxNy8xMC8yMDE1IC0wNzAwLCBKYW1lcyBFLiBMYW5n
IHdyb3RlOgo+UE9QMyBpcyBhIHByb3RvY29sIHRoYXQgZG93bmxvYWRzIHRoZSBtZXNzYWdlcyB0
byB5b3Ugd2l0aG91dCAKPmxlYXZpbmcgYSBjb3B5IG9uIHRoZSBzZXJ2ZXIuCgpXaGF0IGdpdmVz
IHlvdSB0aGlzIG1pc3Rha2VuIGltcHJlc3Npb24/CgpCcmlhbiBCYXJrZXIgIAoK
--=_Part_0_844023051.1445245203873
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: base64

SWYgSSdtIG1pc3Rha2VuIHRoZW4gSSdtIHNvcnJ5LiBNeSB1bmRlcnN0YW5kaW5nIGlzIHRoYXQg
d2l0aCBQT1AzIG9uY2UgeW91IGRvd25sb2FkIHRoZSBtZXNzYWdlIHRvIHlvdXIgbWFpbCBjbGll
bnQgaXQgYmVjb21lcyB0aGUgY2xpZW50J3MgInByb3BlcnR5LiIgWWVzIGl0J3MgcG9zc2libGUg
dG8gcHJlIHNjYW4gYSBwYXJ0IG9mIHlvdXIgaW5jb21pbmcgZU1haWwgdXNpbmcgUE9QMyB0byBy
ZWplY3Qgc29tZSBzcGFtIG9yIG92ZXJzaXplIG1lc3NhZ2VzIGJ1dCBub3QgdG8gZG93bmxvYWQg
aXQgdHdpY2Ugd2l0aG91dCBzZXJ2ZXIgcGVyc29ubmVsIHJldHJpZXZpbmcgaXQgZnJvbSBiYWNr
dXAuIFRoaXMgaXMgd2hhdCBJIG1lYW50LiBGV0lXIGl0IGhhcyBiZWVuIG1hbnkgeWVhcnMgc2lu
Y2UgSSB1c2VkIFBPUDMuPGJyLz4KPGJyLz4KU28gaW4gd2hhdCBkZXRhaWwgYW0gSSBtaXN0YWtl
bj88YnIvPgo8YnIvPgotLSA8YnIvPgpKaW08YnIvPgo8YnIvPgotLS0tLU9yaWdpbmFsIE1lc3Nh
Z2UtLS0tLTxici8+CkZyb206IEJyaWFuIEJhcmtlciAmbHQ7PGEgaHJlZj0ibWFpbHRvOmIubS5i
YXJrZXJAYnRpbnRlcm5ldC5jb20iPmIubS5iYXJrZXJAYnRpbnRlcm5ldC5jb208L2E+Jmd0Ozxi
ci8+ClRvOiA8YSBocmVmPSJtYWlsdG86dXNlcnNAZ2xvYmFsLmxpYnJlb2ZmaWNlLm9yZyI+dXNl
cnNAZ2xvYmFsLmxpYnJlb2ZmaWNlLm9yZzwvYT48YnIvPgpTZW50OiBTdW4sIDE4IE9jdCAyMDE1
IDE1OjQ2PGJyLz4KU3ViamVjdDogUmU6IFtsaWJyZW9mZmljZS11c2Vyc10gVG9vIG1hbnkgbWVz
c2FnZXMgb24gdGhpcyBtYWlsaW5nIGxpc3Q/PyBIb3cgdG8gYXZvaWQgYmVpbmcgc3dhbXBlZCAu
Li48YnIvPgo8YnIvPgpBdCAxNToyNyAxNy8xMC8yMDE1IC0wNzAwLCBKYW1lcyBFLiBMYW5nIHdy
b3RlOjxici8+CiZndDtQT1AzIGlzIGEgcHJvdG9jb2wgdGhhdCBkb3dubG9hZHMgdGhlIG1lc3Nh
Z2VzIHRvIHlvdSB3aXRob3V0IDxici8+CiZndDtsZWF2aW5nIGEgY29weSBvbiB0aGUgc2VydmVy
Ljxici8+Cjxici8+CldoYXQgZ2l2ZXMgeW91IHRoaXMgbWlzdGFrZW4gaW1wcmVzc2lvbj88YnIv
Pgo8YnIvPgpCcmlhbiBCYXJrZXImIzE2MDsgPGJyLz4KPGJyLz4K
--=_Part_0_844023051.1445245203873--

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Shortcut changes

[James E. Lang]

The customize work around is valid. I have modified Fill to be F~ill and Ed~it 
Mode to be E~dit Mode. This makes 4.4.5.2 equivalent to 4.4.6.x in this regard. 
Note that existing accelerators do not appear in the Customize Menu Content 
Entries pane (a part of the Tools menu structure).

-- 
Jim

-Original Message-
From: James E Lang 
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-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...@spamgourmet.com To:
> users@global.libreoffice.org Sent: Sun, 18 Oct 2015 6:40 Subject: Re:
> [libreoffice-users] Shortcut changes

-->8=

Ah, according to bug 93326 comment 8:
   https://bugs.documentfoundation.org/show_bug.cgi?id=93326#c8
and comment 10:
   https://bugs.documentfoundation.org/show_bug.cgi?id=93326#c10
Alt+E, I was changed back to Fill in versions 4.4.6 and 5.0.1, with 
Alt+E, D for Edit Mode.

[Comment 3 for that bug 

https://bugs.documentfoundation.org/show_bug.cgi?id=93326#c3

has this interesting blurb:

> Hi Garry, The simplest way to fix your issue for the time being is to add 'I' 
> as the accelerator for Fill. 
> 1) Open the Tools menu and select Customize. 
> 2) Click on the Menus tab and select 'Edit' in the menu drop down. 
> 3) Select 'Fill' in Menu Content 
> 4) Click the 'Modify' button and select 'Rename...' from the menu. 
> 5) Rename it to 'F~ill'

The main problem with using this technique is that not everybody will have the 
same "accelerators" (shortcuts?) and thus help on this list could become less 
useful. OTOH it does look like a useful work around. -- jl]

Can anyone confirm that? I'm still on 4.4.2; must upgrade sometime...

[I cannot confirm since this bug led me to revert from 4.4.5.2 to 4.3.7.2 and 
steer away from further upgrades. Now that I know about the work around 
technique I'll upgrade again since the 4.4 series does allow me to add/change 
data significantly less slowly (two to four seconds per individually modified 
cell rather than 15 seconds in a two sheet, 2500+ rows {and growing by five to 
20 rows daily} per sheet Calc document). -- jl]

Mark.

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Shortcut changes

[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...@spamgourmet.com To:
> users@global.libreoffice.org Sent: Sun, 18 Oct 2015 6:40 Subject: Re:
> [libreoffice-users] Shortcut changes

-->8=

Ah, according to bug 93326 comment 8:
   https://bugs.documentfoundation.org/show_bug.cgi?id=93326#c8
and comment 10:
   https://bugs.documentfoundation.org/show_bug.cgi?id=93326#c10
Alt+E, I was changed back to Fill in versions 4.4.6 and 5.0.1, with 
Alt+E, D for Edit Mode.

[Comment 3 for that bug 

https://bugs.documentfoundation.org/show_bug.cgi?id=93326#c3

has this interesting blurb:

> Hi Garry, The simplest way to fix your issue for the time being is to add 'I' 
> as the accelerator for Fill. 
> 1) Open the Tools menu and select Customize. 
> 2) Click on the Menus tab and select 'Edit' in the menu drop down. 
> 3) Select 'Fill' in Menu Content 
> 4) Click the 'Modify' button and select 'Rename...' from the menu. 
> 5) Rename it to 'F~ill'

The main problem with using this technique is that not everybody will have the 
same "accelerators" (shortcuts?) and thus help on this list could become less 
useful. OTOH it does look like a useful work around. -- jl]

Can anyone confirm that? I'm still on 4.4.2; must upgrade sometime...

[I cannot confirm since this bug led me to revert from 4.4.5.2 to 4.3.7.2 and 
steer away from further upgrades. Now that I know about the work around 
technique I'll upgrade again since the 4.4 series does allow me to add/change 
data significantly less slowly (two to four seconds per individually modified 
cell rather than 15 seconds in a two sheet, 2500+ rows {and growing by five to 
20 rows daily} per sheet Calc document). -- jl]

Mark.

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Shortcut changes

[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 extremely disruptive for users. My least favorite (most detested!!) such 
> change occurred in version 4.4 of Calc when Alt+E,I was assigned to a brand 
> new menu item in place of "Fill."

That one has caught me out a few times in Calc; I've even lost work because of 
it a few times. Alt+E, I, D used to fill down. Now it reopens the file in 
read-only edit mode,

[I also used to use Alt+E, I, R; Alt+E, I, L; or Alt+E, I, U to fill right, 
left, or up respectively. Read-only edit mode sounds to me like a self 
contradictory phrase and having it activated instead of fill is certainly 
disruptive. -- jl]

without saving changes (it does prompt, but the final D selects "Don't Save") 
Yes, I know there's also Ctrl+D to fill down, but for some reason I'm used to 
Alt+E, I, D and automatically type that.

If they wanted to use Alt+E, I for Edit Mode, I don't really see why it 
couldn't have been done the same as in other menus where several options share 
the same letter. e.g. in Calc Alt+I brings up the insert menu, then H selects 
between "Hyperlink" and "Headers and Footers" and you have to press Enter on 
the one you want.

[That seems like a reasonable suggestion. -- jl]

For what it's worth, the problem of changing shortcuts is not unique to 
LibreOffice. In MS Outlook 2003, Ctrl+S saved a draft of an email, while in 
Outlook 2007 Ctrl+S sent it without any further confirmation. Fortunately I 
never accidentally sent anything more embarrassing than a half-finished 
response as a result (at least, I don't think I did...)

[I repeat that changing shortcuts disrupts user productivity regardless who 
does it: MS or LO. I hope developers are taking notice. I don't know whether 
any of them lurk (or even actively participate) on this users list. If not then 
I hope someone harvests ideas from this list and summarizes them for the 
developers. I think a bug report might be overkill but maybe not. Does anyone 
care to weigh in on this? -- jl]

Mark.

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 eMail. Most of 
these clients do support threading and my list of examples is not a 
recommendation of any of them.

Note that the clients that perform threading of received messages by subject 
generally do also include the threading headers on outgoing (sent) messages.

POP3 is a protocol that downloads the messages to you without leaving a copy on 
the server. IMAP (aka IMAP4) downloads a copy of the messages to you and within 
reason allows you to do as you please to the original (delete, refile to a 
folder or a hierarchy of folders if you like, leave in your INBOX, etc.) that 
is on the server. 

Do a little searching on the internet as to how to configure various clients to 
access the servers (e.g. Gmail, Hotmail, etc.) using these protocols. It can be 
a little intimidating if you don't do the research. Note that some clients may 
speak of mail boxes and trays and folders while others use the terms accounts 
and nested mail boxes. They are the same functionally. 

After the initial setup process (maybe as much as five minutes) I think you'll 
be very pleased with the change though everyone has his (her) own ideas as to 
how an eMail client should look or work. Wikipedia has an article about the 
myriad eMail clients that exist. Many of them are free. Try one; try several. 
You'll probably something to suit your taste.

-- 
Jim

-Original Message-
From: libreoffice-ml.mbou...@spamgourmet.com
To: users@global.libreoffice.org
Sent: Fri, 16 Oct 2015 14:23
Subject: Re: [libreoffice-users] Tooo many messages on this mailing list?? How 
to avoid being swamped ...

anne-ology wrote:
> very interesting, indeed.
>
> And has me curiously wondering ...
>are you saying that by clicking on 'forward' then changing the
> 'Fw'/'Fwd' in the subject line to 'Re' breaks this coding in some
> e-programs ???  ;-o

For someone reading mail using a mail client which uses the in-reply-to: 
and references: headers, replying will keep the thread together 
regardless of the subject line (provided the person sending the reply 
adds those headers).

For someone reading mail using a mail client which uses the in-reply-to: 
and references: headers, forwarding an email instead of replying will 
break the thread, regardless of the subject line. It's a new message, 
usually being forwarded to a different person, not a reply to the 
original sender. So it's best to use "reply" when replying, and keep 
"forward" for forwarding.

For someone reading mail using a mail client which doesn't use those 
headers, but analyses the subject line, whether the messages are groups 
into a thread is somewhat unpredictable. It's common to add "Re:" to the 
beginning of the subject of a reply, so trying to exactly match the 
subject line will often fail. So most clients analysing the subject line 
probably ignore "Re:", and perhaps other languages and variations. Is 
"Fwd:" ignored in the same way? What about "[Fwd]"? Or 
"[libreoffice-users]"? It depends on how the particular client analyses 
the subject line. It could break apart messages which should be part of 
the same thread just because of some unanticipated difference in the 
subject line, or it could treat unrelated messages as being part of the 
same thread just because they have similar subjects.

> I use gmail because I dislike the philosophy of the only ISP
> available in this area;
>(am ready to change the moment there's an alternative available
> to us)
>
> I thus had to quit using Outlook when I switched to gmail;
>I don't know what Live Mail is but have noticed this option pops
> up at times when I'm contacting someone through their site ...
>   not knowing how to use, I merely copy & paste their e-address to
> an e-mail  ;-)

When I mentioned Live Mail, I was thinking of Windows Live Mail which 
replaced Outlook Express. That's probably what you see popping up when 
you click an email link on a web page. As Tom mentioned, there's also 
the successor to Hotmail, which is now called Outlook.com, but it may 
have had the "Live" name at one time...

>
>
>
>
> From: 
> Date: Thu, Oct 15, 2015 at 4:34 PM
> Subject: Re: [libreoffice-users] Tooo many messages on this mailing list??
> How to avoid being swamped ...
> To: users@global.libreoffice.org
>
>
> Not in mail clients which use the Message-Id and References: headers for
> threading. They keep replies in threads regardless of the subject line.
> SeaMonkey (and most likely Thunderbird) do that, as do many others.
>
> MS Outlook seems to ignore the References: header and uses some sort of
> heuristic analysis of the subject line, so changing the subject groups
> me

Re: [libreoffice-users] Shortcut changes

[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 in version 4.4 of Calc when Alt+E,I was assigned to a brand new menu 
item in place of "Fill."

PLEASE, developers, think about the impact your change will have on existing 
users. Then if you deem the change IMPORTANT enough to be warranted make 
certain that A) any replaced usage of the shortcut is assigned a new SUITABLE 
replacement, B) the changed shortcut is applied universally wherever the 
functionality exists in any module of LO, and most importantly C) the changed 
shortcut is PROMINENTLY advertised, preferably several months in advance, with 
comments solicited and carefully considered. The longer a shortcut has existed 
the more attention should be given should be given to the impact of changing it 
with shortcuts that have existed for more than one full major release being 
ALMOST cast in granite. Developers should not operate in a tyrannical manner. 
They are talented and greatly appreciated but they are not omniscient gods.

-- 
Jim

-Original Message-
From: Alexander Thurgood 
To: "users@global.libreoffice.org" 
Sent: Sat, 17 Oct 2015 10:09
Subject: [libreoffice-users] Shortcut change to display data source browser in 
Calc

Hi all Base users,

It seems the design team have taken it upon themselves to change the
shortcut for displaying the data source browser in Calc, you can read up
on the issue here :

https://bugs.documentfoundation.org/show_bug.cgi?id=59418

and comment on it as you deem fit.

Needless to say, this change makes Writer and Calc have two different
shortcuts.

Calc (quote from design irc) : "it has been changed already, it is now
CTRL+SHIFT+F4 in calc"

Writer : F4

so much for application suite consistency, and documentation, and what
the hell...
-- 
Alex Thurgood
Intellectual Property Attorney
IP GALORE
4 rue Durette
F-63500 BRENAT
FRANCE

Mobile : +33 6 40 59 99 16
Fax : +33 4 5680 9558
E-mail :
alex.thurg...@gmail.com
alex.thurg...@ipgalore.eu


CONFIDENTIAL & PRIVILEGED

The information in communications issued by the sender is confidential
and privileged. If you are not the intended recipient of the
communication, you are not authorised to visualise, display, save,
print, copy or otherwise reproduce, transfer or modify said
communication without express agreement from the sender. Any erroneous
reception should be indicated to the original sender and the original
communication subsequently destroyed.

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 happens to 
threading of everything. 

My mail client in this case is MailDroid on my phone. I might originate a copy 
of this test on my other two eMail clients later. Sorry, since this topic is 
not about LO.

I will read this thread on both Gmail accounts and the non Gmail account that 
is subscribed to this list. I'll use MailDroid on my Android phone, Pegasus 
Mail on a Windows desktop, and Mulberry Mail on a Linux laptop. All three use 
the IMAP interface to all accounts and i will examine the threading headers 
(In-Reply-To and References).

-- 
Jim

-Original Message-
From: Tom Davies 
To: Rob Jasper 
Cc: j...@lang.hm, "users@global.libreoffice.org" 
, Mark Bourne 

Sent: Fri, 16 Oct 2015 8:50
Subject: Re: [libreoffice-users] Threading

Hi :)  Breaks it ut for me.  GMail on a Chromebook right now.  


So i think that confirms my GMail account does threading by the subject-line.  
There might be a setting to change that but i don't want to poke around with it 
right now.  Maybe when i get back to my desktop i might have a look.  

Regards from 

Tom :)  



On 16 October 2015 at 12:30, Rob Jasper  wrote:

Stays in the tread for me :-)

Mac OS X Lion 10.7.5 - Mail version 5.3

Rob.




-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Threading

[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: users@global.libreoffice.org
Sent: Thu, 15 Oct 2015 14:37
Subject: Re: [libreoffice-users] Tooo many messages on this mailing list?? How 
to avoid being swamped ...

Not in mail clients which use the Message-Id and References: headers for 
threading. They keep replies in threads regardless of the subject line. 
SeaMonkey (and most likely Thunderbird) do that, as do many others.

MS Outlook seems to ignore the References: header and uses some sort of 
heuristic analysis of the subject line, so changing the subject groups 
messages into a separate conversation. I don't know if any other mail 
clients do that. Seems like a difficult way of doing things, when there 
are standard headers for doing precisely that in a reliable way, without 
unreliably heuristics!

On the other hand, some replies (including yours, here) appear to me in 
a separate thread despite having the same subject, because they don't 
include the References: header. I guess you (and others which do this) 
are posting using MS Outlook or Live Mail, or perhaps a mobile phone / 
tablet app.

Mark.


anne-ology - lagin...@gmail.com wrote:
> well said.
>
> One thing that bothers me re. this threading,
>is that if the subject line is changed in any way, it starts a
> new thread.
>
>
>
> From: Tom Davies 
> Date: Wed, Oct 14, 2015 at 2:52 PM
> Subject: Re: [libreoffice-users] Tooo many messages on this mailing list??
> How to avoid being swamped ...
> To: Rob Jasper 
> Cc: "users@global.libreoffice.org" 
>
>
> Hi :)
> +1
> Most email clients have such threading.  Thunderbird, Claws and Evolution
> do.  "The Bat!" (for Windows) does.  Gmail is not really an email client as
> you tend to create a new email address to use it, but it does the
> conversations/threading thing by default too.
>
> Hotmail (that's an MS one right?) and Microsoft Outlook and Yahoo don't.
> Well, Yahoo might by now but the Micorosoft ones haven't caught up with the
> rest of the world yet.
>
> I found that moving from unthreaded to threaded was a HUGE help.  Before
> that i'd been struggling with every single email!!  A complete nightmare.
> Now i can see the whole thread/conversation and which issues have already
> been dealt with and which issues could maybe do with a bit more work.  It's
> drastically cut the amount of emails i write :))
>
> As with any new system it took me a while to work it out and a little
> longer to really start benefiting from it.  Much the same as when i took a
> touch-typing course, initially my speeds plummeted but quite soon after i
> was really glad i'd made the switch.  When i finally managed to get all my
> emails being pulled into my GMail account it really "polished off" my
> migration.  At first i "kept all the email on the server" so they were
> still in Yahoo and being duplicated in GMail but once i was confident (took
> me about a week) i switched that around so that they get deleted from Yahoo
> if they make it into GMail.  I still have my Yahoo account but i rarely
> ever even sign into it except to change the password and just check.
>
> I'm not saying this to advertise Gmail.  Many, many email systems have this
> functionality.  The main thing is to move away from total reliance on
> Microsoft ones by using any of them.
>
> I suspect that a lot of Alexander's problem with this mailing list is that
> he is still stuck on Hotmail.
> Regards from
> Tom :)
>
>
>
> On 14 October 2015 at 19:00, Rob Jasper  wrote:
>
>>
>> reading with my standard iMac email client set to "organize by
>> Conversation", and this bundels all mails of one thread into one entry,
> so,
>> after the discussion tread calmes down (does not pop to the top of my
>> unread email list anymore) I just delete the whole thing in one go.
>> I'm sure other mailers have the same functionality.
>>
>> Just my solution, but it works for me :-)
>>
>> Regards,
>> Rob.
>>
>


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Replies

[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: users@global.libreoffice.org
Sent: Wed, 14 Oct 2015 7:59
Subject: Re: [libreoffice-users] Though I sent the email, [Please read this too 
because I am worrying about you misunderstand my mind]

-->8=

Those that post replies to messages could ease the load by using "reply to list"
rather than 'reply to all'.  

[I guess this explains what I consider to be the somewhat bizarre configuration 
of this mailing list WRT routing of replies. I know that in general I consider 
Reply to All to be a breach of netiquette. Please don't let this instigate a 
flame war. -- jl]

These are the choices you have on Thunderbird, other mail clients may offer 
different options.

[MailDroid (Android) offers only Reply or Reply to All. OTOH Pegasus Mail 
(Windows) offers a smorgasbord of addresses from which to select any 
combination when replying. -- jl]

If you use 'reply to all', the person to whom you are replying gets two copies 
: one directly to his email address and another one that comes via the 
libreoffice-users list server.

[Both have the same Message-ID and (at least) the mail server that serves my 
mail address that is subscribed to this list retains and delivers only a single 
copy. Of course if I post from an unsubscribed mail address on a different 
server or if I include a Reply-To header that references such an address then 
Reply to All will result in both addresses receiving a copy but that's of my 
own doing. :-)   -- jl]


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Dear Libre Office team

[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, 
I am Libre office user on Mac OS. Above all, I really appreciate to you guys' 
adventure and entrepreneurship to develop this kind of useful Open source 
software that is extremely helpful for Mac OS user.

[For the record it's also good for Windows and Linux users. -- jl]
 
Documents written through MS office are always the source of problem to handle 
based on Mac OS. However, after I used your S/W, then it became much easier and 
I can get rid of burden regarding those stuff. 
 
The reason why I write this letter is to ask you about the security of this 
software, I think since it is open source, so I am worrying about the security 
and possibility of being attacked by hacker and virus. 

[You are displaying a misunderstanding of how the open source paradigm works. 
Yes, you can create a rogue version of the software for your PERSONAL use and 
you can ATTEMPT to entice others to download that version through YOUR OWN 
distribution network but to get your ROGUE code into the OFFICIAL distribution 
channel require that you get it past many critics. MALICIOUS code won't survive 
that review process. -- jl]

I am very sensitive toward security and I do not want my documents sent to the 
hacker later. Can I make myself easy about the concern? 

[Yes. -- jl]
 
And, does this software work independently  like MS office and is it Off-line 
program? 

[Yes. -- jl]

or Does it work through cloud service system, API, and Online based system?

[There is an API available for those who CHOOSE to use it. As for a cloud 
service, I'm not sure whether such is an available OPTION. It most certainly is 
NOT an Online BASED system. -- jl]
 
I wish you will not misunderstand my message, I just want to confirm the 
structure of the program regarding security that is my priority concern. And, 
separated from my question, I sincerely respect your effort.
 
Hope to receive your reply. 
 
Thanks for your development.
 
Best wishes,
 
Alexander

-- 
Jim
(User, not developer)

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LTS

[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. This would reunify the Open 
Office community, solve the branding issue, and provide a valid purpose for 
both organizations. 

Sadly the essential first premise of that statement has not been true.

Just a thought 

-- 
Jim

-Original Subject-

Installing Libreoffice in Ubuntu


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 Andreas is a vociferous participant in this
discussion list, but that doesn't make his criticisms any less justified or 
relevant. What he dislikes is badly implemented change for change's sake, and 
that is an inherent problem in LibreOffice's development. The
project from the start has sacrificed behavioural stability with regard to the 
end user for feature creep.

[An example that I encountered in Calc is that recently (between the 4.3.x.x 
and 4.4.x.x versions I think), Fill (on the Edit menu) is no longer accessible 
via the letter "i" which has been assigned to some new functionality that makes 
Calc warn that a Save is needed. Alt+E, I, R or L or U or D has been a long 
established keyboard shortcut to fill a range Right or Left or Up or Down 
respectively. I'm not completely sure that Ctrl+D still works to fill Down 
since I have reverted from 4.4.5.2 to 4.3.7.2 due in a large part to this 
behavioral change. New features should not preempt existing keyboard shortcuts.]

 We are quite clearly in the "bazaar" mode of the cathedral and bazaar 
dichotomy, where no overlying dictatorship (benevolent or otherwise) exists to 
govern the direction code development should take. This has positive and 
negative effects -
the positive being that people can just turn up and work on the thing they want 
to implement - the negative being the law of unintended consequences, or 
collateral damage, i.e. bugs newly introduced that change long standing 
behaviour to which users have become accustomed.

[Such as I described above. I was under the impression that changes are 
subjected to peer review but apparently not.]

Fortunately, there are still people like Andreas to call the code
contributors out on those decisions.

[More of this is needed.]

I would suggest putting yourself in an admin's place where they have probably 
invested long hours in developing a turnkey
OpenOffice/LibreOffice solution for their group of users, then finding one day 
that that longstanding behaviour has changed because someone
else has not thought through a code change due to the tentacular nature of the 
code base with no one having an overarching knowledge of it all,
and you will perhaps understand Andreas' frustration (which I happen to share 
and have voiced it on the mailing lists in the past).

[Stand alone users are also turned off by such off the wall changes.]

[-->8=]

... you are stuck playing catch up with versions that successively introduce 
new bugs or
behaviours that don't get fixed for at least several point releases, or for 
certain OSes, over multiple major version releases. Steve's mention
in this thread of EPS support 

[I don't know this acronym.]

and printing is just yet another
illustration of a change that was made that has a huge impact on
non-Linux OSes - all because someone thought it would be a good idea to make 
that change without providing a solution for all platforms. Video support in 
Impress is yet another issue that got significantly worse with the move to the 
4.x branch. What was the message we gave to our
users ? "Suck it up." There is only so much of that that users and their admins 
are prepared to do, and in the end, it won't be surprising if people switch to 
another product that offers them greater longterm stability where such changes 
are less invasive or devastating to the day-to-day running of the organisation.

[Sadly -- Hear. Hear! 

Somebody please listen to what Alex or Italo is saying.] 


Alex

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Android version

[James E Lang]

The app (WPS) is also designed to be as similar to MS office as possible. WPS 
stands for Writer, Presentation, Spreadsheet.

Going off topic, do NOT try installing the Windows version of WPS on the same 
Windows computer with LO. It does not play well with LO.

-- 
Jim

-Original Message-
From: James E Lang 
To: Alexander Thurgood , Tom Davies 
Cc: "users@global.libreoffice.org" 
Sent: Mon, 14 Sep 2015 8:02
Subject: Re: [libreoffice-users] Re: Android version

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: [libreoffice-users] Re: Android version

Hi :)
Thanks all :)  So it sounds like AndrOffice and Kingsoft are worth trying.

I had thought about making my exchange-rate spreadsheet into a database.
I'm sure it would be far better, and would allow a purpose-built UI
front-end but the spreadsheet route is plenty good enough for this trip.

The main thing is having the functionality off-line, and from
recommendations from people i trust so i am really glad to have had good
responses so quickly from so many people here so quickly.  I'm going to
look-up some 3rd party articles too but i don't trust them as much as i
trust everyone here.
Many thanks and regards from
Tom :)


On 14 September 2015 at 15:22, Alexander Thurgood 
wrote:

> Le 14/09/2015 14:41, Tom Davies a écrit :
>
> Hi Tom,
>
>
>
> > Has anyone here used the AndrOffice or the LibreOffice version on
> Android?
> >
>
> AndrOpenffice is a huge download, but is usable offline. It is also
> rather clunky, and not really optimized for use with a touch screen, as
> it basically just draws the whole OOo interface, which is far too fiddly
> for fingers and touch screens. If your tablet has a keyboard and mouse
> pointer, well it actually works pretty well most of the time (except for
> Base, which is even more unstable than usual).
>
> The LibreOffice Viewer for Android is just that - a viewer. You can't
> edit documents with it (unlike AndropenOffice), and it is pretty
> hopeless at displaying all the files in a given directory on the tablet
> or phone. For some reason, someone thought that it would be useful to
> cripple the built-in file finder, so as to list only those files which
> are ODF.
>
> So, if you have an Android tablet with a keyboard, AndrOpenOffice is
> currently still the winner with regard to ODF import and editing.
>
>
> Alex
>
>
>
>
>
> --
> 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/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Android version

[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: [libreoffice-users] Re: Android version

Hi :)
Thanks all :)  So it sounds like AndrOffice and Kingsoft are worth trying.

I had thought about making my exchange-rate spreadsheet into a database.
I'm sure it would be far better, and would allow a purpose-built UI
front-end but the spreadsheet route is plenty good enough for this trip.

The main thing is having the functionality off-line, and from
recommendations from people i trust so i am really glad to have had good
responses so quickly from so many people here so quickly.  I'm going to
look-up some 3rd party articles too but i don't trust them as much as i
trust everyone here.
Many thanks and regards from
Tom :)


On 14 September 2015 at 15:22, Alexander Thurgood 
wrote:

> Le 14/09/2015 14:41, Tom Davies a écrit :
>
> Hi Tom,
>
>
>
> > Has anyone here used the AndrOffice or the LibreOffice version on
> Android?
> >
>
> AndrOpenffice is a huge download, but is usable offline. It is also
> rather clunky, and not really optimized for use with a touch screen, as
> it basically just draws the whole OOo interface, which is far too fiddly
> for fingers and touch screens. If your tablet has a keyboard and mouse
> pointer, well it actually works pretty well most of the time (except for
> Base, which is even more unstable than usual).
>
> The LibreOffice Viewer for Android is just that - a viewer. You can't
> edit documents with it (unlike AndropenOffice), and it is pretty
> hopeless at displaying all the files in a given directory on the tablet
> or phone. For some reason, someone thought that it would be useful to
> cripple the built-in file finder, so as to list only those files which
> are ODF.
>
> So, if you have an Android tablet with a keyboard, AndrOpenOffice is
> currently still the winner with regard to ODF import and editing.
>
>
> Alex
>
>
>
>
>
> --
> 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/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Android version

[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
Subject: [libreoffice-users] Android version

Hi :)
Has anyone here used the AndrOffice or the LibreOffice version on Android?

Does anyone know if it installs onto the device itself so that it's usable
off-line?

I have a friend who is going off to a distant land where they won't be able
to use their hand-held phone but has created a spreadsheet to help convert
between the various currencies they will encounter.  I've never used an
Android so i have no idea what to recommend but i'd rather suggest a
LibreOffice or OpenOffice solution.  Any ideas?

Regards from
Tom :)

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LibreOffice Damaged

[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 analysis of the problem 
after you recover from it by comparing the old folder and the new to see what 
was corrupted.

I'm a Linux geek and a former mainframe systems programmer which might 
influence my opinion so YMMV. Don't let this paragraph derail the discussion of 
the problem.

-- 
Jim

-Original Message-
From: Stephan Bergmann 
To: "LibreOffice, users" 
Cc: Taang Zomi , Thudik Zomi 
Sent: Mon, 14 Sep 2015 4:39
Subject: Re: [libreoffice-users] LibreOffice Damaged

On 09/14/2015 01:20 PM, Stephan Bergmann wrote:
> On 09/12/2015 12:13 AM, Taang Zomi wrote:
>> LibreOffice 4.4.4  -- Fatal Error
>> ---
>> The program cannot be started.
>>
>> The service manager is not available.
>>
>> ("premature end of file:///C:/Users/
>> Taang/AppData/Roaming/LibreOffice/4/user/uno_packages/cache/registry/com.sun.star.comp.deployment.component.PackageRegistryBackend/commom.rdb")
>>
>
> This sounds like data on your hard disk got corrupted.  You can try and
> remove the folder
>
>C:\Users\Taang\AppData\Roaminig\LibreOffice\4\user\uno_package\cache
>
> with all its content, and it should get resurrected on the next start of
> LibreOffice.

(To be more precise, removing that folder loses all the extensions that 
are "Installed for current user" and requires you to re-install them. 
Another option should be to only remove the sub-folder

 
C:\Users\Taang\AppData\Roaminig\LibreOffice\4\user\uno_package\cache\registry

and then manually in "Tools - Extension Manager..." re-enable all the 
extensions that are "Installed for current user" and which will have 
become disabled due to removing that sub-folder.)


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 
To: users@global.libreoffice.org
Sent: Thu, 20 Aug 2015 9:20
Subject: Re: [libreoffice-users] Re: LibreOffice 5.0 Review & Rating | PCMag.com

On 20/08/15 12:20, Pedro wrote:
> steveedmonds wrote
>> On 2015-08-19 12:55, James Knott wrote:
>>> On 08/18/2015 07:23 PM, Steve Edmonds wrote:
 Hi. Is this a review for LO 4? When I click on the link I get a review
 for 4.0
>>> It says 5.0, when I click on the link.
>>>
>>>
>> Must be a redirect because that link takes me to
>> http://au.pcmag.com/libreoffice-40/2249/review/libreoffice-40
>
> Here is a direct link
> http://www.pcmag.com/article2/0,2817,2418419,00.asp
>
> Hope this works...

Nope. Still lands up on the 4.0 page from 2013 for me, at 
http://uk.pcmag.com/office-suites-products/2249/review/libreoffice




-- 
Mike Scott
Harlow, Essex, England

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 ..." 
LibreOffice. LO was totally hidden as a possible program to be used to process 
csv files. Uninstalling WPS restored the ability to use LO.]]

-- 
Jim

-Original Message-
From: WMID 
To: users@global.libreoffice.org
Sent: Thu, 30 Jul 2015 22:44
Subject: [libreoffice-users] Images copied to Libre Office Writer from Shutter 
look so pixelated

I have installed UbuntuStudio 14.04 i386 on my Dell Inspiron 1750, I use
Shutter 0-93.1to make tutos with, when I paste it to Libre Office
Writer, see this picture:

Picture LibreOffice 4.4.5.2 http://i.imgur.com/wt0XFSf.png

You see that image have very bad quality. When I do the same in WPS:

Picture WPS Office 9.1.0.4961 http://i.imgur.com/NTJbkv6.png

See that the quality is best. Do you can help to no use WPS because this

Also I search and find this:
http://superuser.com/questions/880756/why-do-images-copied-to-libre-office-writer-look-so-pixelated

in this place said that with the use of SVG files solve this, but the
problem is that Shutter not working with SVG files

-- 
Ingeniero en Alimentos
Washington Indacochea Delgado

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[James E Lang]

Hi Alain,

Try changing your collation selection. I think that will solve your problem.

-- 
Jim

-Original Message-
From: Rafnews 
To: users@global.libreoffice.org
Sent: Mon, 03 Aug 2015 3:23
Subject: [libreoffice-users] [CALC] printing several copies of the same sheet

Hi,

Is there anyone who solved the issue of printing the same page several 
times ?
or is the team of LibreOffice working on this issue ?

I have 1 single sheet (in fact page) to print in Calc and when i select 
5 copies to print of the same page, i always get only 1 single page 
print and only once. nothing else.
-- 

Best Regards

Alain R.

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 
> left out only
> when no parameter follows. For example, in a function with four parameters, 
> where the
> last two parameters are marked as "optional", you can leave out parameter 4 or
> parameters 3 and 4, but you cannot leave out parameter 3 alone.

Someone obviously went to a lot of work to craft that elegant bit of English 
prose but try the following to see that the above statement is false in at 
least one instance:

B1: $5662
B2: 12%
B3: 3
B4: =PMT(B2/12,B3*12,B1,,0)

Note that the fourth parameter was "left out" but the fifth parameter was not. 
Note also that the function returns a valid result (negative $188.06). Filling 
in a zero for the fourth parameter yields the same result. To give credit where 
due, I ran across the formula (designated as valid for Excel) at 
http://math.about.com/library/weekly/aa102503a.htm while researching how a used 
car salesman tried to hornswaggle a senior citizen near here.

Personally I am delighted that LibreOffice has the flexibility to have 
non-terminal parameters left out but it goes to show that the built-in Help is 
in need of some work.

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] [OT] Operating Environment Survey

[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 desktop dual boot Windows XP (and Ubuntu Linux) computer, a 
laptop dual boot Kubuntu Linux (and pre-installed Windows Vista) computer and 
several other laptop, desktop, and dedicated server (Ubuntu Linux based) 
computers. I also have Android Lollipop, Android Kit Kat, and Android Jelly 
Bean tablets and phones. I have nothing from Apple.
• Windows XP is used primarily for single player gaming and e-Sword Bible 
software though it also is used to run LO, FireFox and Pegasus Mail 
(proprietary though free of cost).
• Kubuntu Linux is my general purpose "go to" environment. My first Linux 
system used what I believe was the penultimate marketed version from SuSE 
before the first release of Open SuSE. I liked the flexibility that was 
inherent in the KDE desktop environment and found the UI to be quite similar to 
that of Windows at the time. I have briefly tried Gnome and Unity desktop 
environments but KDE is my personal first choice.
• If I had a tablet computer that I thought could support my Linux usage it, 
too, would run Kubuntu Linux, LO, etc.
• Apple equipment is too expensive for me and from what I've heard about the 
company's software policies, they are too restrictive to suit me.
• Dual boot capabilities are seldom used to deviate from the above information.
• The BSODs on Windows influenced my initial adoption of Linux.

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 
Column Break if you prefer to use a mouse.

If, instead, the page break occurs due to a lack of room for the next row or 
column and you want it in an earlier location substitute Alt+I (Menu Insert) 
for the Alt+E (Menu Edit). I find this usage of two different menus to not be 
intuitive but it's the way things aee.

I'm using LO 4.3.7.2 

-- 
Jim

-Original Message-
From: Budgie 
To: "users@global.libreoffice.org" 
Sent: Fri, 17 Jul 2015 12:29
Subject: [libreoffice-users] Calc:- Moving a fixed page break.

Hi, I have a problem with a page break which was not inserted 
(knowingly) by me.  I have tried to move it in the View - Page Break 
Preview but it will not shift.  Is this a bug or am I doing something wrong.


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 rightly guessed to 
be the code that would unlock the kingdom buried in the middle of it. There was 
no captcha image but only that string of gibberish.

It's interesting that there are both an official set of forums through 
Libreoffice.org and a self acknowledged unofficial set of forums through 
LibreIfficeForum.org.

That said, I'm not a fan of forums in general, prefering rather the interaction 
of a mailing list such as this so I'm unlikely to those forums. IMO a forum is 
useful for archiving helpful hints and the like but I prefer to see active 
discussions pass through my eMail INBOX. I suppose that if there were only a 
single FOSS product in which I was interested then I might view a forum 
differently but I have never gotten into the browser bookmarking mentality. I 
also have not joined the social media bandwagon so I guess I'm some sort of a 
Luddite (sp?). Maybe it's a generational thing.

-- 
Jim

-Original Message-
From: Martin Lewicki 
To: users@global.libreoffice.org
Sent: Tue, 14 Jul 2015 17:22
Subject: [libreoffice-users] Anyone log into LibreOfficeForum.org?

Tried to create an account on this page
http://en.libreofficeforum.org/user/register

Carefully made sure rules followed especially the captcha code but it
always reports an error with captcha code.

-->8=

Marty

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 believe 
it is very proper to suggest alternatives in such a case. 

I do agree that FOSS ought to be included in such recommendations whenever 
possible but each possible solution should be made to stand on its own feet 
recognizing that not all FOSS is created equal and that sometimes even 
proprietary software for a fee is best for a particular task.

Ideally every recommendation will be identified as FOSS, freeware, adware, 
trialware, proprietaryware for a fee, etc. Then the person who seeks help has 
more information upon which to base a decision.

Zeal for FOSS can get out of hand.

-- 
Jim

-Original Message-
From: anne-ology 
To: users@global.libreoffice.org
Sent: Mon, 13 Jul 2015 9:18
Subject: Re: [libreoffice-users] How to use LibreOffice to blur and save a PNG?

   Obviously you're not going to the Gizmo's site.

   Those 4 programs as well as LO are similar, yes.

   Tucows, Cnet, ... are not the same as Gizmo's - those sites do not
cater to the user who wishes to avoid MsFt yet use quality software;
   in fact, I think those sites are attempting to make a profit.



From: Charles-H. Schulz 
Date: Mon, Jul 13, 2015 at 11:05 AM
Subject: Re: [libreoffice-users] How to use LibreOffice to blur and save a
PNG?
To: users@global.libreoffice.org
Cc: Florian Effenberger 


I'm very sorry Anne, but going there prompts me to lists of software by
categories; only a fraction of these are actual Free Software (and I have
to look for them).

-->8=
-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[James E Lang]

Java Runtime Environment? I guess your statement was intended to be in jest.

-- 
Jim

-Original Message-
From: anne-ology 
To: users@global.libreoffice.org
Sent: Mon, 13 Jul 2015 9:10
Subject: Re: [libreoffice-users] Upload a picture to http://ask.libreoffice.org

   I think this was sent to me by mistake;
  am sending to list with the hope that someone can help you here.

   I'm sorry I can't help;
  I know naught about Base; only enough to avoid WIN8; never heard
of acronym JRE  ;-)

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 wander into this maze though I'm not sure how I get there. 
I guess it's via a link someone posts on this list.

I'm a Calc user on Windows and on Linux. I use the Function Wizard to find 
function names by category and F1 to get the specifics as to the meaning of the 
function parameters. The examples are not always very well thought out in terms 
of being very practical.

I would write and use macros a good bit more if there were good documentation 
on the subject through F1. I'd like to see links to an on line tutorial on Star 
Basic and one or more tutorials on the concepts of UNO and how to get started 
using it. At least one tutorial should NOT assume that the reader has a degree 
in computer programming. I, for one, am a retired 1960s era assembler language 
and FORTRAN (later K&R C and Pascal) mainframe programner. My paradigm involves 
procedural code (get values, manipulate them, store/use the results, etc.). I 
need a bridge from that to the UNO paradigm.

-- 
Jim

-Original Message-
From: dallen 
To: users@global.libreoffice.org
Sent: Wed, 24 Jun 2015 9:59
Subject: [libreoffice-users] LibreOffice's documentation (pdf and online)

Hi All,

   I'm an experienced Technical Writer beginning work on LibreOffice's
documentation, but I have some questions for LibreOffice users:

   1) Does anyone EVER look at the pdf documentation? If not, why not?
   2) Does anyone EVER click the F1 key for help? If not, why not?
   3) Do you see any overall issues concerning the documentation?
   4) If the presentation of the documentation were to change to make it
more useful, what would it look like?

Thanks for anyone's help.

Davidaa



--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-s-documentation-pdf-and-online-tp4152516.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Randomly lost sheet

[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 
To: users@global.libreoffice.org
Sent: Fri, 12 Jun 2015 0:53
Subject: [libreoffice-users] Randomly lost sheet

Hello.

A customer of mine reported this problem to me on Windows 7/64b with LO 
4.4.3.

When she opens some XLSX file (which contains from a few to a lot of 
sheets), sometimes one of the sheet is blank (i.e. all the cells are 
empty as if it was a new sheet).
This is very critical, since if she does not realize this, that data is 
lost forever when she saves.

Closing the document and reopening it usually does not show the problem 
again.

I searched bug tracking but found no issue which seems to be like this 
(but perhaps I don't know what to look for exactly).

Any suggestion?

  bye & Thanks
av.

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[James E Lang]

(I intend this reply to be off list)

Thank you.

It has probably been more than 20 years since I studied any flavor of Basic and 
I have not been able to find what dir("path/file.ext") or dir() are supposed to 
do. That is why I said that the "while" loop appears to be suspect. My guess is 
that the former returns "path/" while the latter returns an empty string. I 
must be wrong since that would prevent the macro from accomplishing the desired 
task. But, then again, I fail to see any result when I attempt to use this 
macro. Maybe I need to do more than exit from LO before I start it again in 
order to activate the Subroutine?

-- 
Jim

-Original Message-
From: "Andreas Säger" 
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:
> 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 [ dir("path/file.ext") ] instead of a file name? 
> And, won't it operate on no more than one entity? I thought the idea was to 
> automatically open zero or more office document files when soffice starts 
> running.
> 
> It also could probably be made more robust by adding a supporting function 
> that validates the file's extension. Just a thought.
> 

File name extensions are meaningless. LibreOffice tries to open any file
regardless of its extension. Rename a file to .xyz and open with
LibreOffice.
My code should have an error handler for unsupported (possibly broken)
files so the loop can continue in case of any error. That's it.


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 [ dir("path/file.ext") ] instead of a file name? And, won't 
it operate on no more than one entity? I thought the idea was to automatically 
open zero or more office document files when soffice starts running.

It also could probably be made more robust by adding a supporting function that 
validates the file's extension. Just a thought.

-- 
Jim

-Original Message-
From: "Andreas Säger" 
To: users@global.libreoffice.org
Sent: Thu, 28 May 2015 15:35
Subject: [libreoffice-users] Re: open files automatically

>8

Sub onApplicationStart()
   oSrv = createUnoService("com.sun.star.util.PathSettings")
   sPath = PathConcat(oSrv.Work, "AutoStart")
   sDir = PathConcat(sPath, "*.*")
   s = dir(sDir)
   while len(s)
  sPathName = PathConcat(sPath,s)
  StarDesktop.loadComponentFromURL(sPathName, "_blank", 0, Array())
  s = dir()
   wend
End Sub

Function PathConcat(s1, s2)
   if right(s1,1) <> "/" then s1 = s1 & "/"
   PathConcat = s1 & s2
End Function

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] open files automatically

[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 execution of soffice begins.

You speak of editing the script so that it opens the specific calc (.ods?) 
files. I have not exhaustively examined the 3 1/2 printed pages the script 
occupies so pardon me if the next question is answered in an obvious manner 
within the script. Where does one look in the script for the code to open 
certain "calc" files?

This is a very interesting discussion.

-- 
Jim

-Original Message (heavily pruned)-
From: toki 
To: users@global.libreoffice.org
Sent: Wed, 27 May 2015 22:26
Subject: Re: [libreoffice-users] open files automatically



On 27/05/2015 19:28, Steve Edmonds wrote:
> This is still not what the OP wants.

What he wants to know, is how to edit
«
#!/bin/sh
#
# This file is part of the LibreOffice project.
#
->8=
# oosplash does the rest: forcing pages in, javaldx etc. are
exec $VALGRINDCHECK $STRACECHECK "$sd_prog/oosplash" "$@"
»

so that it opens the specific calc files.

jonathon


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[James E Lang]

Thank you Andreas.

Basically I was inadvertently attempting to do something I ought not to do. I 
was cutting and pasting from a range of cells (Sheet4.A1:AM418) to a different 
sheet. Some of those cells contained references to a PARTIALLY embedded range 
of cells (Sheet4.P$3:P$1230). After the cut and paste operation, the data from 
416 of the 1228 referenced cells in the embedded range has been relocated while 
the data in the other 812 referenced cells remain where they were. LO Cannot be 
expected to read my mind WRT my intent in my internally inconsistent operation.

My only issue was that I was not alerted that I was making this error. When I 
saw that I was getting wrong results I undid the cut and paste. When I finally 
spotted what I'd done wrong I was able to revise the formulas by simply 
deleting rows 419 through 1230 before performing the cut and paste once again. 
In this instance that was the correct action to take.

I'm so happy that I spotted the incorrect values in calculated cells right away 
but it could have been disastrous. 

Upon detection of this inconsistency I would have expected LO to have displayed 
a notification dialog with one option being to cancel the operation.

As I indicated, I made a major boo-boo. I doubt many others have done the same 
but I hope my experience helps somebody else,

-- 
Jim

-Original Message-
From: "Andreas Säger" 
To: users@global.libreoffice.org
Sent: Tue, 05 May 2015 9:55
Subject: [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 that reference a 
> range of cells (e.g. Sheet4.P$3:P$1230) that is partially but not entirely 
> within the Cut range as they were with no warning. This action left me 
> scratching my head for a while. The examples are from real life.
> 
> The desirable action would be to issue a warning but I doubt that would be 
> practical. In this case there were something in the vicinity of 16000 
> formulas that failed to get converted. Thank goodness for the ability to undo 
> multiple steps.
> 


[Tutorial] Absolute, relative and mixed references

> https://forum.openoffice.org/en/forum/viewtopic.php?f=75&t=2443




-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Calc: Cutting and Pasting Ranges

[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 range as they were with no warning. This action left me 
scratching my head for a while. The examples are from real life.

The desirable action would be to issue a warning but I doubt that would be 
practical. In this case there were something in the vicinity of 16000 formulas 
that failed to get converted. Thank goodness for the ability to undo multiple 
steps.

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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: 
X-Spam-Status: No, score=-1.9 tagged_above=-999 required=6.31
 tests=[BAYES_00=-1.9, RCVD_IN_DNSWL_BLOCKED=0.001,
 SPF_HELO_PASS=-0.001] autolearn=ham

I guess that the prior message in the discussion got tagged as potential spam 
on its way to Susan. (??)

-- 
Jim

-Original Message-
From: Susan Deaton 
To: users@global.libreoffice.org
Sent: Tue, 28 Apr 2015 10:07
Subject: Re: [SPAM?] Re: [libreoffice-users] Libre Calc - moving text in cell + 
comparison chart


On 4/26/2015 4:16 PM, Brian Barker wrote:
> At 14:31 26/04/2015 -0400, Charles Meyer wrote:
>> I'm learning the function keys between MS Excel and Libre Calc work 
>> quite differently. In Excel if you wish text in a cell to return to 
>> the next line in that cell, you choose Ctrl + Enter.
>
> I think you are a bit confused here! In Microsoft Excel, Ctrl+Enter is 
> used in place of Enter to complete an entry when you have selected a 
> range of cells and want them all populated with the same entry. In 
> Excel, if you want to create a manual line break within a cell, you 
> use Alt+Enter, not Ctrl+Enter.
>
>> That doesn't seem to work in Libre Calc. Could you please share how 
>> that is done in Libre Calc?
>
> To add to the confusion, Ctrl+Enter is precisely how you achieve the 
> same thing in Calc! But this works only in the cell, not in the Input 
> Line. And - you've guessed it! - Alt+Enter is how you perform multiple 
> insertions. The two keyboard shortcuts swap their effects between 
> Excel and Calc, that is.
>
>> Has anyone happened upon any comparison chart showing how to 
>> accomplish certain functions in Libre Calc compared with how you 
>> perform them in MS Excel?
>
> https://wiki.openoffice.org/wiki/Documentation/UserGuide/Migration_Guide/Calc_and_Excel
>  
> is written for OpenOffice and may or may not be helpful. It's part of 
> OpenOffice's Migration Guide.
>
> I trust this helps.
>
> Brian Barker
>
>
It certainly helps me!  Your "To add to the confusion" paragraph details 
something I've been wanting for a long time.
-- Tim Deaton


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Calc wasting paper

[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 the 
print dialog does NOT save paper.

LO 4.3.5.2 on Windows

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 
To: users@global.libreoffice.org, pete nikolic 
Sent: Sat, 25 Apr 2015 11:47
Subject: Re: [libreoffice-users] selecting cells in calc sheet

The main thing I'm not understanding is whether the formula is to be one fixed 
place or if after 3 data points it is in cell X but after 4 data points it is 
in cell Y. The solution I gave you applies to the latter case.

For the former case I would use a more complex formula like this using your 
latest specification.

=IF(COUNT(A1:A50)>2,AVERAGE(OFFSET(A1,0,COUNT(A1:A50)-3,1,3))-30,"")

That says, if there are more than two values then define a horizontal range 
composed of the last three filled cells, average that range, and subtract 30. 
This works as long as they are no empty or text cells 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

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 
To: users@global.libreoffice.org
Sent: Sun, 26 Apr 2015 11:33
Subject: [libreoffice-users] Libre Calc - moving text in cell + comparison chart

Hi Folks,

I’m learning the function keys between MS Excel and Libre Calc work
quite differently.

In Excel if you wish text in a cell to return to the next line in that
cell, you choose Ctrl + Enter.

That’s doesn’t seem to work in Libre Calc.

Could you please share how that is done in Libre Calc?

Has anyone happened upon any comparison chart showing how to
accomplish certain functions in Libre Calc compared with how you
perform them in MS Excel?

MS has shared that with MS Word and WordPerfect so if you’re
transitioning into MS Word you can acclimate easier.

Thanks so much!

Charles.

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[James E Lang]

You're in business. The AVERAGE() function does the same thing as the SUM() 
function divided by the COUNT() function. I would use AVERAGE() as it is 
cleaner (more streamlined).

I'm glad I could help. I use the OFFSET() function myself to dynamically define 
ranges of cells. If somebody knows 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 
To: James E Lang 
Sent: Sat, 25 Apr 2015 12:17
Subject: Re: [libreoffice-users] selecting cells in calc sheet

On Sat, 25 Apr 2015 11:46:23 -0700
James E Lang  wrote:

> The main thing I'm not understanding is whether the formula is to be one fixed
> place or if after 3 data points it is in cell X but after 4 data points it is 
> in
> cell Y. The solution I gave you applies to the latter case.
> 
> For the former case I would use a more complex formula like this using your 
> latest
> specification.
> 
> =IF(COUNT(A1:A50)>2,AVERAGE(OFFSET(A1,0,COUNT(A1:A50)-3,1,3)-30,"")
> 
> That says, if there are more than two values then define a horizontal range
> composed of the last three filled cells, average that range, and subtract 30. 
> This
> works as long as they are no empty or text cells 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.
> 
> 

Hi Jim ..


Right this is looking promissing   the actual location of the formula /result 
will
be in a separate cell on the same row but outside the range of entered values it
will also be copied to the next 30 or so rows below and edited to suit where
needed   . one other thing you have it averaging the cells they need to be added
together then divided by 3 unless the average function does the same thing 



Thanks  

Pete .
  

-- 
Illegitimi non carborundum . ro for the purists out there
Noli nothis permittere te terere. 

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[James E Lang]

The main thing I'm not understanding is whether the formula is to be one fixed 
place or if after 3 data points it is in cell X but after 4 data points it is 
in cell Y. The solution I gave you applies to the latter case.

For the former case I would use a more complex formula like this using your 
latest specification.

=IF(COUNT(A1:A50)>2,AVERAGE(OFFSET(A1,0,COUNT(A1:A50)-3,1,3)-30,"")

That says, if there are more than two values then define a horizontal range 
composed of the last three filled cells, average that range, and subtract 30. 
This works as long as they are no empty or text cells 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 
To: James E Lang , users@global.libreoffice.org
Sent: Sat, 25 Apr 2015 11:11
Subject: Re: [libreoffice-users] selecting cells in calc sheet

On Sat, 25 Apr 2015 10:53:38 -0700
James E Lang  wrote:

> You did not correct any of my suppositions so here is my very detailed
> recommendation. Note that my quotation marks surrounding text are NOT to be 
> keyed
> into the spreadsheet. For the time being I will limit my discussion to 
> columns A
> through L and rows 1 through 5.
> 
> Starting from scratch with a new (empty) spreadsheet, select cell A1 and enter
> "Region"
> 
> In B1 enter "Constant"
> 
> In cell C1 enter the first date such as "01/01/2015"
> 
> Leave D1 empty but merge C1 and D1.
> 
> Continue with E1 & F1, G1 & H1, I1 & J1, and K1 & L1 in the same manner.
> 
> Now go to the data rows. 
> 
> In cell A2 enter the name of the first region and in B2 that region's constant
> such as "30"
> 
> Prepare cells A3 through B5 similarly.
> 
> Leave cells C2 through G2 empty for now.
> 
> The long sought formula first appears in cell H2. It is
>   =IF(G2="","",AVERAGE(C2,E2,G2)-$B2)
> 
> Now select cells G2 through H2 and copy (Ctrl+C).
> 
> Finally select cells G2 through L5 and paste (Ctrl+V). Of course this final 
> step
> can be modified to cover up to 511 date ranges and over one million regions.
> 
> In production you might accidentally enter data where the formula is. Remember
> that undo (Ctrl+Z) is your friend when this happens. You can also use copy and
> paste or fill vertically to recover.
> 
> I hope this satisfies your requirements, If not then you'll have to explain 
> your
> requirements better.
> 

Hi James .


It may in a round about fashion  lets just totally forget about dates .

Lets imagine a row that has number entered in cells on that row at intervals 
(the
interval is totally unimportant) i enter a number  in A1 then another in A2  
with
just input in A1 & A2 no action  enter a number in A3 then sum the numbers  
(easy so
far) the enter a number in A4  then i want it to forget the value in A1 and sum 
A2
A3 &A4  then enter a number in A5 i then want it to forget A1 & A2 and Sum A3 
A4 &A5
and so on  does this help any 


  PS thanks so far this is one aspect of spread sheets that i find confusing
to say the least


Pete .
 
-- 
Illegitimi non carborundum . ro for the purists out there
Noli nothis permittere te terere. 

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[James E Lang]

You did not correct any of my suppositions so here is my very detailed 
recommendation. Note that my quotation marks surrounding text are NOT to be 
keyed into the spreadsheet. For the time being I will limit my discussion to 
columns A through L and rows 1 through 5.

Starting from scratch with a new (empty) spreadsheet, select cell A1 and enter 
"Region"

In B1 enter "Constant"

In cell C1 enter the first date such as "01/01/2015"

Leave D1 empty but merge C1 and D1.

Continue with E1 & F1, G1 & H1, I1 & J1, and K1 & L1 in the same manner.

Now go to the data rows. 

In cell A2 enter the name of the first region and in B2 that region's constant 
such as "30"

Prepare cells A3 through B5 similarly.

Leave cells C2 through G2 empty for now.

The long sought formula first appears in cell H2. It is
  =IF(G2="","",AVERAGE(C2,E2,G2)-$B2)

Now select cells G2 through H2 and copy (Ctrl+C).

Finally select cells G2 through L5 and paste (Ctrl+V). Of course this final 
step can be modified to cover up to 511 date ranges and over one million 
regions.

In production you might accidentally enter data where the formula is. Remember 
that undo (Ctrl+Z) is your friend when this happens. You can also use copy 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 
To: James E Lang 
Sent: Sat, 25 Apr 2015 8:38
Subject: Re: [libreoffice-users] selecting cells in calc sheet

On Sat, 25 Apr 2015 01:30:53 -0700
James E Lang  wrote:

> Pete,
> 
> Pardon me. I'm confused. 
> 
> When you say C5 (for example) which do you mean, Row 5 in Column C or the 
> fifth
> column?
> 
> Where is the calculation?
> 
> You speak of C1, C3, C5, C7, ... but what about C2, C4, C6, C8, ...?
> 
> Here is what I understand (my suppositions): 
> 
> Row 1 is a ser of column headings. 
> 
> Column A contains a set of names (of regions maybe). 
> 
> Columns C, E, G, I, ... are headed by dates (e.g. Jan 1, Feb 14, etc.). 
> 
> At the intersection of column C and row 2 is a number (maybe a counter of some
> kind) relating to the first region from Jan 1 through Feb 13. Other cells in
> columns C, E, G, I, ... get filled similarly.
> 
> Starting with the third time interval you want to calculate the average of the
> most recent three vakues stored in those cilumns bur adjusted by some mystery
> constant for that region (column B maybe) and maybe store that result in 
> columns
> D, F, H, J 
> 
> 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.
> 



Hi right   ok lets see 


take an ever increasing  list of values  for the first 2 values do nothing  
when a
third value gets added add the three together  then add anoter value to the list
ignore the first 2 values add the next three  add another value  then ignore 
first 3
values  add the remaining three  but every time a value is added discard the
previous sum of three  ...



Pete .


-- 
Illegitimi non carborundum . ro for the purists out there
Noli nothis permittere te terere. 

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[James E Lang]

Pete,

Pardon me. I'm confused. 

When you say C5 (for example) which do you mean, Row 5 in Column C or the fifth 
column?

Where is the calculation?

You speak of C1, C3, C5, C7, ... but what about C2, C4, C6, C8, ...?

Here is what I understand (my suppositions): 

Row 1 is a ser of column headings. 

Column A contains a set of names (of regions maybe). 

Columns C, E, G, I, ... are headed by dates (e.g. Jan 1, Feb 14, etc.). 

At the intersection of column C and row 2 is a number (maybe a counter of some 
kind) relating to the first region from Jan 1 through Feb 13. Other cells in 
columns C, E, G, I, ... get filled similarly.

Starting with the third time interval you want to calculate the average of the 
most recent three vakues stored in those cilumns bur adjusted by some mystery 
constant for that region (column B maybe) and maybe store that result in 
columns D, F, H, J 

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 
To: James E Lang 
Sent: Fri, 24 Apr 2015 23:43
Subject: Re: [libreoffice-users] selecting cells in calc sheet

On Fri, 24 Apr 2015 20:36:10 -0700
James E Lang  wrote:

> 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 there's no more than eight
> months worth of data so I guess C17 ends the series.
> 
> Without some of the information vacuum filled I'm not sure what we can do for 
> you.
> 

Right   let me see how i can put this without attaching a spreadsheet


coloums..

C1 name C3  date1   C5 date2C7 date3C9 date4C11
date5 

in those colums  under the dates will be numbers of i would guess around the 40 
to
60 region but only on or after the date ie under date 1 on row name 1 say 45  
next
month it is date2 name1 say 48 then date3 name1  60, date4 name1  48 date5 
name1 56
ect ect

Dates are columns rows are names there will be about 25 names  8 dates in total 
 so
for date1 date2 both name1 there would be no result , then fill date3 name 1 i 
then
need to do the add date1 date2 date3 divide by .

Thats is the easy bit  now when i fill date4 i need it to ignore date1 and add 
date
2 date3 date4 then divide  when i fill date 5 i need it to ignore date1 date 2  
add
date3 date4 date5 divide by 3 and carry on like that always only picking the 
last
3 dates ignoring any earlier .

does that help any 

date1   data2   date3   date4   date5
  name1 48  60  48  56  

Pete





-- 
Illegitimi non carborundum . ro for the purists out there
Noli nothis permittere te terere. 

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 there's no more than 
eight months worth of data so I guess C17 ends the series.

Without some of the information vacuum filled I'm not sure what we can do for 
you.

-- 
Jim

-Original Message-
From: Piet van Oostrum 
To: pete nikolic 
Cc: users@global.libreoffice.org
Sent: Fri, 24 Apr 2015 14:20
Subject: Re: [libreoffice-users] selecting cells in calc sheet

pete nikolic wrote:

 >   if we start as will be the case  C3   will contain say 50  (the actual 
 > dates are
 >   of little importance )  a month later  C5 will be say 47  and so on every 
 > month
 >   the next cell would be C7 then C9 then C11 what i need is to be able to
 >   automatically pick the last 3 cells containing data  so when C9 is filled 
 > in then
 >   it needs to automatically choose  C9 C7 C5 and add them then divide by 3  
 > then
 >   subtract  a variable defined on the day   ..
 > 
 > Hope this makes it a little clearer 
 > 
That would then be:

IF(ISBLANK(C7);"";AVERAGE(C3;C5;C7)-30)

-- 
Piet van Oostrum 
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 formatted to 
display numbers as currency. How could that formatting be saved without saving 
those "empty" cells?

-- 
Jim

-Original Message-
From: Cley Faye 
To: RamonTavarez 
Cc: "users@global.libreoffice.org" 
Sent: Thu, 23 Apr 2015 13:47
Subject: Re: [libreoffice-users] Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file 
conversion?

That's interesting. Examining the beginning of one of the "big" sheets in
both case, we see that LibreOffice is *very* verbose with what it save. If
I understand it correctly, LO save informations about *every* cells,
including empty ones. Which is very odd, since it does not do it with
*every* sheets.

This does not explain why MSO have to "repair" the files though. Maybe the
devs would be interested in this test case.

-- 
Cley Faye
http://cleyfaye.net

2015-04-23 20:12 GMT+02:00 RamonTavarez :

> Check the post,  I've uploaded the requested file.
>
> Thanks for your interest.
>
> Regards
>
> *Ramón E. Tavárez B.*
>
> On Thu, Apr 23, 2015 at 1:31 PM, Cley Faye [via Document Foundation Mail
> Archive]  wrote:
>
> > Discussion about open formats aside, I've looked at the file and it looks
> > like when saving as xlsx each sheet grow huge (some goes to ~20MB before
> > compression).
> >
> > Could you also post the xlsx file obtained when saving with MSO, for
> > comparison? My guess is that either LO saves *a lot* of empty/dummy
> cells,
> > or that it saves in an older xlsx format that is less compact.
> >
> > btw this is only a "by curiosity" request, but it could help the dev
> > pinpoint an issue if my first guess is correct.
> >
> > --
> > Cley Faye
> > http://cleyfaye.net
> >
> > 2015-04-23 17:28 GMT+02:00 Tom Davies <[hidden email]
> > >:
> >
> > > Hi :)
> > > Yeh, i don't know a good way around that :(  other than the way you
> > already
> > > use! :))
> > >
> > >
> > > People used to be quite happy with the idea of downloading Adobe
> Acrobat
> > to
> > > read Pdfs with.  It used to be that almost any website that shared any
> > kind
> > > of document tended to only have them as Pdfs and also then 'had to'
> have
> > a
> > > button to help people download and install an Adobe Pdf Reader.  We
> > hardly
> > > see any of that these days but that is quite a recent change.
> > >
> > > There were objections from people working in the council, or other
> > > government offices or in big companies that they couldn't install
> > anything
> > > and thus couldn't use the format that everyone else seemed to be using
> > so
> > > much.  Now they seem to use Pdf more than everyone else, and even
> demand
> > > that other people use it!
> > >
> > > Regards from
> > > Tom :)
> > >
> > >
> > >
> > >
> > >
> > > On 23 April 2015 at 16:08, Ramon Tavarez <[hidden email]
> > > wrote:
> > >
> > > > Hi:
> > > >
> > > > Thanks for your attention.
> > > >
> > > > The fact with this file is that can't be supported by .XLS format,
> and
> > my
> > > > coworkers doesn't work with LibO, and that is the only way I can use
> > to
> > > > "keep in touch" with them and their jobs. It may be a pain .. ... ...
> > ,
> > > > but while it work I'll keep using this method to share my jobs with
> > them!
> > > >
> > > > In  use LibO for every document  I  create, even I update every
> > version
> > > of
> > > > LibO  as the module for my Linux distro: Porteus.
> > > >
> > > > On the other hand,I can understand the situation with MSOffice and
> how
> > > > they refuse the OpenDocument formats, but I still worry about   the
> > big
> > > >  file size for those files not supported by the "classical" file
> type.
> > > >
> > > > This can lead erroneously, as you said,  to people to believe that
> > > > everyone else made bad spreadsheet programs and everyone should stick
> > > with
> > > > MS.
> > > >
> > > > Thanks.
> > > >
> > > > *Ramón E. Tavárez B.*
> > > >
> > > > On Thu, Apr 23, 2015 at 10:47 AM, Tom Davies <[hidden email]
> > > wrote:
> > > >
> > > >> Hi :)
> > > >> The XlsX, and other OOXML formats are notoriously unreliable.  Each
> > > >> different version of MS Office uses slightly different versions.
> > There
> > > are
> > > >> at least 3 different "transitional" versions of the format and they
> > are
> > > not
> > > >> always compatible with each other.
> > > >>
> > > >> If you take the XlsX that was saved by MS Office 2013 and try
> opening
> > it
> > > >> in another version of MS Office, say 2010 or 2007, or even 365 then
> > you
> > > may
> > > >> well find it's been opened in "Compatibility Mode" or even that it
> > > doesn'

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

[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 use anything bigger since the speed of 
adding a data value in a single cell at a time was abysmal when I had 4K rows 
on each of four sheets and used less than 100 columns on any single sheet. I 
trimmed the document back to about 1200 rows per sheet for now but I expect it 
will grow to between 4000 and 5000 by the end of the year when I'll start a 
fresh document with a couple hundred rows. 

Of course much of the processing time was most likely spent evaluating some 
reasonably (or maybe unreasonably) complex formulas. I'm working on formula 
simplification but this is difficult since I often make use of the OFFSET() 
function to reference dynamically defined ranges of cells.

-- 
Jim

-Original Message-
From: Luuk 
To: users@global.libreoffice.org
Sent: Thu, 23 Apr 2015 11:54
Subject: Re: [libreoffice-users] column limit in libreoffice 4.3.something

On 23-4-2015 20:39, yahoo-pier_andreit wrote:
> today I encountered a problem opening an excel file with libreoffice
> 4.3.something regarding maximum number of column, why number of columns
> is so low in libreoffice ???
> many thanks, ciao :-) pier
>

- Please, define 'so low'

i see 1024 columns in 4.4.something and also in 4.1.something

- Please, share COMPLETE (version) info, or nothing if you are too lazy 
to find out ;)





-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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: "林承益" 
To: users 
Sent: Tue, 21 Apr 2015 5:04
Subject: [libreoffice-users] libreoffice issue: libreoffice for android crashed

Hi,deer;

I meet a problem after I builded the libreoffcie-core (git from 
git://anongit.freedesktop.org/libreoffice/core ) with android version in winxp 
x86 platform by ant.
I pushed the LibreOfficeUIActivity.apk  into my android mobiephone in android 
4.4.4, opened a dox or xml file ,the 
libreoffcie crashed. The logs as follows:

04-16 16:07:03.410: E/org.mozilla.gecko.gfx.LayerView(25414): ### Creating GL 
thread!
04-16 16:07:03.470: E/lo-bootstrap(25414): lo_apkentry: File 
assets/unpack/etc/fonts/fonts.conf is compressed
04-16 16:07:03.470: E/lo-bootstrap(25414): extract_files: Could not find 
/assets/unpack/etc/fonts/fonts.conf in .apk
04-16 16:07:03.470: E/lo-bootstrap(25414): lo_apkentry: File 
assets/unpack/program/sofficerc is compressed
04-16 16:07:03.470: E/lo-bootstrap(25414): extract_files: Could not find 
/assets/unpack/program/sofficerc in .apk
04-16 16:07:03.885: E/lo-bootstrap(25414): lo_apkentry: File 
assets/program/unorc is compressed
04-16 16:07:03.890: A/libc(25414): Fatal signal 11 (SIGSEGV) at 0x 
(code=1), thread 25587 (Thread-1546)

would you give me some tips for this issue, thanks for a lot







  
> Best Regards
> =
> E-mail：chengyi@keywie.com
-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 
To: users@global.libreoffice.org
Sent: Wed, 22 Apr 2015 14:09
Subject: Re: [libreoffice-users] Re: [Calc] Relative references behavior for 
worksheets


> Replicating your steps, I get a copy of Sheet2 at position #1 and any
> relative reference to the previous sheet needs to raise a #REF! error
> because you told me to reference a cell on the previous sheet. The error is
> perfectly clear, wanted and informative. There is nothing wrong with errors.
> Errors are not a slap in your face. They are not errors because you are
> stupid. I can not see any error in the application. Everything works as
> expected. If you reference something something irreferenciable you get a
> #REF! error.
> 
 
I seem to have a problem explaining the matter.

I do understand how it works. I understand the error. I understand why 
it is giving this error. I am not complaining about receiving an error.

I'll try to explain my point in a different way.

Let's assume the following procedure:
1_ Click on A2.
2_ Type in an equal sign, "=".
3_ Click on A1.
4_ Press [Enter]
5_ Click on A2.

The resulting formula is:
A2: =A1

The default behavior, as seen in this simple procedure, is that cells 
are referenced with relative notation.

If the resulting formula would had been (by default and with no 
additional steps/help):
A2: =$A$1

we would had concluded that the default behavior was absolute 
references. But we know this is not the default behavior, and users 
take advantage of this. All spreadsheet programs that I know of behave 
in this same way. To receive a formula with absolute references in Calc 
we would need some extra step(s) (e.g. [Shift-F4]).

Now let's repeat the procedure, with a slight difference:
1_ Click on Sheet2.A2.
2_ Type in an equal sign, "=".
3_ Click on Sheet1.
4_ Click on Sheet1.A1
5_ Press [Enter]
6_ Click on Sheet2.
7_ Click on Sheet2.A2.

The resulting formula is:
Sheet2.A2: =Sheet1.A1

Here, once again, the cell references are, by default, relative. Since 
we now involved multiple sheets in the formula, the resulting formula 
includes the sheet(s) as part of the reference.

And we also see that, by default, the reference to "Sheet1" is also a 
relative one. Here is where Calc goes differently than other 
spreadsheet programs, and it is here where users (that are used to 
other spreadsheet programs) are having problems (and even reporting 
this behavior as a bug, multiple times already, since they don't 
understand why it is failing, considering that they are used to a 
different default behavior).

When using other spreadsheet programs, the resulting formula for the 
last procedure would had been: "absolute reference for 'Sheet1' and 
relative reference for its 'A1' cell". Or, using Calc's notation:
Sheet2.A2: =$Sheet1.A1

(note the "$").

What I am trying to convey is that Calc should change the default 
behavior for referencing sheets, so to behave as other spreadsheet 
programs do.

I am not saying that:
Sheet2.A2: =Sheet1.A1
is wrong, or that I don't understand the "#REF!" error, or that I don't 
understand why the error is being generated after the copy+paste 
procedure I described in my initial email. I am saying that the 
_default_ behavior should be to obtain absolute references to sheets 
(while keeping relative references to their cells).

I am not suggesting to change the meaning of the "$" in front of the 
sheet. I am not suggesting to change the behavior of the "REF!" error 
nor its meaning.

I _am_ suggesting that, by default, the sheets in Calc should be using 
the "$" in front of them.

If a user wants to use relative notation for sheets, then such result 
should had been obtained by adding some step (e.g. explicitly deleting 
the "$" in front of the sheet reference), instead of obtaining a 
relative reference to the sheet by default, as it is now.

By changing the default behavior regarding default references to 
sheets, Calc would be simply imitating what other worksheet programs 
already do, and less "REF!" situation would be encountered by users.

Additionally, it is easier to replace absolute references to sheets 
with relative references to sheets, whereas it can be very difficult to 
find and correct every "REF!" in complex workbooks.

It is the *default* behavior of "references to sheets" that I am 
talking about. Hopefully I am making it more clear now.

Now, if my experience with other spreadsheet programs (as I described 
it here) is different than other users here in the list, I would like 
to know about it. If the tests / steps I have presented in this email 
thread cannot be replicated by others, or if the default behavior seen 
by others is different than what I am seeing, I would really apprecia

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

[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 $ and relative if entered naked). 
If one or more new sheets are inserted or removed the sheet references should 
be modified applying the same rules as are used with regard to column (row) 
references when one or more columns (rows) are inserted or removed. Any 
spreadsheet program (be it MSO Excel, KingSoft spreadsheet, or even OOo or LO 
Calc) operates differently than this then IMNSHO they got it wrong.

Where am I wrong?

-- 
Jim

-Original Message-
From: Ady 
To: users@global.libreoffice.org
Sent: Wed, 22 Apr 2015 6:45
Subject: [libreoffice-users] [Calc] Relative references behavior for worksheets

Hello,

I had the intention to file a bug report for Calc, but then I thought 
that maybe I should first ask for some user's feedback.

I would like to know if the behavior I am about to describe can be 
replicated with several versions of LibreOffice and/or under different 
configurations / scenarios / OSes. Other comments are also welcome, of 
course.

The following is the text of the bug report I was about to file in. 
Apologies for its length; I have seen too many of these problems 
already and I want to explain the problem (and its solution) as clear 
as possible.

TIA,
Ady.

  


1_ New Calc spreadsheet (aka workbook).
2_ For this test, we need at least 2 Sheets ("Sheet1" and "Sheet2") in 
the new spreadsheet document.
3_ In Sheet2 -> A1 : =Sheet1.A1
4_ Right click on the "Sheet2" tab and select "Move/Copy Sheet...".
5_ In the "Move/Copy Sheet" dialog, select "Copy", then OK.
6_ Select the new "Sheet2_2 , A1" cell.
7_ Note that the content of "Sheet2_2 , A1" is "=#REF!.A1", and the 
result being displayed is "#REF!".
8_ Right click again on the "Sheet2" tab and select "Move/Copy 
Sheet..." (as in step #4 above).
9_ In the "Move/Copy Sheet" dialog, select "Copy", select "move to end 
position", then OK.
10_ Select the new "Sheet2_3 , A1" cell.
11_ Note that the content of "Sheet2_3 , A1" is (this time), 
"=Sheet2.A1".
12_ Note that "Sheet2" has been copied to "Sheet2_3" with _relative_ 
references for _sheets_; e.g. "Sheet2_3 , A1" is not an exact copy of 
"Sheet2 , A1", as "Sheet2_3 , A1" contains "=Sheet2.A1" (pasted with 
relative notation for the _sheet_), instead of containing "Sheet1.A1" 
(as it would had been expected in other spreadsheet programs).


This test shows that the Sheets are being treated with _relative_ 
(reference) notation by default, as cells are.

There seem to be similar reports about "named range of cells", and with 
copies to another spreadsheet file (instead of copying inside the same 
file, as my test here does).

Additionally, changing the name of the sheets, from "SheetN" to 
something else, doesn't change this behavior.

Although I understand the potential advantage in some cases, this 
concept and behavior of "relative" references to Sheets is inadequate.

We have relative notation in/for _cells_ because there is a certain 
standard for their references, a "series". But this is not true for 
Sheets, nor for a named range of cells for that matter.

At first sight, and based on the above test, someone could potentially 
propose to only allow copying sheets "to the end"; but such idea would 
be wrong too. In my sample test, I only used one formula, retrieving 
data from one sheet "from the left" and then copying the sheet "to the 
left" (in the typical LTR display). But I could have multiple sheets 
and I could be retrieving data from surrounding sheets from both sides.

The relative notation in cells works everywhere in almost all cases. 
Applying the same concept and *default* behavior to sheets and named 
ranges of cells is inadequate. I consider this to be almost a bug, and 
I am certainly not the only one.

Using the "relative notation" concept (and behavior) on anything other 
than common cells should *not* be the default behavior, and such 
possibility should be optionally and explicitly selected by the user 
when performing each "copy+paste" action, or by means of the adequate 
notation.

In other words, please leave the "relative notation" as default for 
cells only, and as optional selectable possibility for sheets and for 
named ranges of cells. The default notation for sheets should be 
*absolute references*. In fact, the only references that should default 
to relative notation should be references to cells, and any other 
references should default to absolute notation.

Copying a Sheet already containing a formula pointing to another Sheet 
should not generate "#REF!" errors. Sheets' references should be 
inserted as _absolute_ notation by default.

The current default behavior is UNexpected by users (since other 
Spreadsheet programs do not behave in th

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

[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 
To: jorge 
Cc: users@global.libreoffice.org
Sent: Tue, 21 Apr 2015 12:18
Subject: Re: [libreoffice-users] Re: Heads up -- LibreOffice 5.0 is on the 
horizion

jorge wrote on 21-04-15 18:28:

> https://wiki.documentfoundation.org/File:Design_White_Board-LibreOffice.png

Thanks for your work on this Jorge.
But IMO a design for our needs must be more cute, straight and so.
Yours look more as an idea for a poster - so I would suggest to keep and
improve it for such an opportunity.

Regards,
Cor


-- 
Cor Nouws
GPD key ID: 0xB13480A6 - 591A 30A7 36A0 CE3C 3D28  A038 E49D 7365 B134 80A6
- vrijwilliger http://nl.libreoffice.org
- volunteer http://www.libreoffice.org
- The Document Foundation Membership Committee Member

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 
To: "James E. Lang" 
Sent: Mon, 20 Apr 2015 11:40
Subject: Re: [libreoffice-users] [LibreOffice Writer] Table with alternat[]e 
row color

On 20.04.2015 10:03, James E. Lang wrote:
> Hi Andrew,
>
> This message is off list for technical reasons.

No problem, especially for this type of question :-)

>
> As I stated in a message that I posted to the list yesterday, I don't
> do a lot of work with
> LibreOffice Writer. That said, I tried your macro and it choked
> (Sub-procedure or function
> procedure not defined) on this line:
>
> SetParStyle(oCell.getText(), "OOoTableHeader")


Yeah, sorry about that. What this is doing is setting the first row to 
use the paragraph style named "OOoTableHeader". I don't know if you have 
seen any of my documents, but it is how I format my text tables in 
general. You can comment out that line, or, change "OOoTableHeader" to 
be the paragraph style that you want to use.

There is another line below it

SetParStyle(oCell.getText(), "OOoTableText")

This sets all of the other lines to use the paragraph style 
"OOoTableText", which is probably a paragraph style that you do not have 
if you do not write documentation for LibreOffice.

Comment out these two lines by placing a single quote before them or 
the text REM as follows:

'SetParStyle(oCell.getText(), "OOoTableText")
REM SetParStyle(oCell.getText(), "OOoTableText")



>
> Is this because I don't have the jre installed or is there something
> else that is required
> (defining the UNO interface maybe?) beyond the Sub you posted?
>
> My Macros=>Standard=>Module1 contains only the empty Sub Main, three
> pure Basic (UNO
> free) functions that I wrote for a spreadsheet, and your Sub
> FormatTable which I copied from
> the eMail and pasted into the module.
>
> --
> Jim
>
> On 20 Apr 2015 at 8:03, Andrew Douglas Pitonyak wrote:
>
>> I wrote a macro some years back and I still use it today. You 
>> probably
>> have no interest in the part that sets the borders...
>>
>> Sub FormatTable(Optional oUseTable)
>>Dim oTable
>>Dim oCell
>>Dim nRow As Long
>>Dim nCol As Long
>>
>>If IsMissing(oUseTable) Then
>>  oTable = 
>> ThisComponent.CurrentController.getViewCursor().TextTable
>>Else
>>  oTable = oUseTable
>>End If
>>If IsNull(oTable) OR IsEmpty(oTable) Then
>>  Print "FormatTable: No table specified"
>>  Exit Sub
>>End If
>>
>>Dim v
>>Dim x
>>v = oTable.TableBorder
>>x = v.TopLine
>>x.OuterLineWidth = 2
>>v.TopLine = x
>>
>>x = v.LeftLine
>>x.OuterLineWidth = 2
>>v.LeftLine = x
>>
>>x = v.RightLine
>>x.OuterLineWidth = 2
>>v.RightLine = x
>>
>>x = v.TopLine
>>x.OuterLineWidth = 2
>>v.TopLine = x
>>
>>x = v.VerticalLine
>>x.OuterLineWidth = 2
>>v.VerticalLine = x
>>
>>x = v.HorizontalLine
>>x.OuterLineWidth = 0
>>v.HorizontalLine = x
>>
>>x = v.BottomLine
>>x.OuterLineWidth = 2
>>v.BottomLine = x
>>
>>'v.Distance = 51
>>
>>oTable.TableBorder = v
>>
>>For nRow = 0 To oTable.getRows().getCount() - 1
>>  For nCol = 0 To oTable.getColumns().getCount() - 1
>>oCell = oTable.getCellByPosition(nCol, nRow)
>>If nRow = 0 Then
>>  oCell.BackColor = 128
>>  SetParStyle(oCell.getText(), "OOoTableHeader")
>>Else
>>  SetParStyle(oCell.getText(), "OOoTableText")
>>  If nRow MOD 2 = 1 Then
>>oCell.BackColor = -1
>>  Else
>>REM color is (230, 230, 230)
>>oCell.BackColor = 15132390
>>  End If
>>End If
>>  Next
>>Next
>> End Sub
>>
>> --
>> Andrew Pitonyak

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users]

[James E Lang]

 postmas...@btinternet.com)
Subject: Re: [libreoffice-users] Table with alternat[]e row color
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Thanks Brian. It looks like Paste in this case is the same as Paste Special 
Calc8. They both retain the colors, some formulas, and spreadsheet context (Row 
& Column identities). 

-- 
Jim

-Original Message-
From: Brian Barker 
To: users@global.libreoffice.org
Sent: Sun, 19 Apr 2015 23:13
Subject: Re: [libreoffice-users] Table with alternat[]e row color

At 22:51 19/04/2015 -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. And I 
replied as I assumed that, unlike me, you had made this method work 
and I was genuinely interested to know how.

>I thought this list was one where everyone (expert or novice) shared 
>for the benefit of all.

Of course it is! Let's not change that.

Brian Barker  


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users]

[James E Lang]

 postmas...@btinternet.com)
Subject: Re: [libreoffice-users] Table with alternat[]e row color
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

I performed a simple paste. I guess that technically it's an image (or if you 
like, a picture) but the contents can be editted.

I don't generally use Writer but I do use Calc a lot. I knew that I could 
generate the alternating color bands in Calc by means of formulas so I first 
looked for that functionality in Writer to no avail. Then I tried the technique 
I posted and editted the data successfully so I posted it.

Maybe I'm being over sensitive but I sensed hostlity in your response to me. I 
thought this list was one where everyone (expert or novice) shared for the 
benefit of all.

-- 
Jim

-Original Message-
From: Brian Barker 
To: users@global.libreoffice.org
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 to determine the oddness or evenness of the row number and 
>>control the background colouring using cell styles. But 
>>unfortunately - and as you might expect - the effect of such 
>>formatting is lost if you
>>paste a copy into a text document as a table. So that's a dead duck.
>
>Alain, I don't know whether you consider this to be "simple and 
>automatic" but what I've found is this:
>
>Use LibreOffice to create a spreadsheet. Select the table space. Use 
>Format=>Conditional Formatting=>Condition
>Condition 1:
>   Formula is ISEVEN(ROW())
>   select or create your style for even rows
>
>Add
>Condition 2:
>   Formula is ISODD(ROW())
>   select or create your style for odd rows
>
>OK. Copy the selected cells and paste them into your writer 
>document. This is the best solution I have found. Maybe it will 
>tickle someone else's creativity to come up with a better solution.

It's not clear whether you appreciate that this is the method that I 
described as a dead duck! Could you come clean about exactly how you 
are making this work, please?

Depending on how I paste the cell range from a spreadsheet, I can create:
o a striped graphic with no row or column structure - just a picture,
o an embedded spreadsheet section,
o a blank picture,
o a stack of paragraphs containing only sequences of tab characters, or
o the required table - but without the background formatting!

In particular, freezing the effect of the conditional formatting in 
the spreadsheet before copying the range of cells to the text 
document might be expected to work, but I didn't see any way to do this.

A striped panel is not going to provide the alternately coloured 
table rows that the questioner wanted. Do please explain how you have 
managed to paste the spreadsheet range to create a *formatted table* 
in the text document.

Brian Barker  


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users]

[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 found is this:

Use LibreOffice to create a spreadsheet.

Select the table space.

Use Format=>Conditional Formatting=>Condition

Condition 1: 
  Formula is ISEVEN(ROW())
  select or create your style for even rows

Add

Condition 2:
  Formula is ISODD(ROW())
  select or create your style for odd rows

OK

Copy the selected cells and paste them into your writer document.

This is the best solution I have found. Maybe it will tickle someone else's 
creativity to come up with a better solution.

-- 
Jim

-Original Message-
From: Brian Barker 
To: users@global.libreoffice.org
Sent: Sun, 19 Apr 2015 16:23
Subject: Re: [libreoffice-users] [LibreOffice Writer] Table with alternat[]e 
row color

At 14:10 15/04/2015 +0200, Alain Ronly wrote:
>I'm looking for a simple and automatic way how to tell to my tables 
>in a writer document, to be formatted with alternat[]e rows color 
>for example even rows will be blue in the background and odd rows 
>will have a light blue as background color. I did not find any easy 
>way to do it. Is there someone who has already solved this topic ?

Not me.

o Once you have set the background colour for one row, you can use 
the Format Paintbrush to paint the same colour on other rows. If you 
double-click the button, you can drag the "paint bucket" across 
alternate rows to achieve one colour and then repeat the process for 
the other colour.

o For large numbers of rows, you can copy an entire existing table 
and paste it immediately following - and you can repeat that process. 
You'll end up with multiple tables, but that may suffice, providing 
you delete the empty paragraph between them. If you need to, you can 
put the cursor into the second table and go to Table | Merge Tables 
(or right-click | Merge Tables) to merge the two tables into one.

o It is somewhat easier to set up such background colouring in a 
spreadsheet than in a Writer table. If you colour two rows you can 
easily copy them to two more. Then you can copy four rows to create 
eight in total. With this binary multiplication, you can very quickly 
achieve the desired size. If you then copy an appropriately-sized 
section of the spreadsheet and paste it into your text document using 
Paste Special... and "HTML (HyperText Markup Language)" you will get 
a table with the same background formatting. The table properties can 
be adjusted as necessary.

o The automatic way to colour spreadsheet rows alternately is to use 
Conditional Formatting and create a formula using the ROW() function 
to determine the oddness or evenness of the row number and control 
the background colouring using cell styles. But unfortunately - and 
as you might expect - the effect of such formatting is lost if you 
paste a copy into a text document as a table. So that's a dead duck.

o It's probably much easier to set up formatting such as this before 
you insert your data. If necessary, you should be able to copy any 
existing material and paste it into a new, formatted table.

I trust this helps.

Brian Barker


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Test Message

[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: 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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Basic Calc Question

[James E Lang]

-Original Message-
From: Barry Premeaux 
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 properly. I am trying to
build a general ledger. I have my running balance in the F column and
transactions in the E column. I am trying to construct a conditional
statement that takes the running balance in F4 and adds it to the -/+
transaction in E5 and put the new balance in F5. But when the E5 is $0.00,
I want F5 to remain $0.00 as well until a new transaction is entered.

Reply:

Barry,

Try one of these formulas. The first does what you said you want. The second 
does what I think you want.

=IF(E5=0,0,F4+E5)

=IF(E5="","",F4+E5)

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Basic Calc Question

[James E Lang]

-Original Message-
From: Barry Premeaux 
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 properly. I am trying to
build a general ledger. I have my running balance in the F column and
transactions in the E column. I am trying to construct a conditional
statement that takes the running balance in F4 and adds it to the -/+
transaction in E5 and put the new balance in F5. But when the E5 is $0.00,
I want F5 to remain $0.00 as well until a new transaction is entered.

Revised reply:

Try this in F5
  =IF(E5=0,0,SUM(F4,E5))
or probably better
  =IF(E5="","",SUM(F4,E5))

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Basic Calc Question

[James E Lang]

-- 
Jim

-Original Message-
From: Barry Premeaux 
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 properly. I am trying to
build a general ledger. I have my running balance in the F column and
transactions in the E column. I am trying to construct a conditional
statement that takes the running balance in F4 and adds it to the -/+
transaction in E5 and put the new balance in F5. But when the E5 is $0.00,
I want F5 to remain $0.00 as well until a new transaction is entered.



Try this in F5
  =IF(E5=0,0,F4+E5)

Translated, that says

Barry

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Calc wastes paper

[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 
(LibreOffice Calc tab of the print dialog).

IMO neither Repeated (column header) Rows nor empty strings should, by default, 
force the printing of an otherwise blank page.

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

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

Mosr of the responses in this thread have missed the point. The problem is with 
the "Number of copies" and "Collate" options on the right side of the General 
tab of the print dialog. If you try to print two (2) COPIES only one (1) copy 
prints. The problem is linked to the collate option setting.

My settings on the General tab of the print dialog:

Range and copies
   Selected sheets
From which print
   Pages 1-3
Number of copies
   2
Collate
   Ticked

Solution:
Tick "Create single print jobs for collated output" on the Options tab of the 
print dialog.

-- 
Jim

-Original Message-
From: Tom Davies 
To: Rafnews 
Cc: "users@global.libreoffice.org" 
Sent: Sun, 12 Apr 2015 11:49
Subject: Re: [libreoffice-users] Re: Calc and number of copies does not work

Hi :)
Can you try printing just 1 page and only do 3 copies of it?  ie a really
small test-run to see if anything obvious emerges as to why it's only
giving you 1 page.

Is the printer's memory getting overloaded or something?  Do you have to
enter a code (ie some sort of office set-up or multi-user printer) to get a
print-out and do you have to do that per copy or per session or some other
weird thing like that?

One of my printers needs me to press a green tick twice otherwise it tries
to use a wrong tray (that doesn't even have paper in it).   Apparently it's
fairly normal for that printer model and now i know the trick it's kinda
tolerable.

It is very weird that it's only printing 1 copy but hopefully one of us
might shake something loose about what is causing it.
Regards from
Tom :)




On 12 April 2015 at 18:37, Andreas Säger  wrote:

> Am 12.04.2015 um 14:33 schrieb Andreas Säger:
> > The print dialog has an option "Print current sheet only" which may be
> > checked.
> > Otherwise, the printable sheet may have a print range defined. Once you
> > define print ranges to exclude other ranges from printing, you've got to
> > define print ranges for every sheet you want to be printed.
> > See menu:Format>Print Ranges>Define...
> > menu:Format>Print Ranges>Set sets the currently selected cells.
> > menu:Format>Print Ranges>Remove removes all print ranges from this sheet.
> >
> >
>
> Now I see the screen shot. You print all pages of the selected sheets.
> Either you select more sheets or you check the option to print all pages
> of all sheets.
> If that does not work, remove any defined print areas from all sheets.
>
>
>
> --
> 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/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[James E Lang]

Thank you, Mark. I also don't have a MAC so on that score I was speaking 
theoretically. 

-- 
Jim

-Original Message-
From: libreoffice-ml.mbou...@spamgourmet.com
To: users@global.libreoffice.org
Sent: Fri, 10 Apr 2015 12:56
Subject: Re: [libreoffice-users] Calc: How to concat CTRL+ENTER 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 systems. 
Although I believe Mac OSX uses LF, same as Unix, while Mac OS up to 
version 9 used CR.

Even in the case of plain text, now that files are so readily 
transferred between systems, most decent text editors cope fine with all 
3 formats regardless of which system they're running on.

> Do I over complicate the process?

For LibreOffice documents, I think you do. What do you do in a document 
which might be transferred between different systems?

Does CHAR(13) in a LibreOffice formula on Mac even have the intended 
effect of splitting lines? Come to that, does LibreOffice even run on 
Mac OS 9 or before? I suspect LibreOffice only uses CHAR(10) regardless 
of OS, although I don't have a Mac (let along one before OSX) to try.

On Windows LibreOffice, all that's needed is CHAR(10). CHAR(13) has no 
apparent effect, other than cluttering the formula.

Mark.


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 
driving distance between two such street addresses? I suspect that I will need 
a user defined 
function such as DRDIST(from, to) to accomplish this but I don't know how to go 
about 
writing such a function. 

With A1 containing the address 2345 Weldon and another address being hard coded 
as 
4453 N Ashcroft I envision invoking this function as

  =DRDIST(A1&", Fresno, CA", "4453 N Ashcroft, Fresno, CA") 

and the result, in miles, would be something like 5.2. (Both of these addresses 
where I lived 
as a child no longer exist but I use them as examples of how the function would 
be invoked.)

It would be great if someone already has a function to accomplish this task and 
if it can be 
shared with me. If that is not the case, then I will probably need a lot of 
assistance to create 
such a function which can then be shared with the LO Calc community.

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Another spreadsheet destroyed.

[James E Lang]

Pardon my ignorance. What do you mean when you speak of dialogues in LO Calc? 

-- 
Jim

-Original Message-
From: Johnny Rosenberg 
To: "LibreOffice Användare" 
Sent: Wed, 22 Oct 2014 12:01
Subject: [libreoffice-users] Another spreadsheet destroyed.

A couple of years ago LibreOffice Calc destroyed one of my most important
spreadsheets. Fortunately Apache OpenOffice was able to fix it for me, and
since then I use Apache OpenOffice for all my important work.

Since a few days back though, I started to use LibreOffice Calc (4.2.6.3)
again, also for my important files. I shouldn't have done that, because the
same thing happened again. Fortunately, the spreadsheet could be fixed
again, this time thanks to some backups, but files are supposed to be used
and worked with, not fixed…

The file itself is maybe not that important, but I have been working on it
for almost a decade, so I would probably be somewhat sad if I lost it.
Happy – good, sad – bad… :P

Anyway, it seems that LibreOffice Calc mess up my dialogues. I had three
dialogues and today all the names of all their buttons were replaced with
some default crap. Anyone else experienced this? If so, maybe I (or someone
else) should file a bug report. Fortunately I export all my dialogues and
basic code, so I could easily import them again with Apache OpenOffice. I
tried first with LibreOffice, but when I imported the second dialogue it
crashed.

Ubuntu 14.04
LibreOffice 4.2.6.3.



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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?

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

1) Select the font for a question.

2) Enter a question number, an upper case Q followed by a colon, the question, 
and a pair of Returns.

3) Select the font for an answer.

4) Enter an upper case A followed by a colon, a space, and a pair of returns.

5) Repeat steps 1-4 for each additional question.

Example:

[Q Font]1. Q: What do you like best about working here?

[A Font]A: 

[Q Font]2. Q: Why did you take a job here?

[A Font]A: 

[Q Font]3. Q: …

I hope this is of some help. As others have stated, the fonts can probably be 
selected from predefined styles to simplify the process somewhat. The point is 
to preset the font for the answers so as to minimize the chance the other 
people will mess up the desired formatting. (See the statement in my signature 
block)

Disclaimer: I am certainly not a power user of Writer. I mostly use Calc.

-- 
Jim

You can never make anything so fool proof that a determined fool can't and 
won't find a way around your precautions!

-Original Message-
From: quickbooks office 
To: users@global.libreoffice.org
Sent: Sat, 07 Jun 2014 6:56
Subject: [libreoffice-users] How to ensure all new text entered into a document 
is different font,  without changing the old font settings of the document?

How to ensure all new text entered into a document is different font,
without changing the old font settings of the document?

That is the document has questions in it, with lets say Times New Roman.

When I type the answers in, the font remains Times New Roman.

But I want it so that all new text entered to be Segoe Print without
changing the font of the text already existing in the document (i.e.
the questions)

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Test

[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/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Print Orientation (Calc)

[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 to print orientation?

-- 
Jim-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

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

[James E Lang]

Does the silly form get submitted electronically or on paper?

-- 
Jim

-Original Message-
From: william drescher 
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 11:49 AM, william drescher wrote:
> Medicare, in its infinite wisdom (NOT) released a new (and
> required) Health Insurance Claim Form.
>
> I have a table that I use as a template to fill in the forms
> (using openTBS it fills in automagically).
>
> The problem is that when they revised the section for diagnoses,
> they put the lines to close to together (vertically) that when I
> make the rows fit, the (required) 12 pitch numbers are clipped on
> the bottom.  If I make the row height big enough (.021") to not
> clip, the rows do not line up.
>
> Back in the days of WordPerfect, I would use "advance to" and
> then could slightly overlap the fields.
>
> Anyone have any suggestions of how to approach this?
>
> (form requires 12 pitch (pica) letters)
>
> bill
>
>
Reposting as I am still stuck


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted