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 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: 

[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

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] 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 <pie...@pietvanoostrum.com>
To: "James E. Lang" <jim+...@lang.hm>
Cc: users@global.libreoffice.org
Sent: Fri, 05 Feb 2016 2:39
Subject: Re: [libreoffice-users] 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 <p...@vanoostrum.org>
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 

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

This same behavior exists in 4.4.6.3 (Windows)

Also in both cases my Conditional formatting gets turned off when I turn off 
AutoCalculate. Unexpected behavior.

-- 
Jim

-Original Message-
From: "James E. Lang" <jim+...@lang.hm>
To: LibreOffice Users <users@global.libreoffice.org>
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

Re: [libreoffice-users] Calc 5.0.3.2 AutoCalculate

[James E. Lang]

-Original Message-
From: jorge <jrodrigue...@cpcecr.com>
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" <jim+...@lang.hm>
> To: LibreOffice Users <users@global.libreoffice.org>
> 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

[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

[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] 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" <jim+...@lang.hm>
To: LibreOffice Users <users@global.libreoffice.org>
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

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: 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

[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

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

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]

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 <je...@lang.hm>
To: users@global.libreoffice.org, libreoffice-ml.mbou...@spamgourmet.com
Sent: Sun, 18 Oct 2015 13:11
Subject: Re: [libreoffice-users] Shortcut changes

Thank you Mark,

-Original Message-
From: libreoffice-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] 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 

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

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 

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

[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] 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] 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] 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: 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] 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 <jim+...@lang.hm>
To: Alexander Thurgood <alex.thurg...@gmail.com>, Tom Davies <tomc...@gmail.com>
Cc: "users@global.libreoffice.org" <users@global.libreoffice.org>
Sent: Mon, 14 Sep 2015 8:02
Subject: Re: [libreoffice-users] Re: Android version

Tom,

For what it's worth, KingSoft is a company in China.

-- 
Jim

-Original Message-
From: Tom Davies <tomc...@gmail.com>
To: Alexander Thurgood <alex.thurg...@gmail.com>
Cc: "users@global.libreoffice.org" <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 <alex.thurg...@gmail.com>
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: 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 m...@scottsonline.org.uk
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 wachin...@gmail.com
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 raf.n...@gmail.com
To: users@global.libreoffice.org
Sent: Mon, 03 Aug 2015 3:23
Subject: [libreoffice-users] [CALC] printing several copies of the same sheet

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

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 aje...@errichel.co.uk
To: users@global.libreoffice.org 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

[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] 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 martin.lewi...@gmail.com
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] 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 lagin...@gmail.com
To: users@global.libreoffice.org
Sent: Mon, 13 Jul 2015 9:10
Subject: Re: [libreoffice-users] Upload a picture to http://ask.libreoffice.org

   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] {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 lagin...@gmail.com
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 charles.sch...@documentfoundation.org
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 flo...@documentfoundation.org


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] 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 KR 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 daa.li...@gmail.com
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 m...@netfence.it
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]

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 ville...@t-online.de
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] 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 ville...@t-online.de
To: users@global.libreoffice.org
Sent: Sun, 31 May 2015 13:54
Subject: [libreoffice-users] Re: open files automatically (a Star Basic macro)

Am 31.05.2015 um 22:43 schrieb James E Lang:
 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] 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 toki.kant...@gmail.com
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 ville...@t-online.de
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=75t=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

[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 jim+...@lang.hm
To: users@global.libreoffice.org, pete nikolic pg.nikol...@gmail.com
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 reachmepl...@gmail.com
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 pg.nikol...@gmail.com
To: James E Lang jim+...@lang.hm
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 jim+...@lang.hm 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 pg.nikol...@gmail.com
To: James E Lang jim+...@lang.hm, 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 jim+...@lang.hm 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 pg.nikol...@gmail.com
To: James E Lang jim+...@lang.hm
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 jim+...@lang.hm 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 pg.nikol...@gmail.com
To: James E Lang jim+...@lang.hm
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 jim+...@lang.hm 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] 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 cleyf...@gmail.com
To: RamonTavarez ramontava...@gmail.com
Cc: users@global.libreoffice.org 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 ramontava...@gmail.com:

 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] ml-node+s969070n4147063...@n3.nabble.com 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]
  http:///user/SendEmail.jtp?type=nodenode=4147063i=0:
 
   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]
  http:///user/SendEmail.jtp?type=nodenode=4147063i=1 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]
  http:///user/SendEmail.jtp?type=nodenode=4147063i=2 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't
