Re: [libreoffice-users] Conditional formatting question

[Tom Davies]

Hi :)
The dynamic methods are more scalable (or just extend a little) and easier
to replicate.  Also the original question looked like it required a less
static approach.  With the static approach you need to remember to do 2
actions and try to remember what the reason/rule was for the different
back-grounds.  Each approach has pros/cons.

Anyway, congrats on solving the problem in the way that suits your own
use-case the best :))
Regards from
Tom :)




On 4 July 2015 at 12:42, Rob Jasper  wrote:

> OK, in stead of an dynamic setting I reverted to manual setting (makes the
> sheet faster too).
>
> I set autofilter on the column, selected all rows not empty, and set the
> background color...
> Simple and fast.
>
> Why do something dynamic if the data is not that dynamic.
>
>
>
>
> On 3 jul. 2015, at 21:32, Rob Jasper wrote:
>
> > Andreas & Brian,
> >
> > thanks, that works great!
> >
> > Now I have another followup question:
> >
> > I already had a formatting for 2 colums where I set the number of digits
> behind the decimal based on the formula MOD(F2,0.01)=0.
> > This to make a Euro/dfl denomination look like 0.10 and 0.15, while the
> real old values (e.g. 12.5 cents) display as 0.125
> >
> > For those values which on have 2 digits after de decimal, the background
> color doesn't display..
> > If I look at the conditions the first one is the one just added (Range
> A2:AMJ3500; Formula ISNUMBER($H2). This is followed by a hugh list in the
> style F4  — MOD(F4,0.01)=0
> > F20-F21 — MOD(F20,0.01)=0
> > Apparently the list breaks if rows are added... I changed the condition
> to MOD($F2,0.01=0) for the range F2-F3500.
> >
> > It seems that changing the number format conditionally overrides the set
> background color.
> >
> > Result:
> > If Fx has the value n.nnn it has de correct background but the
> numberformat displayed is now n.nn
> > If Fx has the value n.nn the background is gone
> >
> > Am I missing something here?
> > Is this expected behavior?
> >
> > Thanks,
> > Rob.
> >
> >
> > On 3 jul. 2015, at 19:17, Brian Barker wrote:
> >
> >> At 16:23 03/07/2015 +0200, Rob Jasper wrote:
> >>> I am looking on a way to set the background color of a full row if one
> specific field in the row has a value. [Example: C3 = 3.] I looked at
> conditional formatting but I don't see how to format the complete line
> based on one value in the line.
> >>
> >> By "having a value", do you mean the specific example value of 3, or do
> you mean having value as distinct from not having a value (whatever that
> means)?
> >>
> >> o Select the relevant rows.
> >> o Go to Format | Conditional Formatting... .
> >> o For Condition 1, select "Formula is" from the drop-down menu.
> >> o In the box, enter INDIRECT("$C"&ROW())=3 - or perhaps
> INDIRECT("$C"&ROW())<>0 .
> >> o For Cell Style, select your cell style with the appropriate
> background colour (or click New Style... and create a style on the fly).
> >> o OK.
> >>
> >> 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
> >
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.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] remove older version

[M Henri Day]

2015-07-04 18:01 GMT+02:00 Thomas Blasejewicz :

> Good evening
>
> I made a fresh install of Mint 17.1, 64-bit on a Dell Optiplex 745 machine.
> Mint comes with LibreOffice 4.2.6.3.
> Since there is a newer version (4.4.4.3) available, I downloaded and
> installed it.
> However, I now have under (Mint) Menu -> Office TWO Libreoffice items
> each (Writer, Calc etc.).
> In the newer version I am not able to modify / install an extensions.
> I get errors like:
>
> "Error while installing extension Alternative searching. The error
> message is: an error occurred during file opening
> The extension will not be installed."
>
> "Error reading data from the Internet.
> Server error message: Could not read status line: Connection reset by
> peer."
>
> "General Internet error has occurred."
>
> Somehow I suspect, the old package gets in the way (this kind of trouble
> with extensions has NEVER happened
> on any computer with ANY OS before) and I would like to remove it ...
> but don't know how.
> Software Manager and Synaptic Package Manger show only ONE version of
> LibreOffice: 4.4.4.3.
>
> Is there a trick to do this?
> What are the chances this will solve the extension problem?
> I am also wondering why the newer version did not replace the older one.
>
> Thank you.
> Thomas


