Bug 114909 - Help file on conditional formatting gives wrong information
Summary: Help file on conditional formatting gives wrong information
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
5.3.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-01-08 12:46 UTC by Peter Toye
Modified: 2018-01-18 11:00 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Help file extract (85.12 KB, image/png)
2018-01-08 12:49 UTC, Peter Toye
Details
Screenshot (17.92 KB, image/png)
2018-01-08 12:50 UTC, Peter Toye
Details
Conditional Formatting submenu in LO 5.3.7 (366.99 KB, image/png)
2018-01-12 13:01 UTC, Jean-Baptiste Faure
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Peter Toye 2018-01-08 12:46:27 UTC
Description:
The Help file for conditional formatting references a  non-existent menu item.

Steps to Reproduce:
1. Go to Help. Search for "conditional formatting". This takes you to the page "Applying Conditional Formatting"
2. Scroll to the bottom of the page. Under "related topics" click on "Format - conditional formatting" (and why does this page not appear in the index?)
3. Scroll to the bottom and look at the "Manage conditional formatting". It references a menu item Format - Conditional Formatting - Manage (see "Help format.png" attached. There is no such menu item (see "Format.png"

Actual Results:  
No menu item exists

Expected Results:
A menu item corresponding to the help text


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 5.3.7.2 (x64)
Build ID: 6b8ed514a9f8b44d37a1b96673cbbdd077e24059
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; Layout Engine: new; 
Locale: en-GB (en_GB); Calc: group


User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
Comment 1 Peter Toye 2018-01-08 12:49:36 UTC
Created attachment 138964 [details]
Help file extract
Comment 2 Peter Toye 2018-01-08 12:50:48 UTC
Created attachment 138965 [details]
Screenshot

Screenshot of the format menu drop-down
Comment 3 Gabor Kelemen (allotropia) 2018-01-08 23:28:13 UTC
Thanks for filing a bug.

There is a Format - Conditional Formatting submenu in 5.4 and newer, so the text is correct in the current versions. 
Not sure why you see the text in 5.3, as there was no submenu in that version.
The Conditional Formatting page appears in the index under the conditional formatting - conditions entry, at least in the current master version.

I mark this as invalid, but feel free to open a bug about any inconsistency between the help and the UI in the development version.
Comment 4 Peter Toye 2018-01-10 10:36:43 UTC
Well, I downloaded the LO 5.3.7 code and help files at the same time (give or take a few minutes) so they should have been consistent. So I think this is a bug in the released version. As I understand it 5.4 is for experimental users only - that does not include myself.

And there's further question: how do I find what conditional formatting is applied in my spreadsheet given that the menu item doesn't exist and the help file didn't help?
Comment 5 Xisco Faulí 2018-01-10 10:42:41 UTC
(In reply to Peter Toye from comment #4)
> Well, I downloaded the LO 5.3.7 code and help files at the same time (give
> or take a few minutes) so they should have been consistent. So I think this
> is a bug in the released version. As I understand it 5.4 is for experimental
> users only - that does not include myself.

I think at this stage ( forth minor release ) it's quite safe for end users to use.
As Gabor mentioned, there's no submenu in 5.3, thus it should be tested in 5.4.
Comment 6 Peter Toye 2018-01-10 11:18:02 UTC
Xisco, what you say may be true, but I quote from the official download page: 

LibreOffice logo5.4.4
If you're a technology enthusiast, early adopter or power user, this version is for you!

I am a user, not a developer (any more), and 35 years working in the IT industry has taught me never to use such software!

If there is a bug in the officially released software, it needs attention, and saying - " well, you should be using the slightly dodgy latest version " doesn't help gain use confidence in your devotion to producing usable and stable software.
Comment 7 Xisco Faulí 2018-01-10 11:46:46 UTC
In general, we tend to backport everything to fresh and still branches, however, sometimes it's not possible/convenient, and this is one of those cases.
As a rule of thumb in QA, if a bug is fixed in master, we mark it as RESOLVED.
if Gabor says this is fixed in master and 5.4, it's correct to set it as RESOLVED INVALID as he did.
Said so, I'm afraid there isn't much we can do in 5.3 branch. LibreOffice 5.4 will reach the still status soon. Feel free to reopen it if the issue is still reproducible when you test it with 5.4.
Thanks for reporting the issue anyway.
Comment 8 Jean-Baptiste Faure 2018-01-12 13:01:41 UTC
Created attachment 139070 [details]
Conditional Formatting submenu in LO 5.3.7

I just reinstalled LibreOffice 5.3.7 and, as I remembered, I have found the menu entry Conditional Formatting in the Format menu. So your screencopy does not match version 5.3.7. Additionally it shows an empty entry under Group entry and the position of the Format menu in the menubar is not correct.

Please double check that the version you use is really LO 5.3.7: menu Help > About LibreOffice. 
If you are really running LibreOffice 5.3.7, you should try with a clean new user profile: https://wiki.documentfoundation.org/UserProfile 

Best regards. JBF
Comment 9 Peter Toye 2018-01-18 10:05:47 UTC
Interesting - I renamed my profile to get a new one, and the format menu is certainly different, and the same as yours. This is a bit odd, as my version was downloaded recently. It's definitely 5.7.3 - see the bottom of my original post for all the details. Is your version 64 or 32 bit?

I now have the problem of getting back the bits of the profile that I need - templates, help file etc. This may take some time...
Comment 10 Peter Toye 2018-01-18 11:00:00 UTC
I have found the problem - somehow I had a custom format menu set up - I certainly don't remember doing it (but it's a very old workbook going back to 2007). Now I've reset it the menu is as described in the help file.

Very sorry to have caused so much trouble for nothing.