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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
19 matches
Mail list logo