<html>
<head>
<base href="https://bugs.freedesktop.org/" />
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW --- - EDITING: Data Validity Cell Range not being applied to multiple selected cells"
href="https://bugs.freedesktop.org/show_bug.cgi?id=53920#c12">Comment # 12</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW --- - EDITING: Data Validity Cell Range not being applied to multiple selected cells"
href="https://bugs.freedesktop.org/show_bug.cgi?id=53920">bug 53920</a>
from <span class="vcard"><a class="email" href="mailto:jumbo4444@yahoo.fr" title="Laurent BP <jumbo4444@yahoo.fr>"> <span class="fn">Laurent BP</span></a>
</span></b>
<pre>Hi,
The bug seems to come from the fact that visible tab is not the initial tab.
Some easy workarounds:
- don't use the picker:
- either use a named reference (as mentioned previously)
- or type the reference
- after using the picker, click on tab where the cells to be validated are
- apply twice Data > Validity: second time the dialog is pre-filled, you just
need to click on OK
It is quite strange because after executing dialog, tab is forced to go back to
initial one. See
<a href="http://opengrok.libreoffice.org/xref/core/sc/source/ui/view/cellsh2.cxx#849">http://opengrok.libreoffice.org/xref/core/sc/source/ui/view/cellsh2.cxx#849</a>
849 short nResult = pDlg->Execute();
850 //When picking Cell Range, other Tab may be switched. Need restore the
correct tab
851 pTabViewShell->SetTabNo( nTab );
nTab value is correct. Why it is not enough? What else can be done?</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are on the CC list for the bug.</li>
</ul>
</body>
</html>