​Thomas, my experience with downloading newer versions of LibreOffice on
Linux Mint accords with yours, i e, the new version is installed *alongside*
the older one. The latter is easy to remove, both via Synaptic and from the
menu. As others have mentioned, installing the LibreOffice PPA is one way
of making certain that one always has the latest stable version ; I use it
myself. Why you can't get extensions to work on the new version is,
however, beyond me ; perhaps someone else who frequents our forum knows

Here it might be worth noting that the latest version of Linux Mint, 17.2
Rafael, has now been released with a mechanism that allows for an upgrade
to be done directly from the Update Manager ; I did this last night and it
took all of 2-3 minutes. The version of LibreOffice that comes with LM 17.2
is 4.4.3

Henri

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

[Gordon Burgess-Parker]

On 04/07/15 17:01, Thomas Blasejewicz wrote:
> Since there is a newer version (4.4.4.3) available, I downloaded and
> installed it.
How did you do that?

If you'd added the PPA deb
http://ppa.launchpad.net/libreoffice/ppa/ubuntu trusty main all you
would have had to do is an upgrade.

In a terminal do
sudo apt-get purge libreoffice*


That should remove all your versions of LO.
Then see here for how to install via PPA:
http://linuxpitstop.com/upgrade-libreoffice-4-4-4-on-ubuntu/

As you will have removed ALL your versions of LO then you will have to
edit the final command to

sudo apt-get install libreoffice



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

[Daniel A. Rodriguez]

2015-07-04 13:01 GMT-03:00 Thomas Blasejewicz :
> Good evening
>
> I made a fresh install of Mint 17.1, 64-bit on a Dell Optiplex 745 machine.
> Mint comes with LibreOffice 4.2.6.3.
> Since there is a newer version (4.4.4.3) available, I downloaded and
> installed it.
> However, I now have under (Mint) Menu -> Office TWO Libreoffice items
> each (Writer, Calc etc.).
> In the newer version I am not able to modify / install an extensions.
> I get errors like:
>
> "Error while installing extension Alternative searching. The error
> message is: an error occurred during file opening
> The extension will not be installed."
>
> "Error reading data from the Internet.
> Server error message: Could not read status line: Connection reset by peer."
>
> "General Internet error has occurred."
>
> Somehow I suspect, the old package gets in the way (this kind of trouble
> with extensions has NEVER happened
> on any computer with ANY OS before) and I would like to remove it ...
> but don't know how.
> Software Manager and Synaptic Package Manger show only ONE version of
> LibreOffice: 4.4.4.3.
>
> Is there a trick to do this?
> What are the chances this will solve the extension problem?
> I am also wondering why the newer version did not replace the older one.
>
> Thank you.
> Thomas


To have the latest version I recommend remove installed versions, add
PPA repositories and install from there.









Comunidad LibreOffice Argentina
www.libreoffice.org.ar

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

[Thomas Blasejewicz]

Good evening

I made a fresh install of Mint 17.1, 64-bit on a Dell Optiplex 745 machine.
Mint comes with LibreOffice 4.2.6.3.
Since there is a newer version (4.4.4.3) available, I downloaded and
installed it.
However, I now have under (Mint) Menu -> Office TWO Libreoffice items
each (Writer, Calc etc.).
In the newer version I am not able to modify / install an extensions.
I get errors like:

"Error while installing extension Alternative searching. The error
message is: an error occurred during file opening
The extension will not be installed."

"Error reading data from the Internet.
Server error message: Could not read status line: Connection reset by peer."

"General Internet error has occurred."

Somehow I suspect, the old package gets in the way (this kind of trouble
with extensions has NEVER happened
on any computer with ANY OS before) and I would like to remove it ...
but don't know how.
Software Manager and Synaptic Package Manger show only ONE version of
LibreOffice: 4.4.4.3.