work at all in extreme cases.  Chances are that some things will
 have
   moved
around or vanished, especially if you have anything in a frame (such
  as
images).
   
It makes a bit of sense that a file created with newer 

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 p...@vanoostrum.org
To: pete nikolic pg.nikol...@gmail.com
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 p...@vanoostrum.org
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] 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 luu...@gmail.com
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] [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 ady...@hotmail.com
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 the same way) and it can easily 
generate loss of data 

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 ady...@hotmail.com
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 appreciate 
receiving 

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: 林承益 chengyi@keywie.com
To: users users@global.libreoffice.org
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: 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 oo...@nouenoff.nl
To: jorge jrodrigue...@cpcecr.com
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 and...@pitonyak.org
To: James E. Lang je...@lang.hm
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 b.m.bar...@btinternet.com
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] [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 b.m.bar...@btinternet.com
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]

[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 b.m.bar...@btinternet.com
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

Re: [libreoffice-users] Basic Calc Question

[James E Lang]

-Original Message-
From: Barry Premeaux bpreme...@gmail.com
To: users@global.libreoffice.org
Sent: Mon, 13 Apr 2015 16:17
Subject: [libreoffice-users] Basic Calc Question

I'm a novice at spreadsheets, and google hasn't turned up an answer.
Probably because I haven't worded the question 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

[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 bpreme...@gmail.com
To: users@global.libreoffice.org
Sent: Mon, 13 Apr 2015 16:17
Subject: [libreoffice-users] Basic Calc Question

I'm a novice at spreadsheets, and google hasn't turned up an answer.
Probably because I haven't worded the question 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 bpreme...@gmail.com
To: users@global.libreoffice.org
Sent: Mon, 13 Apr 2015 16:17
Subject: [libreoffice-users] Basic Calc Question

I'm a novice at spreadsheets, and google hasn't turned up an answer.
Probably because I haven't worded the question 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

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 tomc...@gmail.com
To: Rafnews raf.n...@gmail.com
Cc: users@global.libreoffice.org 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 ville...@t-online.de 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:FormatPrint RangesDefine...
  menu:FormatPrint RangesSet sets the currently selected cells.
  menu:FormatPrint RangesRemove 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

[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] 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 gurus.knu...@gmail.com
To: LibreOffice Användare users@global.libreoffice.org
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 quickbooks.off...@gmail.com
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 will...@techservsys.com
To: users@global.libreoffice.org
Sent: Wed, 30 Apr 2014 4:23
Subject: [libreoffice-users] Re: table: clipping of numbers: still helpless

On 4/27/2014 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

Re: [libreoffice-users] Upgrade Problem on Windows

[James E Lang]

'msciexec' is not recognized …

-- 
Jim

-Original Message-
From: Regina Henschel rb.hensc...@t-online.de
To: users@global.libreoffice.org
Sent: Mon, 28 Apr 2014 13:14
Subject: Re: [libreoffice-users] Upgrade Problem on Windows

Hi James,

James E Lang schrieb:
 Hi Florian.

 -Original Message- From: Florian Reisinger
 flo...@libreoffice.org To: LO Users users@global.libreoffice.org,
 James E Lang jim+...@lang.hm, Regina Henschel
 rb.hensc...@t-online.de Sent: Mon, 28 Apr 2014 8:23 Subject: Re:
 [libreoffice-users] Upgrade Problem on Windows

 Hi,

 What I can imagine is the following: Some C++ redistributables.
 Please try a parallel installation (start the installer with the
 option /a).

 [ I was double clicking D:\Downloads\LibreOffice_4.1.5_Win_x86.msi

 How do I add option /a? ]

Click on Start. There click on Run. You get an input line with label 
'Open'. Enter the text

cmd

Now you get a command line window. Enter the following texts and finish 
each line with enter.

D:

cd Downloads

msciexec /a LibreOffice_4.1.5_Win_x86.msi

The reaction has a little bit delay. But then the installation wizard of 
LibreOffice should start.


 This is not a installation, bit an extraction. If you have questions,
 please ask :)

 [ Installation | extraction ? Are you saying that what I'm doing
 should be called an extraction or that option /a makes it an
 extraction? I think somebody stated that if extracted rather than
 installed, the new version would NOT be invoked by double clicking a
 document (e.g. pizzalog.ods).

It will tell you that the files are to be _extracted_ to a net work 
drive. There you get the option to choose the destination, in your case 
drive D. It is correct, that this does not add any registry entries to 
provide call by doubleclick. But you can change that later. First you 
need to get this extraction and then we will help you with the next steps.

Kind regards
Regina

-- 
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] Upgrade Problem on Windows

[James E Lang]

Okay. I guess that should have been msiexec. It yields the same problem. It 
requires 422MB on C:

-- 
Jim

-Original Message-
From: James E Lang jim+...@lang.hm
To: users@global.libreoffice.org
Cc: users@global.libreoffice.org
Sent: Tue, 29 Apr 2014 1:27
Subject: Re: [libreoffice-users] Upgrade Problem on Windows

'msciexec' is not recognized …

-- 
Jim

-Original Message-
From: Regina Henschel rb.hensc...@t-online.de
To: users@global.libreoffice.org
Sent: Mon, 28 Apr 2014 13:14
Subject: Re: [libreoffice-users] Upgrade Problem on Windows

Hi James,

James E Lang schrieb:
 Hi Florian.

 -Original Message- From: Florian Reisinger
 flo...@libreoffice.org To: LO Users users@global.libreoffice.org,
 James E Lang jim+...@lang.hm, Regina Henschel
 rb.hensc...@t-online.de Sent: Mon, 28 Apr 2014 8:23 Subject: Re:
 [libreoffice-users] Upgrade Problem on Windows

 Hi,

 What I can imagine is the following: Some C++ redistributables.
 Please try a parallel installation (start the installer with the
 option /a).

 [ I was double clicking D:\Downloads\LibreOffice_4.1.5_Win_x86.msi

 How do I add option /a? ]

Click on Start. There click on Run. You get an input line with label 
'Open'. Enter the text

cmd

Now you get a command line window. Enter the following texts and finish 
each line with enter.

D:

cd Downloads

msciexec /a LibreOffice_4.1.5_Win_x86.msi

The reaction has a little bit delay. But then the installation wizard of 
LibreOffice should start.


 This is not a installation, bit an extraction. If you have questions,
 please ask :)

 [ Installation | extraction ? Are you saying that what I'm doing
 should be called an extraction or that option /a makes it an
 extraction? I think somebody stated that if extracted rather than
 installed, the new version would NOT be invoked by double clicking a
 document (e.g. pizzalog.ods).

It will tell you that the files are to be _extracted_ to a net work 
drive. There you get the option to choose the destination, in your case 
drive D. It is correct, that this does not add any registry entries to 
provide call by doubleclick. But you can change that later. First you 
need to get this extraction and then we will help you with the next steps.

Kind regards
Regina

-- 
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] Upgrade Problem on Windows

