https://bugs.freedesktop.org/show_bug.cgi?id=53920
--- Comment #12 from Laurent BP <jumbo4444@yahoo.fr> ---
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
http://opengrok.libreoffice.org/xref/core/sc/source/ui/view/cellsh2.cxx#849
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?
-- 
You are receiving this mail because:
You are on the CC list for the bug.
Context
- [Bug 53920] EDITING: Data Validity Cell Range not being applied to multiple selected cells · bugzilla-daemon
 
   
 
  Privacy Policy |
  
Impressum (Legal Info) |
  
Copyright information: Unless otherwise specified, all text and images
  on this website are licensed under the
  
Creative Commons Attribution-Share Alike 3.0 License.
  This does not include the source code of LibreOffice, which is
  licensed under the Mozilla Public License (
MPLv2).
  "LibreOffice" and "The Document Foundation" are
  registered trademarks of their corresponding registered owners or are
  in actual use as trademarks in one or more countries. Their respective
  logos and icons are also subject to international copyright laws. Use
  thereof is explained in our 
trademark policy.