Re: [libreoffice-users] LibreOffice Damaged

[Stephan Bergmann]

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

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

[libreoffice-users] Re: Conditional Formatting On Date [SOLVED]

[Andreas Säger]

Am 14.09.2015 um 09:13 schrieb Dave Barton:
>  Original Message  
> From: Brian Barker
> Date: Mon, 14 Sep 2015 06:15:32 +0100
> 
>> At 22:10 13/09/2015 +0200, Dave Barton wrote:
>>> In Calc I have column with a series of calculated dates (ie. the
>>> result of a formula). I am looking to find a way of using conditional
>>> formatting to set the background colour (eg. green) for those dates
>>> which fall on a Saturday or Sunday (eg. Condition: = WEEKDAY (A2; 2)>5
>>> sets Format: Cell Background = Green)
>>>
>>> Can anyone offer any pointers to a solution?
>>
>> I think you have (almost?) answered your own question.
>>
>> o Select *one* cell of your range - e.g. your A2.
>> o Go to Format | Conditional Formatting... .
>> o With "Condition 1" ticked, select "Formula is".
>> o In the Cell Value Condition box, enter: WEEKDAY(A2;2)>5
>> o For Cell Style, select Green. You need either already to have defined
>> a "Green" cell style or else to create one on the fly using the New
>> Style... button.
>> o Now copy that formatting to other cells in your range. You can do this
>> either by using the Format Paintbrush or by copying A2 and pasting it
>> over the range, but using Paste Special... and selecting *just* Formats
>> in the Paste Special dialogue.
>>
>> Alternatively there is a quite different technique using the STYLE()
>> function. Modify your original formulae to read:
>> =+STYLE(IF(WEEKDAY(CURRENT();2)>5;"Green"))
>>
>> I trust this helps.
>>
>> Brian Barker
> 
> Yes, Thank you Brian. I knew where I wanted to go, but took a wrong turn
> and got lost. I now have no idea why I missed the obvious.
> Also, thanks for reminding me about the "+STYLE(IF" alternative.
> Guess I was having a brain deadlock day. :(
> 
> Regards
> Dave
> 
> 
> 


It works also with a range selection or even with multiple selected
ranges as long as you are aware that the dialog shows the conditional
format of _one_ cell which is the currently active cell within the
current range selection. All relative references are relative to this
single cell and adjust to the other cells when you finish the dialog.

The relative references in a c.f. behave exactly like in a cell formula
which is entered into a range of cells using Alt+Enter.
Test: Select a column of cells, say X1:X5, type =Y1 and hit Alt+Enter.
The c.f. dialog behaves in the same way in respect to the active input
cell and the other selected cells.


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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

[Stephan Bergmann]

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.  If you are lucky, it was just this one file that got 
corrupted (for whatever reason).


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Android version

[Tom Davies]

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

Re: [libreoffice-users] LibreOffice Damaged

[Tom Davies]

Hi :)
Stephan Bergman's answer is a more precise and elegant version of the
re-name/reset the entire User Profile answers.  The Uno Cache is a
sub-sub-folder within the User Profile.

So, if you have already tried renaming/resetting the User Profile then you
have already done this.  If you haven't already tried renaming the entire
User Profile then Stephan's answer is a far more elegant answer and
therefore worth trying first.

Regards from
Tom :)


On 14 September 2015 at 12:38, Stephan Bergmann  wrote:

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

[Gordon Burgess-Parker]

On 14/09/15 13:41, Tom Davies wrote:

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


Hi Tom,
I've not had a good experience with AndrOffice - however the LO Viewer 
(from the Document Foundation) seems to work very well. There's also a 
developers option to enable simple editing, although I've not yet used it.
The LO Viewer downloads to the device, so you don't need to be online 
whereas AFAIK all the others need internet access...


YMMV.

Cheers
Gordon

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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-documentation] Re: [libreoffice-users] Need help To convert Excel Sheet to Libre sheet

[Tom Davies]

Hi :)
As you probably know the Indian Government is making a strong push to free
themselves from the vendor lock-ins created by using non-OpenSource
products.