[James E Lang]

Okay. I guess that should have been msiexec. It yields the same problem. It 
requires 422MB on C:

-- 
Jim
Non-standard behavior alert:
Unless specifically overridden,
•   Reply to this email sends to the LibreOffice Users list.
•   Reply-all to this email sends to me and all recipients of this email.

-Original Message-
From: Florian Reisinger flo...@libreoffice.org
To: LO Users users@global.libreoffice.org, James E Lang jim+...@lang.hm
Sent: Tue, 29 Apr 2014 1:32
Subject: Re: [libreoffice-users] Upgrade Problem on Windows

Hi
Msiexec“ 
Sorry for the typo
-- 
Liebe Grüße, / Yours,
Florian Reisinger

On 29. April 2014 10:27:14 MESZ, James E Lang jim+...@lang.hm wrote:
'msciexec' is not recognized …

-- 
Jim

-Original Message-
From: Regina Henschel rb.hensc...@t-online.de
To: users@global.libreoffice.org
Sent: Mon, 28 Apr 2014 13:14
Subject: Re: [libreoffice-users] Upgrade Problem on Windows

Hi James,

James E Lang schrieb:
 Hi Florian.

 -Original Message- From: Florian Reisinger
 flo...@libreoffice.org To: LO Users users@global.libreoffice.org,
 James E Lang jim+...@lang.hm, Regina Henschel
 rb.hensc...@t-online.de Sent: Mon, 28 Apr 2014 8:23 Subject: Re:
 [libreoffice-users] Upgrade Problem on Windows

 Hi,

 What I can imagine is the following: Some C++ redistributables.
 Please try a parallel installation (start the installer with the
 option /a).

 [ I was double clicking D:\Downloads\LibreOffice_4.1.5_Win_x86.msi

 How do I add option /a? ]

