[Libreoffice-bugs] [Bug 131560] Data/Form provides access to cells that are protected

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #7 from Paul Hodgson <p_d_hodgson at btinternet.com> ---
Hi,
I have found an extension that appears to try to do some of what I am trying to
achieve (https://extensions.libreoffice.org/extensions/enhanced-form). I have
tried it and found a couple of limitations/bugs which I will report to the
author to see if he can deal with them, but it is good for visualisation of the
need:
1. Validation does not work in the form when the "Data Validation" is
"Allow"="Cell Range", and "Source"=a named range. The validation takes the name
of the range minus it's first character as the only entry in the list, so I
replaced it with the explicit range of cells (in the form $Sheet.$A$1:$A$63),
however that exposed a second bug:
2. The code is incorrect in the module 'ListFiltre' line 145 "Redim Preserve
ListFiltre(x)" is using x (I cannot see where this is declared/set, but just
happened to have an unchanging value of 56) for this array which is being set
with the allowable values. As my array is 63 lines long, this causes an error,
my belief is the code should say "Redim Preserve ListFiltre(xf)", as xf is
counting the number of values that will appear in the list.
3. It is not passing values back to the main cell properly (Particularly from
the cells with data validation!
Many thanks for your help.
Paul

-- 
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/20200329/c5f07f6c/attachment.htm>