[libreoffice-users] Re: Conditional formatting in Calc: how to find it?

2018-01-18 Thread ptoye
I took your advice and started with a new profile (backedup up the original first). And the format menu has changed and looks better. Now all I have to do is rescue the bits of the profile that I need like templates. How can this happen? I recently changed from 32- to 64-bit LO. Would this have m

Re: [libreoffice-users] Re: Conditional formatting in Calc: how to find it?

2018-01-12 Thread jorge Rodríguez
Hi Peter and all:     When you create a Conditional Formatting you can use a formatting existing or create a new of it. In whatever option you select, you can see the style done in the Style Option Menu because it is Style.     I hope this help, Jorge Rodríguez El 12/01/2018 a las 06:59, R

Re: [libreoffice-users] Re: Conditional formatting in Calc: how to find it?

2018-01-12 Thread Regina Henschel
Hi Peter, ptoye schrieb am 12.01.2018 um 12:19: The LO version is 5.3.7.2 (x64) which I think is the latest stable version. The bug is at https://bugs.documentfoundation.org/show_bug.cgi?id=114909 The LO staff think it isn't a bug because it's OK in later unstable versions. There isn't a Forma

[libreoffice-users] Re: Conditional formatting in Calc: how to find it?

2018-01-12 Thread ptoye
The LO version is 5.3.7.2 (x64) which I think is the latest stable version. The bug is at https://bugs.documentfoundation.org/show_bug.cgi?id=114909 The LO staff think it isn't a bug because it's OK in later unstable versions. There isn't a Format > Conditional Formatting menu item in my version

[libreoffice-users] Re: Conditional formatting and named ranges issues.

2017-01-07 Thread Andreas Säger
As far as I understand the matter, the LibreOffice devs have broken the c.f. feature. The c.f. conditions are formula expressions but they do not behave like other formula expressions when you move, copy, expand or shrink references. This is one of the things that still work (almost) properly with

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

2015-09-14 Thread 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 look

[libreoffice-users] Re: Conditional Formatting On Date

2015-09-13 Thread Andreas Säger
Am 13.09.2015 um 22:10 schrieb Dave Barton: > 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. Cond

[libreoffice-users] Re: Conditional Formatting On Date

2015-09-13 Thread Pedro
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

[libreoffice-users] Re: Conditional formatting question

2015-07-03 Thread Andreas Säger
Am 03.07.2015 um 16:23 schrieb Rob Jasper: > Hi, > > 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. > > So, if the value is in col C, this would be the result: > > A B C D E > 1 x y

[libreoffice-users] Re: Conditional formatting

2012-11-07 Thread IGraham
Thanks for the reply 'but' umm I forgot to change my sig/version - must in future remember to include such details I am using 3.6.3.2 and this is the version that has introduced the Conditional formatting bug - IGraham W764 LibreOffice 3.6.3.2 -- View this message in context: htt

[libreoffice-users] Re: Conditional Formatting columns

2012-04-09 Thread IGraham
Thanks, both methods work Miguel - now why didn't i see that Brian - had no idea it could be reduced so much thanks people - IGraham W764 LibreOffice 3.5.2.2 -- View this message in context: http://nabble.documentfoundation.org/Conditional-Formatting-columns-tp3896993p3898033.html Sent f

Re: [libreoffice-users] Re: Conditional Formatting columns

2012-04-09 Thread Brian Barker
At 12:20 09/04/2012 -0700, Graham Lovatt wrote: Seems my initial post was too ambiguous, contained info that wasn't needed and was unclear as to what i wanted etc etc (so I've been told) so I've uploaded a demo file that might make things a little clearer You've got the opposite of what you wa

Re: [libreoffice-users] Re: Conditional Formatting columns

2012-04-09 Thread MiguelAngel
El 09/04/12 21:20, IGraham escribió: Seems my initial post was to ambiguous, contained info that wasn't needed and was unclear as to what i wanted etc etc (so I've been told) so I've uploaded a demo file that might make things a little clearer http://nabble.documentfoundation.org/file/n3897740/c

[libreoffice-users] Re: Conditional Formatting columns

2012-04-09 Thread IGraham
Seems my initial post was to ambiguous, contained info that wasn't needed and was unclear as to what i wanted etc etc (so I've been told) so I've uploaded a demo file that might make things a little clearer http://nabble.documentfoundation.org/file/n3897740/column_test.ods column_test.ods

Re: [libreoffice-users] Re: Conditional formatting cell copying?

2011-07-13 Thread jorge
Hi You can do it like this: 1) Select two columns and all rows that you need format. 2) Select Menu-Format-Conditional Format 3) Make the format that you need 4) Accept I know that this conditional format is for all area selected and it didn't show a special cell formula o condit

Re: [libreoffice-users] Re: Conditional formatting cell copying?

2011-07-13 Thread Johnny Rosenberg
2011/7/13 Hylton Conacher (ZR1HPC) : > Hi Dave, > > Thanks for the answer, and sorry for the belated reply, however it > doesn't work using LibreOffice 3.3.1 > OOO330m19 (Build:8) > tag libreoffice-3.3.1.2 On OpenSuse 11.0 > > You are quite correct that the conditional formulae are copied too, > ho

[libreoffice-users] Re: Conditional formatting cell copying?

2011-07-13 Thread Gérard Fargeot
Hylton Conacher (ZR1HPC) wrote: > > > In other words if you copied cell C3 and pasted special on C4:c10, the > conditional formatting would be copied but the cell references in cell > C10 for the conditional formatting would point to the same cell as those > referenced in cell C3. > Formulae i

Re: [libreoffice-users] Re: Conditional formatting cell copying?

2011-07-13 Thread Hylton Conacher (ZR1HPC)
Hi Dave, Thanks for the answer, and sorry for the belated reply, however it doesn't work using LibreOffice 3.3.1 OOO330m19 (Build:8) tag libreoffice-3.3.1.2 On OpenSuse 11.0 You are quite correct that the conditional formulae are copied too, however the formulae still refer to the same cell refer

[libreoffice-users] Re: Conditional formatting cell copying?

2011-07-12 Thread Dave Griffiths
Hylton Conacher (ZR1HPC) wrote: > Hi all, > > Is there a way to copy a particular cells conditional formatting rules > across a cell selection either in a row or a column? > > I have a spreadsheet with three columns of numbers, two of which require > three conditional formatting rules on each a