So, it is possible there may even be funding to help with this sort of
thing or there may well be some organisation, or conglomeration of
organisations to help with this sort of work.

Almost certainly you may well be able to find someone local who can do the
re-programming either as a one-off for just this Excel-Calc migration or as
a part-time employee/consultant to help with similar jobs in the future or
to help as 2nd/3rd tier in-house IT Support for any issues that may "crop
up" in the whole migration away from all the Microsoft and other
proprietary products.

One of the advantages of OpenSource is that you don't have to wait until
some profit-making organisation decides on the value to them of the help
you need.  With an OpenSource program you can pay someone to do it for you,
on your priorities, or even have a go yourself.  If your code is of good
enough quality then it might well be added to the main program.  Many
organisations find that paying for a dev to work on their own issues is
still cheaper than paying licensing fees as well as giving them more
control.  Quite a lot of the development of LibreOffice is due to many
organisations co-operating with each other in this way through The Document
Foundation.

Regards from
Tom :)


On 11 September 2015 at 06:16, David Johnson 
wrote:

> Dear Joel,
> It is a paid processional, we need to recreate the same excel in Libre
> office, we need this at the earliest.
> --
> Thanks ,
> *|David Johnson|***|***H**O* - Technology & Process*|**|**Janalakshmi
> Financial Services Limited**|***|**No.34/1 Andree Road, Shantinagar,
> Bangalore - 560027*|***|***www.janalakshmi.com**|*
> *|**Phone :* +91 080-42595100/700*|**|**Ext*-242*|**|**Mobile*: +91
> 95-38-455118*||**E-Mail *: david.john...@janalakshmi.com*|*
> On 11-09-2015 10:40, Joel Madero wrote:
>
>> You mean a paid professional? I could ask one or two people - if you're
>> instead asking for a volunteer to assist, best bet is to just asked around
>> on the email thread and maybe the OOo forum (there are a few great macro
>> people over there).
>>
>> Best,
>> Joel
>>
>> On 09/10/2015 09:39 PM, David Johnson wrote:
>>
>>> Dear Joel & Tim,
>>> Thanks for your valuable inputs, appreciate it. Is there any
>>> professional, whom you know, could help me to redevelop the same in Libre
>>> Calc.
>>> --
>>> Thanks ,
>>> *|David Johnson|***|***H**O* - Technology & Process*|**|**Janalakshmi
>>> Financial Services Limited**|***|**No.34/1 Andree Road, Shantinagar,
>>> Bangalore - 560027*|***|***www.janalakshmi.com**|*
>>> *|**Phone :* +91 080-42595100/700*|**|**Ext*-242*|**|**Mobile*: +91
>>> 95-38-455118*||**E-Mail *: david.john...@janalakshmi.com*|*
>>> On 11-09-2015 04:20, Joel Madero wrote:
>>>
 That is a true statement - LibreOffice does not support the proprietary
 Microsoft VBA (it may in a very very limited way but not enough for most
 test cases that I've seen) - you'll have to rewrite it in Basic.

 Best,
 Joel

 On Thu, Sep 10, 2015 at 2:04 PM, Tim Lloyd >> tim.ll...@gmx.com>> wrote:

 Hi David,

 my understanding is that macros in excel and calc are written in
 different languages so need to be rewritten.

 Maybe one of the more learned members of the forum can confirm
 or otherwise.

 Cheers


 On 10/09/15 19:48, David Johnson wrote:


 Dear Gabriele and Tim,
 PFA; This is the Excel Macro sheet we are trying to convert.
 Could you please help me.

 -- Thanks ,
 *|David Johnson|***|***H**O* - Technology &
 Process*|**|**Janalakshmi Financial Services
 Limited**|***|**No.34/1 Andree Road, Shantinagar, Bangalore
 - 560027*|***|***www.janalakshmi.com
 **|*
 *|**Phone :* +91 080-42595100
 /700*|**|**Ext*-242*|**|**Mobile*:
 +91 95-38-455118 *||**E-Mail *:
 david.john...@janalakshmi.com
 *|*
 On 10-09-2015 12:17, Tim Lloyd wrote:

 Hi David,

 as noted below. It could just work! Which version were
 you think of using? I think there is some consensus that
 5.0 may be a little too "fresh" for an enterprise
 environment. So the still version of 4.4.5 may be a good
 base. Download this version and give it a go:

 http://www.libreoffice.org/download/libreoffice-still/

 There may also be some value having a hunt around the
 

[libreoffice-users] Re: Android version

[Pedro]

Hi Tom


TomD wrote
> 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?

AndrOffice is a port of OpenOffice but the interface was not redesigned so
it's unusable in a mobile phone (maybe on a 10" tablet it could work)

LibreOffice Viewer is...  a viewer (and absurdly slow). I realize that at
some point it will have editing functions but at the moment it is a huge
download just to view files. The main advantage is that is supports ODF

I use WPS Office (formerly Kingston Office) but it is not Open Source. It is
a reverse-code software from an unknown company, so use at your own risk...
The usability is quite good even on a mobile phone. IMO it is currently the
best option. It doesn't support ODF, only MS formats (old binary and XHTML)

All of these are installed on the phone and work with files on the phone (no
need to connect to the "cloud")

Finally there is Microsoft Office... The interface is not bad (but inferior
to WPS) and it works with local files but requires an account to synchronize
at some point to the "cloud". I was not very impressed. I can't remember if
it worked with ODF...

Hope this helps (and looking forward to read other opinions :) )
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/Android-version-tp4160256p4160263.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

