Conditional formatting in Calc: how to find it?

classic Classic list List threaded Threaded
6 messages Options
ptoye ptoye
Reply | Threaded
Open this post in threaded view
|

Conditional formatting in Calc: how to find it?

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



-----
Peter
--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html

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

Peter
Jean-Baptiste Faure-3 Jean-Baptiste Faure-3
Reply | Threaded
Open this post in threaded view
|

Re: Conditional formatting in Calc: how to find it?

Le 10/01/2018 à 11:51, ptoye a écrit :
> 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

--
Seuls des formats ouverts peuvent assurer la pérennité de vos documents.
Disclaimer: my Internet Provider being located in France, each of our
exchanges over Internet will be scanned by French spying services.

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
ptoye ptoye
Reply | Threaded
Open this post in threaded view
|

Re: Conditional formatting in Calc: how to find it?

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>



-----
Peter
--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html

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

Peter
Regina Henschel Regina Henschel
Reply | Threaded
Open this post in threaded view
|

Re: Conditional formatting in Calc: how to find it?

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

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
jorge Rodríguez jorge Rodríguez
Reply | Threaded
Open this post in threaded view
|

Re: Conditional formatting in Calc: how to find it?

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, Regina Henschel escribió:

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


--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
ptoye ptoye
Reply | Threaded
Open this post in threaded view
|

Re: Conditional formatting in Calc: how to find it?

This post was updated on .
In reply to this post by Regina Henschel
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?

[Added later] I've done some more experiments with rather odd results. The Format menu is wrong only for one workbook. Other workbooks don't show the problem. And this is the same using the original profile as well. I don't know of anything I did which would change the menu for an individual workbook - I didn't think it was even possible. But I've now looked into the Customise menu and found it, so I can probably get back to where it should be.

Thanks for the help.



-----
Peter
--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html

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

Peter