Conditional formatting in Calc: how to find it?

users
#1

I have a spreadsheet with some cells with conditional formatting applied.
Unfortunately I don't know what formula or style was used. I tried the
Format | Condition | Edit option but all I got was this:
<http://nabble.documentfoundation.org/file/t474865/Conditional_Format.png>
The condition certainly isn't an equality, and the style certainly isn't
"default", so it's not showing me what's actually there.

Is there any way of finding out what format's been applied? The help file
directs me to a non-existent menu item (sent to Bugzilla).

#2

I have a spreadsheet with some cells with conditional formatting applied.
Unfortunately I don't know what formula or style was used. I tried the
Format | Condition | Edit option but all I got was this:
<http://nabble.documentfoundation.org/file/t474865/Conditional_Format.png>
The condition certainly isn't an equality, and the style certainly isn't
"default", so it's not showing me what's actually there.

What is your version of LibreOffice? In current versions you can get an overview of all conditional formattings whit menu Format > Conditional Formatting > Manage...

Is there any way of finding out what format's been applied? The help file
directs me to a non-existent menu item (sent to Bugzilla).

What is the bug number ?

Best regards.
JBF

#3

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 of
Calc. That's the problem. See the screenshot.

<http://nabble.documentfoundation.org/file/t474865/Format.png>

#4

Hi Peter,

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 of
Calc. That's the problem. See the screenshot.

<http://nabble.documentfoundation.org/file/t474865/Format.png>

It seems, you are using an older user profile, because the order of items is different and the sub-menu "Sheet" is missing. Please rename the entire user folder and then start LibreOffice again. Do you see the missing items then? And please compare the menu with your screenshot. Do you see differences?

Kind regards
Regina

#5

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

#6

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 made a difference?