Is there a trick to do this?
What are the chances this will solve the extension problem?
I am also wondering why the newer version did not replace the older one.

Thank you.
Thomas

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

[Rob Jasper]

OK, in stead of an dynamic setting I reverted to manual setting (makes the 
sheet faster too).

I set autofilter on the column, selected all rows not empty, and set the 
background color...
Simple and fast.

Why do something dynamic if the data is not that dynamic.




On 3 jul. 2015, at 21:32, Rob Jasper wrote:

> Andreas & Brian,
> 
> thanks, that works great!
> 
> Now I have another followup question:
> 
> I already had a formatting for 2 colums where I set the number of digits 
> behind the decimal based on the formula MOD(F2,0.01)=0.
> This to make a Euro/dfl denomination look like 0.10 and 0.15, while the real 
> old values (e.g. 12.5 cents) display as 0.125
> 
> For those values which on have 2 digits after de decimal, the background 
> color doesn't display..
> If I look at the conditions the first one is the one just added (Range 
> A2:AMJ3500; Formula ISNUMBER($H2). This is followed by a hugh list in the 
> style F4  — MOD(F4,0.01)=0 
> F20-F21 — MOD(F20,0.01)=0
> Apparently the list breaks if rows are added... I changed the condition to 
> MOD($F2,0.01=0) for the range F2-F3500.
> 
> It seems that changing the number format conditionally overrides the set 
> background color.
> 
> Result: 
> If Fx has the value n.nnn it has de correct background but the numberformat 
> displayed is now n.nn
> If Fx has the value n.nn the background is gone
> 
> Am I missing something here?
> Is this expected behavior?
> 
> Thanks,
> Rob.
> 
> 
> On 3 jul. 2015, at 19:17, Brian Barker wrote:
> 
>> At 16:23 03/07/2015 +0200, Rob Jasper wrote:
>>> I am looking on a way to set the background color of a full row if one 
>>> specific field in the row has a value. [Example: C3 = 3.] I looked at 
>>> conditional formatting but I don't see how to format the complete line 
>>> based on one value in the line.
>> 
>> By "having a value", do you mean the specific example value of 3, or do you 
>> mean having value as distinct from not having a value (whatever that means)?
>> 
>> o Select the relevant rows.
>> o Go to Format | Conditional Formatting... .
>> o For Condition 1, select "Formula is" from the drop-down menu.
>> o In the box, enter INDIRECT("$C"&ROW())=3 - or perhaps 
>> INDIRECT("$C"&ROW())<>0 .
>> o For Cell Style, select your cell style with the appropriate background 
>> colour (or click New Style... and create a style on the fly).
>> o OK.
>> 
>> 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
> 


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

[Thomas]

On 2015/07/04 18:48, Johnny Rosenberg wrote:
2015-07-04 11:34 GMT+02:00 Thomas >:


Good evening
In Calc however, there is no "Font color fill"and ANY shortcut I
assign
to "Font color"
brings up the "Cell Format" dialog box.


Doesn't sound much like a task for a spreadsheet application to me,
Yes. I am aware of that AND totally agree with you. However, translation 
agencies keep sending me Excel files for translation or
editing all the time. I have been trying to convince them for 20 years, 
that Excel, or Calc, is for CALCULATION.
So far with no success at all. That is why I have to cope with these 
"inappropriate" tasks/tools.


I don't know, but I am pretty sure you can make a macro that does that 
for you.


A macro. OK, I will try that.
Thomas


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

[Thomas]

Good evening
I working with Calc, checking translations made by someone else.
I would like to mark certain words within the text in red or any color.
For Writer I used:
Tools -> Customize -> Keyboard -> Format -> "Font color fill" and
assigned a shortcut key.

In Calc however, there is no "Font color fill"and ANY shortcut I assign
to "Font color"
brings up the "Cell Format" dialog box.

Is it not possible to assign a shortcut key that will change the font
color of the particular word/text
I am working on in a particular cell?
If there is, how do I achieve that?

Thank you.
Thomas

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