<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:es@x84.org" title="Elliot <es@x84.org>"> <span class="fn">Elliot</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - setting General number format does not work with selected cells if they are formatted to different number formats"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=96954">bug 96954</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Version</td>
<td>Inherited From OOo
</td>
<td>6.1.5.2 release
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - setting General number format does not work with selected cells if they are formatted to different number formats"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=96954#c10">Comment # 10</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - setting General number format does not work with selected cells if they are formatted to different number formats"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=96954">bug 96954</a>
from <span class="vcard"><a class="email" href="mailto:es@x84.org" title="Elliot <es@x84.org>"> <span class="fn">Elliot</span></a>
</span></b>
<pre>In the Calc component, the format Cells dialog does not format cells if
selected cells have heterogeneous formats and if the user elects to format the
selected cells to the default (Number General) format. The work-around to this
bug is to change the selected cells format to a non-default format, and only
then is the user able to change the selected cells format to the default format
of "Number General."
Here is a video of the bug in action:
<a href="https://www.youtube.com/watch?v=CXZQFnwnt-w">https://www.youtube.com/watch?v=CXZQFnwnt-w</a>
In the attached screenshot Screenshot from 2019-03-02 22-19-11.png, pressing
"OK" should change the formatting of the selected cells, however due to this
bug, pressing "OK" has no effect whatsoever on the selected cells.
I *tried and failed* to change importance from medium to major because
formatting cells is of major importance in a spreadsheet. Fortunately this bug
is a fairly common behavior of many application's UI so many users will be able
to intuitively figure out the work-around, but users who do not figure out this
work-around will have a bad day.
Previous comments report this bug happening in Windows 10. In this present
comment I can confirm this bug happening in Linux Mint.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>