Click on Start. There click on Run. You get an input line with label 
'Open'. Enter the text

cmd

Now you get a command line window. Enter the following texts and finish

each line with enter.

D:

cd Downloads

msciexec /a LibreOffice_4.1.5_Win_x86.msi

The reaction has a little bit delay. But then the installation wizard
of 
LibreOffice should start.


 This is not a installation, bit an extraction. If you have questions,
 please ask :)

 [ Installation | extraction ? Are you saying that what I'm doing
 should be called an extraction or that option /a makes it an
 extraction? I think somebody stated that if extracted rather than
 installed, the new version would NOT be invoked by double clicking a
 document (e.g. pizzalog.ods).

It will tell you that the files are to be _extracted_ to a net work 
drive. There you get the option to choose the destination, in your case

drive D. It is correct, that this does not add any registry entries to 
provide call by doubleclick. But you can change that later. First you

need to get this extraction and then we will help you with the next
steps.

Kind regards
Regina

-- 
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] Upgrade Problem on Windows

[James E Lang]

Yes


-- 
Jim

-Original Message-
From: James E Lang je...@lang.hm
To: users@global.libreoffice.org, Florian Reisinger flo...@libreoffice.org
Cc: users@global.libreoffice.org
Sent: Tue, 29 Apr 2014 1:45
Subject: Re: [libreoffice-users] Upgrade Problem on Windows

Yes


-- 
Jim

-Original Message-
From: Florian Reisinger flo...@libreoffice.org
To: James E Lang je...@lang.hm, users@global.libreoffice.org
Cc: users@global.libreoffice.org
Sent: Tue, 29 Apr 2014 1:44
Subject: Re: [libreoffice-users] Upgrade Problem on Windows

Hi,
Also with additional parameter /a?
-- 
Liebe Grüße, / Yours,
Florian Reisinger

On 29. April 2014 10:40:47 MESZ, James E Lang je...@lang.hm wrote:
Okay. I guess that should have been msiexec. It yields the same
problem. It requires 422MB on C:

-- 
Jim

-Original Message-
From: James E Lang jim+...@lang.hm
To: users@global.libreoffice.org
Cc: users@global.libreoffice.org
Sent: Tue, 29 Apr 2014 1:27
Subject: Re: [libreoffice-users] Upgrade Problem on Windows

'msciexec' is not recognized …

-- 
Jim

-Original Message-
From: Regina Henschel rb.hensc...@t-online.de
To: users@global.libreoffice.org
Sent: Mon, 28 Apr 2014 13:14
Subject: Re: [libreoffice-users] Upgrade Problem on Windows

Hi James,

James E Lang schrieb:
 Hi Florian.

 -Original Message- From: Florian Reisinger
 flo...@libreoffice.org To: LO Users users@global.libreoffice.org,
 James E Lang jim+...@lang.hm, Regina Henschel
 rb.hensc...@t-online.de Sent: Mon, 28 Apr 2014 8:23 Subject: Re:
 [libreoffice-users] Upgrade Problem on Windows

 Hi,

 What I can imagine is the following: Some C++ redistributables.
 Please try a parallel installation (start the installer with the
 option /a).

 [ I was double clicking D:\Downloads\LibreOffice_4.1.5_Win_x86.msi

 How do I add option /a? ]

Click on Start. There click on Run. You get an input line with label 
'Open'. Enter the text

cmd

Now you get a command line window. Enter the following texts and finish

each line with enter.

D:

cd Downloads

msciexec /a LibreOffice_4.1.5_Win_x86.msi

