[Libreoffice-bugs] [Bug 135246] LibreOffice Calc does not apply conditional formatting as expected

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=135246

James B. Byrne <byrnejb at harte-lyne.ca> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|All                         |FreeBSD
           Severity|normal                      |minor
            Version|4.1 all versions            |6.4.5.2 release
           Hardware|All                         |x86-64 (AMD64)

--- Comment #11 from James B. Byrne <byrnejb at harte-lyne.ca> ---
This is causing a major difficulty.  I have tried to resolved this by removing
the customs style used by the conditionally formatted cells displaying the
problem.  However, this has proved to be impossible.  Regardless of the view in
the Style pane selecting and deleting does not remove the custom style.

In the hierarchical view the style is removed from the list, but opening custom
style view shows it still present.  Switching back to the hierarchical view and
the 'deleted' style reappears.

Likewise, find and search and replace do not allow me to search for a custom
style> I can choose only from: Default, Excel Builtin Normal (whatever that
is), and Report Page.

On the affected spreadsheet I cannot modify any style.  I can add but I cannot
modify, the dialogue box does not display.

If I go to the affected cells and remove the conditional formatting then the
display reverts t o the direct formatting applied.  However, if I then attempt
to apply conditional formating using one of the provided styles, say Attention,
then the direct formatting is ignored.  Looking at the cell formatting shows
the correct format but the display does not match.

I am now faced with the prospect of having to rebuild this entire spreadsheet,
and all of its formulas and formats, because of this issue.  If I could roll
back to an earlier version of LO then I would do that but this does not seem to
be possible with FreeBSD.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200810/7f137079/attachment.htm>