Re: [libreoffice-users] AutoText crashes

[Dan Lewis]

On 09/12/2015 02:32 PM, Sylvain Bromberger wrote:

AutoText used to work well, but now when I click on it in Edit (writer) it
crashes LibreOffice writer. I am currently located where I cannot download
5. Is there any remedy? Thanks in advance for any help.

Sylvain

   Are you perhaps using a computer made by Apple? I have a MacBook 
that I use. This means that instead of Control+F3 key combination, I 
have to use Control+F3+Fn. With some testing, this three key combination 
does not crash Writer, but it minimizes it. I found that I could use 
AutoText by using Edit > AutoText instead of the shortcut keys.


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

[Tom Davies]

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

[libreoffice-users] Re: Android version

[Alexander Thurgood]

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

Re: [libreoffice-users] Android version

[jorge]

Hi Tom and all:

I've used AndrOffice in my tablet. It has improved step by step. Now I
think it is, in general, stable for general perfomance that I've used
it. It has digital mouse and other special things. 

Another program that I've used is WPS (Kingsoft Office) but I think it
isn't free software like LibreOffice but it is free an usually is
stable.

My experience with my tablet (10 inch) is that the screen is to small
to work seriusly (For example to the job) or using digital keybord. To
modify something fast is ok and so usefull and help a lot, or to review
a file already finished.

I hope this words help you and your friend,

Regards,

Jorge Rodríguez


El lun, 14-09-2015 a las 13:41 +0100, Tom Davies escribió:
> 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 :)
> 

-- 
Atentamente,

Jorge Rodríguez


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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

[Oogie McGuire]

Why not take one of the free or inexpensive purpose built exchange rate apps 
for Android? Some of them will download updated exchange rate data when 
connections are available and all the ones I looked at briefly allow you to run 
the conversions offline. 

I think that would be a much better option than trying to force that into a 
spreadsheet type app.

> On Sep 14, 2015, at 8:45 AM, Tom Davies  wrote:
> 
> 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.

Eugenie (Oogie) McGuire 
Desert Weyr, LLC - Black Welsh Mountain Sheep http://www.desertweyr.com/  
LambTracker - Open Source SW for Shepherds http://www.lambtracker.com
Paonia, CO USA


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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 
To: Alexander Thurgood , Tom Davies 
Cc: "users@global.libreoffice.org" 
Sent: Mon, 14 Sep 2015 8:02
Subject: Re: [libreoffice-users] Re: Android version

Tom,

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

-- 
Jim

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

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

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

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


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

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

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Android version

[Albert Oszkó]

There is also Eurooffice, which is free for Android and can be 
downloaded from GooglePlay. It has also (non-free) versions for Windows 
and some linuxes.