The reaction has a little bit delay. But then the installation wizard
of 
LibreOffice should start.


 This is not a installation, bit an extraction. If you have questions,
 please ask :)

 [ Installation | extraction ? Are you saying that what I'm doing
 should be called an extraction or that option /a makes it an
 extraction? I think somebody stated that if extracted rather than
 installed, the new version would NOT be invoked by double clicking a
 document (e.g. pizzalog.ods).

It will tell you that the files are to be _extracted_ to a net work 
drive. There you get the option to choose the destination, in your case

drive D. It is correct, that this does not add any registry entries to 
provide call by doubleclick. But you can change that later. First you

need to get this extraction and then we will help you with the next
steps.

Kind regards
Regina

-- 
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] Upgrade Problem on Windows

[James E Lang]

Yes


-- 
Jim

-Original Message-
From: Florian Reisinger flo...@libreoffice.org
To: James E Lang je...@lang.hm, users@global.libreoffice.org
Cc: users@global.libreoffice.org
Sent: Tue, 29 Apr 2014 1:44
Subject: Re: [libreoffice-users] Upgrade Problem on Windows

Hi,
Also with additional parameter /a?
-- 
Liebe Grüße, / Yours,
Florian Reisinger

On 29. April 2014 10:40:47 MESZ, James E Lang je...@lang.hm wrote:
Okay. I guess that should have been msiexec. It yields the same
problem. It requires 422MB on C:

-- 
Jim

-Original Message-
From: James E Lang jim+...@lang.hm
To: users@global.libreoffice.org
Cc: users@global.libreoffice.org
Sent: Tue, 29 Apr 2014 1:27
Subject: Re: [libreoffice-users] Upgrade Problem on Windows

'msciexec' is not recognized …

-- 
Jim

-Original Message-
From: Regina Henschel rb.hensc...@t-online.de
To: users@global.libreoffice.org
Sent: Mon, 28 Apr 2014 13:14
Subject: Re: [libreoffice-users] Upgrade Problem on Windows

Hi James,

James E Lang schrieb:
 Hi Florian.

 -Original Message- From: Florian Reisinger
 flo...@libreoffice.org To: LO Users users@global.libreoffice.org,
 James E Lang jim+...@lang.hm, Regina Henschel
 rb.hensc...@t-online.de Sent: Mon, 28 Apr 2014 8:23 Subject: Re:
 [libreoffice-users] Upgrade Problem on Windows

 Hi,

 What I can imagine is the following: Some C++ redistributables.
 Please try a parallel installation (start the installer with the
 option /a).

 [ I was double clicking D:\Downloads\LibreOffice_4.1.5_Win_x86.msi

 How do I add option /a? ]

Click on Start. There click on Run. You get an input line with label 
'Open'. Enter the text

cmd

Now you get a command line window. Enter the following texts and finish

each line with enter.

D:

cd Downloads

msciexec /a LibreOffice_4.1.5_Win_x86.msi

The reaction has a little bit delay. But then the installation wizard
of 
LibreOffice should start.


 This is not a installation, bit an extraction. If you have questions,
 please ask :)

 [ Installation | extraction ? Are you saying that what I'm doing
 should be called an extraction or that option /a makes it an
 extraction? I think somebody stated that if extracted rather than
 installed, the new version would NOT be invoked by double clicking a
 document (e.g. pizzalog.ods).

It will tell you that the files are to be _extracted_ to a net work 
drive. There you get the option to choose the destination, in your case

drive D. It is correct, that this does not add any registry entries to 
provide call by doubleclick. But you can change that later. First you

need to get this extraction and then we will help you with the next
steps.

Kind regards
Regina

-- 
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: Upgrade Problem on Windows

[James E Lang]

Thank you Urmas. I'll try the TEMP environmental variable. 

I don't understand this remark of yours: You can relocate the Windows 
Installer folder (by creating a directory junction)

Someone suggested relocaring Virtual Memory from C:. That indeed serves as a 
work around. I now have about 2.5GB available on C:.

I'm still interested in this issue even though there is no longer a _critical_ 
problem.

-- 
Jim

-Original Message-
From: Urmas davian...@gmail.com
To: users@global.libreoffice.org
Sent: Tue, 29 Apr 2014 17:52
Subject: [libreoffice-users] Re: Upgrade Problem on Windows

James E Lang:

After I specified that LO be installed on volume D: the installer still 
requires 427MB on C:
Is there any way to avoid using C:?

You can relocate the Windows Installer folder (by creating a directory 
junction) and the temporary folder (by setting TEMP environental variable).

There are several tutorials available in the Internet.



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