I had mentioned in bug 87356 comment 2 that it would be useful to have conditional formatting data bars with the hiding of the underlying values from the cells. I had noticed this feature in Excel's dialog (attachment 110901 [details]) as a checkbox called 'Show Bar Only'.
This feature is available in Excel 2010+ and having this feature would also improve MSO compatibility.
For me this sounds reasonable and good, especially if it also increases the compatibility with MSO.
This feature is implemented and just not available in the UI.
Thanks Markus for the info. I just confirmed that importing an xlsx file with data bars without values is imported correctly, and exporting it as an ods also retains the valueless fields, but there is no means of turning the values on after doing so in LO's UI.
So all that is necessary is adding a checkbox to the dialog (attachment 109791 [details]) to add the necessary functionality.
Katarina Behrens committed a patch related to this issue.
It has been pushed to "master":
tdf#89199: UI option to show data bar only (no values)
It will be available in 5.0.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
(forgot to assign to myself)
This bug fix is mentioned in the release notes of the coming LibreOffice 5.0 (see release notes https://wiki.documentfoundation.org/ReleaseNotes/5.0). Therefore it would be wonderful if this feature really worked well, otherwise it should not be mentioned in the release notes. In the notes it reads:
UI for Data bars without showing their underlying values. (feature without UI has been available since 3.6) tdf#89199 (Katarina Behrens)