2015-09-14 14:41 keltezéssel, Tom Davies írta:

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

Re: [libreoffice-users] LO 5 Documentation

[dave boland]

Did not know that.  Thanks!

Dave,
--
“Before you criticize a man, walk a mile in his shoes. That way, when
you do criticize him, you'll be a mile away and have his shoes.”
― Steve Martin 



On Mon, Sep 14, 2015, at 04:26 PM, Brian Barker wrote:
> At 15:03 14/09/2015 -0400, Dave Boland wrote:
> >I tend to write things in the margins to clarify a point, or an 
> >example, etc. Tough to do that with the PDF version.
> 
> No, it's very easy. The security properties of the PDF manuals say 
> "Commenting: Allowed" and a suitable viewer (even my freeware Adobe 
> Reader) will allow addition of notes, comments, sticky notes, stamps, 
> even audio, as well as formatting such as highlighting. Just what you
> need.
> 
> 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
> 
-- 
  dave boland
  dbola...@fastmail.fm

-- 
http://www.fastmail.com - Faster than the air-speed velocity of an
  unladen european swallow


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] LO Writer 5 loses recent documents list

[MR ZenWiz]

Since I upgraded to LO 5.0.1, I've noticed that the Writer seems to
lose the recent documents list at random.

This morning I edited a document and it had all the ones I've worked
on recently in the list.  An hour later, it had only three, none of
which were the one I'd worked on and most of the ones I have worked on
were gone.

What's up with that?

Thanks.
MR

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] LO 5 Documentation

[Brian Barker]

At 15:03 14/09/2015 -0400, Dave Boland wrote:
I tend to write things in the margins to clarify a point, or an 
example, etc. Tough to do that with the PDF version.


No, it's very easy. The security properties of the PDF manuals say 
"Commenting: Allowed" and a suitable viewer (even my freeware Adobe 
Reader) will allow addition of notes, comments, sticky notes, stamps, 
even audio, as well as formatting such as highlighting. Just what you need.


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

Re: [libreoffice-users] LO 5 Documentation

[dave boland]

On Mon, Sep 14, 2015, at 03:50 PM, Dave Barton wrote:
>  Original Message  
> From: Dave Boland
> Date: Mon, 14 Sep 2015 15:03:39 -0400
> 

> 
> Soft felt tip pens are not so damaging :-))

Hey, there's an idea!

> https://wiki.documentfoundation.org/Documentation/Publications
> then you can add all the notes you want. Maybe you could even finish up
> contributing your edits to the doc project. :) Yes?

Will definitely consider this.

> 

> In addition to the above, the main reason for the delay in docs for
> version 5 is the tiny number of (overworked) people working on them. 

Isn't that always the case?  Speaking as an engineer, the documentation
is my version of latrine duty - no fun!  It's like they used to say at
Charmin "No job is finished until the paper work is done"

We
> have been very fortunate to have the "Base Handbook" for 5 near
> completion, thanks to the German language project (mainly Robert
> Großkopf), who not only created the original, but also did most of the
> "heavy lifting" translating it into English.
> 
> The short answer to your question is that the 5 docs are not much more
> that a dot on the horizon, so go with the 4.2 docs for now.

I'll give it a try - thanks!

Dave,
--
I never know where the line is until AFTER I crossed it!

-- 
  dave boland
  dbola...@fastmail.fm

-- 
http://www.fastmail.com - Or how I learned to stop worrying and
  love email again


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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-projects] Re: [libreoffice-documentation] Re: [libreoffice-users] Need help To convert Excel Sheet to Libre sheet

[timofonic timofonic]

A bit oftopic, but I would really love this in KiCad soon!
On Sep 15, 2015 1:57 AM, "Tom Davies"  wrote:

> Hi :)
> As you probably know the Indian Government is making a strong push to free
> themselves from the vendor lock-ins created by using non-OpenSource
> products.
>
> So, it is possible there may even be funding to help with this sort of
> thing or there may well be some organisation, or conglomeration of
> organisations to help with this sort of work.
>
> Almost certainly you may well be able to find someone local who can do the
> re-programming either as a one-off for just this Excel-Calc migration or as
> a part-time employee/consultant to help with similar jobs in the future or
> to help as 2nd/3rd tier in-house IT Support for any issues that may "crop
> up" in the whole migration away from all the Microsoft and other
> proprietary products.
>
> One of the advantages of OpenSource is that you don't have to wait until
> some profit-making organisation decides on the value to them of the help
> you need.  With an OpenSource program you can pay someone to do it for you,
> on your priorities, or even have a go yourself.  If your code is of good
> enough quality then it might well be added to the main program.  Many
> organisations find that paying for a dev to work on their own issues is
> still cheaper than paying licensing fees as well as giving them more
> control.  Quite a lot of the development of LibreOffice is due to many
> organisations co-operating with each other in this way through The Document
> Foundation.
>
> Regards from
> Tom :)
>
>
> On 11 September 2015 at 06:16, David Johnson <
> david.john...@janalakshmi.com>
> wrote:
>
> > Dear Joel,
> > It is a paid processional, we need to recreate the same excel in Libre
> > office, we need this at the earliest.
> > --
> > Thanks ,
> > *|David Johnson|***|***H**O* - Technology & Process*|**|**Janalakshmi
> > Financial Services Limited**|***|**No.34/1 Andree Road, Shantinagar,
> > Bangalore - 560027*|***|***www.janalakshmi.com**|*
> > *|**Phone :* +91 080-42595100/700*|**|**Ext*-242*|**|**Mobile*: +91
> > 95-38-455118*||**E-Mail *: david.john...@janalakshmi.com*|*
> > On 11-09-2015 10:40, Joel Madero wrote:
> >
> >> You mean a paid professional? I could ask one or two people - if you're
> >> instead asking for a volunteer to assist, best bet is to just asked
> around
> >> on the email thread and maybe the OOo forum (there are a few great macro
> >> people over there).
> >>
> >> Best,
> >> Joel
> >>
> >> On 09/10/2015 09:39 PM, David Johnson wrote:
> >>
> >>> Dear Joel & Tim,
> >>> Thanks for your valuable inputs, appreciate it. Is there any
> >>> professional, whom you know, could help me to redevelop the same in
> Libre
> >>> Calc.
> >>> --
> >>> Thanks ,
> >>> *|David Johnson|***|***H**O* - Technology & Process*|**|**Janalakshmi
> >>> Financial Services Limited**|***|**No.34/1 Andree Road, Shantinagar,
> >>> Bangalore - 560027*|***|***www.janalakshmi.com**|*
> >>> *|**Phone :* +91 080-42595100/700*|**|**Ext*-242*|**|**Mobile*: +91
> >>> 95-38-455118*||**E-Mail *: david.john...@janalakshmi.com*|*
> >>> On 11-09-2015 04:20, Joel Madero wrote:
> >>>
>  That is a true statement - LibreOffice does not support the
> proprietary
>  Microsoft VBA (it may in a very very limited way but not enough for
> most
>  test cases that I've seen) - you'll have to rewrite it in Basic.
> 
>  Best,
>  Joel
> 
>  On Thu, Sep 10, 2015 at 2:04 PM, Tim Lloyd    tim.ll...@gmx.com>> wrote:
> 
>  Hi David,
> 
>  my understanding is that macros in excel and calc are written in
>  different languages so need to be rewritten.
> 
>  Maybe one of the more learned members of the forum can confirm
>  or otherwise.
> 
>  Cheers
> 
> 
>  On 10/09/15 19:48, David Johnson wrote:
> 
> 
>  Dear Gabriele and Tim,
>  PFA; This is the Excel Macro sheet we are trying to convert.
>  Could you please help me.
> 
>  -- Thanks ,
>  *|David Johnson|***|***H**O* - Technology &
>  Process*|**|**Janalakshmi Financial Services
>  Limited**|***|**No.34/1 Andree Road, Shantinagar, Bangalore
>  - 560027*|***|***www.janalakshmi.com
>  **|*
>  *|**Phone :* +91 080-42595100
>  /700*|**|**Ext*-242*|**|**Mobile*:
>  +91 95-38-455118 *||**E-Mail *:
>  david.john...@janalakshmi.com
>  *|*
>  On 10-09-2015 12:17, Tim Lloyd wrote:
> 
>  Hi David,
> 
>  as noted below. It could just work! Which version were
>  you think of using? I think there is some consensus that
>  

Re: [libreoffice-users] Style a text value if a value is present, after a vlookup

[Wade Smart]

--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005


On Sun, Sep 13, 2015 at 12:54 AM, Brian Barker
 wrote:
> At 09:12 11/09/2015 -0500, Wade Smart wrote:
>>
>> This fills out the team rosters:
>> Sheet 1
>> G16=VLOOKUP($E16,$Teams.$A$12:$I$23,($O$13+1),0)
>>
>> Sheet 2
>> Column B2:B9 = team name
>> Column C2:C9 = captain name
>>
>> What I would like to do is bold the capt name for each team. How would you
>> go about doing this (automatically)?
>
>
> I'm, not sure I understand your general problem, but ...
>
>> How do you style a element based on a range with a IF statement?
>
>
> You may find the STYLE() function useful - something like:
> =(STYLE(IF(condition;;)))
> The condition is evaluated and the appropriate style name returned to the
> STYLE() function, which applies that style to the cell. The STYLE() function
> itself returns the value zero; to avoid this being appended inappropriately
> to the result of  (which is what you want to see in the cell),
> the T()function is used. This returns an empty string for numerical
> arguments.
>
> If you want the style to depend on the result of  (i.e. the
> value in the cell itself), you can use something like:
> =(STYLE(IF(CURRENT()=;;)))
>
> 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
>

I messed with this for a while and just made a mess of it. I think I can do
without the styling for now.

Thanks

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Conditional Formatting On Date [SOLVED]

[Dave Barton]

 Original Message  
From: Brian Barker
Date: Mon, 14 Sep 2015 06:15:32 +0100

> At 22:10 13/09/2015 +0200, Dave Barton wrote:
>> In Calc I have column with a series of calculated dates (ie. the
>> result of a formula). I am looking to find a way of using conditional
>> formatting to set the background colour (eg. green) for those dates
>> which fall on a Saturday or Sunday (eg. Condition: = WEEKDAY (A2; 2)>5
>> sets Format: Cell Background = Green)
>>
>> Can anyone offer any pointers to a solution?
> 
> I think you have (almost?) answered your own question.
> 
> o Select *one* cell of your range - e.g. your A2.
> o Go to Format | Conditional Formatting... .
> o With "Condition 1" ticked, select "Formula is".
> o In the Cell Value Condition box, enter: WEEKDAY(A2;2)>5
> o For Cell Style, select Green. You need either already to have defined
> a "Green" cell style or else to create one on the fly using the New
> Style... button.
> o Now copy that formatting to other cells in your range. You can do this
> either by using the Format Paintbrush or by copying A2 and pasting it
> over the range, but using Paste Special... and selecting *just* Formats
> in the Paste Special dialogue.
> 
> Alternatively there is a quite different technique using the STYLE()
> function. Modify your original formulae to read:
> =+STYLE(IF(WEEKDAY(CURRENT();2)>5;"Green"))
> 
> I trust this helps.
> 
> Brian Barker

Yes, Thank you Brian. I knew where I wanted to go, but took a wrong turn
and got lost. I now have no idea why I missed the obvious.
Also, thanks for reminding me about the "+STYLE(IF" alternative.
Guess I was having a brain deadlock day. :(

Regards
Dave



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] LO 5 Documentation

[dave boland]

All,

Does anyone know when the LO 5 documentation will be available?  If not,
or if it may be awhile, would it be worth going to the bother of
printing the 4.2 docs for Calc and Base?  I know there are changes to
Calc, but my guess is that the 4.2 docs may still be worth printing if
it will be a while.  Don't know about Base.

Thanks,
Dave
-- 
  dave boland
  dbola...@fastmail.fm

-- 
http://www.fastmail.com - Or how I learned to stop worrying and
  love email again


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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 Knott]

On 09/14/2015 08:41 AM, Tom Davies wrote:
> Does anyone know if it installs onto the device itself so that it's usable
> off-line?

AndrOffice works off line.  However, your friend should test it before
he goes.  Also, while it works on a tablet, I'd hate to use it on a phone.

There are currency converters, on Google Play, that might be more
appropriate, though I haven't used any of them.



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] LO 5 Documentation

[Dave Barton]

 Original Message  
From: Dave Boland
Date: Mon, 14 Sep 2015 15:03:39 -0400

> Brian,
> 
> Well, I tried that.  The problem was all the marks and words I made on
> the monitor (crib notes) - they ruined my monitor :-)) .

Soft felt tip pens are not so damaging :-))

> Actually, that is the point.  I tend to write things in the margins to
> clarify a point, or an example, etc.  Tough to do that with the PDF
> version.

Seriously, grab the ODT editions from
https://wiki.documentfoundation.org/Documentation/Publications
then you can add all the notes you want. Maybe you could even finish up
contributing your edits to the doc project. :) Yes?

> In any event, the Ver. 5 docs. are not out yet, so we come back to my
> question - how close are the 4.2 docs?  I looked at the change log, but
> I never get a good feel for the changes until I start using something. 
> In the case of Calc, the changes to areas I need seem to be minor.

The number of changes vary from module to module. Unfortunately, it's
not just a case of "plonking" new bits of text into revisions of the
existing documents. There are a number of other aspects that slow down
the editing/reviewing process, such as screen captures for interface
changes and revised instructions for default menu/toolbar items that
have been moved, added and removed. Compared to previous documentation
revisions there have been massive changes in these areas and there are
more to come in the next releases.

In addition to the above, the main reason for the delay in docs for
version 5 is the tiny number of (overworked) people working on them. We
have been very fortunate to have the "Base Handbook" for 5 near
completion, thanks to the German language project (mainly Robert
Großkopf), who not only created the original, but also did most of the
"heavy lifting" translating it into English.

The short answer to your question is that the 5 docs are not much more
that a dot on the horizon, so go with the 4.2 docs for now.

> Dave
> --
> The world is my coloring book; I just can't stay within the lines.
> 
> 
> On Mon, Sep 14, 2015, at 02:50 PM, Brian Barker wrote:
>> At 13:58 14/09/2015 -0400, Dave Boland wrote:
>>> ... would it be worth going to the bother of printing the 4.2 docs 
>>> for Calc and Base?
>>
>> Why print them? Do you have access to a computer? If so, you can 
>> search the documentation and read it on your display!
>>
>> 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

Re: [libreoffice-users] LO 5 Documentation

[Brian Barker]

At 13:58 14/09/2015 -0400, Dave Boland wrote:
... would it be worth going to the bother of printing the 4.2 docs 
for Calc and Base?


Why print them? Do you have access to a computer? If so, you can 
search the documentation and read it on your display!


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

Re: [libreoffice-users] LO 5 Documentation

[dave boland]

Brian,

Well, I tried that.  The problem was all the marks and words I made on
the monitor (crib notes) - they ruined my monitor :-)) .

Actually, that is the point.  I tend to write things in the margins to
clarify a point, or an example, etc.  Tough to do that with the PDF
version.

In any event, the Ver. 5 docs. are not out yet, so we come back to my
question - how close are the 4.2 docs?  I looked at the change log, but
I never get a good feel for the changes until I start using something. 
In the case of Calc, the changes to areas I need seem to be minor.

Dave
--
The world is my coloring book; I just can't stay within the lines.


On Mon, Sep 14, 2015, at 02:50 PM, Brian Barker wrote:
> At 13:58 14/09/2015 -0400, Dave Boland wrote:
> >... would it be worth going to the bother of printing the 4.2 docs 
> >for Calc and Base?
> 
> Why print them? Do you have access to a computer? If so, you can 
> search the documentation and read it on your display!
> 
> 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
> 
-- 
  dave boland
  dbola...@fastmail.fm

-- 
http://www.fastmail.com - The professional email service


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted